# Springboot配置Mybatis Plus逻辑删除、updateTime与insertTime字段

1、添加依赖

        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.4.3</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.47</version>
        </dependency>

2、配置application.yml

spring:
  application:
    name: springboot-mybatis-learn

  jackson:
    date-format: yyyy-MM-dd HH:mm:ss # 设置日期格式化

  datasource:
    url: jdbc:mysql://localhost:3306/springsecurity?useUnicode=true&characterEncoding=utf-8
    driver-class-name: com.mysql.jdbc.Driver
    username: root
    password: 123456

mybatis-plus:
  mapper-locations: classpath:/mapper/**/*.xml # 配置xml映射文件
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl # 配置日志实现
  global-config:
    db-config:
      id-type: assign_id # ID策略
      logic-delete-field: deleted # 逻辑删除字段名
      logic-not-delete-value: 0 # 逻辑删除未删除的值
      logic-delete-value: 1 # 已删除的值
  type-aliases-package: dev.xuanran.springsecurity

3、创建数据库表

create table springsecurity.sys_user
(
    id          varchar(50) not null
        primary key,
    username    varchar(20) not null,
    password    varchar(20) not null,
    role_id     varchar(20) null,
    deleted     int         null,
    create_time datetime    null,
    update_time datetime    null
)
    comment '用户表' charset = utf8mb4;

4、创建实体类

package dev.xuanran.springsecurity.bean;

import com.baomidou.mybatisplus.annotation.*;

import java.io.Serializable;
import java.time.LocalDateTime;
import java.util.Date;

import lombok.Data;

/**
 * 用户表
 * @TableName sys_user
 */
@TableName(value ="sys_user")
@Data
public class SysUser implements Serializable {
    @TableId
    private String id;

    private String username;

    private String password;

    private String roleId;

    @TableLogic // 逻辑删除
    @TableField(fill = FieldFill.INSERT) // 逻辑删除在java层面自动配置时需要加上此注解，也可以在数据库层面默认设置为0
    private Integer deleted;

    @TableField(fill = FieldFill.INSERT) // 设置在数据插入时自动填充当前时间
    private Date createTime;

    @TableField(fill = FieldFill.INSERT_UPDATE) // 数据更新和插入时自动填充字段
    private Date updateTime;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;
}

5、创建Mapper映射

package dev.xuanran.springsecurity.mapper;

import dev.xuanran.springsecurity.bean.SysUser;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author XuanRan
* @description 针对表【sys_user(用户表)】的数据库操作Mapper
* @createDate 2022-10-03 17:21:53
* @Entity dev.xuanran.springsecurity.bean.SysUser
*/
public interface SysUserMapper extends BaseMapper<SysUser> {

}

6、创建字段填充规则

package dev.xuanran.springsecurity.handle;

import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import lombok.extern.slf4j.Slf4j;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;

import java.util.Date;

/**
 * Created by XuanRan on 2022/10/2
 * 当Mybatis进行数据插入和更新时执行
 */
@Slf4j
@Component
public class MybatisPlusTableFieldHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        // 插入数据时执行此方法
        setFieldValByName("deleted", 0, metaObject);
        setFieldValByName("createTime", new Date(), metaObject);
        setFieldValByName("updateTime", new Date(), metaObject);
    }
    
    // 更新数据时执行此方法
    @Override
    public void updateFill(MetaObject metaObject) {
        setFieldValByName("updateTime", new Date(), metaObject);
    }
}

6、在Springboot入口添加MapperScan

package dev.xuanran.springsecurity;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("dev.xuanran.springsecurity.mapper")
public class SpringSecurityApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringSecurityApplication.class, args);
    }

}

7、执行测试

@Test
void contextLoads() {
    SysUser user = new SysUser();
    user.setUsername("XuanRan");
    user.setPassword("123456");
    int i = userMapper.insert(user);
    System.out.println(i);
}

    @Test
    public void deleteUser() {
        HashMap<String, Object> map = new HashMap<>();
        map.put("username", "XuanRan");
        int delete = userMapper.deleteByMap(map);
        System.out.println(delete);
    }

8、测试结果

可以看到插入数据时已经自动填充deleted和create_time等

==> Preparing: INSERT INTO sys_user ( id, username, password, deleted, create_time, update_time ) VALUES ( ?, ?, ?, ?, ?, ? )
> Parameters: 1576946704336740353(String), XuanRan(String), 123456(String), 0(Integer), 2022-10-03 22:46:07.226(Timestamp), 2022-10-03 22:46:07.226(Timestamp)
< Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@130a6eb9]

删除数据时也自动更新了deleted字段

JDBC Connection [HikariProxyConnection@1210734791 wrapping com.mysql.jdbc.JDBC4Connection@3e74fd84] will not be managed by Spring
==> Preparing: UPDATE sys_user SET deleted=1 WHERE username = ? AND deleted=0
> Parameters: XuanRan(String)
< Updates: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5b742bc8]
1