CustomBaseSqlDaoImpl.java 文件源码

/**
 * 根据hql语句和分页条件查找分页数据
 * @param hql
 * @param currentPage
 * @param pageSize
 * @return
 */
@SuppressWarnings({ "rawtypes", "unchecked" })
public PageModel queryForPage(String hql,int currentPage,int pageSize){
    PageModel page = new PageModel();
    List list = null;
    Integer totalCount = 0;
    Integer totalPage = 0; //总页数
    try {
        int firstResult = (currentPage-1)*pageSize;
        Query query = em.createQuery(hql);
        query.setMaxResults(pageSize);
        query.setFirstResult(firstResult);
        list = query.getResultList();

        Query query2 = em.createQuery(hql);
        List list2 = query2.getResultList();
        totalCount = (list2 == null) ? 0 : list2.size();
        if(totalCount % pageSize == 0){
            totalPage = totalCount/pageSize;
        }else{
            totalPage = totalCount/pageSize + 1;
        }

        page.setCurrentPage(currentPage);
        page.setList(list);
        page.setPageSize(pageSize);
        page.setTotalCount(totalCount);
        page.setTotalPage(totalPage);
    } catch (Exception e) {
        e.printStackTrace();
    }finally{
        em.close();
    }       
    return page;
}