其中goods.sql文件内容如下:
drop database if exists dbgoods;
create database dbgoods default character set utf8;
use dbgoods;
create table tb_goods(
id bigint primary key auto_increment,
name varchar(100) not null,
remark text,
createdTime datetime not null
)engine=InnoDB;
insert into tb_goods values (null,‘java’,‘very good’,now());
insert into tb_goods values (null,‘mysql’,‘RDBMS’,now());
insert into tb_goods values (null,‘Oracle’,‘RDBMS’,now());
insert into tb_goods values (null,‘java’,‘very good’,now());
insert into tb_goods values (null,‘mysql’,‘RDBMS’,now());
insert into tb_goods values (null,‘Oracle’,‘RDBMS’,now());
insert into tb_goods values (null,‘java’,‘very good’,now());
=================================================================================
第一步:基于IDEA创建项目Module,如图所示:
第二步:添加依赖
- mysql数据库驱动依赖。
mysql
mysql-connector-java
runtime
- spring对象jdbc支持(此时会默认帮我们下载HiKariCP连接池)。
org.springframework.boot
spring-boot-starter-jdbc
=============================================================================
打开application.properties配置文件,添加如下内容(必写)。
spring.datasource.url=jdbc:mysql:///dbgoods?serverTimezone=GMT%2B8&characterEncoding=utf8
sp