spring管理hibernate分页的方法总结
public List findAll(final final int first,final int size)
{
return getHibernateTemplate().executeFind(new HibernateCallback()
{
public Object doInHibernate(Session session) throws HibernateException, SQLException
{
StringBuffer sbSQL=new StringBuffer("from Table where 1=1");
Query query=session.createQuery(sbSQL.toString());
query.setFirstResult(first);
query.setMaxResults(size);
return query.list();
}
});
}
public int totalRow(){
return (Integer)getHibernateTemplate().execute(new HibernateCallback()
{
public Object doInHibernate(Session session) throws HibernateException, SQLException
{
StringBuffer sbSQL=new StringBuffer("select count(t.id) from Table t where 1=1");
Query query=session.createQuery(sbSQL.toString());
Long obj=(Long)query.uniqueResult();
return obj.intValue();
}
});
}
