pom文件的配置
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.4.2</version>
</dependency>
一、逻辑删除(二者选一)
1.在实体类中所对应的属性值上方加注解(局部配置)
@TableLogic
2.在application.yml
或者application.properties
中添加配置,如下以yml文件为例:(全局配置)
#逻辑删除设置:删除logic-delete-value在数据库中显示2,未删除logic-not-delete-value在数据库中则显示0(数字可以自行设置)
global-config:
db-config:
logic-delete-value: 1
logic-not-delete-value: 0
#逻辑删除对应的字段
logic-delete-field: deleted
二、自动填充
1.时间的自动填充(创建时间、修改时间)
(1.)在实体类中所对应的属性值上方加注解
@TableField(fill = FieldFill.INSERT)
@TableField(fill = FieldFill.INSERT_UPDATE)
(2.)自定义实现类,实现MetaObjectHandler这个接口
package com.example.demo.fill;
import com.baomidou.mybatisplus.core.handlers.MetaObjectHandler;
import org.apache.ibatis.reflection.MetaObject;
import org.springframework.stereotype.Component;
import java.util.Date;
@Component
public class MyMetaObjectHandler implements MetaObjectHandler {
@Override
public void insertFill(MetaObject metaObject) {
this.setFieldValByName("createTime", new Date(), metaObject);
this.setFieldValByName("updateTime", new Date(), metaObject);
this.setFieldValByName("version", 1, metaObject);
}
@Override
public void updateFill(MetaObject metaObject) {
this.setFieldValByName("updateTime", new Date(), metaObject);
}
}
三、乐观锁
1.添加插件
package com.example.demo.config;
import com.baomidou.mybatisplus.extension.plugins.OptimisticLockerInterceptor;
import com.baomidou.mybatisplus.extension.plugins.PaginationInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class AppConfig {
@Bean
public OptimisticLockerInterceptor optimisticLockerInterceptor(){
return new OptimisticLockerInterceptor();
}
@Bean
public PaginationInterceptor paginationInterceptor(){
return new PaginationInterceptor();
}
}
2.在实体类中所对应的属性值加注解
@Version
3.在自动填充类中加
this.setFieldValByName("version", 1, metaObject);