jpa 默认生成sql语句_springboot-jpa自动创建数据库表
第一步创建springboot项目，jpa，mysql,
代码如下:
application.yml
spring:
datasource:
url: jdbc:mysql://127.0.0.1:3306/springboot_test
username: root
password: 514730
driver-class-name: com.mysql.jdbc.Driver
jpa:
hibernate:
# 更新或者创建数据表结构
ddl-auto: update
# 控制台显示SQL
show-sql: true
实体类
import javax.persistence.*;
@Entity
@Table(name = "person")
public class Person {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Long id;
@Column(length =50,name = "name")
private String name;
private String email;
private String gender;
private String address;
}
运行springboot主配置文件，来到数据库界面管理软件。发现我们的"person"表 自动创建好了
图片.png
记得给主键ID加上:@GeneratedValue(strategy = GenerationType.IDENTITY)
第一步创建springboot项目，jpa，mysql, 代码如下: application.yml spring: datasource: url: jdbc:mysql://127.0.0.1:3306/springboot_test username: root password: 514730 driver-class-name: com.mysql.jdbc.Driver jpa: hibernate: # 更新或者创建数据表结构 ddl-auto: update # 控制台显示SQL show-sql: true 实体类 import javax.persistence.*; @Entity @Table(name = "person") public class Person { @Id @GeneratedValue(strategy = GenerationType.IDENTITY) private Long id; @Column(length =50,name = "name") private String name; private String email; private String gender; private String address; } 运行springboot主配置文件，来到数据库界面管理软件。发现我们的"person"表 自动创建好了 图片.png 记得给主键ID加上:@GeneratedValue(strategy = GenerationType.IDENTITY)