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();  
        }  
    }