## QBC查詢(Criteria方式) 特點:完全面向對象. ## 全查 ~~~ Criteria criteria = session.createCriteria(Customer.class); List<Customer> list = criteria.list(); for (Customer c : list) { System.out.println(c); } ~~~ ## 條件查 條件可以去網上看, Restrictions.條件 ~~~ Criteria criteria = session.createCriteria(Customer.class); criteria.add(Restrictions.like("name", "%j%")); List<Customer> list = criteria.list(); ~~~ ## 分頁查 ~~~ Criteria criteria = session.createCriteria(Customer.class); criteria.setFirstResult(2); criteria.setFirstResult(2); List<Customer> list = criteria.list(); ~~~ ## 排序查 ~~~ Criteria criteria = session.createCriteria(Customer.class); criteria.addOrder(Order.desc("name")); List<Customer> list = criteria.list(); ~~~ ## 聚合查 ~~~ Criteria criteria = session.createCriteria(Customer.class); //下面兩條語句是一致的 criteria.setProjection(Projections.count("id")); // criteria.setProjection(Projections.rowCount()); Object o = criteria.uniqueResult(); System.out.println(o); ~~~