spring boot集成开源分页插件pagehelper

在实际项目中用到了开源的pagehelper，开始觉得用着还不错，但是后面数据量慢慢多了起来，还是觉得原始的分页配置limit，再查count好用，个人感觉吧。

1.pom.xml   
 <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper</artifactId>
      <version>5.1.2</version>
    </dependency>
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
      <version>1.2.3</version>
    </dependency>
    <dependency>
      <groupId>com.github.pagehelper</groupId>
      <artifactId>pagehelper-spring-boot-starter</artifactId>
      <version>1.2.3</version>
    </dependency>

2.配置Mysql方言
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;
  }

}

3.分页
PageHelper.startPage(当前页码, 每页数量);
PageInfo info = new PageInfo<>(infoList);

 

 

转载于:https://my.oschina.net/648885471/blog/1632266