jpa的分页实现

最新推荐文章于 2020-01-09 14:18:00 发布

转载最新推荐文章于 2020-01-09 14:18:00 发布 · 172 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/a565810497/p/9418662.html

文章标签：

#前端 #ViewUI

本文介绍了一个使用Spring MVC实现的分页查询功能，其中包括了后端控制器处理方法与前端页面的分页导航链接生成。通过PageRequest获取当前页码和每页显示数量，再调用repository查询数据，并将数据及总页数等信息传递给视图。

 @RequestMapping(value = "/show")
    public ModelAndView show( int page){
        ModelAndView mv = new ModelAndView();
        int size=8;
        PageRequest pageable=PageRequest.of(page,size);
        Page<Management> pageObject=managementRepository.findAll(pageable);
        //getTotalPages()返回总的页数
        int totalPage=pageObject.getTotalPages();
        //getTotalElements()返回总数
        long count=pageObject.getTotalElements();
        List<Management> managements=pageObject.getContent();
        mv.addObject("managements",managements);
        mv.addObject("count",count);
        mv.addObject("totalPage",totalPage);
        mv.addObject("page",page);
        mv.setViewName("/ShowManagement.btl");
        return mv;

    }

前端代码：

<div class="dataTables_paginate paging_simple_numbers" id="datatable-responsive_paginate">
    <ul class="pagination">
        <% if(page==0) { %>
        <li class="paginate_button previous disabled" id="datatable-responsive_previous">
            <a href="#" aria-controls="datatable-responsive" data-dt-idx="0"
               tabindex="0">前一页</a></li>
        <% }else{ %>
        <li class="paginate_button previous " id="datatable-responsive_previous1">
            <a href="/management/show?page=${page-1}" aria-controls="datatable-responsive" data-dt-idx="0"
               tabindex="0">前一页</a></li>
        <% } %>

        <% for (var i=1;i<=totalPage;i++) { %>
        <li class="paginate_button " ><a href="/management/show?page= ${i-1}"
                                        aria-controls="datatable-responsive"
                                        tabindex="0">${i}</a></li>
        <% }
        %>
        <% if(page==totalPage-1) { %>
        <li class="paginate_button previous disabled" id="datatable-responsive_previous2">
            <a href="#" aria-controls="datatable-responsive" data-dt-idx="0"
               tabindex="0">后一页</a></li>
        <% }else{ %>
        <li class="paginate_button next" id="datatable-responsive_next"><a href="/management/show?page=${page+1}"
                                                                           aria-controls="datatable-responsive"
                                                                           tabindex="0">后一页</a>
        </li>
        <% } %>
    </ul>
</div>