使用hibernate 代替 mysql 中 limit 進行分頁

Session session  =  HibernateSessionFactory.getSession();
Transaction tx  =  session.beginTransaction();
List < ServiceInfo >  serviceInfos  =   new  ArrayList < ServiceInfo > ();
      
String hql  =   " from Serviceinfo where syned<> "   +  deleted  +   "  order by servicename " ;
Query query  =  session.createQuery(hql);
query.setFirstResult(first);
query.setMaxResults(count);
Iterator < Serviceinfo >  serviceinfosIt  =  query.iterate();

 

 

 @SuppressWarnings("unchecked")
 public List<NewsBean> findNewsListByPaging(final int pageIndex,final int pageSize) {
        return (List<NewsBean>) getHibernateTemplate().execute( new HibernateCallback(){
            public Object doInHibernate(Session session) throws HibernateException, SQLException {
                return session.createQuery("FROM NewsBean n order by n.newsId").setFirstResult((pageIndex-1)*pageSize).setMaxResults(pageSize).list();
            }
        });
    }

评论

1 楼 358135071 2012-05-08  

学习了，感谢分享！