SpringBoot整合Mybaties分页插件PageHelper

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);

}