select distinct(r.rname) from User u,Role r,UserRole ur where u.uname='xxxx' and u.uid=ur.uid and ur.rid=r.rid你试试我的语句能执行通过吗?我本机没配Hibernate没法测试,如果不能通过请留言!
//多对多的关系,你在User类中,应该有roles属性吧,用来映射Role的public void queryById(int id){User user = (User)session.get(User.class,id);Set set = user.getRoles();for(Role role : set){
Sys