MyBatis-Plus 乐观锁 防止超卖、逻辑删除、自动填充、Id自增

@Version
private Integer version;

    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        mybatisPlusInterceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return mybatisPlusInterceptor;
    }

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `age` int(11) NULL DEFAULT NULL COMMENT '年龄',
  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `version` int(10) NULL DEFAULT 1 COMMENT '乐观锁',
  `deleted` int(10) NULL DEFAULT 0 COMMENT '逻辑删除',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1337575143814062086 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

@Data
@AllArgsConstructor
@NoArgsConstructor
@Accessors(chain = true)
@TableName(value = "user")
public class User {
    @TableId(type = IdType.AUTO)
    private Long id;
    private String name;
    private Integer age;
    private String email;

    @Version  // 这里是乐观锁的注解
    private Integer version;

    @TableLogic  // 这是逻辑删除的注解
    private Integer deleted;

    @TableField(fill = FieldFill.INSERT)  //这里是自动填充的注解
    private Date createTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;
}

public interface UserMapper extends BaseMapper<User> {

}

@Configuration
public class MybatisPlusConfig {

    // 分页
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor mybatisPlusInterceptor = new MybatisPlusInterceptor();
        // 这里是注册分页插件
        mybatisPlusInterceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
        // 注册乐观锁 插件
        mybatisPlusInterceptor.addInnerInterceptor(new OptimisticLockerInnerInterceptor());
        return mybatisPlusInterceptor;
    }    
}

server:
  port: 8484
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/mybatis_plus?serverTimezone=UTC&useSSL=false&characterEncoding=utf8&serverTimezone=GMT

    @Test
    public  void updateOptimisticLockerInterceptor(){
        //A 线程
        User user = userMapper.selectById(102L);
        user.setName("点赞1");
        user.setAge(3);
        //B 线程  模拟另外一个线程插队
        User user1 = userMapper.selectById(102L);
        user1.setName("收藏加三连");
        user1.setAge(4);
        userMapper.updateById(user1);
        // 自旋锁来尝试多次提交
        userMapper.updateById(user);  // 如果没有乐观锁 就会覆盖插队的值
    }

    @Test
    public  void updateOptimisticLockerInterceptor(){
        //A 线程
        User user = userMapper.selectById(102L);
        user.setName("关注宁在春");
        user.setAge(3);
        //B 线程  模拟另外一个线程插队
        User user1 = userMapper.selectById(102L);
        user1.setName("给宁在春点赞");
        user1.setAge(4);
        userMapper.updateById(user1);
        // 自旋锁来尝试多次提交
        userMapper.updateById(user);  // 如果没有乐观锁 就会覆盖插队的值
    }

mybatis-plus:
  global-config:
    db-config:
      logic-delete-field: flag  # 全局逻辑删除的实体字段名(since 3.3.0,配置后可以忽略不配置步骤2)
      logic-delete-value: 1 # 逻辑已删除值(默认为 1)
      logic-not-delete-value: 0 # 逻辑未删除值(默认为 0)

@TableLogic
private Integer deleted;	

// TODO tableLogic 逻辑删除
@Test
public void tableLogic(){
    userMapper.deleteById(103);
    List<User> userList = userMapper.selectList(null);
    userList.forEach(System.out::println);
}

public class User {

    // 注意！这里需要标记为填充字段
    @TableField(fill = FieldFill.INSERT)
    private Date createTime;

    @TableField(fill = FieldFill.INSERT_UPDATE)
    private Date updateTime;

}

@Slf4j
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {

    @Override
    public void insertFill(MetaObject metaObject) {
        log.info("start insert fill ....");
        this.setFieldValByName("createTime",new Date(),metaObject);
        this.setFieldValByName("updateTime",new Date(),metaObject);
    }

    @Override
    public void updateFill(MetaObject metaObject) {
        log.info("start update fill ....");
        this.setFieldValByName("updateTime",new Date(),metaObject);
    }
}

//TODO insert 配置了自动填充后的insert
@Test
public void insert() {
    User user = new User().setName("自动填充").setAge(99).setEmail("ssss@qq.com");
    int i = userMapper.insert(user);
    System.out.println(i);
    Map<String, Object> map = new HashMap<String,Object>();
    map.put("name","自动填充");
    List<User> users = userMapper.selectByMap(map);
    users.forEach(System.out::println);
}