Flyway+Springboot整合使用

最新推荐文章于 2025-07-05 11:11:27 发布

原创最新推荐文章于 2025-07-05 11:11:27 发布 · 1.1k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #mysql #flyway #spring boot

SpringBoot 同时被 3 个专栏收录

18 篇文章

订阅专栏

Java

10 篇文章

订阅专栏

mysql

3 篇文章

订阅专栏

本文详细介绍了在非SpringBoot环境下如何配置Flyway进行数据库迁移，包括项目依赖设置、YAML配置、脚本编写及项目启动流程。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

flyway在非springboot中的配置方法可参考flyway入门使用教程

1.项目依赖

项目中需要的依赖

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>

  <groupId>com.lx</groupId>
  <artifactId>flyway</artifactId>
  <version>1.0-SNAPSHOT</version>

  <parent>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-parent</artifactId>
    <version>2.2.5.RELEASE</version>
    <relativePath/>
  </parent>

  <dependencies>
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <scope>runtime</scope>
    </dependency>
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-web</artifactId>
    </dependency>
    <!--与springboot整合时需要此包，如果是通过插件的方式则不需要-->
    <dependency>
      <groupId>org.flywaydb</groupId>
      <artifactId>flyway-core</artifactId>
      <version>6.2.4</version>
    </dependency>
    <!--配置flywaydb时，需要引入org.springframework:spring-jdbc包，否则会报找不到驱动bug-->
    <dependency>
      <groupId>org.springframework.boot</groupId>
      <artifactId>spring-boot-starter-jdbc</artifactId>
    </dependency>
  </dependencies>

  <build>
    <plugins>
      <plugin>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-maven-plugin</artifactId>
      </plugin>
    </plugins>
  </build>
</project>

2.yml配置

spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
    username: root
    password: root

  flyway:
    enabled: true
    encoding: UTF-8
    locations: ['classpath:db/migration']
    url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false
    user: root
    password: root

更多配置信息可以参考org.springframework.boot.autoconfigure.flyway.FlywayProperties基本和flyway入门使用教程中的配置参数一致，只是不需要在写driver驱动，而是根据链接自动识别，通过springboot引入的spring-jdbc引用数据源

3.编写脚本

参照flyway入门使用教程编写一个数据迁移脚本V1.0__Create_user_table.sql

DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
 `update_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP,
 `valid` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否有效 0.有效 1.无效',
 `delete_time` datetime(0) NULL DEFAULT NULL,
 `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号名称',
 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '加密后密码',
 `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码盐值',
 `admin_role_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '角色id（多个使用,号隔开）',
 PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '用户表' ROW_FORMAT = Compact;