spring-boot + mybatis-enhance-actable实现自动创建表

1、pom.xml

  		
        <dependency>
            <groupId>mysqlgroupId>
            <artifactId>mysql-connector-javaartifactId>
            <version>8.0.30version>
        dependency>

        <dependency>
            <groupId>com.alibabagroupId>
            <artifactId>druidartifactId>
            <version>1.2.13-SNSAPSHOTversion>
        dependency>

        <dependency>
            <groupId>com.baomidougroupId>
            <artifactId>mybatis-plus-boot-starterartifactId>
            <version>3.4.1version>
        dependency>

        <dependency>
            <groupId>com.gitee.sunchenbin.mybatis.actablegroupId>
            <artifactId>mybatis-enhance-actableartifactId>
            <version>1.5.0.RELEASEversion>
        dependency>

2、yml

classpath*:mapper/.xml：自己xml的路径
classpath:com/gitee/sunchenbin/mybatis/actable/mapping//.xml： actable的路径，固定写死

mybatis:
  table:
    auto: update
  model:
    pack: com.java.test.entity
  database:
    type: mysql

mybatis-plus:
  mapper-locations: classpath:mapper/*.xml,classpath*:com/gitee/sunchenbin/mybatis/actable/mapping/*/*.xml

3、Application

com.gitee.sunchenbin.mybatis.actable… ： 固定写死

@MapperScan(basePackages = {"com.gitee.sunchenbin.mybatis.actable.dao.*","com.java.test.mapper"})
@ComponentScan("com.gitee.sunchenbin.mybatis.actable.manager.*")

4、entity

1. @Id是主键
2. @GeneratedValue 主键配置：

3. @GeneratedValue无效就使用@IsAutoIncrement
4. @Column默认是VARCHAR类型
5. @ColumnType指定其他类型，默认参数是enum对象MySqlTypeConstant

@Data
@Entity
@Table(name = "t_table")
public class Table {
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    @ColumnType(MySqlTypeConstant.INT)
    @IsAutoIncrement
    private Long id;
    @Column(length = 50)
    private String name;
    @Column(length = 50)
    private String age;
    @Column
    @ColumnType(value = MySqlTypeConstant.TEXT)
    private String text;

}

5、日志

2022-09-29 09:29:37.621  INFO 11247 --- [main]  ......  : databaseType=mysql，开始执行mysql的处理方法
2022-09-29 09:29:37.769  INFO 11247 --- [main]  ......  : {dataSource-1} inited
2022-09-29 09:29:38.219  INFO 11247 --- [main]  ......  : 开始创建表：t_table
2022-09-29 09:29:38.862  INFO 11247 --- [main]  ......  : 完成创建表：t_table