我有一个简单的用户实体,它可能有朋友(从用户到多个关系),它被映射到数据库中的朋友表中,但是我没有一个单独的用于映射的朋友实体对象。这是用户实体。
@Entity
@Table(name="users")
public class User extends Persistent{
@NotEmpty
@Size(min=4,max=16)
@Column(name="USER_NAME",nullable = false,unique = true)
private String username;
@NotEmpty
@Email
@Column(name="EMAIL",nullable = false,unique = true)
private String email;
@NotEmpty
@Size(min=3,max=99)
@Column(name="PASSWORD",nullable = false)
private String password;
@Column(name="ACTIVE")
private boolean active = true;
@NotEmpty
@Column(name="FIRST_NAME",nullable = false)
private String firstName;
@NotEmpty
@Column(name="LAST_NAME",nullable = false)
private String lastName;
@NotEmpty
@Column(name="DOB",nullable = false)
private String DOB;
@Column(name="PROFILE_PICTURE")
private String profilePicture;
//user activities
@OneToMany(mappedBy = "user",fetch = FetchType.LAZY,cascade = CascadeType.REMOVE)
private List<Post> posts;
@OneToMany(mappedBy = "user",fetch = FetchType.LAZY,cascade = CascadeType.REMOVE)
private List<Comment> comments;
@OneToMany(mappedBy = "user",fetch = FetchType.LAZY,cascade = CascadeType.REMOVE)
private List<Like> likes;
@ManyToMany(cascade={CascadeType.ALL},fetch=FetchType.EAGER)
@JoinTable(name="friends",
joinColumns={@JoinColumn(name="userId")},
inverseJoinColumns={@JoinColumn(name="friendId")})
private List<User> friends;
@ManyToMany(mappedBy="friends",fetch=FetchType.EAGER)
private List<User> friendsWith;
.....
}
因此,我已经使用热切加载加载朋友的用户。但是,如果我想加载用户的朋友,而不是急切地加载,但使用JPQL .是否可以使用JPQL加载用户朋友信息,因为我没有朋友实体类??我是否需要创建一个单独的朋友实体类来映射freinds ??
发布于 2015-04-11 07:20:07
你在实体之间有关联。可以使用fetch join在JPQL中急切地加载关联:
select distinct u from User u left join fetch u.friends where u.id = :id
无论关联是什么,以及映射的方式如何,这都适用。
https://stackoverflow.com/questions/29579420
复制