SpringBoot2.x自动创建表并初始化数据库

骑猪看日落 2022-10-20 13:56 163阅读 0赞

# 1、使用springboot jdbc初始化数据库 #

项目结构：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNzUzNzI0_size_16_color_FFFFFF_t_70]

## 1.1 **application.yml配置文件：** ##

spring:
      datasource:
        username: root
        password: 123456
        url: jdbc:mysql://192.168.56.101:3306/jdbc
        driver-class-name: com.mysql.cj.jdbc.Driver
        initialization-mode: always
        schema:
          - classpath:department.sql

## 1.2 **department.sql:** ##

/* Navicat MySQL Data Transfer Source Server : 本地 Source Server Version : 50528 Source Host : 127.0.0.1:3306 Source Database : restful_crud Target Server Type : MYSQL Target Server Version : 50528 File Encoding : 65001 Date: 2018-03-05 10:41:40 */
    
    SET FOREIGN_KEY_CHECKS=0;
    
    -- ----------------------------
    -- Table structure for department
    -- ----------------------------
    DROP TABLE IF EXISTS `department`;
    CREATE TABLE `department` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `departmentName` varchar(255) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;

## 1.3 **在SpringBoot2.x中,我们需要在配置文件中配置一下:** ##

spring.datasource.initialization-mode: always

## 1.4 **启动项目后查看数据库，如下图，确实是创建了department表：** ##

![在这里插入图片描述][20210518120315325.png]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQzNzUzNzI0_size_16_color_FFFFFF_t_70]: /images/20221020/9d484e51f855491c9a3cda82f396d893.png
[20210518120315325.png]: /images/20221020/02cf8c3c59f440f6adc43c19dde22621.png