Mybaties下的分页功能的实现

jsp页面

 1  <!-- 页码 -->
 2         <div class="ipRListNav2">
 3             <a href="zyxx.do?findZyxx&currentPage=1">首页</a>&nbsp;
 4             <c:forEach begin="1" end="${page.totalPage}" var="p" >
 5                 <c:choose>
 6                     <c:when test="${page.currentPage==p}">
 7                           <c:if test="${p==1}">
 8                              <c:if test="${page.totalPage>1}">
 9                                  <a href="zyxx.do?findZyxx&currentPage=${p+1}">下一页</a>&nbsp;
10                              </c:if>
11                          </c:if>
12                          <c:if test="${p>1}">                                                              
13                              <c:if test="${p<page.totalPage}">
14                                  <a href="zyxx.do?findZyxx&currentPage=${p-1}">上一页</a>&nbsp;
15                                  <a href="zyxx.do?findZyxx&currentPage=${p+1}">下一页</a>&nbsp;
16                              </c:if>
17                              <c:if test="${p==page.totalPage}">
18                                  <a href="zyxx.do?findZyxx&currentPage=${p-1}">上一页</a>&nbsp;
19                              </c:if>
20                          </c:if>
21                     </c:when>
22                 </c:choose> 
23                 </c:forEach>
24                     <a href="zyxx.do?findZyxx&currentPage=${page.totalPage}">末页</a>&nbsp;&nbsp;&nbsp;
25                           当前&nbsp;<span class="STYLE1">${page.currentPage}</span>/${page.totalPage}&nbsp;页&nbsp;转到
26                     <input name="pageIndex" id="pageIndex" class="navIpt" type="text" onblur="if(this.value=='' || Number(this.value)!=this.value)this.value=1;" value="1" />页&nbsp;
27                     <input name="" value="GO" class="navBtn" type="button" onclick="goPage2(document.getElementById('pageIndex').value);" />&nbsp;
28         </div>  
29                     <script type="text/javascript">
30                         function goPage2(currentPage){
31                         alert("go");
32                             var total = ${page.totalPage};
33                             var index = currentPage.indexOf(".");
34                             if(index!=-1){
35                                 alert("输入数字必须为整数！请重新输入！");
36                                 return;
37                             }
38                             if(currentPage<=0){
39                                 alert("输入必须大于0！请重新输入！");
40                                 return;
41                             }
42                             if(currentPage>total){
43                                 alert("输入数字过大！请重新输入！");
44                                 return;
45                             }
46                         
47                             location.href="zyxx.do?findZyxx&currentPage="+currentPage+"";
48                         }
49                     </script>
50

 

page 类

 

 1 package org.lq.ssm.page;
 2 
 3 public  class Page {
 4     
 5         // 分页时输入的参数
 6         private int currentPage = 1; // 当前页码
 7         private int pageSize = 10; // 每页显示的行数
 8 
 9         // 写分页SQL时需要的条件，由输入参数计算而来
10         private int begin; // 当前页的起始值
11         private int end; // 当前页的终止值
12         
13 
14         // 用于计算总页数
15         private int rows; // 总行数
16 
17         // 总页数，由rows和pageSize计算而来
18         private int totalPage;
19 
20         public int getBegin() {
21             begin = (currentPage - 1) * pageSize;
22             return begin;
23         }
24 
25         public int getEnd() {
26             end = currentPage * pageSize + 1;
27             return end;
28         }
29 
30         public int getTotalPage() {
31             if(rows==0){
32                 totalPage = 1;
33             }else if (rows % pageSize == 0) {
34                 totalPage = rows / pageSize;
35             } else {
36                 totalPage = rows / pageSize + 1;
37             }
38             
39             return totalPage;
40         }
41 
42         public int getCurrentPage() {
43             return currentPage;
44         }
45 
46         public void setCurrentPage(int currentPage) {
47             this.currentPage = currentPage;
48         }
49 
50         public int getPageSize() {
51             return pageSize;
52         }
53 
54         public void setPageSize(int pageSize) {
55             this.pageSize = pageSize;
56         }
57 
58         public int getRows() {
59             return rows;
60         }
61 
62         public void setRows(int rows) {
63             this.rows = rows;
64         }
65     
66 
67 }

 

Controller 

@RequestMapping(params="findZyxx")
    public String findZyxx(Page page,Model m){
        
        m.addAttribute("professionList", professionBiz.findAll(page));
        page.setRows( professionBiz.count());
        m.addAttribute("page",page);
        return "view/profession/professioninfo/professioninfo_list";
        
    }

实现类

 

1 public List<Profession> findAll(Page page) {
2         
3         int begin =page.getBegin();
4         int end= page.getEnd();
5         
6         return professionDao.findPage(begin,end);
7     }

mapper文件中sql

1  <select id="findPage" resultMap="profession_map">
2        
3         select * from (select a.*,rownum r from ( select * from zyml_table ) a) where r  &lt; #{end} and r &gt; #{begin}
4       <!--  select * from zyml_table -->
5         
6      </select>

 

效果展示

 

posted @ 2017-04-20 17:32  xiaotian_小天  Views(235)  Comments(0)  Edit  收藏  举报