/** * TOP查询 * @param sql String * @param top int * @return List */ public List findTop(String sql, int top) { HibernateTemplate ht = this .getHibernateTemplate(); ht.setMaxResults(top); return ht.find(sql); } /** * 分页查询 * @param sql String * @param firstRow int * @param maxRow int * @return List */ public List findPage( final String sql, final int firstRow, final int maxRow) { return this .getHibernateTemplate().executeFind( new HibernateCallback(){ public Object doInHibernate(Session session) throws SQLException, HibernateException { Query q = session.createQuery(sql); q.setFirstResult(firstRow); q.setMaxResults(maxRow); return q.list(); } }); }
模板实现分页: public List find( final String hsql, final int firstRow, final int maxRow) throws Exception { return getHibernateTemplate().executeFind( new HibernateCallback() { public Object doInHibernate(Session s) throws HibernateException, SQLException { Query query = s.createQuery(hsql); query.setFirstResult(firstRow); query.setMaxResults(maxRow); List list = query.list(); return list; } }); }
Spring+hibernate分页查询
最新推荐文章于 2019-05-06 00:02:00 发布