增加测试，增加mybatis3.3.1新功能的例子

abel533 · abel533 · commit 953e99892fae · 2016-03-06T18:14:46.000+08:00
diff --git a/pom.xml b/pom.xml
@@ -40,6 +40,10 @@
             <groupId>org.springframework.boot</groupId>
             <artifactId>spring-boot-starter-freemarker</artifactId>
         </dependency>
+        <dependency>
+            <groupId>org.springframework.boot</groupId>
+            <artifactId>spring-boot-starter-test</artifactId>
+        </dependency>
 
         <dependency>
             <groupId>mysql</groupId>
diff --git a/src/test/java/tk/mybatis/springboot/mapper/MyBatis331Mapper.java b/src/test/java/tk/mybatis/springboot/mapper/MyBatis331Mapper.java
@@ -0,0 +1,67 @@
+/*
+ * The MIT License (MIT)
+ *
+ * Copyright (c) 2014-2016 abel533@gmail.com
+ *
+ * Permission is hereby granted, free of charge, to any person obtaining a copy
+ * of this software and associated documentation files (the "Software"), to deal
+ * in the Software without restriction, including without limitation the rights
+ * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+ * copies of the Software, and to permit persons to whom the Software is
+ * furnished to do so, subject to the following conditions:
+ *
+ * The above copyright notice and this permission notice shall be included in
+ * all copies or substantial portions of the Software.
+ *
+ * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+ * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+ * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+ * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+ * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+ * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
+ * THE SOFTWARE.
+ */
+
+package tk.mybatis.springboot.mapper;
+
+import org.apache.ibatis.annotations.*;
+import tk.mybatis.springboot.model.City2;
+
+import java.util.List;
+
+/**
+ * mybatis3.3.1版本新增功能测试
+ *
+ * @author liuzh
+ * @since 2016-03-06 17:22
+ */
+public interface MyBatis331Mapper {
+
+    /**
+     * 批量插入
+     *
+     * @param cities
+     * @return
+     */
+    @Insert("<script>" +
+            "insert into city (id, name, state) values " +
+            "<foreach collection=\"list\" item=\"city\" separator=\",\" >" +
+                "(#{city.id}, #{city.cityName}, #{city.cityState})" +
+            "</foreach>" +
+            "</script>")
+    @Options(useGeneratedKeys = true, keyProperty = "id")
+    int insertCities(List<City2> cities);
+
+    @Results(id = "cityResult", value = {
+        @Result(property = "id", column = "id", id = true),
+        @Result(property = "cityName", column = "name", id = true),
+        @Result(property = "cityState", column = "state", id = true)
+    })
+    @Select("select id, name, state from city where id = #{id}")
+    City2 selectByCityId(Integer id);
+
+
+    @ResultMap("cityResult")
+    @Select("select id, name, state from city")
+    List<City2> selectAll();
+}
diff --git a/src/test/java/tk/mybatis/springboot/mapper/MyBatis331Test.java b/src/test/java/tk/mybatis/springboot/mapper/MyBatis331Test.java
@@ -0,0 +1,92 @@
+/*
+ * The MIT License (MIT)
+ *
+ * Copyright (c) 2014-2016 abel533@gmail.com
+ *
+ * Permission is hereby granted, free of charge, to any person obtaining a copy
+ * of this software and associated documentation files (the "Software"), to deal
+ * in the Software without restriction, including without limitation the rights
+ * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+ * copies of the Software, and to permit persons to whom the Software is
+ * furnished to do so, subject to the following conditions:
+ *
+ * The above copyright notice and this permission notice shall be included in
+ * all copies or substantial portions of the Software.
+ *
+ * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+ * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+ * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+ * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+ * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+ * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
+ * THE SOFTWARE.
+ */
+
+package tk.mybatis.springboot.mapper;
+
+import org.junit.Assert;
+import org.junit.Test;
+import org.junit.runner.RunWith;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.boot.test.SpringApplicationConfiguration;
+import org.springframework.test.annotation.Rollback;
+import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
+import org.springframework.test.context.web.WebAppConfiguration;
+import org.springframework.transaction.annotation.Transactional;
+import tk.mybatis.springboot.Application;
+import tk.mybatis.springboot.model.City2;
+
+import java.util.ArrayList;
+import java.util.List;
+
+/**
+ * @author liuzh
+ * @since 2016-03-06 17:42
+ */
+@RunWith(SpringJUnit4ClassRunner.class)
+@WebAppConfiguration
+@Transactional
+@SpringApplicationConfiguration(Application.class)
+public class MyBatis331Test {
+    private Logger logger = LoggerFactory.getLogger(getClass());
+
+    @Autowired
+    private MyBatis331Mapper mapper;
+
+    @Test
+    @Rollback
+    public void testInsertList() {
+        List<City2> city2List = new ArrayList<City2>();
+        city2List.add(new City2("石家庄", "河北"));
+        city2List.add(new City2("邯郸", "河北"));
+        city2List.add(new City2("秦皇岛", "河北"));
+        Assert.assertEquals(3, mapper.insertCities(city2List));
+        for (City2 c2 : city2List) {
+            logger.info(c2.toString());
+            Assert.assertNotNull(c2.getId());
+        }
+    }
+
+    @Test
+    public void testSelectById(){
+        City2 city2 = mapper.selectByCityId(1);
+        logger.info(city2.toString());
+        Assert.assertNotNull(city2);
+        Assert.assertNotNull(city2.getCityName());
+        Assert.assertNotNull(city2.getCityState());
+    }
+
+    @Test
+    public void testSelectAll(){
+        List<City2> city2List = mapper.selectAll();
+        for(City2 c2 : city2List){
+            logger.info(c2.toString());
+            Assert.assertNotNull(c2);
+            Assert.assertNotNull(c2.getCityName());
+            Assert.assertNotNull(c2.getCityState());
+        }
+    }
+
+}
diff --git a/src/test/java/tk/mybatis/springboot/mapper/city.sql b/src/test/java/tk/mybatis/springboot/mapper/city.sql
@@ -0,0 +1,18 @@
+SET FOREIGN_KEY_CHECKS=0;
+
+-- ----------------------------
+-- Table structure for city
+-- ----------------------------
+DROP TABLE IF EXISTS `city`;
+CREATE TABLE `city` (
+  `id` bigint(20) NOT NULL AUTO_INCREMENT,
+  `name` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
+  `state` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
+  PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
+
+-- ----------------------------
+-- Records of city
+-- ----------------------------
+INSERT INTO `city` VALUES ('1', '石家庄', '河北');
+INSERT INTO `city` VALUES ('2', '邯郸', '河北');
diff --git a/src/test/java/tk/mybatis/springboot/model/City2.java b/src/test/java/tk/mybatis/springboot/model/City2.java
@@ -0,0 +1,80 @@
+/*
+ * The MIT License (MIT)
+ *
+ * Copyright (c) 2014-2016 abel533@gmail.com
+ *
+ * Permission is hereby granted, free of charge, to any person obtaining a copy
+ * of this software and associated documentation files (the "Software"), to deal
+ * in the Software without restriction, including without limitation the rights
+ * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
+ * copies of the Software, and to permit persons to whom the Software is
+ * furnished to do so, subject to the following conditions:
+ *
+ * The above copyright notice and this permission notice shall be included in
+ * all copies or substantial portions of the Software.
+ *
+ * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
+ * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
+ * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
+ * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
+ * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
+ * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
+ * THE SOFTWARE.
+ */
+
+package tk.mybatis.springboot.model;
+
+/**
+ * mybatis 3.3.1新功能测试使用
+ *
+ * @author liuzh
+ * @since 2016-01-22 22:16
+ */
+public class City2 {
+    private Integer id;
+
+    private String cityName;
+
+    private String cityState;
+
+    public City2() {
+    }
+
+    public City2(String cityName, String cityState) {
+        this.cityName = cityName;
+        this.cityState = cityState;
+    }
+
+    public Integer getId() {
+        return id;
+    }
+
+    public void setId(Integer id) {
+        this.id = id;
+    }
+
+    public String getCityName() {
+        return cityName;
+    }
+
+    public void setCityName(String cityName) {
+        this.cityName = cityName;
+    }
+
+    public String getCityState() {
+        return cityState;
+    }
+
+    public void setCityState(String cityState) {
+        this.cityState = cityState;
+    }
+
+    @Override
+    public String toString() {
+        return "City2{" +
+                "id=" + id +
+                ", cityName='" + cityName + '\'' +
+                ", cityState='" + cityState + '\'' +
+                '}';
+    }
+}
