devbox
花生_TL007
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

分页pageHelper_pagehelper需要 main allow

作者：花生_TL007 | 2024-03-18 11:43:03

赞

踩

pagehelper需要 main allow

1.application.properties

  1. # 解决升级springboot2.6 因循环引用导致启动时报错
  2. spring.main.allow-circular-references=true
  3.  
  4. # pagehelper
  5. #如果不配置会自动检测
  6. pagehelper.helperDialect=mysql
  7. #分页参数合理化
  8. pagehelper.reasonable=true
  9. #支持通过mapper接口参数来传递分页参数
  10. pagehelper.supportMethodsArguments=true
  11. #用于从对象属性名中取值
  12. pagehelper.params=count=countSql

2.pom.xml

  1.         <dependency>
  2.             <groupId>com.github.pagehelper</groupId>
  3.             <artifactId>pagehelper-spring-boot-starter</artifactId>
  4.             <version>1.2.5</version>
  5.             <exclusions>
  6.                 <exclusion>
  7.                     <groupId>org.mybatis</groupId>
  8.                     <artifactId>mybatis</artifactId>
  9.                 </exclusion>
  10.                 <exclusion>
  11.                     <groupId>mybatis-spring</groupId>
  12.                     <artifactId>org.mybatis</artifactId>
  13.                 </exclusion>
  14.             </exclusions>
  15.         </dependency>

3.测试

  1.   @Test
  2.     public void test2(){
  3.         PageHelper.startPage(5,2);
  4.         List<Book> bookList=bookMapper.selectList();
  5.         PageInfo pageInfo=new PageInfo(bookList);
  6.         System.out.println("总记录数："+pageInfo.getTotal());
  7.         System.out.println("总页数："+pageInfo.getPages());
  8.         System.out.println("一页的大小："+pageInfo.getSize());
  9.         System.out.println(pageInfo);
  10.     }

4.问题解决

报错原因：

依赖循环引用是不鼓励的，默认情况下是禁止的。更新应用程序以删除bean之间的依赖循环。作为最后的手段，可以通过设置spring.main来自动打破循环。allow-circular-references为true。

在application.properties文件中添加以下代码：

# 解决升级springboot2.6 因循环引用导致启动时报错

spring.main.allow-circular-references=true

  1. # 解决升级springboot2.6 因循环引用导致启动时报错
  2. spring.main.allow-circular-references=true
  1. package com.sunjob.zyx2.entity;
  2.  
  3. import lombok.Data;
  4.  
  5. @Data
  6. public class BaseDTO {
  7. //  当前查询第几页，从一开始
  8.     private Integer pageNow;
  9. //    每页查询多少条
  10.     private Integer pageSize;
  11. }
  1. package com.sunjob.zyx2.entity;
  2.  
  3. import lombok.AllArgsConstructor;
  4. import lombok.Data;
  5. import lombok.NoArgsConstructor;
  6.  
  7. import java.io.Serializable;
  8. @Data
  9. @NoArgsConstructor
  10. @AllArgsConstructor
  11. public class Book  extends BaseDTO implements Serializable{
  12.     private Integer bid;
  13.     private String name;
  14.     private String author;
  15.     private Long price;
  16.     private String sales;
  17.     private String stock;
  18.     private String image;
  19.     private String descc;
  20.  
  21.  
  22. }
  1. package com.sunjob.zyx2.entity;
  2.  
  3. import io.swagger.models.auth.In;
  4. import lombok.Data;
  5.  
  6. import java.util.List;
  7.  
  8. @Data
  9. public class TableResult<T> {
  10. //    查询聊天记录
  11.     private List<T> rows;
  12. //    总条数
  13.     private  Long totalCount;
  14. //    总的页数
  15.     private Long pageCount;
  16. //    上一页
  17.     private Long prepageNum;
  18. //    下一页
  19.     private Long nextpageNum;
  20. //    当前页
  21. //    private Long pageNum;
  22.  
  23.  
  24. //    设置总的页数
  25.     public void setPageCountByHelper(Long pageCount){
  26.         this.pageCount = pageCount;
  27.     }
  28.  
  29.     //    设置上一页
  30.     public void setprepageNum(Long pageNum){
  31.      if (pageNum==1){
  32.          this.prepageNum = 1L;
  33.      }else {
  34.          this.prepageNum = pageNum-1;
  35.      }
  36.     }
  37.  
  38.     //    设置下一页
  39.     public void setnextpageNum(Long pageNum){
  40.         this.nextpageNum = pageNum+1;
  41.     }
  42.  
  43. }
  1. package com.sunjob.zyx2.service;
  2.  
  3. import com.github.pagehelper.PageInfo;
  4. import com.sunjob.zyx2.entity.TableResult;
  5. import com.sunjob.zyx2.entity.Book;
  6.  
  7. import java.util.List;
  8. public interface BookService {
  9. //    分页第一步
  10.     TableResult<Book> listByPageViaPageHelper(Book book);
  11. }
  1. @Service
  2. public class BookServiceImpl  implements BookService {
  3.     @Autowired
  4.     private BookMapper bookMapper;
  5.  
  6.    @Override
  7.     public TableResult<Book> listByPageViaPageHelper(Book book) {
  8.  
  9. //        传入参数
  10.         PageHelper.startPage(book.getPageNow(),book.getPageSize());
  11.  
  12.         TableResult<Book> tableResult = new TableResult<>();
  13. //        总数据
  14.         List<Book> books = bookMapper.selectListByPageViaPageHelper(book);
  15.  
  16. //        不需要强制类型转换
  17.         PageInfo<Book> bookPageInfo=new PageInfo<>(books);
  18.         tableResult.setRows(bookPageInfo.getList());
  19.         tableResult.setTotalCount(bookPageInfo.getTotal());
  20.         tableResult.setPageCountByHelper((long) bookPageInfo.getPages());
  21.  
  22.         tableResult.setprepageNum((long) bookPageInfo.getPageNum());
  23.         tableResult.setnextpageNum((long) bookPageInfo.getPageNum());
  24. //        需要强制类型转换
  25. //        Page<Book> page=(Page<Book>) books;
  26. //        总条数
  27. //        Long totalCount = bookMapper.selectCount(book);
  28. //        tableResult.setRows(books);
  29. //        tableResult.setTotalCount(page.getTotal());
  30. //        tableResult.setPageCountByHelper(page.getPages());
  31.         return tableResult;
  32.     }
  33. }
  1. @RestController
  2. @RequestMapping("/book")
  3. public class BookController {
  4.     @Autowired
  5.     private BookService bookService;
  6.     @GetMapping("/list")  //等价于@RequestMapping(method = RequestMethod.GET)
  7. //@RequestParam是将请求参数绑定到控制器的方法参数上
  8. //@RequestParam(defaultValue="1") int pageNum, @RequestParam(defaultValue="3") int pageSize
  9.     public Object listPages(@RequestParam(defaultValue="1") int pageNum) {
  10.         if (pageNum <= 0) {
  11.             pageNum = 1;
  12.         }
  13. //        if (pageSize == null) {
  14. //            pageSize = 8; // 设置默认每页显示的数据数
  15. //        }
  16.         Book book=new Book();
  17.         Integer pageSize=3;
  18.         book.setPageNow(pageNum);
  19.         book.setPageSize(pageSize);
  20.         TableResult<Book> tableResult=bookService.listByPageViaPageHelper(book);
  21.         System.out.println(tableResult);
  22.         System.out.println(tableResult.getRows());
  23.         System.out.println(tableResult.getRows().size());
  24.         ModelAndView mv=new ModelAndView("add");
  25.         mv.addObject("page", tableResult.getRows());
  26.         mv.addObject("pagess", tableResult);
  27.         System.out.println(mv);
  28.         return mv;
  29.     }
  30.  
  31.  
  32. }
  1. @Mapper
  2. @Repository
  3. public interface BookMapper{
  4. //    分页第二步
  5.     List<Book> selectListByPageViaPageHelper(Book book);
  6. }
  1. <?xml version="1.0" encoding="UTF-8" ?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.sunjob.zyx2.mapper.BookMapper">
  6.     <sql id="whereComn">
  7.         <where>
  8.             <if test=' name !=null and name!="" '>
  9.                 name like concat('%',#{name},'%')
  10.             </if>
  11.         </where>
  12.     </sql>
  13. <!--    第三步-->
  14.     <select id="selectListByPageViaPageHelper" resultType="com.sunjob.zyx2.entity.Book">
  15.         select * from book
  16.         <include refid="whereComn"/>
  17.         order by bid asc
  18.     </select>
  19. </mapper>
  1. <!--<%@ page language="java" contentType="text/html; charset=UTF-8"-->
  2. <!--pageEncoding="UTF-8" %>-->
  3. <!--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>-->
  4. <!--文件头开始-->
  5. <!DOCTYPE>
  6. <!--<html xmlns:c="http://mybatis.org/schema/mybatis-mapper" xmlns:th="http://www.w3.org/1999/xhtml">-->
  7. <html lang="en" xmlns:th="http://www.thymeleaf.org">
  8. <meta charset="UTF-8">
  9. <title>Title</title>
  10. <head>
  11.  
  12.     <meta http-equiv="Content-Language" content="zh-cn">
  13.     <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  14.     <meta name="description" content="顾客信息表">
  15.     <title>所有顾客信息表</title>
  16.     <LINK href="../../css/main.css" rel=stylesheet>
  17.     <link rel="stylesheet" type="text/css" href="../../css/test3.css">
  18.     <script language="JavaScript" src="../../js/main.js"></script>
  19.     <script src="../../js/jquery-1.12.3.min.js"></script>
  20. <!--    <span th:text="${page}"/>-->
  21. </head>
  22. <body>
  23.  
  24. <div class="">
  25.     <table width="100%" border="0" cellspacing="0" cellpadding="0">
  26.         <tr>
  27.             <table width="100" border="0" cellspacing="0" cellpadding="0" align="center">
  28.             </table>
  29.             </td>
  30.         </tr>
  31.     </table>
  32.     <table cellspacing="1" cellpadding="3" align="center" border="0" width="98%">
  33.     </table>
  34.     <!--文件体开始-->
  35.     <br>
  36.     <br>
  37.     <table cellspacing=1 cellpadding=3 align=center class=tableBorder2>
  38.         <tr>
  39.             <td height=25 valign=middle bgcolor="#E4F3FF" align="center">
  40.                 <a href="AFirstLog">返回首页</a>
  41.             </td>
  42.             <td height=25 valign=middle bgcolor="#E4F3FF" align="center">
  43.                 <b>顾客信息如下！</b>
  44.             </td>
  45.         </tr>
  46.     </table>
  47.     <br>
  48.     <form method="get" name="reg" action="">
  49.         <table cellpadding="3" cellspacing="1" align="center" class="tableborder3" id="table1">
  50.             <tr>
  51.                 <td valign="middle" colspan="2" align="center" height="25" color="#9999FF">
  52.                     <font><b></b></font></td>
  53.             </tr>
  54.             <tr>
  55.                 <td width="10%" class="tablebody1" align="center"><b>客户编号</b>
  56.                 </td>
  57.                 <td width="10%" class="tablebody1" align="center"><b>用户名</b><br>
  58.                 </td>
  59.                 <td width="10%" class="tablebody1" align="center"><b>密码</b>
  60.                 </td>
  61.                 <td width="10%" class="tablebody1" align="center"><b>姓名 </b>
  62.                 </td>
  63.                 <td width="10%" class="tablebody1" align="center"><b>性别 </b>
  64.                 </td>
  65.                 <td width="10%" class="tablebody1" align="center"><b>年龄</b>
  66.                 </td>
  67.                 <td width="10%" class="tablebody1" align="center"><b>联系方式</b>
  68.                 </td>
  69.                 <td width="10%" class="tablebody1" align="center"><b>Email地址</b>
  70.                 </td>
  71.                 <td width="10%" class="tablebody1" align="center"><b>联系地址</b>
  72.                 </td>
  73.                 <td width="10%" class="tablebody1" align="center"><b>信息修改</b>
  74.                 </td>
  75.             </tr>
  76. <!--            current展示当前的user对象-->
  77. <!--            index是索引属性，从0开始-->
  78. <!--            count是计数，下标从1开始-->
  79. <!--            first，last，odd，even均是返回boolean值，分别判断下标是否为第一个/最后一个/奇数/偶数-->
  80. <!--            size指的是当前userList的大小，返回的是同一个值-->
  81. <!--            1.book指的是当前循环的对象的变量名称，可以随意定义，但要于下面 " . 属性"引用保持一致相当于增强for循环的临时变量；-->
  82. <!--            2.bookStat指当前循环对象状态的变量(可选，默认就是你第一步设置的对象变量名称+ Stat)-->
  83. <!--            3.${bookList }是当前循环的集合-->
  84. <!--            <c:forEach items="${page.rows}" var="book" begin="0" varStatus="stusts">-->
  85.             <tbody th:each="book,itemStats : ${page}" >
  86.                 <tr>
  87.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.bid}"/>
  88.                     </td>
  89.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.name}"/>
  90.                     </td>
  91.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.author}"/>
  92.                     </td>
  93.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.stock}"/>
  94.                     </td>
  95.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.sales}"/>
  96.                     </td>
  97.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.price}"/>
  98.                     </td>
  99.                     <td width="10%" class="tablebody1" align="center"><span th:text="${book.descc}"/>
  100.                     </td>
  101.                     <td width="10%" class="tablebody1" align="center"><img th:src="${book.image}" style="width: 200px;height: 200px"/>
  102.                     </td>
  103.                     <td width="10%" class="tablebody1" align="center"><span th:text="${itemStats.count}"/>
  104.                     </td>
  105.                     <td width="15%" class="tablebody1" align="center">
  106.                         <a href="ACInf?account=${customer.account}">修改</a>
  107.                     </td>
  108.                 </tr>
  109.             </tbody>
  110.         </table>
  111.  
  112.     </form>
  113.  
  114.     <div style="text-align: center;font-size: 15px;" id="p">
  115. <!--        <a th:href="@{/book/list?pageNum=2&pageSize=3}">超链接</a>-->
  116.         <a th:href="@{'/book'+'/list?'+'pageNum=1'}">第一页</a>
  117.         <a th:href="@{'/book'+'/list?'+'pageNum='+${pagess.prepageNum}}">上一页</a>
  118.         当前：<span th:text="${page.pageNum}"/>
  119.         <a th:href="@{'/book'+'/list?'+'pageNum='+${pagess.nextpageNum}}">下一页</a>
  120.         <a th:href="@{'/book'+'/list?'+'pageNum='+${page.pages}}">尾页</a>
  121.     </div>
  122. </div>
  123. </body>
  124. </html>
  125. <!--<span th:text="${page}"/>-->
声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/花生_TL007/article/detail/262781
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号