Hibernate中的QBC（标准查询）Criteria 即原生SQL查询-蒲公英云

Hibernate中的QBC（标准查询）Criteria 即原生SQL查询

QBC查询：

//Criteria 标准
    //conjunction连接词And
    //disConjunction Or
    //Restriction 约束
    @Test
    public void testQBC2() {
        Criteria criteria = session.createCriteria(Item.class);
        //添加排序
        criteria.addOrder(Order.asc("id"));
        //添加分页
        int pageNo = 2;
        int size = 1;
        criteria.setFirstResult((pageNo - 1) * size);
        criteria.setMaxResults(size);
        Conjunction conjunction = Restrictions.conjunction();
//        conjunction.add(Restrictions.eq("id", 1));
//        conjunction.add(Restrictions.like("name", "衣",MatchMode.END));
        Disjunction disjunction = Restrictions.disjunction();
        disjunction.add(Restrictions.eq("id", 1));
        disjunction.add(Restrictions.like("name", "球",MatchMode.END));
        criteria.add(conjunction);
        criteria.add(disjunction);
        List<Item> items = criteria.list();
        System.out.println(criteria);
        items.forEach((item) -> System.out.println(item.getName()));
    }
//统计查询
    @Test
    public void testQBC3() {
        Criteria criteria = session.createCriteria(Item.class);
        criteria.setProjection(Projections.max("amount"));
        System.out.println(criteria.uniqueResult());
    }

原生SQL查询：

@Test
    public void testSqlQuery() {
        String sql = "insert into category(name) values(?)";
        Query query = session.createSQLQuery(sql).setString(0, "母婴");
        query.executeUpdate();
    }