Hibernate 的QBC语法 DetachedCriteria ！
日期：2014-05-16 浏览次数：20673 次
?
1：例子
?public Paginate getList0(Paginate paginate) { ??DetachedCriteria criter = DetachedCriteria.forClass(Paginate .class); ??DetachedCriteria criterForTotalResults = DetachedCriteria.forClass(Paginate .class); ?? ??criter.add(Expression.eq("dealed", new Boolean(false))); ??Calendar c = Calendar.getInstance(); ??c.add(Calendar.DATE, -10); ??c.set(Calendar.HOUR_OF_DAY, 0); ??c.set(Calendar.MINUTE, 0); ??c.set(Calendar.SECOND, 0); ??criter.add(Expression.ge("createtime", c.getTime())); ?? ??Paginate .setTotalResults(this.getTotalResults(criterForTotalResults)); ??List<ComStudy> list = this.getHibernateTemplate().findByCriteria(criter, paginate.getFirstResult(), Paginate .getPageSize()); ??Paginate .setResults(list); ??return Paginate ; ?}
2:参照
?
| 大于等于 | >= | Expression.ge() |
| 大于 | > | Expression.gt() |
| 小于等于 | <= | Expression.le() |
| 小于 | < | Expression.lt() |
| 等于 | = | Expression.eq() |
| 不等于 | <> | Expression.ne() |
| 为空 | is null | Expression.isNll() |
| 不为空 | is not null | Expression.isNotNull() |
| 在指定范围 | between and | Expression.betweed() |
| 不再指定范围内的属性值 | not between and | Expression.not(Expression.betweed()) |
| 属性值属于指定集合 | in | Expression.in() |
| 属性值不属于指定集合 | not in | Expression.not(Expression.in()) |
| 与 | and | Expression.and() |
| 或 | or | Expression.or() |
| 非 | not | Expression.not() |
| 模糊查询 | like | Expression.like() |
?
Expression.like("name","%"+dept.getName+"%");
