PageHeplper使用

1、引入POM

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.2.0</version>
</dependency>

2、Mybatis添加PageHepler配置

@Bean
public PageInterceptor pageInterceptor(){
        PageInterceptor pageInterceptor = new PageInterceptor();
        Properties properties=new Properties();
        properties.setProperty("helperDialect","mysql");
        properties.setProperty("helperDialect","mysql");
        properties.setProperty("reasonable","true");
        properties.setProperty("supportMethodsArguments","true");
        properties.setProperty("params","count=countSql");
        pageInterceptor.setProperties(properties);
        return pageInterceptor;
}

3、代码中使用

public PageInfo<OauthClientDetail> listByPage(Integer page, Integer limit){
        PageHelper.startPage(page,limit);
        List<OauthClientDetail> oauthClientDetails = oauthClientDetailsMapper.listByPage();
        return PageInfo.of(oauthClientDetails);
    、}