HibernateDaoSupport分页.

使用扩展HibernateDaoSupport实现分页技术总结(2008-06-04 16:50:54)
1.定义MyHibernateDaoSupport 扩展HibernateSupport
import java.sql.SQLException;
import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class MyHibernateDaoSupport extends HibernateDaoSupport {
 public List findByPage(final String hql,final int offset,final int pageSize)
 {
  List list=this.getHibernateTemplate().executeFind(new HibernateCallback()
  {
   public Object doInHibernate(Session session)
     throws HibernateException, SQLException {
    List result=session.createQuery(hql).setFirstResult(offset).setMaxResults(pageSize).list();
    return result;
   }
  }
  );
  return list;
 }
 public List findByPage(final String hql,final String value,final int offset,final int pageSize)
 {
  List list=this.getHibernateTemplate().executeFind(new HibernateCallback()
  {
   public Object doInHibernate(Session session)