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
|
//获取记录总数
recordCount=Convert.ToInt32(criteria.SetProjection( Projections.Count(MovieUrl.__ID )) .UniqueResult( ));
criteria.SetProjection( null );
Criteria c=session.createCriteria(Book.class);
c.add(Restrictions.like("bookname", "a",MatchMode.ANYWHERE));
c.add(Restrictions.between("bid", 1, 3));
c.add(Restrictions.not(Restrictions.in("bid", new Integer[]{1,2,4})));
c.setFirstResult(0);
c.setMaxResults(2);
List list=c.list();
Restrictions.like(“”,…,MatchMode.ANYWHERE)
AddOrder(Order.asc(“fwid”))
在oracle数据库中,如果使用Restrictions.ne("name","张三"),不会包括该字段值为空的记录
posted on 2009-11-03 17:46
junly 阅读(5094)
评论(0) 编辑 收藏 所属分类:
hibernate/orm