springboot2.0x 初始化sql脚本
springboot2.0x和1.x不一样
在application.yml中需要写上一个重要的配置
spring:
datasource:
username: root
password: root
url: jdbc:mariadb://192.168.2.159:3306/jdbc
driver-class-name: org.mariadb.jdbc.Driver
schema:
- classpath:employee.sql
initialization-mode: ALWAYS
那就是 initialization-mode: ALWAYS
那就是 initialization-mode: ALWAYS
那就是 initialization-mode: ALWAYS
执行完之后看下控制台
. ____ _ __ _ _
/\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \
( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \
\\/ ___)| |_)| | | | | || (_| | ) ) ) )
' |____| .__|_| |_|_| |_\__, | / / / /
=========|_|==============|___/=/_/_/_/
:: Spring Boot :: (v2.1.7.RELEASE)
2019-08-23 03:12:10.600 INFO 25039 --- [ main] c.r.s.SpringbootDataJdbcApplicationTests : Starting SpringbootDataJdbcApplicationTests on rick-PC with PID 25039 (started by rick in /home/rick/IdeaProjects/springboot-data-jdbc)
2019-08-23 03:12:10.609 INFO 25039 --- [ main] c.r.s.SpringbootDataJdbcApplicationTests : No active profile set, falling back to default profiles: default
2019-08-23 03:12:13.814 INFO 25039 --- [ main] o.s.s.concurrent.ThreadPoolTaskExecutor : Initializing ExecutorService 'applicationTaskExecutor'
2019-08-23 03:12:14.161 INFO 25039 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2019-08-23 03:12:14.249 INFO 25039 --- [ main] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.
2019-08-23 03:12:14.621 INFO 25039 --- [ main] c.r.s.SpringbootDataJdbcApplicationTests : Started SpringbootDataJdbcApplicationTests in 4.782 seconds (JVM running for 6.139)
class com.zaxxer.hikari.HikariDataSource
HikariProxyConnection@1107218767 wrapping org.mariadb.jdbc.MariaDbConnection@4d6ee47
2019-08-23 03:12:14.829 INFO 25039 --- [ Thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown initiated...
2019-08-23 03:12:14.839 INFO 25039 --- [ Thread-2] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Shutdown completed.
2019-08-23 03:12:14.840 INFO 25039 --- [ Thread-2] o.s.s.concurrent.ThreadPoolTaskExecutor : Shutting down ExecutorService 'applicationTaskExecutor'
Process finished with exit code 0
并没有输出日志但是!!!刷新一下数据库啊
它就有了数据了!!!!