使用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]