一方
package com.jpa.vo;
import javax.persistence.*;
import java.io.Serializable;
@Entity
@Table(name = "role")
public class RoleVO implements Serializable {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "role_id")
private Integer roleId;
@Column(name = "role_name")
private String roleName;
@ManyToOne
@JoinColumn(name="role_id",insertable = false , updatable = false)
private UserVO userVO;
}
多方
package com.jpa.vo;
import javax.annotation.sql.DataSourceDefinition;
import javax.persistence.*;
import java.util.List;
/**
-
用户信息类
*/
@Entity
@Table(name="users")
public class UserVO {@Column(name="role_id")
private Integer roleId;@Id
@Column(name = "user_id")
@GeneratedValue
private Integer userId;@Column( name="user_name")
private String userName;@Column(name ="pass_word")
private String password;@OneToMany( cascade = CascadeType.ALL, fetch = FetchType.EAGER, mappedBy = "userVO")
List roles;
}
spring data jpa 多表联合查询 ， 查询结果 List 为空无法映射
{
"roleId": 1,
"userId": 1,
"userName": "wuming",
"password": "1234",
"roles": [
{}
]
}
