Hibernate筆記：3.資料檢索Criteria查詢的用法（同Query一樣的效果）

Session session = new Configuration().configure().buildSessionFactory().openSession();

       Criteria cri = session.createCriteria(Person.class);

       //cri.add(Expression.eq("id",3));

       cri.add(Expression.eq("name", "李四"));// 等於 關係       

       List all = cri.list();

      

       if(all.size()>0){

           Person per = (Person)all.get(0);

           System.out.println(per.getName() + " --> " + per.getSex());

       }

 

 

Session session = new Configuration().configure().buildSessionFactory().openSession();

       Criteria cri = session.createCriteria(Person.class);

      

       //cri.add(Expression.gt("age", 25));//年齡大於25的查詢

       //cri.add(Expression.lt("age", 25));//年齡小於25的查詢     le是<=   gt 是 >=

      

       //cri.add(Expression.between("age", 25, 35));//年齡在25到35之間包括25，35

      

       cri.add(Expression.like("name", "%1%")); // 名字中有1的人         List all = cri.list();

       Iterator iter = all.iterator();

       while(iter.hasNext()){

          

           Person per = (Person)iter.next();

           System.out.println(per.getName() + " --> " + per.getSex()+ " --> " +per.getAge());

       }