We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
分页时错误,总共只有9条记录,查询第100页时,理论上应该显示null,但是将最后一条数据返回。 page 传入100 size 传入 2 ,理论上应该为空,但是实际上却是返回了最后一条记录。请大佬解惑下
@GetMapping("/getRecord") public Result getRecord( @RequestParam(value="page", required= true) Integer page, @RequestParam(value="size", required= true) Integer size ){ PageHelper.startPage(page, size); List<ProgramUpgrade> all = programUpgradeRepos.getAll(); PageInfo<ProgramUpgrade> info = new PageInfo(all); log.info("info:{}",info); return Result.ok(0,"获取成功",all,info.getTotal()); }
@Select("select * from programUpgrade order by date desc ") List<ProgramUpgrade> getAll();
sql语句打印如下:
[15:20:33.026] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 132 connectionLog - {conn-10005} pool-connect [15:20:33.027] DEBUG org.mybatis.spring.transaction.SpringManagedTransaction 87 openConnection - JDBC Connection [com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl@27aa66dc] will not be managed by Spring [15:20:33.027] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: SELECT count(0) FROM programUpgrade [15:20:33.029] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters: [15:20:33.030] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20002, rs-50001} open [15:20:33.030] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20002, rs-50001} Header: [count(0)] [15:20:33.031] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20002, rs-50001} Result: [9] [15:20:33.032] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - <== Total: 1 [15:20:33.032] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20002, rs-50001} closed [15:20:33.034] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Preparing: select * from programUpgrade order by date desc LIMIT ?, ? [15:20:33.036] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - ==> Parameters: 8(Integer), 2(Integer) [15:20:33.039] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20003, rs-50002} open [15:20:33.039] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20003, rs-50002} Header: [id, md5FileContent, compressFileName, compressFileMd5Code, date, username] [15:20:33.039] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20003, rs-50002} Result: [1, 57e63128ef2fbe861e7526a254e93316 MyUpdateFile.tgz, MyUpdateFile.tgz, null, 2020-09-07 15:36:50.0, null] [15:20:33.040] DEBUG org.apache.ibatis.logging.jdbc.BaseJdbcLogger 159 debug - <== Total: 1 [15:20:33.040] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 142 resultSetLog - {conn-10005, pstmt-20003, rs-50002} closed [15:20:33.041] DEBUG org.mybatis.spring.SqlSessionUtils 191 closeSqlSession - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@7e96f57b] [15:20:33.041] DEBUG com.alibaba.druid.filter.logging.Log4j2Filter 132 connectionLog - {conn-10005} pool-recycle [15:20:33.042] INFO com.xinda.controller.ProgramUpgradeController 90 getRecord - info:PageInfo{pageNum=5, pageSize=2, size=1, startRow=9, endRow=9, total=9, pages=5, list=Page{count=true, pageNum=5, pageSize=2, startRow=8, endRow=10, total=9, pages=5, reasonable=true, pageSizeZero=false}[ProgramUpgrade(id=1, md5FileContent=57e63128ef2fbe861e7526a254e93316 MyUpdateFile.tgz, compressFileName=MyUpdateFile.tgz, compressFileMd5Code=null, date=Mon Sep 07 15:36:50 CST 2020, username=null)], prePage=4, nextPage=0, isFirstPage=false, isLastPage=true, hasPreviousPage=true, hasNextPage=false, navigatePages=8, navigateFirstPage=1, navigateLastPage=5, navigatepageNums=[1, 2, 3, 4, 5]}
The text was updated successfully, but these errors were encountered:
已经升级到最新版
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <!--<version>1.2.13</version>--> <version>1.3.0</version> </dependency>
Sorry, something went wrong.
No branches or pull requests
分页时错误,总共只有9条记录,查询第100页时,理论上应该显示null,但是将最后一条数据返回。
page 传入100 size 传入 2 ,理论上应该为空,但是实际上却是返回了最后一条记录。请大佬解惑下
sql语句打印如下:
The text was updated successfully, but these errors were encountered: