limit分页查询

 controller层

    @ApiOperation("员工分页查询")@GetMapping("/page")public Result<PageResult> page(EmployeePageQueryDTO employeePageQueryDTO){log.info("员工分页查询，参数为{}",employeePageQueryDTO);PageResult pageResult=employeeService.pageQuery(employeePageQueryDTO);return Result.success(pageResult);}

 Service层

    PageResult pageQuery(EmployeePageQueryDTO employeePageQueryDTO);

  ServiceImpl层

使用PageHelper插件进行自动分页

    @Overridepublic PageResult pageQuery(EmployeePageQueryDTO employeePageQueryDTO) {PageHelper.startPage(employeePageQueryDTO.getPage(),employeePageQueryDTO.getPageSize());Page<Employee> page = employeeMapper.pageQuery(employeePageQueryDTO);long total=page.getTotal();List<Employee> records=page.getResult();return new PageResult(total,records);}

 mapper层

 配置动态xml

    Page<Employee> pageQuery(EmployeePageQueryDTO employeePageQueryDTO);

    <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>