MyBatis-plus 关于spring boot jpa自动建表功能

1.导入依赖

      <!--MySQL依赖 用于jdbc连接-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>

        <!--jpa依赖 自动建表-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        
        <!--mybatis依赖 用于操作数据库的crud,可以不用到，若是业务需要可以改为mybatis-->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>

 2.application.yml配置

<!--配置数据库连接与jpa的yml配置-->

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis_plus?userSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT%2B8
    password: root
    username: root
  jpa:
    database: mysql
    show-sql: true
    hibernate:
      ddl-auto: update
                #create----每次运行该程序，没有表格会新建表格，表内有数据会清空
                #create-drop----每次程序结束的时候会清空表
                #update----每次运行程序，没有表格会新建表格，表内有数据不会清空，只会更新
                #validate----运行程序会校验数据与数据库的字段类型是否相同，不同会报错
      dialect: org.hibernate.dialect.MySQL5InnoDBDialect

3.进行实体类entity写入

@Data
@Entity
@Table(name = "demo_user")
@TableName("demo_user")
public class User {
    @TableId(type = IdType.AUTO)
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "userid",columnDefinition = "int comment '主键ID'")
    private Integer userId;
    @Column(name = "name")
    private String name;
    @Column(name = "age")
    private Integer age;
    @Column(name = "email")
    private String email;

    @Column(name = "phone")
    private String phone;
}

各注解的文档解释

 

4.启动测试

 

 数据库表生成后的代码