对照表如下:
HQL运算符 | QBC运算符 | 含义 |
= | Restrictions.eq() | 等于(equals) |
<> | 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() | 区间x到y中的任意值 |
not between x and y | Restrictions.not(Restrictions.between()) | 小于值x或大于值y |