hibernate中criteria查询

package com.tudou.hibernates.t1; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.SessionFactory; import org.hibernate.Transaction; import org.hibernate.cfg.Configuration; import org.hibernate.criterion.Expression; import org.hibernate.criterion.Order; public class TestGetCriteria { private static Configuration cfg = new Configuration().configure(); private static SessionFactory fac = cfg.buildSessionFactory(); private static Session son = fac.openSession(); private static Transaction tr = son.beginTransaction(); // Criteria查询 public static void criteriaSelect() { Criteria cri = son.createCriteria(Card.class); List<Card> cards = cri.list(); for (Card c : cards) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } } // Criteria条件查询 public static void criteriaSelectByExpressionEq() { Criteria cri = son.createCriteria(Card.class); cri.add(Expression.eq("cardName", "传奇世界")); List<Card> cards = cri.list(); for (Card c : cards) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } } // Criteria模糊条件查询 public static void criteriaSelectByExpressionLike() { Criteria cri = son.createCriteria(Card.class); cri.add(Expression.like("cardName", "%世界%")); List<Card> cards = cri.list(); for (Card c : cards) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } } // Criteria分页查询 public static void criteriaByPage() { Criteria cri = son.createCriteria(Card.class); cri.setFirstResult(0); cri.setMaxResults(3); List<Card> cards1 = cri.list(); for (Card c : cards1) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } cri.setFirstResult(3); List<Card> cards2 = cri.list(); for (Card c : cards2) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } } // Criteria分页排序查询 public static void criteriaByPageOrder() { Criteria cri = son.createCriteria(Card.class); cri.setFirstResult(0); cri.setMaxResults(6); cri.addOrder(Order.desc("createDate")); List<Card> cards1 = cri.list(); for (Card c : cards1) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } cri.setMaxResults(3); cri.addOrder(Order.desc("createDate")); List<Card> cards = cri.list(); for (Card c : cards) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } cri.setFirstResult(3); cri.setMaxResults(3); cri.addOrder(Order.desc("createDate")); List<Card> cards2 = cri.list(); for (Card c : cards2) { System.out.println(c.getCardName() + "\t" + c.getCreateDate()); } } // 程序入口 public static void main(String[] args) { // 测试方法 criteriaByPageOrder(); tr.commit(); son.close(); fac.close(); } }