Hibernate:Disjunction&Conjunction构造复杂的查询条件
来源:互联网 发布:168源码 编辑:程序博客网 时间:2024/04/27 23:34
HIBERNATE:DISJUNCTION&CONJUNCTION构造复杂的查询条件.
Hibernate:Disjunction&Conjunction构造复杂的查询条件
Disjunction和Conjunction是逻辑或和逻辑与,如下:
用来组合一组逻辑或【or】条件的方法
- 1.Restrictions.disjunction();
用来组合一组逻辑与【and】条件的方法
- 2.Restrictions.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 = ?))
实例二:构造模糊查询
- Disjunction dis=Restrictions.disjunction();
- dis.add(Restrictions.like("chanpin", "冰箱", MatchMode.ANYWHERE));
- dis.add(Restrictions.like("chanpin", "洗衣机", MatchMode.ANYWHERE));
- dis.add(Restrictions.like("chanpin", "热水器", MatchMode.ANYWHERE));
- dis.add(Restrictions.like("chanpin", "空调", MatchMode.ANYWHERE));
- detachedCriteria.add(dis);
0 0
- hibernate: 用Disjunction和Conjunction构造复杂的查询条件
- hibernate: 用Disjunction和Conjunction构造复杂的查询条件
- Hibernate:Disjunction&Conjunction构造复杂的查询条件.
- Hibernate:Disjunction&Conjunction构造复杂的查询条件
- Hibernate的Disjunction和Conjunction
- Hibernate的Disjunction和Conjunction
- Hibernate 使用Disjunction动态添加查询条件
- 复杂条件的查询
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- DetachedCriteria多条件查询or,disjunction
- 使用hibernate复杂的条件查询和Criteria联表查询应用
- Hibernate的条件查询
- 随堂笔记第一天:环境变量配置,代码的三种注释方法,第一个程序,基本数据类型------1
- 7.COM 自动化原理
- 在 Laravel 5 中使用 Laravel Excel 实现 Excel/CSV 文件导入导出功能
- 浅拷贝&深拷贝|| MutableCopy& Copy
- Counting Kangaroos is Fun
- Hibernate:Disjunction&Conjunction构造复杂的查询条件
- 22.css定义width和height的大小
- 二分查找
- 2016多校第三场 HDU 5755
- Android Studio 提交现有项目到osc
- FZU2039 匈牙利算法
- HDFS 单机搭建
- POJ-2507 Crossed ladders
- MongoDB之数据库管理