由于内置H2数据库不直观,查看数据不方便,考虑使用MySql数据库
添加依赖
在pom.xml中添加依赖
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
配置数据库连接
在application.yml中添加如下配置
spring:
datasource:
url: jdbc:mysql://localhost:3306/tacocloud?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=utf8
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
jpa:
show-sql: true
在Navicat中执行sql语句
create table if not exists Taco (
id identity not null ,
name varchar(50) not null,
createdAt timestamp not null
);
由于identity无法识别因此将这段改为
create table if not exists Taco (
id BIGINT auto_increment PRIMARY KEY ,
name varchar(50) not null,
createdAt timestamp not null
);
Taco_Order表的创建类似进行修改