PageHelper 分页的实例

后端代码

//做一个显示全部的
@RequestMapping("/goto_shopkeeperJSP")
public String goto_shopkeeperJSP(@RequestParam(value = "pn", required = false, defaultValue = "1")Integer pn , Model model){
   //暂时不做商家登录界面
//这个一定要先写在查询前面，一般是这样
   PageHelper.startPage(pn,5);

   List<Shopkeeper>  shopkeeperList01= shopkeeperService.selectAll();

//这个要写后面，注意上面一行代码的集合名字和下面的一致

   PageInfo pageInfos = new PageInfo(shopkeeperList01, 5);

   System.out.println(pageInfos + " from ShopkeeperController");

   model.addAttribute("pageInfos", pageInfos);

   return "shopkeeper";
}

前端代码

<table>
    <thead>
    <tr>
        <th>商家姓名</th>
        <th>订单号</th>
        <th>买家id</th>
        <th>余额</th>
        <th>交易时间</th>
    </tr>
    </thead>
    <tbody>
//这里注意，是pageInfos.list 而不是model里面的pageInfos

    <c:forEach items="${pageInfos.list}" var="page">
        <tr>
            <td>${page.id}</td>
            <td>${page.keepername}</td>
            <td>${page.exchange_id}</td>
            <td>${page.buyerid}</td>
            <td>${page.keepercount}</td>
            <td><fmt:formatDate value="${page.exchange_time}" pattern="yyyy-MM-dd HH:mm:ss"></fmt:formatDate></td>
        </tr>
    </c:forEach>
    </tbody>
</table>

//上面是数据显示，下面是分页

 

<div class="col-md-6">
    当前是第 ${pageInfos.pageNum} 页，总共是 ${pageInfos.pages} 页, 总共有 ${pageInfos.total} 条信息

</div>

 

<div class="col-md-6">
    <nav aria-label="Page navigation">
        <ul class="pagination">
            <li><a href="${pageContext.request.contextPath}/shopkeeper/goto_shopkeeperJSP?pn=1">首页</a></li>

            <c:if test="${ pageInfos.hasPreviousPage}">
                <li>
                    <a href="${pageContext.request.contextPath}/shopkeeper/goto_shopkeeperJSP?pn=${pageInfos.pageNum-1}" aria-label="Previous">上一页</a>
                </li>
            </c:if>

            <c:forEach items="${pageInfos.navigatepageNums}" var="page_Num">
                <c:if test="${page_Num == pageInfos.pageNum }">
                    <li class="active"><a href="#">${page_Num }</a></li>

                </c:if>
                <c:if test="${page_Num != pageInfos.pageNum }">
                    <li><a href="${pageContext.request.contextPath}/shopkeeper/goto_shopkeeperJSP/?pn=${page_Num }">${page_Num }</a></li>

                </c:if>

            </c:forEach>
            <c:if test="${pageInfos.hasNextPage}">
                <li>
                    <a href="${pageContext.request.contextPath}/shopkeeper/goto_shopkeeperJSP?pn=${pageInfos.pageNum +1}" aria-label="Next">
                       下一页
                    </a>
                </li>

            </c:if>
            &nbsp;&nbsp;
            <li><a href="${pageContext.request.contextPath}/shopkeeper/goto_shopkeeperJSP?pn=${pageInfos.pages}">末页</a></li>
        </ul>
    </nav>
</div>

//页面展示

 

//分页功能可以正常使用

 

//还有就是pagehelper出现问题可以参考

https://blog.youkuaiyun.com/qq_40995335/article/details/80845914