分离sql

houko · houko · commit e059e1fd52a0 · 2016-11-16T11:31:47.000+08:00
diff --git a/multipleSource/src/main/java/info/xiaomo/multipleSource/controller/MultipleSourceController.java b/multipleSource/src/main/java/info/xiaomo/multipleSource/controller/MultipleSourceController.java
@@ -1,6 +1,7 @@
 package info.xiaomo.multipleSource.controller;
 
 import info.xiaomo.core.controller.Result;
+import info.xiaomo.multipleSource.sql.Sql;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Qualifier;
 import org.springframework.jdbc.core.JdbcTemplate;
@@ -40,11 +41,11 @@ public MultipleSourceController(@Qualifier("primaryJdbcTemplate") JdbcTemplate j
     @RequestMapping("/")
     public Result index() {
         // 往第一个数据源中插入两条数据
-        jdbcTemplate1.update("insert into user(name,age) values(?, ?)", "xiaomo", 20);
-        jdbcTemplate2.update("insert into user(name,age) values(?, ?)", "xiaoming", 30);
+        jdbcTemplate1.update(Sql.addUser1, "xiaomo", 20);
+        jdbcTemplate2.update(Sql.addUser1, "xiaoming", 30);
 
-        int count1 = jdbcTemplate1.queryForObject("select count(1) from user", Integer.class);
-        int count2 = jdbcTemplate2.queryForObject("select count(1) from user", Integer.class);
+        int count1 = jdbcTemplate1.queryForObject(Sql.selectUser1, Integer.class);
+        int count2 = jdbcTemplate2.queryForObject(Sql.selectUser2, Integer.class);
         return new Result(new Object[]{count1, count2});
     }
 }
diff --git a/multipleSource/src/main/java/info/xiaomo/multipleSource/sql/Sql.java b/multipleSource/src/main/java/info/xiaomo/multipleSource/sql/Sql.java
@@ -0,0 +1,26 @@
+package info.xiaomo.multipleSource.sql;
+
+/**
+ * 把今天最好的表现当作明天最新的起点．．～
+ * いま 最高の表現 として 明日最新の始発．．～
+ * Today the best performance  as tomorrow newest starter!
+ * Created by IntelliJ IDEA.
+ *
+ * @author: xiaomo
+ * @github: https://github.com/qq83387856
+ * @email: hupengbest@163.com
+ * @QQ_NO: 83387856
+ * @Date: 2016/11/16 11:29
+ * @Description: 用户实体类
+ * @Copyright(©) 2015 by xiaomo.
+ **/
+
+public class Sql {
+
+    public static String addUser1= "insert into user(name,age) values(?, ?)";
+    public static String addUser2= "insert into user(name,age) values(?, ?)";
+
+    public static String selectUser1 = "select count(1) from user";
+    public static String selectUser2 = "select count(1) from user";
+
+}
