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), ""); + } + +}