• springboot+jpa分页(Pageable+Page)


    Pageable+Page实现分页无需配置,也不需要加入jar包(maven依赖)

    Controller控制层

    package com.gxuwz.late.controller;
    
    import com.gxuwz.late.bean.Record;
    import com.gxuwz.late.repository.RecordRepository;
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.data.domain.Page;
    import org.springframework.data.domain.PageRequest;
    import org.springframework.data.domain.Pageable;
    import org.springframework.data.domain.Sort;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import javax.servlet.http.HttpServletResponse;
    
    @Controller
    @RequestMapping("/manager")
    public class ManagerController {
        static Logger logger = LoggerFactory.getLogger(ManagerController.class);
    
        @Autowired
        RecordRepository recordRepository;
    
        @RequestMapping("/list")
        public String list(HttpServletResponse response, Model model, Integer pageNum){
                           
            if (pageNum == null){
                pageNum = 1;
            }
         // 排序方式,这里是以“recordNo”为标准进行降序 Sort sort
    = new Sort(Sort.Direction.DESC, "recordNo"); // 这里的"recordNo"是实体类的主键,记住一定要是实体类的属性,而不能是数据库的字段 Pageable pageable = new PageRequest(pageNum - 1, 6, sort); // (当前页, 每页记录数, 排序方式) Page<Record> list = recordRepository.findAll(pageable); logger.info("pageNum==" + pageNum); model.addAttribute("pageInfo", list); response.addHeader("x-frame-options","SAMEORIGIN"); // 允许iframe return "record_list"; } }

    html页面

          <table id = "table" class="table table-hover text-center">
                  <tr>
                    <th>晚归记录编号</th>
                    <th>宿舍楼编号</th>
                    <th>宿舍号</th>
                    <th>学号</th>
                    <th>班级</th>
                    <th>辅导员</th>
                    <th>晚归时间</th>
                    <th>晚归原因</th>
                    <th>操作</th>
                  </tr>
              
         <!--  pageInfo.getContent() 返回的是一个list      -->
                    <tr th:each="record:${pageInfo.getContent()}">
                        <td th:text="${record.recordNo }"></td>
                        <td th:text="${record.buildingNo }"></td>
                        <td th:text="${record.dorId }"></td>
                        <td th:text="${record.studentNo }"></td>
                        <td th:text="${record.className }"></td>
                        <td th:text="${record.instName }"></td>
                        <td th:text="${record.time }"></td>
                        <td th:text="${record.reason }"></td>
                    </tr>
                      <tr>
                        <td colspan="8">
                            <div class="pagelist">
                                <p>当前<span th:text="${pageInfo.getNumber()} + 1"></span>页,总<span th:text="${pageInfo.totalPages}"></span>页
                     共<span th:text="${pageInfo.totalElements}"></span>条记录 
                                <a th:href="@{/manager/list}">首页</a>
                                <a th:href="@{/manager/list(pageNum = ${pageInfo.hasPrevious()} ? ${pageInfo.getNumber() } : 1)}">上一页</a>
                                <a th:href="@{/manager/list(pageNum = ${pageInfo.hasNext()} ? ${pageInfo.getNumber()} + 2 : ${pageInfo.totalPages})}">下一页</a>
                                <a th:href="@{/manager/list(pageNum = ${pageInfo.totalPages})}">尾页</a></p>
                            </div>
    
                        </td>
                  </tr>
                </table>

    实现效果:

     

  • 相关阅读:
    (转)[Unity3D]计时器/Timer
    characterCustomezition的资源打包代码分析
    论文笔记:语音情感识别(四)语音特征之声谱图,log梅尔谱,MFCC,deltas
    论文笔记:语音情感识别(三)手工特征+CRNN
    论文笔记:语音情感识别(二)声谱图+CRNN
    论文笔记:2018 PRCV 顶会顶刊墙展
    论文笔记:Emotion Recognition From Speech With Recurrent Neural Networks
    CTC(Connectionist Temporal Classification)介绍
    论文笔记:语音情感识别(一)语音知识概览
    710 Random Pick with Blacklist
  • 原文地址:https://www.cnblogs.com/chuangqi/p/11261482.html
Copyright © 2020-2023  润新知