hibernate many to many查询

 原文地址:http://topic.youkuaiyun.com/u/20100524/11/07083ba1-ddeb-44ce-985e-c8991e3c7b6a.html

 

三个table
1. User
 
2. Role
 
3. User_Role
 
Role对象里面有个many-to-many的关系 Set <User>
 
需求：查询所有 传进来一个 user 然后查出 与他关联的 List<Role>
hibernate hql 查询如何实现？

 

4楼:

select a from User_Role a left join a.User b where b.user_id=userId

 

7楼:

select * from Role where (from User where id=" + value + ") in elements(users)