Criteria cri = session.createCriteria(Student.class);
cri.add(Example.create(s)); //s是一個(gè)Student對象
list cri.list();

實(shí)質(zhì)：創(chuàng)建一個(gè)模版，比如我有一個(gè)表serial有一個(gè) giftortoy字段，我設(shè)置serial.setgifttoy("2"),
則這個(gè)表中的所有的giftortoy為2的數(shù)據(jù)都會(huì)出來

2: QBC (Query By Criteria) 主要有Criteria,Criterion,Oder,Restrictions類組成

 session = this.getSession();
Criteria cri = session.createCriteria(JdItemSerialnumber.class);
Criterion cron = Restrictions.like("customer",name);
cri.add(cron);
list = cri.list();

比較運(yùn)算符

HQL運(yùn)算符 QBC運(yùn)算符 含義
=Restrictions.eq()等于
<> Restrictions.not(Exprission.eq())  不等于
>Restrictions.gt()大于
>= Restrictions.ge()大于等于
<= Restrictions.le()小于等于
is null Restrictions.isnull()  等于空值
is not nullRestrictions.isNotNull()  非空值
like  Restrictions.like() 字符串模式匹配
and Restrictions.and()  邏輯與
and Restrictions.conjunction()邏輯與
or Restrictions.or()邏輯或
or Restrictions.disjunction()邏輯或
notRestrictions.not()  邏輯非
in(列表) Restrictions.in()等于列表中的某一個(gè)值
ont in(列表)Restrictions.not(Restrictions.in())不等于列表中任意一個(gè)值
between x and yRestrictions.between() 閉區(qū)間xy中的任意值
not between x and y  Restrictions.not(Restrictions..between()) 小于值X或者大于值y

3: HQL

    String hql = "select s.name ,avg(s.age) from Student s group by s.name";
Query query = session.createQuery(hql);
list = query.list();
....

   session = sessionFactory.openSession();
tran = session.beginTransaction();
SQLQuery sq = session.createSQLQuery(sql);
sq.addEntity(Student.class);
list = sq.list();
tran.commit();

5: QID

Session的get()和load()方法提供了根據(jù)對象ID來檢索對象的方式。該方式被用于事先知道了要檢索對象ID的情況。

【編輯推薦】

1. 層層解析Hibernate中的事務(wù)的濫用
2. 關(guān)于Struts+Hibernate分頁的問題
3. Struts與Hibernate的完美結(jié)合方案
4. 關(guān)于Hibernate你必須知道的六個(gè)方面