• SSM实现paghleper插件分页


    第一步:引入分页插件

    <!--引入pageHelper分页插件 -->
      <dependency>
       <groupId>com.github.pagehelper</groupId>
       <artifactId>pagehelper</artifactId>
       <version>4.1.5</version>
      </dependency>

    第二步:在src/main/resourse下面新建一个sqlConfig.xml文件

    <?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
      PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
      "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>

        <!-- mybatis分页插件 -->
        <plugins>
            <plugin interceptor="com.github.pagehelper.PageHelper"></plugin>
        </plugins> 
    </configuration>

    第三步:controller类

     /**
         * 分页查询用户信息
         * @param pn 默认从第一页开始  请求参数
         * @param model
         * @return
         */
        @RequestMapping("/showUser.do")
        public String getUsers(@RequestParam(value="pn",defaultValue="1")Integer pn,Model model){
            //从第一条开始 每页查询五条数据
         PageHelper.startPage(pn, 5);
            List<User> users = userService.selectUser();
            System.out.println(users.size());
            //将用户信息放入PageInfo对象里
            PageInfo page = new PageInfo(users,5);
            model.addAttribute("pageInfo", page);
            model.addAttribute("userList",users);
            return "index";
        }

    第四步:jsp页面

     <!-- 分页信息 -->
            <div class="row">
                <!-- 分页文字信息,其中分页信息都封装在pageInfo中 -->
                <div class="col-md-6">
                    当前第:${pageInfo.pageNum}页,总共:${pageInfo.pages}页,总共:${pageInfo.total}条记录
                </div>
            <!-- 分页条 -->
                <div class="col-md-6">
                    <nav aria-label="Page navigation">
                      <ul class="pagination">
                        <li><a href="${pageContext.request.contextPath}/showUser.do?pn=1">首页</a></li>
                        <c:if test="${pageInfo.hasPreviousPage }">
                             <li>
                              <a href="${path}/showUser.do?pn=${pageInfo.pageNum-1}" aria-label="Previous">
                                <span aria-hidden="true">&laquo;</span>
                              </a>
                            </li>
                        </c:if>
                        <c:forEach items="${pageInfo.navigatepageNums }" var="page_Num">
                            <c:if test="${page_Num == pageInfo.pageNum }">
                                <li class="active"><a href="#">${ page_Num}</a></li>
                            </c:if>
                            <c:if test="${page_Num != pageInfo.pageNum }">
                                <li><a href="${pageContext.request.contextPath}/showUser.do?pn=${ page_Num}">${ page_Num}</a></li>
                            </c:if>
                        </c:forEach>
                        <c:if test="${pageInfo.hasNextPage }">
                            <li>
                              <a href="${pageContext.request.contextPath}/showUser.do?pn=${pageInfo.pageNum+1}" aria-label="Next">
                                <span aria-hidden="true">&raquo;</span>
                              </a>
                            </li>
                        </c:if>  
                        <li><a href="${pageContext.request.contextPath}/showUser.do?pn=${pageInfo.pages}">末页</a></li>
                      </ul>
                    </nav>
                </div>
            </div>
       
      </div>
     </div>
     

    这就完成了利用分页插件实现分页功能.

  • 相关阅读:
    win10如何将现有的桌面壁纸找出来
    js 显示网站当前访客是几位访客
    SELECT DISTINCT 取列中所有不重复的值
    mysql5.6和8.0中都没有len()函数,获取字符串长度的函数是length()
    TOP 子句用于规定要返回的记录的数目。
    sqlmap提示you haven't updated sqlmap for more than 126 days!!!
    利用代码生成a-z的所有字母的指定长度的组合字典
    生成图形验证码 将图形验证码流写到前台
    JDK历史版本
    mysql 数据库隔离级别
  • 原文地址:https://www.cnblogs.com/shenzhenhuaya/p/sdfsdsrfg.html
Copyright © 2020-2023  润新知