分页使用逻辑删除

Mp分页的使用

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;


@GetMapping("/page")
    public R<Page> page(int page,int pageSize,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);
    }

逻辑删除先在yml文件的mp全局配置中加上logic-delete-field、logic-delete-field、logic-not-delete-value配置，然后再在实体类中加上@TableLogic(value = "0", delval = "1")注解

mybatis-plus:

  configuration:
    #在映射实体或者属性时，将数据库中表名和字段名中的下划线去掉，按照驼峰命名法映射
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl

  global-config:
    db-config:
      id-type: ASSIGN_ID
      logic-delete-field: isDeleted #逻辑删除的字段
      logic-delete-field: 1 # 逻辑已删除值
      logic-not-delete-value: 0 #默认没有删除

例如：

@TableLogic(value = "0", delval = "1")
    private Integer isDeleted;