SSH-----------hql通过用户id查找权限,多表左连接查询

public List<Function> findListByUserId(String useid) {

    String hsp="select distinct f from Function f ";
    hsp+=" left outer join f.roles r ";
    hsp+=" left outer join r.users u ";
    hsp+=" where u.id=? ";
    return hibernateTemplate.find(hsp,useid);
}

 

 

@Test
public void test01() {
    List<Function> functionList= iFunctionDao.findListByUserId("40289f817292c0f1017292c277bb0000");
    for (Function function:functionList){
        System.out.println("id:"+function.getId()+"---name:"+function.getName());
    }

}