本文详细介绍了HQL和QBC中的各种运算符及其使用方法，包括但不限于等于、不等于、大于、小于等基本比较运算符，以及逻辑运算符如逻辑与、逻辑或、逻辑非等，还有特殊运算符如字符串模式匹配、区间匹配等。
Restrictions查询用法
| 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
|
原文链接--->阅读原文
扫一扫
307
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
