SSM Maven项目实现简单分页

最新推荐文章于 2020-10-19 16:04:00 发布

?????%

最新推荐文章于 2020-10-19 16:04:00 发布

阅读量747

点赞数 1

文章标签： maven 框架 sql 分页前端

本文链接：https://blog.csdn.net/yujiabao0725/article/details/78534988

版权

首先添加依赖的jar

<!-- 分页 -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>4.0.0</version>
</dependency>

j然后搭好框架就可以，然后创建bean ，dao，service，serviceImpl，

controller类，直接书写查询所有的信息方法就可以，

@RequestMapping(value = "/请求地址")
public String 方法名(Model model,@Param("pname")String pname,@RequestParam(value = "PageNum",defaultValue = "1")
        Integer PageNum, @RequestParam(value = "PageSize",defaultValue = "3") Integer PageSize) {
    PageHelper.startPage(PageNum,PageSize);
    List<phone> se = phoneService.selectphone(pname);
    PageInfo pageInfo=new PageInfo(se);
    model.addAttribute("pageInfo", pageInfo);
    return "完成后跳转的页面";

，然后直接去写sql语句直接写查询所有方法的sql语句就可以，然后去写前端页面（jsp）

（页面导入这个）//Bootstrap样式已经加好，如果想让页面更好看一些，就引入吧

<%
    String path = request.getContextPath();
    String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort() + path;
%>

，直接复制粘贴到下面就可以

<div class="row">

    <div style="font-weight: bold;font-size: 16px;font-family:'微软雅体';" class="col-md-7">

        共<i class="blue">${pageInfo.total}</i>条记录,
        当前显示第&nbsp;<i class="blue">${pageInfo.pageNum}/${pageInfo.pages}</i>&nbsp;页

    </div>


    <nav aria-label="Page navigation">
        <ul class="pagination">
            <c:if test="${!pageInfo.isFirstPage}">
                <li><a href="<%=basePath%>/phone/selphone.action?PageNum=1">首页</a></li>

                <li><a href="<%=basePath%>/phone/selphone.action?PageNum=${pageInfo.pageNum-1 }"
                       aria-label="Previous">
                    <span aria-hidden="true">&laquo;</span>
                </a>
                </li>
            </c:if>
            <c:forEach items="${pageInfo.navigatepageNums }" var="num">
                <c:if test="${num == pageInfo.pageNum }">
                    <li class="active"><a href="<%=basePath%>/phone/selphone.action?PageNum=${num }">${num }</a>
                    </li>
                </c:if>
                <c:if test="${num != pageInfo.pageNum }">
                    <li><a href="<%=basePath%>/phone/selphone.action?PageNum=${num }">${num }</a></li>
                </c:if>
            </c:forEach>
            <c:if test="${!pageInfo.isLastPage}">
                <li>
                    <a href="<%=basePath%>/phone/selphone.action?PageNum=${pageInfo.pageNum+1 }"
                       aria-label="Next">
                        <span aria-hidden="true">&raquo;</span>
                    </a>
                </li>
                <li><a href="<%=basePath%>/phone/selphone.action?PageNum=${pageInfo.lastPage}">尾页</a></li>
            </c:if>
        </ul>
    </nav>
</div>