1.pom引入依赖

  1.    <!--*****************************引入分页插件********************************-->
  2.     <dependency>
  3.       <groupId>com.github.pagehelper</groupId>
  4.       <artifactId>pagehelper</artifactId>
  5.       <version>5.1.10</version>
  6.     </dependency>
  7.     <!-- pagehelper 依赖 -->
  8.     <dependency>
  9.       <groupId>com.github.jsqlparser</groupId>
  10.       <artifactId>jsqlparser</artifactId>
  11.       <version>2.1</version>
  12.     </dependency>
  13.     <!--*****************************引入分页插件********************************-->

2.Java代码中使用

注意配置：application.xml部分

  1. <!-- 配置 MyBatis SqlSessionFactoryBean-->
  2.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  3.         <property name="dataSource" ref="dataSource"/>
  4.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
  5.         <!-- 配置分页插件 -->
  6.         <property name="plugins">
  7.             <array>
  8.                 <bean class="com.github.pagehelper.PageInterceptor">
  9.                     <property name="properties">
  10.                         <!--使用下面的方式配置参数，一行配置一个 -->
  11.                         <value>
  12.                             helperDialect=mysql
  13.                         </value>
  14.                     </property>
  15.                 </bean>
  16.             </array>
  17.         </property>
  18.     </bean>
  1.   /**
  2.      * 分页展示手游信息列表（条件查询）
  3.      * @param pageNo
  4.      * @param AppInfo
  5.      * @return
  6.      */
  7.     @Override
  8.     public PageInfo<AppInfo> page(Integer pageNo, AppInfo AppInfo) {
  10.         PageHelper.startPage(pageNo, Constants.pageSize," creationDate desc ");
  12.         List<AppInfo> li=appInfoMapper.getList(AppInfo);
  13.         PageInfo<AppInfo> pageInfo=new PageInfo(li, Constants.pageSize);
  15.         return pageInfo;
  16.     }

3.前端jsp页面代码

  2.             <form action="${ctxf}/comment/scene/page" method="post">
  3.                 <input type="hidden" name="ticketDate" value="${o.ticketDate }">
  4.                 <%@ include file="page.jsp" %>
  5.             </form>

page.jsp如下：

  1. <%@ page language="java" contentType="text/html; charset=utf-8"
  2.     pageEncoding="utf-8"%> 
  4.  <c:if test="${pageInfo.size ==0 }">
  5.     <p style="text-align: center;">暂无数据</p>
  6. </c:if>
  7. <c:if test="${pageInfo.size >0 }">
  8.         <!-----------------------------------------分页插件-------------------------------------------->
  9.         <nav aria-label="Page navigation" id="fenye" style="text-align: center;">
  10.         <input type="hidden" value="${pageNo }" name="pageNo" id="pageNo"/>
  11.          <button type="submit" style="display: none" id="sub"></button>
  14.             <ul class="pagination">
  15.                 <!-----------------------------------------首页分割线-------------------------------------------->
  17.                 <li class="page-item"><a class="page-link" data-p=1
  18.                     href="javascript:;">首页</a></li>
  20.                 <!-----------------------------------------上一页分割线------------------------------------------>
  21.                 <c:if test="${pageInfo.hasPreviousPage && pageInfo.pageNum>1}">
  22.                     <li class="page-item"><a class="page-link"
  23.                                              href="javascript:;" data-p=${pageInfo.pageNum-1}
  24.                                                      aria-label="Previous"> <span aria-hidden="true">&laquo;</span>
  25.                     </a></li>
  26.                 </c:if>
  27.                 <!-----------------------------------------数字翻页分割线---------------------------------------->
  30.                 <c:if test="${pageInfo.pages<=10}">
  31.                     <c:forEach begin="1" end="${pageInfo.pages }" var="i">
  32.                         <c:choose>
  33.                             <c:when test="${i eq pageInfo.pageNum }">
  34.                                 <li class=" page-item active"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  35.                             </c:when>
  36.                             <c:otherwise>
  37.                                 <li class=" page-item"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  38.                             </c:otherwise>
  39.                         </c:choose>
  40.                     </c:forEach>
  41.                 </c:if>
  44.                 <c:if test="${pageInfo.pages>10}">
  45.                     <c:if test="${pageInfo.pageNum-5>0}">
  46.                         <c:if test="${pageInfo.pageNum+5>=pageInfo.pages}">
  47.                             <c:forEach begin="${pageInfo.pages-9 }" end="${pageInfo.pages}" var="i">
  48.                                 <c:choose>
  49.                                     <c:when test="${i eq pageInfo.pageNum }">
  50.                                         <li class=" page-item active"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  51.                                     </c:when>
  52.                                     <c:otherwise>
  53.                                         <li class=" page-item"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  54.                                     </c:otherwise>
  55.                                 </c:choose>
  56.                             </c:forEach>
  57.                         </c:if>
  58.                         <c:if test="${pageInfo.pageNum+5<pageInfo.pages}">
  59.                             <c:forEach begin="${pageInfo.pageNum-5 }" end="${pageInfo.pageNum+4}"
  60.                                 var="i">
  61.                                 <c:choose>
  62.                                     <c:when test="${i eq pageInfo.pageNum }">
  63.                                             <li class=" page-item active"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  64.                                     </c:when>
  65.                                     <c:otherwise>
  66.                                         <li class=" page-item"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  67.                                     </c:otherwise>
  68.                                 </c:choose>
  69.                             </c:forEach>
  70.                         </c:if>
  71.                     </c:if>
  72.                     <c:if test="${pageInfo.pageNum-5<=0}">
  73.                         <c:forEach begin="1" end="10" var="i">
  74.                             <c:choose>
  75.                                 <c:when test="${i eq pageInfo.pageNum }">
  76.                                         <li class=" page-item active"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  77.                                 </c:when>
  78.                                 <c:otherwise>
  79.                                      <li class=" page-item"><a href="javascript:;"  class="page-link" data-p=${i}>${i}</a></li>
  80.                                 </c:otherwise>
  81.                             </c:choose>
  82.                         </c:forEach>
  83.                     </c:if>
  84.                 </c:if>
  86.                 <!-----------------------------------------下一页分割线------------------------------------------>
  87.                 <c:if test="${pageInfo.pageNum>1&&pageInfo.pageNum+1<pageInfo.pages}">
  88.                     <li class="page-item"><a class="page-link"
  89.                         href="javascript:;" data-p=${pageInfo.pageNum+1}
  90.                         aria-label="Next"> <span aria-hidden="true">&raquo;</span>
  91.                     </a></li>
  93.                 </c:if>
  94.                 <!-----------------------------------------末页分割线-------------------------------------------->
  96.                 <li class="page-item"><a class="page-link"
  97.                     href="javascript:;" data-p=${pageInfo.pages}>末页</a></li>
  99.             </ul>
  100.         </nav>
  101.         <p style="text-align:center;clear: both;">共${pageInfo.total }条数据，当前是第${pageInfo.pageNum }页，每页${pageInfo.pageSize }条，共${pageInfo.pages }页</p>
  102. </c:if>
  106. <script type="text/javascript">
  107.  $("#fenye a").click(function(){
  108.      $("#pageNo").val( $(this).attr("data-p"));
  109.      $("#sub").click();
  110.      return false;
  111.  })
  112.  </script>