public void testBuildIn() { Object[][] data = { // {new String[] {"a", "b", "c"}, "(f IN ('a','b','c'))"}, // {new String[] {"a", "b", null}, "((f IN ('a','b')) OR (f IS NULL))"}, // }; for (int i = 0; i < data.length; i++) { ISQLLogic logic = SQLLogicBuilder.buildIn("f", DataTypes.STRING, (Object[]) data[i][0]); String strSQL = logic.toSQL(null); System.out.println("[" + i + "]SQL=" + strSQL); assertEquals((String) data[i][1], strSQL); } }