|
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”))
posted on 2009-11-03 17:46
junly 閱讀(5110)
評論(0) 編輯 收藏 所屬分類:
hibernate/orm