<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>${mybatis-plus.version}</version>
</dependency>
<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <scope>runtime</scope>
</dependency>

# 數(shù)據(jù)源
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/test
spring.datasource.username=root
spring.datasource.password=root

# 日志實(shí)現(xiàn)
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl
# 開(kāi)啟駝峰匹配
mybatis-plus.configuration.map-underscore-to-camel-case=true
# 配置全局?jǐn)?shù)據(jù)庫(kù)主鍵
mybatis-plus.global-config.db-config.id-type=auto

@Data
@TableName("user_info")
public class UserInfo {
    
    /**
     * 主鍵ID
     **/
    @TableId
    private Integer id;

    /**
     * 姓名
     **/
    private String name;

    /**
     * 年齡
     **/
    private Integer age;


    /**
     * 性別
     **/
    private String sex;

    /**
     * 工作
     **/
    private String job;

    /**
     * 生日
     **/
    private LocalDateTime birthday;

    /**
     * 創(chuàng)建時(shí)間
     **/
    private LocalDateTime createdTime;

    /**
     * 更新時(shí)間
     **/
    private LocalDateTime updateTime;
}

public interface UserInfoMapper extends BaseMapper<UserInfo> {

}

@Data
@TableName("user_info")
public class UserInfo {
    
    // 其他字段...

    /**
     * 創(chuàng)建時(shí)間
     **/
    @TableField(fill = FieldFill.INSERT)
    private LocalDateTime createdTime;

    /**
     * 更新時(shí)間
     **/
    @TableField(fill = FieldFill.INSERT_UPDATE)
    private LocalDateTime updateTime;
}

public enum FieldFill {
    DEFAULT,       // 默認(rèn)不處理
    INSERT,        // 插入填充字段
    UPDATE,        // 更新填充字段
    INSERT_UPDATE  // 插入和更新填充字段
}

@Slf4j
@Component
public class AutoFillMetaObjectHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        log.info("insertFill 開(kāi)始自動(dòng)填充......");
        this.strictInsertFill(metaObject, "createdTime", LocalDateTime.class, LocalDateTime.now());
        this.strictInsertFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        log.info("updateFill 開(kāi)始自動(dòng)填充......");
        this.strictUpdateFill(metaObject, "updateTime", LocalDateTime.class, LocalDateTime.now());
    }
}

 @Test
void contextLoads01() {
    UserInfo userInfo = new UserInfo();
    userInfo.setName("test");
    userInfo.setAge(18);
    userInfoMapper.insert(userInfo);
}