hibernate: 用Disjunction和Conjunction构造复杂的查询条件

[url]http://blog.csdn.net/whqcfp/article/details/6029061[/url]
[color=darkblue][b]Disjunction和Conjunction是逻辑或和逻辑与[/b][/color]，可以用这个来构造复杂的SQL查询条件，实例如下：

 private void CheckBsc_lj(Criteria queryCriteria) 
 {
  Disjunction disjunction = Restrictions.disjunction();
  Criterion cirterion = Restrictions.sqlRestriction("SIMULPORTCAPACITY<SIMULPORTCAPACITYOCUPIED".toLowerCase());
  disjunction.add(cirterion);
  cirterion = Restrictions.sqlRestriction("ADSLPORTCAPACITY<ADSLPORTCAPACITYOCCUPIED".toLowerCase());
  disjunction.add(cirterion);
  cirterion = Restrictions.sqlRestriction("LANPORTCAPACITY<LANPORTCAPACITYOCCUPIED".toLowerCase());
  disjunction.add(cirterion);

  // ONU端口，至少要录入一种端口
  Conjunction conjunction = Restrictions.conjunction();
  cirterion = Restrictions.eq("lanportcapacity", 0);
  conjunction.add(cirterion);
  cirterion = Restrictions.eq("simulportcapacity", 0);
  conjunction.add(cirterion);
  cirterion = Restrictions.eq("adslportcapacity", 0);
  conjunction.add(cirterion);

  disjunction.add(conjunction);
  queryCriteria.add(disjunction);
 }

构造出的条件如下：

select *
  from aaaa this_
 where (simulportcapacity < simulportcapacityocupied or
       adslportcapacity < adslportcapacityoccupied or
       lanportcapacity < lanportcapacityoccupied or
       (this_.LANPORTCAPACITY = ? and this_.SIMULPORTCAPACITY = ? and
       this_.ADSLPORTCAPACITY = ?))