完善测试

abel533 · abel533 · commit 3a9cc7375063 · 2015-12-11T22:13:45.000+08:00
diff --git a/src/test/java/tk/mybatis/mapper/model/Entity.java b/src/test/java/tk/mybatis/mapper/model/Entity.java
@@ -34,6 +34,8 @@
  * @since 2015-12-06 10:31
  */
 public class Entity<ID extends Serializable, NAME extends Serializable> {
+    //这里的a,b,c,d仅用来测试FieldHelper中的静态字段
+    private static Integer a, b, c, d;
 
     private ID id;
 
diff --git a/src/test/java/tk/mybatis/mapper/test/country/TestSelect.java b/src/test/java/tk/mybatis/mapper/test/country/TestSelect.java
@@ -86,6 +86,26 @@ public void testDynamicSelectPage() {
         }
     }
 
+    /**
+     * 查询全部
+     */
+    @Test
+    public void testAllColumns() {
+        SqlSession sqlSession = MybatisHelper.getSqlSession();
+        try {
+            CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
+            Country country = new Country();
+            //35,'China','CN'
+            country.setCountrycode("CN");
+            country.setId(35);
+            country.setCountryname("China");
+            List<Country> countryList = mapper.select(country);
+            Assert.assertEquals(1, countryList.size());
+        } finally {
+            sqlSession.close();
+        }
+    }
+
     /**
      * 入参为null时查询全部
      */
diff --git a/src/test/java/tk/mybatis/mapper/test/country/TestUpdateByPrimaryKey.java b/src/test/java/tk/mybatis/mapper/test/country/TestUpdateByPrimaryKey.java
@@ -76,6 +76,7 @@ public void testDynamicUpdateByPrimaryKey() {
             CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
             Country country = new Country();
             country.setId(174);
+            country.setCountryname(null);
             country.setCountryname("美国");
             Assert.assertEquals(1, mapper.updateByPrimaryKey(country));
 
diff --git a/src/test/java/tk/mybatis/mapper/test/example/TestSelectByExample.java b/src/test/java/tk/mybatis/mapper/test/example/TestSelectByExample.java
@@ -163,4 +163,19 @@ public void testSelectColumnsByExample() {
         }
     }
 
+    @Test
+    public void testOrderBy() {
+        SqlSession sqlSession = MybatisHelper.getSqlSession();
+        try {
+            CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
+            Example example = new Example(Country.class);
+            example.setOrderByClause("id desc");
+            List<Country> countries = mapper.selectByExample(example);
+            //查询总数
+            Assert.assertEquals(183, (int) countries.get(0).getId());
+        } finally {
+            sqlSession.close();
+        }
+    }
+
 }

Original file line number	Diff line number	Diff line change
`@@ -163,4 +163,19 @@ public void testSelectColumnsByExample() {`
`163`	`163`	`}`
`164`	`164`	`}`
`165`	`165`
	`166`	`+ @Test`
	`167`	`+ public void testOrderBy() {`
	`168`	`+ SqlSession sqlSession = MybatisHelper.getSqlSession();`
	`169`	`+ try {`
	`170`	`+ CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);`
	`171`	`+ Example example = new Example(Country.class);`
	`172`	`+ example.setOrderByClause("id desc");`
	`173`	`+ List<Country> countries = mapper.selectByExample(example);`
	`174`	`+ //查询总数`
	`175`	`+ Assert.assertEquals(183, (int) countries.get(0).getId());`
	`176`	`+ } finally {`
	`177`	`+ sqlSession.close();`
	`178`	`+ }`
	`179`	`+ }`
	`180`	`+`
`166`	`181`	`}`