（17）QBC、QBE

来源：互联网发布：淘宝上比较好的手办店编辑：程序博客网时间：2024/06/06 05:11

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

阅读全文

0 0