Changes between Version 1 and Version 2 of demo_04

Timestamp:

04/05/2012 02:15:18 PM (14 years ago)

Author:

chenyang

Comment:

--

demo_04

@@ -1 @@
-单元测试应用示例——测试工具类
+== 单元测试应用示例——测试工具类 ==
+工具类cn.com.pcgames.gamehall2.util.SqlHelper是游戏大厅DAO层辅助工具类.例如:SqlHelper.buildInsert(List<FieldDesc> fields, String tablename,String[] excludes);[[BR]]
+根据数据库表元信息，表名生成sql插入语句,使用示例代码如cn.com.pcgames.gamehall2.repository.impl.GameDAOImpl[[BR]]
+
+{{{ #!java
+   public class GameDAOImpl extends AbstractRepository<Game> implements GameDAO {
+
+        private  List<FieldDesc> tableFields;
+
+        public void setTableFields(List<FieldDesc> tableFields) {
+                this.tableFields = tableFields;
+        }
+
+        public void init() {
+                this.tableFields = SqlHelper.listFields(simpleJdbcTemplate, "game");
+        }
+
+        public GameDAOImpl() {
+                super(Game.class);
+        }
+
+        public long createGame(Game game) {
+                long gameId = idGenerator.generate("game", "gameId");
+                game.setGameId(gameId);
+                //SqlHelper生成插入语句
+                String sql = SqlHelper.buildInsert(tableFields, "game", null);
+                Object[] params = SqlHelper.getParameters(game, tableFields, null);
+                int result = simpleJdbcTemplate.update(sql, params);
+
+                return result == 1 ? gameId : 0;
+        }
+        
+       ......
+     }
+}}}