带连接的Spring data jap多表列

Question

我有两个表，user_info和user_password。我想在显示userInfo详细信息时直接显示typeName，但我不想配置这两个实体之间的关系（OneToMany或manytone）。但不行，谁能帮我？

@Data
@Entity
@DynamicUpdate
public class UserInfo {// user_info
    @Id
    private Integer id;
    private String name;
    private Byte gender;
    private String thirdPartId;
    private Integer age;
    private String telphone;
    private String registerMode;
}

@Entity
@Data
public class UserPassword {//user_password

    @Id
    private Integer id;
    private String encryptPassword;
    private Integer userId;


}


/** 
 * This is wish result entity
 * @author Mason
 * @version v1.0
 * @since 2019/1/16
 */
@Data
public class UserInfoPassword {
    private Integer id;
    private String name;
    private Byte gender;
    private String thirdPartId;
    private Integer age;
    private String telphone;
    private String registerMode;
    private String encryptPassword;
}

 @Query(value = "SELECT u.id,u.name,u.gender,u.third_part_id,u.age,u.telphone,u.register_mode,p.encrypt_password FROM user_info u " +
            "LEFT JOIN user_password p ON  u.id=p.user_id ", nativeQuery = true)
    List<UserInfoPassword > queryAll();

此返回类型UserInfoPassword将出现异常：org.springframework.core.convert.ConverterNotFoundException：找不到能够从类型[org.springframework.data.jpa.repository.query.AbstractJpaQuery$TupleConverter$TupleBackedMap]转换为类型[com.mason.sell.repository.model.UserInfoPassword]的转换器

如果我改变返回对象，并这样做:

 List<Object> userInfoPasswords = userInfoRepository.queryAll();
        for (Object o : userInfoPasswords) {
            UserInfoPassword uip = (UserInfoPassword) o;
            System.out.println(uip);
        }

然后会出现这个异常：

java.lang.ClassCastException： [Ljava.lang.Object; 不能被投射到 com.mason.sell.repository.model.userInfoPassword

谁有很好的方法来进行多表连接查询？？？

Answer 1

它将返回一个对象数组，因为您没有提供任何映射。

试试这个：-

List<Object[]> userInfoPasswords = userInfoRepository.queryAll();
for (Object o[] : userInfoPasswords) {
    System.out.println("id: " + o[0]); // or call the setter of new UserInfoPassword
    System.out.println("name: " + o[1]);
    // ... and so on
}