public void testAnd() { log("to test and()... "); ISQLLogic logic1 = SQLLogicBuilder.build("field", SQLOperator.GREATER_OR_EQUAL, 100); ISQLLogic logic2 = SQLLogicBuilder.build("filed", SQLOperator.NOT_EQUAL, false); // 1. and TRUE ISQLLogic logic = SQLLogicBuilder.and(logic1, SQLLogicString.TRUE); List params = new ArrayList(); assertTrue(logic == logic1); // 2. and FALSE logic = SQLLogicBuilder.and(logic1, SQLLogicString.FALSE); assertTrue(logic == SQLLogicString.FALSE); // 3. TRUE and logic = SQLLogicBuilder.and(SQLLogicString.TRUE, logic2); assertTrue(logic == logic2); // 4. FALSE and logic = SQLLogicBuilder.and(SQLLogicString.FALSE, logic2); assertTrue(logic == SQLLogicString.FALSE); // 5. 1 and 2 logic = SQLLogicBuilder.and(logic1, logic2); params.clear(); assertEquals("field>=? AND filed<>?", logic.toSQL(params)); }