@Test public void testSelectWithFunction() throws SQLException { Query<Person> t1 = QB.create(Person.class); // 只选择指定的列 t1.addCondition(new FBIField("MOD(age, 10)", t1), 2); t1.setCascade(false); List<Person> map = db.select(t1.getInstance()); }
/** * 测试JpqlExpression表达式的使用 * * @throws SQLException */ @Test public void testExpression1() throws SQLException { System.out.println("=========== testExpression1 Start =========="); Query<Person> p = QB.create(Person.class); p.addCondition( new FBIField("upper(name)||str(age)", p), new JpqlExpression("upper(name)||'22'", p)); List<Person> ps = db.select(p); assertTrue(ps.size() > 0); System.out.println("=========== testExpression1 End =========="); }