HQL运算符 |
QBC运算符 |
含义 |
= |
Restrictions.eq() |
等于equal |
<> |
Restrictions.ne() |
不等于not equal |
> |
Restrictions.gt() |
大于greater than |
>= |
Restrictions.ge() |
大于等于greater than or equal |
< |
Restrictions.lt() |
小于less than |
<= |
Restrictions.le() |
小于等于less than or equal |
is null |
Restrictions.isnull() |
等于空值 |
is not null |
Restrictions.isNotNull() |
非空值 |
like |
Restrictions.like() |
字符串模式匹配 |
and |
Restrictions.and() |
逻辑与 |
and |
Restrictions.conjunction() |
逻辑与 |
or |
Restrictions.or() |
逻辑或 |
or |
Restrictions.disjunction() |
逻辑或 |
not |
Restrictions.not() |
逻辑非 |
in(列表) |
Restrictions.in() |
等于列表中的某一个值 |
not in(列表) |
Restrictions.not(Restrictions.in()) |
不等于列表中任意一个值 |
between x and y |
Restrictions.between() |
闭区间xy中的任意值 |
not between x and y |
Restrictions.not(Restrictions..between()) |
小于值X或者大于值y |
相关文章
- 12-23MyBatis Generator Example.Criteria 查询条件复制
- 12-23Nhibernate Query By Criteria 条件查询
- 12-23Hibernate QBC 条件查询(Criteria Queries) and Demos
- 12-23Nhibernate Criteria 多个or条件查询
- 12-23Mybatis-技术专区-Criteria的and和or进行联合条件查询
- 12-23hibernate条件查询 Criteria查询
- 12-23hibernate Criteria查询多对多(Set集合)条件筛选
- 12-23【JAVAEE学习笔记】hibernate04:查询种类、HQL、Criteria、查询优化和练习为客户列表增加查询条件
- 12-23Hibernate 多表查询 - Criteria添加子字段查询条件 - 出错问题解决
- 12-23一起谈.NET技术,NHibernate3.0剖析:Query篇之NHibernate.Linq标准查询