多数据操作

逻辑删除

删除操作业务问题:业务数据从数据库中丢弃 逻辑删除:为数据设置是否可用状态字段,删除时设置状态字段为不可用状态,数据保留在数据库中

package com.xxx.domain;

@Data
@TableName("tbl_user")
public class User {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    @TableField(value = "pwd", select = false)
    private String password;
    private Integer age;
    private String tel;
    @TableField(exist = false)
    private Integer online;
    // 逻辑删除字段,标记当前记录是否被删除
    @TableLogic(value = "0", delval = "1")
    private Integer delted;
}
mybatis-plus:
  configuration:
    log-impl: org.apache.itbatis.logging.stdout.StdOutImpl
  global-config:
    banner: false
    db-config:
      id-type: assign_id # 实体类中表名不需要在使用@TableId注解
      table-prefix: tbl_ # 给实体类类名加前缀
      logic-delete-field: deleted # 不需要写@TableLogic注解
      logic-not-delete-value: 0
      logic-deletec-value: 1