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;
}
}
}