方式2.使用mybatis插件
1.pom.yml中添加依赖
<!-- mybatis 分页插件 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.10</version>
</dependency>
2.添加配置类
@Configuration
public class MyBatisConfiguration {
@Bean
public PageHelper pageHelper() {
System.out.println("MyBatisConfiguration.pageHelper()");
PageHelper pageHelper = new PageHelper();
Properties prop = new Properties();
prop.setProperty("offSetAsPageNum", "true");
prop.setProperty("rowBoundsWithCount", "true");
prop.setProperty("reasonable", "true");
pageHelper.setProperties(prop);
return pageHelper;
}
}
方法2.使用pagehelper-spring-boot-starter
1。pom.yml中添加依赖
<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper-spring-boot-starter -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.12</version>
</dependency>
2。application.propertie中添加配置
# pagehelper-spring-boot-starter配置
pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql
3。Pagehelper.startPage(pageIndex,pageSize)