hibernate-CRM系统跟据员工ID查管理权限HQL怎么写?
仙人长 2010-09-16 12:39:24 五张表:
employee, role,authority ,role_employee,role_authority
源sql :
String sql="select aut.authorityid,aut.authorityName from authority as aut
inner join role_authority as rau on(rau.authorityid=aut.authorityid)
where rau.roleId in(select roleId from role_employee as rem
inner join employee as emp on(re.employeeId=emp.employeeId) where eimployeeId=1)
";
HQL语句怎么写?
想要的结果:员工ID(employeeId)查管理权限(List<Authority>)
谢谢大虾!谢谢大虾!谢谢大虾!