舒大少博客

手机扫码查看

Springboot版本

<parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.2.6.RELEASE</version>
    <relativePath/> <!-- lookup parent from repository -->
</parent>

依赖

<!--分页助手-->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.3.0</version>
</dependency>

控制层

// 帖子管理
@RequestMapping("/posts")
public String posts(String pageIndex,String pageSize,HttpServletRequest request){
    // 判断页码和页大小
    int pageNum=0,pageSizes=0;
    if(pageIndex==null)pageNum=1;
    else pageNum=Integer.parseInt(pageIndex);
    if(pageSize==null)pageSizes=10;
    else pageSizes=Integer.parseInt(pageSize);

    BbsPostMapper postMapper = ss.getMapper(BbsPostMapper.class);
    // 设置分页
    PageHelper.startPage(pageNum,pageSizes);
    // 查询所有
    List<BbsPost> bbsPost = postMapper.getAllBbsPost2();

    BbsItemMapper itemMapper = ss.getMapper(BbsItemMapper.class);
    HashSet<BbsItem> itemHashSet=new HashSet<>();
    // 封装数据
    PageInfo<BbsPost> pageInfo=new PageInfo<>(bbsPost);

    for (BbsPost bbsPosts : pageInfo.getList()) {
        BbsItem bbsItem = itemMapper.selectByPrimaryKey(bbsPosts.getItemid());
        itemHashSet.add(bbsItem);
    }
    request.setAttribute("itemHashSet",itemHashSet);
    request.setAttribute("bbsPost",bbsPost);
    request.setAttribute("pageInfo",pageInfo);
    return "admin/posts";
}

页面分页

<div class="pages">
    <nav aria-label="Page navigation example">
        <ul class="pagination justify-content-center">
            <li class="page-item">
                <a class="page-link" href="/bbsServer/posts">首页</a>
            </li>
            <c:if test="${requestScope.pageInfo.isFirstPage!=true}">
                <li class="page-item">
                    <a class="page-link" href="/bbsServer/posts?pageIndex=${requestScope.pageInfo.prePage}">上一页</a>
                </li>
            </c:if>
            <c:forEach var="i" begin="1" end="${requestScope.pageInfo.pages}" >
                <li class="page-item">
                    <a class="page-link" href="/bbsServer/posts?pageIndex=${i}">${i}</a>
                </li>
            </c:forEach>
            <c:if test="${requestScope.pageInfo.isLastPage!=true}">
                <li class="page-item">
                    <a class="page-link" href="/bbsServer/posts?pageIndex=${requestScope.pageInfo.nextPage}">下一页</a>
                </li>
                <li class="page-item">
                    <a class="page-link" href="/bbsServer/posts?pageIndex=${requestScope.pageInfo.navigateLastPage}">尾页</a>
                </li>
            </c:if>
            <li class="page-item">
                <a class="page-link">共计${requestScope.pageInfo.total} 条数据</a>
            </li>
        </ul>
    </nav>
</div>