controller 层
/**
* 员工分页查询
* @param employeePageQueryDTO
* @return
*/
@GetMapping("/page")
@ApiOperation("员工分页查询")
public Result<PageResult> page(EmployeePageQueryDTO employeePageQueryDTO) {
log.info("员工分页查询 ， 参数为：{}" , employeePageQueryDTO);
PageResult pageResult = employeeService.queryPage(employeePageQueryDTO);
return Result.success(pageResult);
}
service层
/**
* 分页查询
* @param employeePageQueryDTO
* @return
*/
PageResult queryPage(EmployeePageQueryDTO employeePageQueryDTO);
serviceImpl层
这里实际上是使用了分页查询的插件
/**
* 员工分页查询
*
* @param employeePageQueryDTO
* @return
*/
@Override
public PageResult queryPage(EmployeePageQueryDTO employeePageQueryDTO) {
PageHelper.startPage(employeePageQueryDTO.getPage(), employeePageQueryDTO.getPageSize());
Page<Employee> page = employeeMapper.pageQuery(employeePageQueryDTO);
long total = page.getTotal();
List<Employee> result = page.getResult();
return new PageResult(total, result);
}
mapper层
/**
* 分页查询
* @param employeePageQueryDTO
* @return
*/
Page<Employee> pageQuery(EmployeePageQueryDTO employeePageQueryDTO);
XML 语句
<!--分页查询-->
<select id="pageQuery" resultType="com.sky.entity.Employee">
select * from employee
<where>
<if test="name != null and name != ''">
and name like concat('%',#{name},'%')
</if>
</where>
order by create_time desc
</select>