spring boot集成pagehelper(两种方式)

首先在pom.xml中配置pagehelper的maven支持。 
 

 <dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper-spring-boot-starter</artifactId>
   <version>1.2.3</version>
</dependency>

 

1.在application.properties中添加分页配置

# 配置pageHelper分页插件的内容
pagehelper.helper-dialect=mysql
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql

或者在application.yml文件中添加分页配置

pagehelper:
 helperDialect: mysql
 reasonable: true
 supportMethodsArguments: true
 params: count=countSql

2.配置其bean类，热加载方便修改

   在注解涵盖package下面新建PageHeleperConfig

import com.github.pagehelper.PageHelper;
import java.util.Properties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
 


@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 pageHelper;
 }
 
}

pageHelper使用：

    @RequestMapping(value = "/select")
    public list<User> test{
        PageHelper.startPage(3 , 3);
        List<User> list= UserService.select();
        //得到分页的结果对象
        PageInfo<User> pageInfo= new PageInfo<>(list);
        //得到分页中的user条目对象
        List<User> pageList = pageInfo.getList();
        return list;
    }