Skip to content
New issue

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

分页 #172

Open
githublms opened this issue Sep 12, 2020 · 1 comment
Open

分页 #172

githublms opened this issue Sep 12, 2020 · 1 comment

Comments

@githublms
Copy link

分页时错误,总共只有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]}

@githublms
Copy link
Author

已经升级到最新版

<dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper-spring-boot-starter</artifactId>
            <!--<version>1.2.13</version>-->
            <version>1.3.0</version>
        </dependency>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant