1.注入依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
2. 配置 application.yml
#pagehelper分页配置
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
3.Controller层使用
public interface ArticleMapper {
@Select("select * from tb_article")
public List<Article> getArticleById ();
}
public String pageArticle(@RequestParam(defaultValue = "1")Integer pageNum,
@RequestParam(defaultValue = "10")Integer pageSize,Model model ){
PageHelper.startPage(pageNum,pageSize);
List<Article> article = articleService.getArticleIndex();
PageInfo<Article> alist = new PageInfo<Article>(article);
model.addAttribute("alist",article);
}