HQL跟QBC支持的各种类型
HQL和QBC支持的各种类型
对照表如下:
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 |