Hibernate Restrictions方法说明 收集

方法说明

Restrictions.eq＝

Restrictions.allEq利用Map来进行多个等于的限制

Restrictions.gt＞

Restrictions.ge＞＝

Restrictions.lt＜

Restrictions.le＜＝

Restrictions.betweenBETWEEN

Restrictions.likeLIKE

Restrictions.inin

Restrictions.andand

Restrictions.oror

Restrictions.sqlRestriction用SQL限定查询

:QBE(QueryByExample)

Criteriacri=session.createCriteria(Student.class);

cri.add(Example.create(s));//s是一个Student对象

listcri.list();

实质：创建一个模版，比如我有一个表serial有一个giftortoy字段，我设置serial.setgifttoy("2"),

则这个表中的所有的giftortoy为2的数据都会出来

2:QBC(QueryByCriteria)主要有Criteria,Criterion,Oder,Restrictions类组成

session=this.getSession();

Criteriacri=session.createCriteria(JdItemSerialnumber.class);

Criterioncron=Restrictions.like("customer",name);

cri.add(cron);

list=cri.list();

==============================

比较运算符

HQL运算符QBC运算符含义

=Restrictions.eq()等于

<>Restrictions.not(Exprission.eq())不等于

>Restrictions.gt()大于

>=Restrictions.ge()大于等于

<Restrictions.lt()小于

<=Restrictions.le()小于等于

isnullRestrictions.isnull()等于空值

isnotnullRestrictions.isNotNull()非空值

likeRestrictions.like()字符串模式匹配

andRestrictions.and()逻辑与

andRestrictions.conjunction()逻辑与

orRestrictions.or()逻辑或

orRestrictions.disjunction()逻辑或

notRestrictions.not()逻辑非

in(列表)Restrictions.in()等于列表中的某一个值

ontin(列表)Restrictions.not(Restrictions.in())不等于列表中任意一个值

betweenxandyRestrictions.between()闭区间xy中的任意值

notbetweenxandyRestrictions.not(Restrictions..between())小于值X或者大于值y

3:HQL

Stringhql="selects.name,avg(s.age)fromStudentsgroupbys.name";

Queryquery=session.createQuery(hql);

list=query.list();

....

4:本地SQL查询

session=sessionFactory.openSession();

tran=session.beginTransaction();

SQLQuerysq=session.createSQLQuery(sql);

sq.addEntity(Student.class);

list=sq.list();

tran.commit();

5:QID

Session的get()和load()方法提供了根据对象ID来检索对象的方式。该方式被用于事先知道了要检索对象ID的情况。