Example增加了4个方法

abel533 · abel533 · commit 56319e4e41dd · 2015-10-29T21:12:22.000+08:00
diff --git a/src/main/java/tk/mybatis/mapper/entity/Example.java b/src/main/java/tk/mybatis/mapper/entity/Example.java
@@ -26,6 +26,7 @@
 
 import org.apache.ibatis.reflection.MetaObject;
 import org.apache.ibatis.reflection.SystemMetaObject;
+import org.apache.ibatis.type.TypeHandler;
 import tk.mybatis.mapper.mapperhelper.EntityHelper;
 
 import java.util.*;
@@ -305,6 +306,55 @@ public Criteria andNotLike(String property, String value) {
             return (Criteria) this;
         }
 
+        /**
+         * 手写条件
+         *
+         * @param condition 例如 "length(countryname)<5"
+         * @return
+         */
+        public Criteria andCondition(String condition) {
+            addCriterion(condition);
+            return (Criteria) this;
+        }
+
+        /**
+         * 手写左边条件，右边用value值
+         *
+         * @param condition 例如 "length(countryname)="
+         * @param value     例如 5
+         * @return
+         */
+        public Criteria andCondition(String condition, Object value) {
+            criteria.add(new Criterion(condition, value));
+            return (Criteria) this;
+        }
+
+        /**
+         * 手写左边条件，右边用value值
+         *
+         * @param condition   例如 "length(countryname)="
+         * @param value       例如 5
+         * @param typeHandler 类型处理
+         * @return
+         */
+        public Criteria andCondition(String condition, Object value, String typeHandler) {
+            criteria.add(new Criterion(condition, value, typeHandler));
+            return (Criteria) this;
+        }
+
+        /**
+         * 手写左边条件，右边用value值
+         *
+         * @param condition   例如 "length(countryname)="
+         * @param value       例如 5
+         * @param typeHandler 类型处理
+         * @return
+         */
+        public Criteria andCondition(String condition, Object value, Class<? extends TypeHandler> typeHandler) {
+            criteria.add(new Criterion(condition, value, typeHandler.getCanonicalName()));
+            return (Criteria) this;
+        }
+
         /**
          * 将此对象的不为空的字段参数作为相等查询条件
          *
diff --git a/src/test/java/tk/mybatis/mapper/test/example/TestSelectByExample.java b/src/test/java/tk/mybatis/mapper/test/example/TestSelectByExample.java
@@ -1,6 +1,7 @@
 package tk.mybatis.mapper.test.example;
 
 import org.apache.ibatis.session.SqlSession;
+import org.apache.ibatis.type.StringTypeHandler;
 import org.junit.Assert;
 import org.junit.Test;
 import tk.mybatis.mapper.entity.Example;
@@ -33,6 +34,24 @@ public void testSelectByExample() {
         }
     }
 
+    @Test
+    public void testAndExample() {
+        SqlSession sqlSession = MybatisHelper.getSqlSession();
+        try {
+            CountryMapper mapper = sqlSession.getMapper(CountryMapper.class);
+            Example example = new Example(Country.class);
+            example.createCriteria()
+                    .andCondition("countryname like 'C%' and id < 100")
+                    .andCondition("length(countryname) = ", 5)
+                    .andCondition("countrycode =", "CN", StringTypeHandler.class);
+            List<Country> countries = mapper.selectByExample(example);
+            //查询总数
+            Assert.assertEquals(1, countries.size());
+        } finally {
+            sqlSession.close();
+        }
+    }
+
     @Test
     public void testSelectByExampleInNotIn() {
         SqlSession sqlSession = MybatisHelper.getSqlSession();
diff --git a/src/test/resources/mybatis-java.xml b/src/test/resources/mybatis-java.xml
@@ -29,7 +29,7 @@
                 <property name="url" value="jdbc:hsqldb:mem:basetest" />
                 <property name="username" value="sa" />
                 <!--<property name="driver" value="com.mysql.jdbc.Driver" />
-                <property name="url" value="jdbc:mysql://192.168.1.200:3306/pagehelper" />
+                <property name="url" value="jdbc:mysql://192.168.16.137:3306/test" />
                 <property name="username" value="root" />
                 <property name="password" value="" />-->
             </dataSource>
