Hibernate Restrictions QBC運算子

標籤：nbsp   c運算子   運算   cin   idt   style   nat   isnull   字串   

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

Hibernate Restrictions QBC運算子