--用户实体类
public class Syuser implements java.io.Serializable {
private String id;
private Date createdatetime;
private Date updatedatetime;
private String loginname;
private String pwd;
private String name;
private String sex;
private Integer age;
private String photo;
private Set<Syorganization> syorganizations = new HashSet<Syorganization>(0);
@ManyToMany(fetch = FetchType.LAZY)
@JoinTable(name = "syuser_syorganization", schema = "", joinColumns = { @JoinColumn(name = "syuser_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "syorganization_id", nullable = false, updatable = false) })
public Set<Syorganization> getSyorganizations() {
return this.syorganizations;
}
public void setSyorganizations(Set<Syorganization> syorganizations) {
this.syorganizations = syorganizations;
}
}
--机构实体
public class Syorganization implements java.io.Serializable {
private String pid;// 虚拟属性,用于获得当前机构的父机构ID
private String id;
private Date createdatetime;
private Date updatedatetime;
private String name;
private String address;
private String code;
private String iconCls;
private Integer seq;
private Syorganization syorganization;
private Set<Syorganization> syorganizations = new HashSet<Syorganization>(0);
private Set<Syuser> syusers = new HashSet<Syuser>(0);
@ManyToMany(fetch = FetchType.LAZY)
@JoinTable(name = "syuser_syorganization", schema = "", joinColumns = { @JoinColumn(name = "syorganization_id", nullable = false, updatable = false) }, inverseJoinColumns = { @JoinColumn(name = "syuser_id", nullable = false, updatable = false) })
public Set<Syuser> getSyusers() {
return this.syusers;
}
public void setSyusers(Set<Syuser> syusers) {
this.syusers = syusers;
}
}
一个用户可以属于多个机构,一个机构下面可以有多个人
现在我要做一个hql双向查询,**查询当前登录用户所在机构下的人**
select distinct t from Syuser t join t.syorganizations
我可以拿到当前登录人所属机构的set集合 但是不知道set如何做条件查询
请各位指导! 谢谢!