1. pom 文件
- 不要用 pagehelper-starter
<!-- pagehelper 依赖 -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.11</version>
</dependency>
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>2.1</version>
</dependency>
2. 配置 mybatisplus
package com.whu.config;
import com.baomidou.mybatisplus.autoconfigure.ConfigurationCustomizer;
import com.baomidou.mybatisplus.core.MybatisConfiguration;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import com.baomidou.mybatisplus.extension.plugins.pagination.optimize.JsqlParserCountOptimize;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
/**
* @author Hedon Wang
* @create 2020-07-18 13:49
*/
@Configuration
public class MybatisPlusConfig {
@Bean
public PaginationInterceptor paginationInterceptor() {
return new PaginationInterceptor();
}
@Bean
public ConfigurationCustomizer mybatisConfigurationCustomizer() {
return new ConfigurationCustomizer() {
@Override
public void customize(org.apache.ibatis.session.Configuration configuration) {
configuration.addInterceptor(new com.github.pagehelper.PageInterceptor());
}
};
}
}
3. 分页查询
@GetMapping("/algorithms")
public CommonResult selectAllAlgorithms(@RequestParam(value = "pageNum",defaultValue = "1")Integer pageNum,
@RequestParam(value = "pageSize",defaultValue = "6")Integer pageSize,
@RequestParam(value = "keyWord",defaultValue = "")String keyWord){
//1. 开启分页查询
PageHelper.startPage(pageNum,pageSize);
//2. 从数据库拉取信息
List<AlgorithmResponseVo> algorithmResponseVos = algorithmService.getAllFullAlgorithms(keyWord);
//3. 封装到 pageInfo 中
PageInfo pageInfo = new PageInfo(algorithmResponseVos,5);
//4. 传给前端
return CommonResult.success().add("pageInfo",pageInfo);
}
这样就可以用了~
感谢该参考文章:https://blog.csdn.net/u012280292/article/details/99678037