左连接语句【原创】

语句如下：

   Query q = sessionFactory.getCurrentSession().createSQLQuery("select funcid,menuid,operid,i_funcid,c_opername,c_actionname from (select a.i_funcid as funcid,a.i_menuid as menuid,a.i_operid as operid,b.i_funcid from op_menufunction a left join op_menufunction b on a.i_funcid=b.i_funcid and a.i_menuid=:mid) d,op_menuoperate e where e.i_operid=operid");  
   q.setParameter("mid", mid);
   return q.list();

注意要使用createSQLQuery

 

评论

1 楼 uin57 2011-05-11  

纯水帖.....鉴定完毕