Changes between Version 3 and Version 4 of demo_04

Timestamp:

04/05/2012 02:30:47 PM (14 years ago)

Author:

chenyang

Comment:

--

demo_04

@@ -36 +36 @@
 如何单元测试SqlHelper.buildInsert?[[BR]]
 测试SqlHelper.buildInsert(List<FieldDesc> fields, String tablename,String[] excludes);方法，需要准备fields,tablename,excludes这三个参数[[BR]]
+
+* 准备fields
 fields是数据库表的元信息,元信息依赖SimpleJdbcTemplate对象根据表名获取,我们让测试类SqlHelperTest继承之AbstractTransactionalJUnit4SpringContextTests[[BR]]
 以获得applicationContext对象的引用，然后注入SimpleJdbcTemplate对象.
@@ -50 +52 @@
 }
 }}}
+* 准备tablename,我们可以在数据库中创建一张表，用来测试
+
+{{{ #!java
+        private void createTesttable(String table) {
+
+                simpleJdbcTemplate.update("DROP TABLE IF EXISTS `" + table + "`");
+
+                simpleJdbcTemplate
+                                .update("CREATE TABLE `" + table + "` ("
+                                                + "`id` bigint(20) NOT NULL,"
+                                                + "`createAt` timestamp NULL DEFAULT NULL,"
+                                                + "`name` varchar(50) DEFAULT NULL,"
+                                                + "`age` int(11) DEFAULT NULL,"
+                                                + "`info` text,"
+                                                + "`rate` float DEFAULT NULL,"
+                                                + "PRIMARY KEY (`id`)"
+                                                + ") ENGINE=InnoDB DEFAULT CHARSET=gbk;");
+
+                Calendar calendar = Calendar.getInstance();
+                calendar.set(Calendar.YEAR, 2011);
+                calendar.set(Calendar.MONTH, 10);
+                calendar.set(Calendar.DAY_OF_MONTH, 10);
+                calendar.set(Calendar.HOUR_OF_DAY, 23);
+                calendar.set(Calendar.MINUTE, 23);
+                calendar.set(Calendar.SECOND, 23);
+
+                int rows = simpleJdbcTemplate.update(
+                                "INSERT INTO test_table VALUES(?,?,?,?,?,?)", new Object[] {
+                                                393648562, calendar.getTime(), "chenyang", 25,
+                                                "速度第一,完美第二",0.35 });
+
+                Assert.assertEquals(1, rows);
+
+        }
+}}}