Java中使用myBatis根据实体类创建表

①：引入依赖（pom）

1. 引入基本依赖

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jdbc</artifactId>
</dependency>

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-web</artifactId>
</dependency>

<dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <optional>true</optional>
</dependency>

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

2. 引入 mysql、myBatis、数据源

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

<!--创建表的插件-->
<dependency>
    <groupId>com.gitee.sunchenbin.mybatis.actable</groupId>
    <artifactId>mybatis-enhance-actable</artifactId>
    <version>1.5.0.RELEASE</version>
</dependency>

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.3.0</version>
</dependency>

<!--druid数据源-->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.21</version>
</dependency>

3. maven插件（可选）

<build>
    <plugins>
        <plugin>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-maven-plugin</artifactId>
            <configuration>
                <excludes>
                    <exclude>
                        <groupId>org.projectlombok</groupId>
                        <artifactId>lombok</artifactId>
                    </exclude>
                </excludes>
            </configuration>
        </plugin>
    </plugins>
</build>

②：配置yaml（myBatis、数据连接）

server:
  port: 8089

spring:
  datasource:
    url: jdbc:mysql://你的ip地址:3306/self_Project?characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    username: root
    password: www.Coke.com
    driver-class-name: com.mysql.cj.jdbc.Driver
  servlet:
    multipart:
      max-file-size: 20MB
      max-request-size: 20MB
#  jpa:
#    database-platform: org.hibernate.dialect.MySQLDialect
mybatis:
  table:
    auto: add
    #create        系统启动后，会将所有的表删除掉，然后根据model中配置的结构重新建表，该操作会破坏原有数据。
    #update        系统会自动判断哪些表是新建的，哪些字段要修改类型等，哪些字段要删除，哪些字段要新增，该操作不会破坏原有数据。
    #none         系统不做任何处理。
    #add        新增表/新增字段/新增索引/新增唯一约束的功能，不做修改和删除 (只在版本1.0.9.RELEASE及以上支持)。
  model:
    pack: com.it.entity #扫描用于创建表的对象的包名，多个包用“,”隔开
  database:
    type: mysql #数据库类型 目前只支持mysql

③：配置类

1. 数据源配置 DataSourceConfig

import com.alibaba.druid.pool.DruidDataSource;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.beans.factory.annotation.Value;
import org.springframework.beans.factory.config.PropertiesFactoryBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.ComponentScan;
import org.springframework.context.annotation.Configuration;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
import org.springframework.jdbc.datasource.DataSourceTransactionManager;

@Configuration
@ComponentScan(basePackages = {"com.gitee.sunchenbin.mybatis.actable.manager.*"})
public class DataSourceConfig {

    @Value("${spring.datasource.driver-class-name}")
    private String driver;

    @Value("${spring.datasource.url}")
    private String url;

    @Value("${spring.datasource.username}")
    private String username;

    @Value("${spring.datasource.password}")
    private String password;

    @Bean
    public PropertiesFactoryBean configProperties() throws Exception{
        PropertiesFactoryBean propertiesFactoryBean = new PropertiesFactoryBean();
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        propertiesFactoryBean.setLocations(resolver.getResources("classpath*:application.yaml"));
        return propertiesFactoryBean;
    }

    @Bean
    public DruidDataSource dataSource() {
        DruidDataSource dataSource = new DruidDataSource();
        dataSource.setDriverClassName(driver);
        dataSource.setUrl(url);
        dataSource.setUsername(username);
        dataSource.setPassword(password);
        dataSource.setMaxActive(30);
        dataSource.setInitialSize(10);
        dataSource.setValidationQuery("SELECT 1");
        dataSource.setTestOnBorrow(true);
        return dataSource;
    }

    @Bean
    public DataSourceTransactionManager dataSourceTransactionManager() {
        DataSourceTransactionManager dataSourceTransactionManager = new DataSourceTransactionManager();
        dataSourceTransactionManager.setDataSource(dataSource());
        return dataSourceTransactionManager;
    }

    @Bean
    public SqlSessionFactoryBean sqlSessionFactory() throws Exception{
        SqlSessionFactoryBean sqlSessionFactoryBean = new SqlSessionFactoryBean();
        sqlSessionFactoryBean.setDataSource(dataSource());
        PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
        sqlSessionFactoryBean.setMapperLocations(resolver.getResources("classpath*:com/gitee/sunchenbin/mybatis/actable/mapping/*/*.xml"));
        sqlSessionFactoryBean.setTypeAliasesPackage("com.it.entity.*");
        return sqlSessionFactoryBean;
    }
}

2. myBatis相关配置 MyBatisMapperScannerConfig

import org.mybatis.spring.mapper.MapperScannerConfigurer;
import org.springframework.boot.autoconfigure.AutoConfigureAfter;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@AutoConfigureAfter(DataSourceConfig.class)
public class MyBatisMapperScannerConfig {

    @Bean
    public MapperScannerConfigurer mapperScannerConfigurer() throws Exception{
        MapperScannerConfigurer mapperScannerConfigurer = new MapperScannerConfigurer();
        mapperScannerConfigurer.setBasePackage("com.it.mapper.*;com.gitee.sunchenbin.mybatis.actable.dao.*");
        mapperScannerConfigurer.setSqlSessionFactoryBeanName("sqlSessionFactory");
        return mapperScannerConfigurer;
    }
}

④：创建实体类

1. 创建实体类 User

import com.fasterxml.jackson.annotation.JsonFormat;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.gitee.sunchenbin.mybatis.actable.annotation.Column;
import com.gitee.sunchenbin.mybatis.actable.annotation.IsAutoIncrement;
import com.gitee.sunchenbin.mybatis.actable.annotation.IsKey;
import com.gitee.sunchenbin.mybatis.actable.annotation.Table;
import com.gitee.sunchenbin.mybatis.actable.command.BaseModel;
import com.gitee.sunchenbin.mybatis.actable.constants.MySqlTypeConstant;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

@Data
@Table(name = "user_test", comment = "测试表")//设置表名  注释
public class User extends BaseModel implements Serializable {

    private static final long serialVersionUID = 9435278593475930L;

    @IsAutoIncrement   //自增
    @IsKey             //主键
    @Column(comment = "用户ID")//字段注释
    private Long id;

    /**
     * 创建时间
     */

    @Column(name = "create_time", type = MySqlTypeConstant.DATETIME, comment = "创建时间")
    private Date createTime;


    /**
     * 修改时间
     */
    @Column(name = "update_time", type = MySqlTypeConstant.DATETIME, comment = "修改时间")
    private Date updateTime;


    /**
     * 联系邮箱
     */
    @Column(name = "email",comment = "联系邮箱", length = 255)
    private String email;

    /**
     * 联系手机
     */
    @Column(name = "mobile",comment = "联系手机", length = 255)
    private String mobile;

    /**
     是否为超级管理员 0 否 1 是
     */
    @Column(name = "super_admin",comment = "是否为超级管理员", defaultValue = "0",length = 10)
    private Integer superAdmin = 0;

    /**
     * 姓名
     */
    @Column(name = "name", comment = "姓名", length = 255)
    private String name;

    /**
     * 头像
     */
    @Column(name = "avatar", comment = "头像", defaultValue = "https://img01.yzcdn.cn/vant/leaf.jpg",length = 255)
    private String avatar;

    /**
     登录用户名
     */
    @Column(name = "username", comment = "登录用户名", length = 255)
    private String username;


    /**
     * 密码
     */
    @Column(name = "password", comment = "密码", length = 200)
    private String password;


    /**
     * 账号时效
     */
    @JsonIgnore
    @Column(name = "prescription", comment = "账号时效", length = 200)
    private Integer prescription;


    /**
     * 密码盐
     */
    @JsonIgnore
    @Column(name = "salt", comment = "密码盐", length = 255)
    private String salt;


    /**
     * 状态 0、正常 1、锁定
     */
    @Column(name = "state",comment = "状态 0、正常 1、锁定",defaultValue = "0", length = 10)
    private Integer state;


    /**
     * 前5次密码
     */
    @JsonIgnore
    @Column(name = "his_pass", comment = "前5次密码", length = 255)
    private String hisPass;


    /**
     * 删除状态 0、正常 1、删除
     */
    @Column(name = "del_state",comment = "删除状态 0、正常 1、删除",defaultValue = "0", length = 10)
    private Integer delState;


    /**
     * 最后修改密码时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "Asia/Shanghai")
    @Column(name = "up_pass_time", type = MySqlTypeConstant.DATETIME, comment = "最后修改密码时间")
    private Date upPassTime;


    /**
     * 删除时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "Asia/Shanghai")
    @Column(name = "del_pass_time", type = MySqlTypeConstant.DATETIME, comment = "删除时间")
    private Date delPassTime;


    /**
     * 最后登录时间
     */
    @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss", timezone = "Asia/Shanghai")
    @Column(name = "last_login_time", type = MySqlTypeConstant.DATETIME, comment = "最后登录时间")
    private Date lastLoginTime;
    
 
    /**
     * 新增数据时自动添加时间
     */
    @PrePersist
    protected void onCreate() {
      create_time = new Date();
    }

    /**
     * 更新数据时自动更新时间
     */
    @PreUpdate
    protected void onUpdate() {
      pwd_update_time = new Date();
    }

    /**
     * 删除数据时自动更新时间
     */
    @PreRemove
    protected void onDelete() {
      is_deleted = 1;
    }

    /**
     * 登录时自动更新时间
     */
    @PreUpdate
    protected void onLogin() {
      last_login_time = new Date();
    }

}

⑤：测试

1. 启动项目

2. 创建成功