1.首先导入jar包,三种jar都不要缺少,尤其第二个,缺少启动会报错(深深有体会)
<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. 接着在application.properties中添加配置
#pagehelper配置 pagehelper.helperDialect: mysql pagehelper.reasonable: true pagehelper.supportMethodsArguments: true pagehelper.params: count=countSql
3.最后就是在service中调用
PageHelper.startPage(pageNum, pageSize);//pageNum 页码 pageSize 每页显示条数 List<Card> list = cardMapper.selectCardList(cardStatus, tel, cardNo, cardPwd, batchNo); PageInfo<Card> pageInfo = new PageInfo<>(list);
4.自己亲自使用过应该是没什么问题,有问题的话欢迎来扰 (参考了很多大牛的博客,如果有相同希望告知我写上出处,小白一个,打扰了)