Cyh的博客

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

          Criteria查詢表達(dá)式

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

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

          à簡單實(shí)例說明:

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



                                                                                                                 --    學(xué)海無涯
                  

          主站蜘蛛池模板: 刚察县| 孟连| 陵水| 迁安市| 都江堰市| 田林县| 金秀| 嵊州市| 诸暨市| 平乐县| 观塘区| 正蓝旗| 清丰县| 儋州市| 喀喇沁旗| 石首市| 鹤峰县| 息烽县| 云浮市| 横山县| 会理县| 平乐县| 兖州市| 霍山县| 三明市| 河北省| 弥勒县| 利津县| 靖西县| 永嘉县| 师宗县| 宜昌市| 滦平县| 三都| 汝州市| 玉溪市| 虹口区| 登封市| 云南省| 云龙县| 阿克陶县|