• 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>

    效果展示

  • 相关阅读:
    五分钟秒懂机器学习混淆矩阵、ROC和AUC
    五分钟学会Python装饰器,看完面试不再慌
    LeetCode54 螺旋矩阵,题目不重要,重要的是这个技巧
    Golang——变量的声明与定义
    LeetCode52题,别再问我N皇后问题了
    spark中的pair rdd,看这一篇就够了
    MySQL不香吗,为什么还要有noSQL?
    JBOSS安装配置详细教程
    Aspose.Words关于域的应用
    SqlServer PIVOT行转列
  • 原文地址:https://www.cnblogs.com/xiaotian-222/p/6739923.html
Copyright © 2020-2023  润新知