day09 瑞吉外卖二 员工分页查询

 

 

config包下

/**
 * mp分页查询配置类
 */
public class MybatisPlusConfig {
    @Bean
     public MybatisPlusInterceptor mybatisPlusInterceptor(){
           MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
           mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor());
           return mybatisPlusInterceptor;
     }
}

 /**
     * 员工分页查询和条件查询
     */

    @GetMapping("/page")
    public R<Page> page(int pageSize, int page, String name) {
        log.info("page={},pageSize={},name={}", page, pageSize, name);
        Page pageInfo = new Page(page, pageSize);

        //构造条件构造器
        LambdaQueryWrapper<Employee> queryWrapper = new LambdaQueryWrapper();
        //添加过滤条件
        queryWrapper.like(StringUtils.isNotEmpty(name), Employee::getName, name);
        //添加排序条件
        queryWrapper.orderByDesc(Employee::getUpdateTime);

        //执行查询
        employeeService.page(pageInfo, queryWrapper);

        return R.success(pageInfo);
    }