一、POM坐标
< dependency>
< groupId> com.github.pagehelper</ groupId>
< artifactId> pagehelper-spring-boot-starter</ artifactId>
< version> 1.4.6</ version>
</ dependency>
二、基本使用
@Select ( "select* from emp" )
List < Emp > selectEmps ( ) ;
public PageBean page ( Integer pageNum, Integer pageSize) {
PageHelper . startPage ( pageNum, pageSize) ;
Page < Emp > page = ( Page < Emp > ) empMapper. selectEmps ( ) ;
PageBean pageBean = new PageBean ( page. getTotal ( ) , page. getResult ( ) ) ;
return pageBean;
}
三、条件分页查询
List < Emp > selectEmps ( String name, Integer deptId) ;
< select id = " selectEmps" >
select < include refid = " commonSelect" > </ include> from emp
< where>
< if test = " name != null and name != ''" >
and name like concat('%', #{name}, '%')
</ if>
< if test = " deptId != null" >
dept_id=#{deptId}
</ if>
</ where>
</ select>
public PageBean page ( String name, Integer deptId, Integer pageNum, Integer pageSize) {
PageHelper . startPage ( pageNum, pageSize) ;
Page < Emp > page = ( Page < Emp > ) empMapper. selectEmps ( name, deptId) ;
PageBean pageBean = new PageBean ( page. getTotal ( ) , page. getResult ( ) ) ;
return pageBean;
}