为什么使用pagehelper?
在使用mybatis进行分页时,要么需要编写sql进行分页,要么需要对结果集进行分页操作,当功能复杂之后,不方便拓展以及复用。pagehelper使用时,不需要去关心怎么实现的分页操作,你只管给它参数就好,同时也方便前端获取数据。
依赖
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
配置文件application.properties
#pagehelper
pagehelper.helperDialect=postgresql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql
代码
/**
* 分页请求入参对象
*/
public class PageRequest {
/**
* 当前页码
*/
private Integer pageNum;
/**
* 每页数量
*/
private Integer pageSize;
public Integer getPageNum() {
return pageNum;
}
public void setPageNum(Integer pageNum) {
this.pageNum = pageNum;
}
public Integer getPageSize() {
return pageSize;
}
public void setPageSize(Integer pageSize) {
this.pageSize = pageSize;
}
}
package com.example.demo.service;
import com.example.demo.dao.DomeDaoMapper;
import com.example.demo.entity.Dome;
import com.example.demo.page.PageRequest;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
/**
* @creator wangli66
* @create-time 17:17 2019/12/26
**/
@Component
@Transactional
public class DomeServiceImpl implements DomeService {
@Autowired
private DomeDaoMapper domeDaoMapper;
/**
* 分页查询,使用pageHelper隔离sql的变化
*
* @param pageRequest
* @return
*/
@Override
public PageInfo<Dome> findAllPage(PageRequest pageRequest) {
int pageNum = pageRequest.getPageNum() == null ? 1 : pageRequest.getPageNum();
int pageSize = pageRequest.getPageSize() == null ? 10 : pageRequest.getPageSize();
PageHelper.startPage(pageNum, pageSize);
List<Dome> domes = domeDaoMapper.findAll();
return new PageInfo<Dome>(domes);
}
}