本文共 904 字，大约阅读时间需要 3 分钟。
| 方法 | 说明 |
|---|---|
| Restrictions.eq | = |
| Restrictions.allEq | 利用Map来进行多个等于的限制 |
| Restrictions.gt | > |
| Restrictions.ge | >= |
| Restrictions.lt | < |
| Restrictions.le | <= |
| Restrictions.between | BETWEEN |
| Restrictions.like | LIKE |
| Restrictions.in | in |
| Restrictions.and | and |
| Restrictions.or | or |
| Restrictions.sqlRestriction | 用SQL限定查询 |
Restrictions.eq
great-than > 大于Restrictions.ge
great-equal >= 大于等于Restrictions.lt
less-than < 小于Restrictions.le
less-equal <= 小于等于Restrictions.between
对应SQL的between子句Restrictions.like
对应SQL的like子句Restrictions.in
对应SQL的in子句Restrictions.and
and关系Restrictions.or
or关系Restrictions.isNull
判断属性是否为空，空则返回trueRestrictions.isNotNull
与isNull相反Restrictions.sqlRestriction
SQL限定的查询Order.asc
根据传入的字段进行升序排序Order.desc
根据传入的字段进行降序排序MatchMode.EXACT
字符串精确匹配，相当于"like ‘value’ "MatchMode.ANYWHERE
字符串在中间匹配，相当于"like ‘%value%’ "MatchMode.START
字符串在最前面的位置，相当于"like ‘value%’ "MatchMode.END
字符串在最后面的位置，相当于"like ‘%value’ "转载地址：http://jjsqb.baihongyu.com/