Hibernate 分页基类及分页实体类

1. package com.shop.base;
4. import org.hibernate.Query;
5. import org.hibernate.Session;
7. import com.shop.entity.Pagination;
9. /**
10.  * 分页基类 继承于BaseHibernateDAO类
11.  * @author Administrator
12.  *
13.  */
14. public abstract class BasePagination extends BaseHibernateDao {
15.     /**
16.      * 分页查询
17.      * @param page
18.      *      分页实体类
19.      * @param sql
20.      *      分页用sql查询语句
21.      *      类似:select c.id,c.name,c.age from Customers c order by c.id desc
22.      * @param Object[] conObjects
23.      *          查询条件
24.      */
25.     @SuppressWarnings("unchecked")
26.     protected void searchByPagination(Pagination pagination,String hql,Object[] conditions){
27.         try{
28.             Session session1 = HibernateSessionFactory.getSession();
29.             Query query1=session1.createQuery(hql);
30.             query1=setQuery(query1, conditions);
31.             query1.setFirstResult((pagination.getPageIndex()-1)*pagination.getPageSize());
32.             query1.setMaxResults(pagination.getPageSize());
33.             pagination.setList(query1.list());
34.             session1.close();
35.             
36.             Session session2 = HibernateSessionFactory.getSession();
37.             Query query2 = session2.createQuery(hql);
38.             pagination.setAllRows(countRows(query2, conditions, session2));
39.             try {
40.                 pagination.setPageCounts();
41.             } catch (Exception e) {
42.                 // TODO 自动生成 catch 块
43.                 e.printStackTrace();
44.             }
45.             session2.close();
46.         }catch(RuntimeException re){
47.             re.printStackTrace();
48.         }
49.     }
50.     
51.     /**
52.      * 设置Query的参数
53.      * @param query
54.      * @param conObjects
55.      * @return
56.      */
57.     private Query setQuery(Query query,Object[] conditions){
58.         if(conditions==null || conditions.length==0){
59.             return query;
60.         }
61.         for (int i = 0; i < conditions.length; i++) {
62.             query.setParameter(i, conditions[i]);
63.         }
64.         return query;
65.     }
66.     
67.     /**
68.      * 得到总行数
69.      * @param query
70.      * @return
71.      */
72.     private int countRows(Query query,Object[] conditions,Session session){
73.         String hql=query.getQueryString();
74.         String queryString="";
75.         if (hql.toUpperCase().indexOf("SELECT")!=-1) {
76.             int fromIndex=hql.toUpperCase().indexOf("FROM");
77.             queryString="select Count(*) "+hql.substring(fromIndex+1,hql.length());
78.         }else {
79.             queryString="select Count(*) "+hql;
80.         }
81.         if (queryString.toUpperCase().indexOf("ORDER")!=-1) {
82.             queryString=queryString.substring(0,queryString.toUpperCase().indexOf("ORDER"));
83.         }
84.         Query rowQuery=session.createQuery(queryString);
85.         rowQuery=setQuery(rowQuery, conditions);
86.         rowQuery.setCacheable(true);
87.         return Integer.parseInt(rowQuery.uniqueResult().toString());
88.     }
89.     
90. }

 

 

 

 

 

1. package com.shop.entity;
3. import java.util.List;
5. /**
6.  * 分页实体类
7.  * @author Administrator
8.  *
9.  */
10. public class Pagination {
11.     private int pageIndex;
12.     private int pageSize;
13.     private int allRows;
14.     private int pageCounts;
15.     private List<Object> list;
17.     public Pagination(){}
18.     
19.     public Pagination(int pageIndex,int pageSize){
20.         this.pageIndex=pageIndex;
21.         this.pageSize=pageSize;
22.     }
23.     /**
24.      * 得到当前页是第几页
25.      * @return
26.      */
27.     public int getPageIndex() {
28.         return pageIndex;
29.     }
30.     /**
31.      * 设置当前页是第几页
32.      * @param pageIndex
33.      */
34.     public void setPageIndex(int pageIndex) {
35.         this.pageIndex = pageIndex;
36.     }
37.     /**
38.      * 得到页大小
39.      * @return 
40.      */
41.     public int getPageSize() {
42.         return pageSize;
43.     }
44.     /**
45.      * 设置页大小
46.      * @param pageSize
47.      */
48.     public void setPageSize(int pageSize) {
49.         this.pageSize = pageSize;
50.     }
51.     /**
52.      * 设置总页数
53.      * @return
54.      * @throws Exception
55.      */
56.     public void setPageCounts() throws Exception {
57.         if (pageSize==0) {
58.             throw new Exception("页尺寸不能为0!");
59.         }
60.         if (allRows%pageSize==0) {
61.             this.pageCounts=allRows/pageSize;
62.             
63.         }else {
64.             this.pageCounts=allRows/pageSize+1;
65.         }
66.     }
67.     /**
68.      * 得到总页数
69.      * @return
70.      */
71.     public int getPageCounts(){
72.         return this.pageCounts;
73.     }
74.     /**
75.      * 得到总行数
76.      * @return
77.      */
78.     public int getAllRows() {
79.         return allRows;
80.     }
81.     /**
82.      * 设置总行数
83.      * @param allRows
84.      */
85.     public void setAllRows(int allRows) {
86.         this.allRows = allRows;
87.     }
88.     /**
89.      * 得到分页记录集合
90.      * @return
91.      */
92.     public List<Object> getList() {
93.         return list;
94.     }
95.     /**
96.      * 设置分页记录集合
97.      * @param list
98.      */
99.     public void setList(List<Object> list) {
100.         this.list = list;
101.     

}

 

 

 

页面控制

1. 1.                 <c:if test="${requestScope.pagination.list!=null}">
   2.                    <c:set var="page" value="${requestScope.pagination}"/>
   3.                    <c:choose>
   4.                         <c:when test="${page.pageIndex==1}">
   5.                             <span><c:out value="首　页  上一页"/></span>
   6.                         </c:when>
   7.                         <c:otherwise>
   8.                                  <a href="mer.do?method=doBrowserSMer&pageIndex=1&" class="blueText"><span class="blueText">首　页</span></a> 
   9.                                  <a href="mer.do?method=doBrowserSMer&pageIndex=${page.pageIndex-1}" class="blueText"><span class="blueText">上一页</span></a> 
   10.                         </c:otherwise>
   11.                    </c:choose>
   12.                     <c:choose>
   13.                         <c:when test="${page.pageIndex==page.pageCounts || page.pageCounts==0}">
   14.                             <span><c:out value=" 下一页 末　页"/></span>
   15.                         </c:when>
   16.                         <c:otherwise>
   17.                             <a href="mer.do?method=doBrowserSMer&pageIndex=${page.pageIndex+1}" class="blueText"><span class="blueText">下一页</span></a> 
   18.                             <a href="mer.do?method=doBrowserSMer&pageIndex=${page.pageCounts}" class="blueText"><span class="blueText">末　页</span></a> 
   19.                         </c:otherwise>              
   20.                     </c:choose>
   21.         </c:if>
   22.                     　当前第[<span class="redText">${page.pageIndex}</span>]页
   23.                     　共[<span class="redText">${page.pageCounts}</span>]页　
   24.                     　每页[<span class="redText">${page.pageSize}</span>]条
   25.                     　共[<span class="redText">${page.allRows}</span>]条