（17）QBC、QBE

QBC:

    @Test
    public void HQ_1() {

        Session session=sf.getCurrentSession();
        session.beginTransaction();
        //Criteria:标准、准则、约束
        Criteria c=session.createCriteria(Topic.class)//from Topic
                .add(Restrictions.gt("id", 2))//id>2
                .add(Restrictions.lt("id", 8))//id<8
                .add(Restrictions.like("name", "t_"))
                .createCriteria("category")//相当于连接
                .add(Restrictions.between("id", 3,5));//category.id>=3 and category.id<=5
        List<Topic> topics=(List<Topic>)c.list();
        for(Topic t:topics){
            System.out.println(t.getName());
        }
        session.getTransaction().commit();
    }

QBE:

@Test
    public void HQ_1() {

        Session session=sf.getCurrentSession();
        session.beginTransaction();
        Topic tExample=new Topic();
        tExample.setName("T_");
        Example e=Example.create(tExample).ignoreCase().enableLike();

        Criteria c=session.createCriteria(Topic.class)//from Topic
                .add(Restrictions.gt("id", 2))//id>2
                .add(Restrictions.lt("id", 8))//id<8
                .add(e);
        List<Topic> topics=(List<Topic>)c.list();
        for(Topic t:topics){
            System.out.println(t.getName());
        }
        session.getTransaction().commit();
    }