{"id":52,"date":"2021-01-13T09:11:08","date_gmt":"2021-01-13T01:11:08","guid":{"rendered":"http:\/\/mengstudy.com\/?p=52"},"modified":"2021-01-15T09:02:18","modified_gmt":"2021-01-15T01:02:18","slug":"springboot%e9%a1%b9%e7%9b%ae%e6%95%b0%e6%8d%ae%e5%ba%93%e8%ae%bf%e9%97%aemysql","status":"publish","type":"post","link":"https:\/\/fugary.com\/?p=52","title":{"rendered":"SpringBoot\u9879\u76ee\u6570\u636e\u5e93\u8bbf\u95eeMySQL"},"content":{"rendered":"

SpringBoot\u9879\u76ee\u6570\u636e\u5e93\u8bbf\u95eeMySQL<\/h2>\n

\u6b64\u9879\u76ee\u4ee5MySQL\u6570\u636e\u5e93\u4f5c\u4e3a\u6d4b\u8bd5\u6570\u636e\u5e93\uff0c\u5e76\u4f7f\u7528Flyway\u6765\u7ba1\u7406\u6570\u636e\u5e93\u7248\u672c\u3002<\/p>\n

\u5148\u8981\u5b89\u88c5\u597dMySQL\u6570\u636e\u5e93\uff0c\u7136\u540e\u5efa\u7acb\u6d4b\u8bd5\u6570\u636e\u5e93user_db\uff0c\u6211\u4eec\u4f7f\u7528Flyway\u6765\u7ba1\u7406\u6570\u636e\u5e93\u7248\u672c\uff0c\u56e0\u6b64\u4e0d\u7528\u5efa\u8868\uff0c\u76f4\u63a5\u901a\u8fc7Flyway\u811a\u672csql\u6765\u89c1\u8868\uff0c\u5e76\u81ea\u52a8\u7ef4\u62a4\u597d\u6570\u636e\u5e93\u8868\u7ed3\u6784\u7248\u672c\u4fe1\u606f\u3002<\/p>\n

\u65b0\u5efa\u9879\u76ee<\/h3>\n

\u53c2\u8003\u57fa\u672c\u914d\u7f6e\u6587\u7ae0\uff1ahttps:\/\/fugary.com\/?p=51<\/a><\/p>\n

\u7528https:\/\/start.spring.io\u6765\u5efa\u7acb\u65b0\u9879\u76ee\uff0c\u7136\u540e\u914d\u7f6e\u6210\u7ee7\u627f\u901a\u7528\u7684\u7236\u7ea7\u9879\u76ee\u3002<\/p>\n

\u65b0\u5efa\u9879\u76ee<\/h4>\n

\u9879\u76ee\u540d\u79f0simple-boot-mysql-demo\uff0c\u6e90\u7801\u5730\u5740\uff1a<\/p>\n

\"\"<\/div><\/p>\n

\u4e3b\u8981\u8981\u5f15\u5165\uff0cMySQL\u3001Flyway\u3001Lombok\u3001MyBatis\u7b49\u3002<\/p>\n

\u9879\u76ee\u57fa\u672c\u914d\u7f6e<\/h4>\n

\u7136\u540e\u628a\u751f\u6210\u7684\u9879\u76ee\u590d\u5236\u5230\u6211\u4eec\u7684\u5de5\u7a0b\u4e4b\u4e2d\uff0c\u5e76\u5728\u7236\u7ea7\u9879\u76ee\u4e2d\u914d\u7f6emodule<\/p>\n

<module>simple-boot-mysql-demo<\/module><\/code><\/pre>\n
\u9879\u76eepom.xml<\/p>\n
<?xml version="1.0" encoding="UTF-8"?>\n<project xmlns="http:\/\/maven.apache.org\/POM\/4.0.0" xmlns:xsi="http:\/\/www.w3.org\/2001\/XMLSchema-instance"\n   xsi:schemaLocation="http:\/\/maven.apache.org\/POM\/4.0.0 https:\/\/maven.apache.org\/xsd\/maven-4.0.0.xsd">\n   <modelVersion>4.0.0<\/modelVersion>\n   <parent>\n      <groupId>com.mengstudy<\/groupId>\n      <artifactId>simple-boot-parent<\/artifactId>\n      <version>0.0.1-SNAPSHOT<\/version>\n   <\/parent>\n   <artifactId>simple-boot-mysql-demo<\/artifactId>\n   <version>0.0.1-SNAPSHOT<\/version>\n   <name>simple-boot-mysql-demo<\/name>\n   <description>MySQL Demo project for Spring Boot<\/description>\n   <properties>\n      <java.version>1.8<\/java.version>\n   <\/properties>\n   <dependencies>\n      <dependency>\n         <groupId>org.springframework.boot<\/groupId>\n         <artifactId>spring-boot-starter-web<\/artifactId>\n      <\/dependency>\n      <dependency>\n         <groupId>org.flywaydb<\/groupId>\n         <artifactId>flyway-core<\/artifactId>\n      <\/dependency>\n      <dependency>\n         <groupId>org.mybatis.spring.boot<\/groupId>\n         <artifactId>mybatis-spring-boot-starter<\/artifactId>\n      <\/dependency>\n      <dependency>\n         <groupId>com.baomidou<\/groupId>\n         <artifactId>mybatis-plus-boot-starter<\/artifactId>\n      <\/dependency>\n      <dependency>\n         <groupId>org.springframework.boot<\/groupId>\n         <artifactId>spring-boot-devtools<\/artifactId>\n         <scope>runtime<\/scope>\n         <optional>true<\/optional>\n      <\/dependency>\n      <dependency>\n         <groupId>mysql<\/groupId>\n         <artifactId>mysql-connector-java<\/artifactId>\n         <scope>runtime<\/scope>\n      <\/dependency>\n      <dependency>\n         <groupId>org.springframework.boot<\/groupId>\n         <artifactId>spring-boot-configuration-processor<\/artifactId>\n         <optional>true<\/optional>\n      <\/dependency>\n      <dependency>\n         <groupId>org.projectlombok<\/groupId>\n         <artifactId>lombok<\/artifactId>\n         <optional>true<\/optional>\n      <\/dependency>\n      <dependency>\n         <groupId>org.springframework.boot<\/groupId>\n         <artifactId>spring-boot-starter-test<\/artifactId>\n         <scope>test<\/scope>\n         <exclusions>\n            <exclusion>\n               <groupId>org.junit.vintage<\/groupId>\n               <artifactId>junit-vintage-engine<\/artifactId>\n            <\/exclusion>\n         <\/exclusions>\n      <\/dependency>\n   <\/dependencies>\n   <build>\n      <plugins>\n         <plugin>\n            <groupId>org.springframework.boot<\/groupId>\n            <artifactId>spring-boot-maven-plugin<\/artifactId>\n         <\/plugin>\n      <\/plugins>\n   <\/build>\n<\/project><\/code><\/pre>\n
application.yml\u914d\u7f6e<\/p>\n
server:\n  port: 8080\nspring:\n  application:\n    name: simple-boot-mysql-demo\n  datasource:\n    type: com.zaxxer.hikari.HikariDataSource\n    driver-class-name: com.mysql.jdbc.Driver\n    url: jdbc:mysql:\/\/localhost:3306\/user_db?useUnicode=true&characterEncoding=UTF-8\n    username: root\n    password: 123456\n    hikari: # \u8fde\u63a5\u6c60\u914d\u7f6e\n      maximum-pool-size: 30\n      minimum-idle: 2\n      connection-test-query: select 1;\n  flyway:\n    baseline-on-migrate: true\n    out-of-order: true\n    #\u5f88\u591a\u90fd\u662f\u9ed8\u8ba4\u914d\u7f6e\uff0c\u5e76\u4e0d\u9700\u8981\u914d\u7f6e\n    placeholder-prefix: "${"\n    table: flyway_schema_history\n    locations: classpath:db\/migration<\/code><\/pre>\n
\u9879\u76eeFlyway\u7ba1\u7406<\/h3>\n
\u7531\u4e8e\u6211\u4eec\u4f7f\u7528\u4e86flyway\u6765\u7ba1\u7406\u7248\u672c\uff0c\u9ed8\u8ba4flyway\u7684sql\u6587\u4ef6\u5b58\u653e\u4f4d\u7f6e\uff1aclasspath:db\/migration\u6587\u4ef6\u5939\u4e0b\u9762\u3002<\/p>\n
\u914d\u7f6espring.flyway.baseline-on-migrate=true<\/code>\uff0c\u628a\u7b2c\u4e00\u4e2a\u7248\u672c\u4e3abaseline\uff0c\u4e5f\u5c31\u662f\u6570\u636e\u5e93\u57fa\u7ebf\uff0c\u5982\u679c\u6b64\u6570\u636e\u5e93\u5df2\u7ecf\u6709\u5f88\u591a\u8868\u7ed3\u6784\u548c\u6570\u636e\u7684\u60c5\u51b5\u4e0b\u9700\u8981\u914d\u7f6e\u597d\u57fa\u7ebf\uff0c\u65b9\u4fbf\u65b0\u7684\u7ed3\u6784\u548c\u7248\u672c\u7ba1\u7406<\/p>\n
\u9879\u76ee\u811a\u672c\u6570\u636e<\/h4>\n
\u8fd9\u4e9b\u811a\u672c\u7684\u6587\u4ef6\u53ef\u4ee5\u81ea\u5b9a\u4e49\uff0c\u4f46\u662f\u662f\u6309\u7167Flyway\u811a\u672c\u7684\u683c\u5f0f\u6765\u7f16\u5199\uff1a\u7248\u672c\u53f7__\u7248\u672c\u63cf\u8ff0.sql<\/code>\uff0c\u7248\u672c\u53f7\u7528\u4e0b\u5212\u7ebf\u5206\u9694\u5c0f\u7248\u672c\u7684\u503c\u3002<\/p>\n
V1_0_0__db schema.sql\uff1a<\/p>\n
DROP TABLE IF EXISTS t_user;\nCREATE TABLE `t_user` (\n  `id` bigint not null,\n  `user_name` varchar(100) NOT NULL,\n  `nick_name` varchar(100) DEFAULT NULL,\n  `birth` timestamp DEFAULT NULL,\n  `user_password` varchar(1024) DEFAULT NULL,\n  `user_status` int DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;<\/code><\/pre>\n
V1_0_1__db mock data.sql\uff1a<\/p>\n
DELETE FROM t_user;\nINSERT INTO `t_user`(`id`, `user_name`, `nick_name`, `birth`, `user_password`, `user_status`)\nVALUES (1, 'gary', 'Gary', '2000-01-01', '123456', 1),\n(2, 'jerry', 'Jerry', '2000-01-02', '123456', 1), \n(3, 'tom', 'Tom', '2000-01-03', '123456', 1);<\/code><\/pre>\n
Flyway\u914d\u7f6e\u8bf4\u660e<\/h4>\n
\u4e00\u822c\u4f7f\u7528\u9ed8\u8ba4\u914d\u7f6e\u5373\u53ef\uff0c\u8be6\u7ec6\u7684\u9ed8\u8ba4\u503c\u53ef\u4ee5\u53c2\u8003\u6587\u4ef6FlywayProperties<\/code>\u7684\u6784\u9020\u65b9\u6cd5\uff1aorg.springframework.boot.autoconfigure.flyway.FlywayProperties#FlywayPropertie()<\/code><\/p>\n
public FlywayProperties() {\n    this.encoding = StandardCharsets.UTF_8;\n    this.schemas = new ArrayList();\n    this.table = "flyway_schema_history"; \/\/ \u9ed8\u8ba4\u7684\u8868\u540d\u79f0\uff0c\u4f1a\u81ea\u52a8\u5efa\u7acb\n    this.baselineDescription = "<< Flyway Baseline >>"; \/\/ base line \u63cf\u8ff0\n    this.baselineVersion = "1";\n    this.placeholders = new HashMap();\n    this.placeholderPrefix = "${";    \/\/ \u5982\u679c\u53c2\u6570\u5360\u4f4d\uff0c\u6709\u53ef\u80fd\u4f1a\u548cmaven\u7b49\u51b2\u7a81\uff0c\u56e0\u6b64\u53ef\u80fd\u9700\u8981\u81ea\u5b9a\u4e49\uff0c\u5982:@{\n    this.placeholderSuffix = "}";\n    this.placeholderReplacement = true;\n    this.sqlMigrationPrefix = "V";\n    this.sqlMigrationSuffixes = new ArrayList(Collections.singleton(".sql"));\n    this.sqlMigrationSeparator = "__"; \/\/ sql\u683c\u5f0f\uff0c\u7248\u672c\u53f7\u548c\u63cf\u8ff0\u5206\u9694\u7b26\u914d\u7f6e\uff0c\u5982\uff1aV1_0_1__\u4e00\u4e9b\u63cf\u8ff0.sql\n    this.repeatableSqlMigrationPrefix = "R";\n    this.initSqls = new ArrayList();\n    this.ignoreFutureMigrations = true;\n    this.validateOnMigrate = true;\n}<\/code><\/pre>\n
\u5176\u4ed6\u8bf4\u660e\uff1a<\/p>\n
spring:\n  flyway:\n    baseline-on-migrate: true #\u662f\u5426\u5efa\u7acbbaseline\n    out-of-order: true #\u7248\u672c\u662f\u5426\u662f\u65e0\u5e8f\uff0c\u5efa\u8bae\u662f\u5f00\u542f\uff0c\u5c24\u5176\u662f\u591a\u4eba\u5f00\u53d1\u7684\u65f6\u5019\uff0c\u540e\u63d0\u4ea4\u8001\u7248\u672c\u7684sql\u4e5f\u80fd\u5f97\u5230\u6267\u884c\n    locations: classpath:db\/migration #\u9ed8\u8ba4\u4f4d\u7f6e<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
SpringBoot\u9879\u76ee\u6570\u636e\u5e93\u8bbf\u95eeMySQL \u6b64\u9879\u76ee\u4ee5MySQL\u6570\u636e\u5e93\u4f5c\u4e3a\u6d4b\u8bd5\u6570\u636e\u5e93\uff0c\u5e76\u4f7f\u7528Flyway\u6765\u7ba1\u7406 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[12,11],"_links":{"self":[{"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/posts\/52"}],"collection":[{"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fugary.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=52"}],"version-history":[{"count":2,"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/posts\/52\/revisions"}],"predecessor-version":[{"id":103,"href":"https:\/\/fugary.com\/index.php?rest_route=\/wp\/v2\/posts\/52\/revisions\/103"}],"wp:attachment":[{"href":"https:\/\/fugary.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=52"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fugary.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=52"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fugary.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=52"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}