QBC(Query By Criteria) QBE (Query By Example)

QBC  参考：(Hibernate的QBC查询)

    //is empty and is not empty

    @Test

    public void testQBC(){

        Session session = sf.getCurrentSession();

        session.beginTransaction();

        //criterion 标准/准则/规范

        Criteria c = session.createCriteria(Topic.class)//from Topic

                .add(Restrictions.gt("id", 2))    //greater than = id > 2

                .add(Restrictions.lt("id", 8))    //less than = id < 8

                .add(Restrictions.like("title", "t_"))

                .createCriteria("category")

                .add(Restrictions.between("id", 0, 5)) //category.id >= 0 and category.id <= 5

                ;

        //DetachedCriteria

        for(Object o : c.list()){

            Topic t = (Topic)o;

            System.out.println(t.getId() + "-" + t.getTitle() );

        }

        session.getTransaction().commit();

    }

QBE   参考：(hibernate的QBE和QBC) 和 (Hibernate 查询方式(HQL/QBC/QBE)汇总)

     //is empty and is not empty

     //QBC Query By Criteria

     //QBE Query By Example

     @Test

     public void testQBE(){

         Session session = sf.getCurrentSession();

         session.beginTransaction();

         Topic tExample = new Topic();

         tExample.setTitle("T_");

         Example e = Example.create(tExample)

                 .ignoreCase().enableLike();//构建 example

         Criteria c = session.createCriteria(Topic.class)

                 .add(Restrictions.gt("id", 3))

                 .add(Restrictions.lt("id", 8))

                 .add(e)

                 ;

         for(Object o : c.list()){

             Topic t = (Topic)o;

             System.out.println(t.getId() + "-" + t.getTitle() );

         }

         session.getTransaction().commit();

     }

jar包链接: https://pan.baidu.com/s/1kVbVPmZ 密码: 384f

QBC链接: https://pan.baidu.com/s/1dFEHIYt 密码: nfms

QBE链接: https://pan.baidu.com/s/1i4JJa0d 密码: 2zby