现在有这个一个多对多的关系
@Entity
public class Users {
/* 主键,20位*/
private String username;
/* 20位, 不能为null /
private String password;
/ 姓名 10位 不能为null /
private String realname;
/ 性别 不能为null /
private Gender gender;
/ 学历 10位 /
private String degree;
/ 身份证 必须提供 /
private IDCard idCard;
/ 毕业院校 20位 /
private String school;
/ 联系电话 20 /
private String phone;
/ 电子邮件 50 /
private String email;
/ 照片 41 /
private String imageName;
/ 员工在职状态 true为在职,false为离职 */
private Boolean visible = true;
private Department department;
private Set groups = new HashSet();
private Set privileges = new HashSet();
@ManyToMany(cascade=CascadeType.REFRESH,fetch=FetchType.EAGER)
@JoinTable(name="user_role", joinColumns=@JoinColumn(name="username"),
inverseJoinColumns=@JoinColumn(name="groupid"))
public Set<PrivilegeGroup> getGroups() {
return groups;
}
public void setGroups(Set<PrivilegeGroup> groups) {
this.groups = groups;
}
/**
* 添加权限级
* @param group
*/
public void addPrivilegeGroup(PrivilegeGroup group){
this.groups.add(group);
}
/**
* 添加权限
* @param privilege
*/
public void addSystemPrivilege(SystemPrivilege privilege){
this.privileges.add(privilege);
}
怎么用jpql取user_role里的数据