Cyh的博客

          Email:kissyan4916@163.com
          posts - 26, comments - 19, trackbacks - 0, articles - 220

          Criteria查詢表達式

          Posted on 2009-02-16 19:41 啥都寫點 閱讀(378) 評論(0)  編輯  收藏 所屬分類: J2EE

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

          à簡單實例說明:

          àEqual:

          public class HibernateDemo01 {

                 /**

                  * @param args

                  */

                 public static void main(String[] args) {

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

                                      .openSession();

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

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

                        }

                 }

          }

          à大于

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

          cri.add(Expression.gt("age", 25));

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

                 }

          à小于

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

          cri.add(Expression.lt("age", 25));

          àbetween

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

          cri.add(Expression.between("age", 25, 35));

          à模糊查詢:

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

                        cri.add(Expression.like("name","%%"));

          àin

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

                        Set<Integer> conds = new TreeSet<Integer>();

                        conds.add(new Integer(1));

                        conds.add(new Integer(2));

                        cri.add(Expression.in("id", conds));

          àand

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

          cri.add(Expression.and(Expression.eq("name", "張三"), Expression.eq("sex", "")));

          àExample查詢條件跟已知對象的條件相同

            Person person = new Person() ;

                        person.setName("張三") ;

                        person.setSex("") ;

                        person.setAge(20) ;

                        cri.add(Example.create(person));



                                                                                                                 --    學海無涯
                  

          主站蜘蛛池模板: 喀喇沁旗| 内丘县| 依安县| 马鞍山市| 怀远县| 东乡| 陈巴尔虎旗| 龙陵县| 麻栗坡县| 桃源县| 福泉市| 东兰县| 枝江市| 石嘴山市| 神农架林区| 松桃| 长汀县| 开封县| 富宁县| 神池县| 江山市| 渝北区| 白山市| 阳春市| 太仆寺旗| 马龙县| 江西省| 平泉县| 七台河市| 闵行区| 彰武县| 紫云| 平泉县| 黄大仙区| 哈巴河县| 旬邑县| 靖江市| 桑日县| 安徽省| 平度市| 哈密市|