简单的hibernate分页代码

public class userServiceImpl extends HibernateDaoSupport implements userService {
	
	private int count;		//总记录条数
	private int pagecount;	//总页数
	private int pageNum;	//页码
	private int pageSize;	//每页显示条数

	public List<InformationSheet> pageInfo(String sql, int page) {
		// TODO Auto-generated method stub
		Session session=getHibernateTemplate().getSessionFactory().openSession();
		Query query=(Query) session.createSQLQuery(sql).addEntity(InformationSheet.class);
		List list = query.list();	
	    count = list.size();	//总记录数
	    pageSize=8;				//每页显示8条
	    if(count>0){
	    	 pagecount = 0;          //总页数
	 	    pageNum=page;           //当前页
	 	    
	 	    if((count%pageSize)!=0){
	 	    	pagecount = (count/pageSize)+1;		
	 	    }else{
	 	    	pagecount = count/pageSize;
	 	    }
	 	    //判断当前页是否有效
	 	    if(pageNum>pagecount){
	 	    	pageNum=pagecount;
	 	    }else if(page<=0){
	 	    	pageNum=1;
	 	    }
	 		query.setFirstResult((pageNum-1)*pageSize);
	 		query.setMaxResults(pageSize);
	 		List returnList=query.list();
	 		session.close();
	 		return returnList;
	    }else{
	    	session.close();
	    	return null;
	    }
	}
	
	
}