流程
1,maven 依赖
2,在 mybatis 配置文件启用插件
3,修改 service 层
依赖
1<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper --> 2<dependency> 3 <groupId>com.github.pagehelper</groupId> 4 <artifactId>pagehelper</artifactId> 5 <version>5.1.2</version> 6</dependency>
启用插件
1<plugins> 2 <plugin interceptor="com.github.pagehelper.PageInterceptor"> 3 <property name="helperDialect" value="mysql" /> 4 </plugin> 5</plugins>
service 层代码示例
1@Service("accountService") 2public class AccountServiceImpl implements IAccountService { 3 @Autowired 4 private AccountMapper am; 5 6 @Override 7 public PageInfo<Account> selectBySearch(Account record, String startDate, String endDate, String companyName, 8 Integer currentPage, Integer pageSize) { 9 10 // 如果没有传递分页属性值,默认第一页,每页10条数据 11 if(currentPage == null) { 12 currentPage = 1; 13 } 14 if(pageSize == null) { 15 pageSize = 10; 16 } 17 18 // 这是关键,设置分页属性 19 PageHelper.startPage(currentPage, pageSize); 20 21 // 和 mapper 接口文件中的方法一致 22 List<Account> list = am.selectBySearch(record, startDate, endDate, companyName); 23 24 // 分页成功,返回 25 PageInfo<Account> pageInfo = new PageInfo<>(list); 26 return pageInfo; 27 } 28}