功能
管理数据库版本,便于多人协作
配置
maven,集成
<!--h2数据库-->
<project xmlns="...">
...
<build>
<plugins>
<plugin>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<version>6.3.1</version>
<configuration>
<url>jdbc:h2:file:./target/foobar</url>
<user>sa</user>
<password>123<password>
</configuration>
<dependencies>
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.4.197</version>
</dependency>
</dependencies>
</plugin>
</plugins>
</build>
</project>
<!--mysql直接用这个了-->
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-core</artifactId>
<version>6.3.1</version>
</dependency>
#配置flyway
flyway.url = jdbc:mysql://localhost:3306/mysql
flyway.user = root
flyway.password = root
使用
创建目录src/main/resources/db/migration,在下面写sql语句
语句命名规范:V1__Create_person_table.sql
在terminal终端执行 mvn flyway:migrate
注意事项
- V1后面有两个下划线
- 执行之后的sql语句是不能改的,要改的话重新写一个Vn的sql语句去改