容易的hibernate分页代码

简单的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 stubSession 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;    }}}