Index: ssts-web/src/test/resources/test/forgon/tools/AllTests.xml
===================================================================
diff -u -r16829 -r17661
--- ssts-web/src/test/resources/test/forgon/tools/AllTests.xml (.../AllTests.xml) (revision 16829)
+++ ssts-web/src/test/resources/test/forgon/tools/AllTests.xml (.../AllTests.xml) (revision 17661)
@@ -9,6 +9,7 @@
+
\ No newline at end of file
Index: ssts-web/src/test/java/test/forgon/tools/util/SqlUtilsTest.java
===================================================================
diff -u
--- ssts-web/src/test/java/test/forgon/tools/util/SqlUtilsTest.java (revision 0)
+++ ssts-web/src/test/java/test/forgon/tools/util/SqlUtilsTest.java (revision 17661)
@@ -0,0 +1,42 @@
+package test.forgon.tools.util;
+
+import org.testng.annotations.Test;
+import static org.testng.Assert.*;
+import com.forgon.tools.util.SqlUtils;
+
+import test.forgon.disinfectsystem.AbstractCSSDTest;
+/**
+ * sql语句工具类的测试
+ * @author Chenjiaru
+ *
+ */
+public class SqlUtilsTest extends AbstractCSSDTest {
+
+ /**
+ * 此方法主要测试四种场景
+ * 1、当field="name",arr = {"张三", "李四"}时。预期结果:" and (name='张三' or name='李四')"
+ * 2、当field="po.name",arr = {"张三", "李四"}时。预期结果:" and (po.name='张三' or po.name='李四')"
+ * 3、当field="",arr = {"张三", "李四"}时。预期结果:""
+ * 4、当field="name",arr = {}时。预期结果:""
+ *
+ */
+ @Test
+ public void testGet_OrSql() {
+ String field1 = "name";
+ String[] arr1 = {"张三", "李四"};
+ assertEquals(SqlUtils.get_OrSql(field1, arr1), " and (name='张三' or name='李四')");
+
+ String field2 = "po.name";
+ String[] arr2 = {"张三", "李四"};
+ assertEquals(SqlUtils.get_OrSql(field2, arr2), " and (po.name='张三' or po.name='李四')");
+
+ String field3 = "";
+ String[] arr3 = {"张三", "李四"};
+ assertEquals(SqlUtils.get_OrSql(field3, arr3), "");
+
+ String field4 = "name";
+ String[] arr4 = {};
+ assertEquals(SqlUtils.get_OrSql(field4, arr4), "");
+ }
+
+}