使用Flyway来管理数据库版本

dyc87112 · dyc87112 · commit 51b5f430ec87 · 2017-12-25T22:38:31.000+08:00
diff --git a/Chapter3-2-9/src/main/java/com/didispace/service/UserServiceImpl.java b/Chapter3-2-9/src/main/java/com/didispace/service/UserServiceImpl.java
@@ -18,21 +18,21 @@ public class UserServiceImpl implements UserService {
 
     @Override
     public void create(String name, Integer age) {
-        jdbcTemplate.update("insert into t_user(NAME, AGE) values(?, ?)", name, age);
+        jdbcTemplate.update("insert into user(NAME, AGE) values(?, ?)", name, age);
     }
 
     @Override
     public void deleteByName(String name) {
-        jdbcTemplate.update("delete from t_user where NAME = ?", name);
+        jdbcTemplate.update("delete from user where NAME = ?", name);
     }
 
     @Override
     public Integer getAllUsers() {
-        return jdbcTemplate.queryForObject("select count(1) from t_user", Integer.class);
+        return jdbcTemplate.queryForObject("select count(1) from user", Integer.class);
     }
 
     @Override
     public void deleteAllUsers() {
-        jdbcTemplate.update("delete from t_user");
+        jdbcTemplate.update("delete from user");
     }
 }
diff --git a/Chapter3-2-9/src/main/resources/db/V1__Base_version.sql b/Chapter3-2-9/src/main/resources/db/V1__Base_version.sql
@@ -1,9 +1,9 @@
-DROP TABLE IF EXISTS t_user ;
+DROP TABLE IF EXISTS `user` ;
 
 
-CREATE TABLE `t_user` (
+CREATE TABLE `user` (
   `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
-  `name` varchar(20) NOT NULL COMMENT '姓名',
+  `name` varchar(30) NOT NULL COMMENT '姓名',
   `age` int(5) DEFAULT NULL COMMENT '年龄',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

Original file line number	Diff line number	Diff line change
`@@ -18,21 +18,21 @@ public class UserServiceImpl implements UserService {`
`18`	`18`
`19`	`19`	`@Override`
`20`	`20`	`public void create(String name, Integer age) {`
`21`		`- jdbcTemplate.update("insert into t_user(NAME, AGE) values(?, ?)", name, age);`
	`21`	`+ jdbcTemplate.update("insert into user(NAME, AGE) values(?, ?)", name, age);`
`22`	`22`	`}`
`23`	`23`
`24`	`24`	`@Override`
`25`	`25`	`public void deleteByName(String name) {`
`26`		`- jdbcTemplate.update("delete from t_user where NAME = ?", name);`
	`26`	`+ jdbcTemplate.update("delete from user where NAME = ?", name);`
`27`	`27`	`}`
`28`	`28`
`29`	`29`	`@Override`
`30`	`30`	`public Integer getAllUsers() {`
`31`		`- return jdbcTemplate.queryForObject("select count(1) from t_user", Integer.class);`
	`31`	`+ return jdbcTemplate.queryForObject("select count(1) from user", Integer.class);`
`32`	`32`	`}`
`33`	`33`
`34`	`34`	`@Override`
`35`	`35`	`public void deleteAllUsers() {`
`36`		`- jdbcTemplate.update("delete from t_user");`
	`36`	`+ jdbcTemplate.update("delete from user");`
`37`	`37`	`}`
`38`	`38`	`}`