Mybatis-plus 笔记

原创已于 2022-11-22 10:25:44 修改 · 103 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#mybatis #java #mysql

于 2022-11-22 10:25:37 首次发布

Mybatis-plus

基础环境

<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>5.1.47</version>
</dependency>

<dependency>
	<groupId>com.baomidou</groupId>
	<artifactId>mybatis-plus-boot-starter</artifactId>
	<version>3.3.1</version>
</dependency>

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://8.134.166.133:3306/docker?useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8

# log
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

@Mapper
public interface UserMapper extends BaseMapper<User> {
}

@MapperScan("com.tintin.mybatisplus.mapper")
@SpringBootApplication
public class MybatisPlusApplication {

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

}

自动填充

@Data
public class User {

    @TableId(type = IdType.ASSIGN_ID)

    @TableField(fill = FieldFill.INSERT)
    private Date createTime;

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

@Component //易漏写
public class MymetaObjectHandler implements MetaObjectHandler {
    @Override
    public void insertFill(MetaObject metaObject) {
        this.setFieldValByName("createTime", new Date(), metaObject);
        this.setFieldValByName("updateTime", new Date(), metaObject);
    }

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

乐观锁

配置插件

@MapperScan("com.tintin.mybatisplus.mapper")
@Configuration
public class MybatisConfiguration {

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

}

添加注解

@Data
public class User {

    ...

    @Version
    private int version;
}

调用

@Test
void update(){
    User user = userMapper.selectById("1594620946973532162");
    user.setEmail("3");

    userMapper.updateById(user);
}

page插件

@Bean
public PaginationInnerInterceptor paginationInnerInterceptor(){
  return new PaginationInnerInterceptor();
}

void selectPage(){
  Page<User> userPage = new Page<>(1, 2);
  userMapper.selectPage(userPage, null);

  userPage.getRecords().forEach(System.out::println);
}

逻辑删除

新版

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)

@Data
public class User {	
  	...
      
    @TableLogic
    private int deleted;
}

旧版

# 配置逻辑删除
mybatis-plus.global-config.db-config.logic-delete-value=1
mybatis-plus.global-config.db-config.logic-not-delete-value=0

@MapperScan("com.example.mybatisplus.mapper")
@EnableTransactionManagement
@Configuration // 配置类
public class MyBatisPlusConfig {

    // 逻辑删除组件！
    @Bean
    public ISqlInjector sqlInjector() {
        return new LogicSqlInjector();
    }
}

@TableLogic //逻辑删除
private Integer deleted;

代码生成器

String projectPath = System.getProperty("user.dir");
        // 数据源配置
        Builder dataSourceConfig = new Builder(
                "jdbc:mysql://8.134.166.133:3306/docker?useUnicode=true&serverTimezone=GMT&useSSL=false&characterEncoding=utf8",
                "root",
                "123456")
                .dbQuery(new MySqlQuery())
                .typeConvert(new MySqlTypeConvert())
                .keyWordsHandler(new MySqlKeyWordsHandler());

        FastAutoGenerator.create(dataSourceConfig)
                .globalConfig(builder -> {
                    builder.author("Tintin") //设置作者
                            .commentDate("YYYY-MM-DD HH:mm:ss")//注释日期
                            //.outputDir(projectPath + "/src/main/java/com/demo/user"); //指定输出目录
                            .outputDir(projectPath + "/service-user/src/main/java/com/demo/user"); //指定输出目录

                })
                .packageConfig(builder -> {
                    builder.parent(""); // 设置父包名
                })
                .strategyConfig(builder -> {
                    builder.addInclude("user") // 设置需要生成的表名
                            .addTablePrefix("tb_"); // 设置过滤表前缀
                    builder.entityBuilder().enableLombok();//开启 lombok 模型
                    builder.entityBuilder().enableTableFieldAnnotation();//开启生成实体时生成字段注解
                    builder.controllerBuilder().enableRestStyle();//开启生成@RestController 控制器

                })
                .templateEngine(new FreemarkerTemplateEngine()) // 使用Freemarker引擎模板，默认的是Velocity引擎模板
                .execute();
    }