springboot2.X下pagehelper分页失效问题解决

...
	PageHelper.startPage(pagenum,1);
	List userList = userService.getLists();//只有紧接startpage的查询会被分页，后续的都不会
	PageInfo listPageInfo = new PageInfo(userList);
...

排除写法的问题，我的问题出在包引入上，先后尝试过1.2.5和1.2.3版本均无法正常分页。另外发现包冲突时，尽量不要屏蔽分页starter带的包，避免因为包的版本问题导致失效，最终成功的引入如下：

		
            com.github.pagehelper
            pagehelper-spring-boot-starter
            1.4.1














        

成功分页时控制台打印出的sql日志如下：

JDBC Connection [HikariProxyConnection@1526157060 wrapping oracle.jdbc.driver.T4CConnection@1bfe1615] will not be managed by Spring
==>  Preparing: SELECT count(0) FROM test_user
==> Parameters: 
<==    Columns: COUNT(0)
<==        Row: 3
<==      Total: 1
==>  Preparing: SELECt * FROM ( SELECt TMP_PAGE.*, ROWNUM PAGEHELPER_ROW_ID FROM ( SELECt id,user_name,pass_word,real_name,gmt_create,gmt_modified FROM test_user ) TMP_PAGE) WHERe PAGEHELPER_ROW_ID <= ? AND PAGEHELPER_ROW_ID > ?
==> Parameters: 1(Long), 0(Long)
<==    Columns: ID, USER_NAME, PASS_WORD, REAL_NAME, GMT_CREATE, GMT_MODIFIED, PAGEHELPER_ROW_ID
<==        Row: 1526446217821896706, zhangsan, 1111, 张三, null, null, 1
<==      Total: 1

以yml为例，开启mybatis日志输出，配置文件增加：

mybatis-plus:
	configuration:
    	log-impl: org.apache.ibatis.logging.stdout.StdOutImpl