HibernateCRUD基础框架(2)-HQL语句构造器(HqlQueryBuilder,HqlUpdateBuilder)(三)

2014-11-24 07:25:33 · 作者: · 浏览: 1
on(age, Operator.EQUALS, ageva lue); String str2 = condition2.toString(); Assert.assertEquals(str2, age + EQUALS_WITH_BLANK + ageva lue); // =,String String name = "name"; String nameva lue = "LeiWen@FansUnion.cn"; Condition condition = new Condition(name, Operator.EQUALS, nameva lue); String str = condition.toString(); Assert.assertEquals(str, name + EQUALS_WITH_BLANK + buildQuota(nameva lue)); // =,Date String date = "date"; Date dateva lue = new Date(); Condition condition3 = new Condition(date, Operator.EQUALS, dateva lue); String str3 = condition3.toString(); Assert.assertEquals(str3, date + EQUALS_WITH_BLANK + buildQuota(dateva lue)); GroupCondition groupCondition1 = new GroupCondition(); groupCondition1.addCondition(condition); groupCondition1.addCondition(condition2, true); groupCondition1.addCondition(condition3, false); return groupCondition1; } }


5.输出结果

from HqlQueryBuilder where (name = 'LeiWen@FansUnion.cn' or age = 24 and date = 'Mon Dec 30 16:57:21 CST 2013')

or (name = 'LeiWen@FansUnion.cn' or age = 24 and date = 'Mon Dec 30 16:57:21 CST 2013')

group by name,id order by id desc,name asc

原文链接:http://blog.fansunion.cn/articles/3622(小雷博客-blog.fansunion.cn)