基本查询
@Test public void test_01(){ Session session = HibernateUtils.openSession(); Transaction transaction = session.beginTransaction(); Criteria criteria = session.createCriteria(Customer.class); List<Customer> list = criteria.list(); for(Customer cus:list) System.out.println(cus); }
条件查询
public void test_02(){ Session session = HibernateUtils.openSession(); Transaction transaction = session.beginTransaction(); Criteria criteria = session.createCriteria(Customer.class); criteria.add(Restrictions.eq("cust_id",1l)); Customer customer = (Customer) criteria.uniqueResult(); System.out.println(customer); transaction.commit(); session.close(); }
分页查询
public void test_03(){ //分页查询 Session session = HibernateUtils.openSession(); Transaction transaction = session.beginTransaction(); Criteria criteria = session.createCriteria(Customer.class); criteria.setFirstResult(0); criteria.setMaxResults(3); List<Customer> list = criteria.list(); for(Customer cus : list){ System.out.println(cus); } transaction.commit(); session.close(); }
使用聚合函数:
public void test04(){ //设置查询总的记录数 Session session = HibernateUtils.openSession(); Transaction transaction = session.beginTransaction(); Criteria criteria = session.createCriteria(Customer.class); criteria.setProjection(Projections.rowCount()); Long count = (Long) criteria.uniqueResult(); System.out.println(count); transaction.commit(); session.close(); }