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 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题