首页 > Web开发 > 详细

hibernate分页查询的各种方法

时间:2015-04-23 23:12:21      阅读:362      评论:0      收藏:0      [点我收藏+]

统计总数:

	public Integer countAll1() {
		 
			String hql = "select count(*) from News as news";
			List list = getHibernateTemplate().find(hql);
			return list.get(0).hashCode(); 
	}
	
	public Integer countAll2() {
		 
		Criteria  criteria = this.getSession().createCriteria(News.class);
		return ((Integer) (criteria.setProjection(Projections.rowCount())).uniqueResult()).intValue();
}

分页查询:

	public List pagerList(Integer beginNum,Integer maxNum){
		DetachedCriteria dCriteria = DetachedCriteria.forClass(News.class);
		List list = getHibernateTemplate().findByCriteria(dCriteria, beginNum, maxNum);
		return list;
	}

	public List pagerList1(String news,Integer beginNum,Integer maxNum){
		Criteria criteria = this.getSession().createCriteria(News.class);
		criteria.setFirstResult(beginNum);
		criteria.setMaxResults(maxNum);
		return criteria.list();
	}
	
	public List pagerList2(String news,Integer beginNum,Integer maxNum){
		String hql = "from News";
		Query query = this.getSession().createQuery(hql);
		query.setFirstResult(beginNum);
		query.setMaxResults(maxNum);
		return query.list();
	}

  

 

hibernate分页查询的各种方法

原文:http://www.cnblogs.com/koal/p/4451775.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!