SpringBoot整合Mybaties分页插件PageHelper
一:pom.xml 引入pagehelper项目依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.6</version>
</dependency>
二 : 在springBoot启动时,初始化PageHelper配置参数
public class CustomerHoleApplication {
@Bean
public PageHelper pageHelper(){
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("offsetAsPageNum","true");
properties.setProperty("rowBoundsWithCount","true");
properties.setProperty("reasonable","true");
properties.setProperty("dialect","mysql"); //配置数据库的方言
pageHelper.setProperties(properties);
return pageHelper;
}
public static void main(String[] args) {
SpringApplication.run(CustomerHoleApplication.class, args);
}
}
三:Controller
@GetMapping("getDataTable")
public ResponseEntity<JSONObject> getDataTable(){
PageHelper.startPage(1, 10);
List<User> list = userService.getAllUser();
PageBean<User> pageData = new PageBean<>(1, 10, list.size());
pageData.setItems(list);
}