public List<MeetMenu> getMeetMenuByUserId(UserLogin u) throws DAOException {
try{
final String sql="select me.menu_id,me.menu_name,me.menu_text,me.link_url,me.sortid,me.isvalid,me.remark,me.parentname from meet_menu me,rolemenu rm,userrole ur
where me.menu_id=rm.menuid and ur.role_id=rm.roleid and ur.user_id="+u.getId();
List l =this.executeFind(new HibernateCallback(){
public Object doInHibernate(Session session) throws HibernateException, SQLException {
SQLQuery query=session.createSQLQuery(sql);
return query.list();
}
});
hibernate 支持SQL
最新推荐文章于 2022-06-17 10:38:35 发布