HQL 查询多对关系,可以用到语句:
select o from Message o join o.inAdmins oo where oo.id = ? order by o.id desc
这样就可以根据对象Message,里面的对应多对多对象inAdmins 的 id = 某值 查询出 具体有哪条记录
非常简单,不用写的辛苦,但是,如果是
select o from Message o join o.inAdmins oo where oo.id = ? or o.status = ? order by o.id desc
这样的多条件查询,它就会查询出来重复语句,具体原因,它会取出message里面的inAdmins,这样就有几个记录了
解决:select distinct o from Message o join o.inAdmins oo where oo.id = ? or o.status = ? order by o.id desc
一个对象有多个 List 对象,并且要作为条件进行查询:
select distinct o from com.bang.model.User o join o.users oo , o.friends ooo where oo.id = ? or ooo.id = ? order by o.id desc