主要原因:
pagehelper依赖版本请选择
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
其次配置文件
* @create: 2020-10-28 16:46
**/
@Configuration
public class PageHelperConfig {
@Bean
public PageHelper getPageHelper() {
PageHelper pageHelper=new PageHelper();
Properties properties=new Properties();
properties.setProperty("helperDialect","mysql");
properties.setProperty("reasonable","true");
properties.setProperty("supportMethodsArguments","true");
properties.setProperty("params","count=countSql");
pageHelper.setProperties(properties);
return new PageHelper();
}
}
为啥要添加配置文件,
仔细看一下我的yml文件:
#pagehelper
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
希望对你有所帮助
一个问题困扰了我两个小时(小白)
有大佬提出更合适的解决方法,请在下方留言,非常感谢!!!