xrd698 2016-06-21 15:03 采纳率: 0%
浏览 1077

hibernate 多对多双向查询问题

--用户实体类
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如何做条件查询
请各位指导! 谢谢!

  • 写回答

2条回答 默认 最新

  • devmiao 2016-06-21 15:19
    关注
    评论

报告相同问题?

悬赏问题

  • ¥15 iOS 自定义输入法-第三方输入法
  • ¥15 很想要一个很好的答案或提示
  • ¥15 扫描项目中发现AndroidOS.Agent、Android/SmsThief.LI!tr
  • ¥15 怀疑手机被监控,请问怎么解决和防止
  • ¥15 Qt下使用tcp获取数据的详细操作
  • ¥15 idea右下角设置编码是灰色的
  • ¥15 全志H618ROM新增分区
  • ¥15 在grasshopper里DrawViewportWires更改预览后,禁用电池仍然显示
  • ¥15 NAO机器人的录音程序保存问题
  • ¥15 C#读写EXCEL文件,不同编译