分页

最新推荐文章于 2024-09-20 21:32:51 发布

ouou009

最新推荐文章于 2024-09-20 21:32:51 发布

阅读量208

点赞数

文章标签： list string query session

本文链接：https://blog.csdn.net/ouou009/article/details/7379976

版权

@SuppressWarnings("unchecked")
public void findHolidays(PageBean pageBean, int startRow, int pageSize) {
  final String hql = "from TblLegalHoliday";
  final String countHql = "select count(*) from TblLegalHoliday";
  Session session = getHibernateTemplate().getSessionFactory()
    .getCurrentSession();
  Query query = session.createQuery(hql);
  query.setFirstResult(startRow);
  query.setMaxResults(pageSize);
  List list = query.list();
  int totalPage = ((Long) session.createQuery(countHql).uniqueResult())
    .intValue();
  int pageIndex = (startRow / pageSize) + 1;
  pageBean.setCurrentPage(pageIndex);
  pageBean.setList(list);
  pageBean.setPageSize(pageSize);
  int pageCount = (int) ((totalPage - 1 + pageSize) / pageSize);
  if (pageCount > 0 && pageIndex > pageCount) {
   pageIndex = pageCount;
  }
  pageBean.setTotalPage(pageCount);
  System.out.println("***************** totalPage:" + totalPage);
  pageBean.setAllRow(totalPage);// 怎么解决?
}