SpringBoot中配置起动时的数据库初始化脚本

配置application.yml

连接字符串

spring:
  datasource:
    platform: mysql
    url: jdbc:mysql://localhost:3306/gov_admin?useUnicode=true&characterEncoding=UTF-8
    username: root
    password: 111111
    driver-class-name: com.mysql.jdbc.Driver
    sql-script-encoding: utf-8
    schema: classpath:schema.sql
    data: classpath:data.sql
    continue-on-error: true
    initialization-mode: always
    type: com.alibaba.druid.pool.DruidDataSource

初始化数据

spring.datasource.schema=classpath:schema.sql
spring.datasource.data=classpath:data.sql
spring.datasource.sql-script-encoding=utf-8
spring.datasource.initialization-mode=ALWAYS

因为SpringBoot在启动时，只有检测到spring.datasource.initialization-mode=ALWAYS配置，后再检测spring.datasource.schema之后，且配置的sql角本命令不为空，才会去执行schema和spring.datasourc