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

最新推荐文章于 2024-02-25 04:45:15 发布

whqcfp

最新推荐文章于 2024-02-25 04:45:15 发布

阅读量1.1w

点赞数

分类专栏： JAVA Hibernate 文章标签： hibernate sql

本文链接：https://blog.csdn.net/whqcfp/article/details/6029061

版权

JAVA 同时被 2 个专栏收录

45 篇文章 0 订阅

订阅专栏

Hibernate

7 篇文章 0 订阅

订阅专栏

Disjunction和Conjunction是逻辑或和逻辑与，可以用这个来构造复杂的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 = ?))