Question

Hibernate的getHibernateTemplate().executeFind(new HibernateCallback()为空

点击树形节点的时候加载用户的列表信息，但是查出来的list集合是空的，请路过大侠帮小弟解决下问题。谢谢，代码如下 public List findUserList(final Users user) { List list = null; try { final Page page = user.getPage(); list = getHibernateTemplate().executeFind(new HibernateCallback() { public Object doInHibernate(Session s) throws HibernateException, SQLException { Criteria c = s.createCriteria(Users.class); if (user != null) { //部门 if (user.getDeptId() != null && user.getDeptId()>0) { c.add(Restrictions.eq("deptId",user.getDeptId())); } c.addOrder(Order.desc("id")); //分页 ////总数据条数 page.setTotalCount(c.list().size()); ////总页数的第几页 c.setFirstResult((page.getCurrPage() -1) * page.getCount()); ////每页的数据条数 c.setMaxResults(page.getCount()); } return c.list(); } }); } catch (Exception e) { e.printStackTrace(); } return list; }

Answer 1

/** * 动态显示下拉框的值（创建人） */ public List CreateMan(final String roleInfo, final String roleInfoTwo, final String userState) { List list = new ArrayList(); // hql语句 final String hql = " from UserInfo where roleInfo=? or roleInfo=? and userState=?"; return (List) getHibernateTemplate().execute(new HibernateCallback() { public Object doInHibernate(Session session) throws HibernateException { // 创建query对象 Query query = session.createQuery(hql); // 循环给数组赋值 query.setString(0, roleInfo); query.setString(1, roleInfoTwo); query.setString(2, userState); List list = query.list();// 查询集合 Hibernate.initialize(list); return list; } }); }