@Test
//基本查询
public void criteriaDemo1() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//条件查询
public void criteriaDemo2() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
//criteria.add(Restrictions.idEq(2l));
criteria.add(Restrictions.eq("cust_id", 2l));
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//分页查询
public void criteriaDemo3() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.setFirstResult(0);
criteria.setMaxResults(2);
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//排序查询
public void criteriaDemo4() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.addOrder(Order.asc("cust_id"));
criteria.addOrder(Order.desc("cust_id"));
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//统计
public void criteriaDemo5() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.setProjection(Projections.rowCount());
Number num = (Number) criteria.uniqueResult();
System.out.println(num);
tx.commit();
}
//基本查询
public void criteriaDemo1() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//条件查询
public void criteriaDemo2() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
//criteria.add(Restrictions.idEq(2l));
criteria.add(Restrictions.eq("cust_id", 2l));
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//分页查询
public void criteriaDemo3() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.setFirstResult(0);
criteria.setMaxResults(2);
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//排序查询
public void criteriaDemo4() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.addOrder(Order.asc("cust_id"));
criteria.addOrder(Order.desc("cust_id"));
List<Customer> list = criteria.list();
tx.commit();
}
@Test
//统计
public void criteriaDemo5() {
Session session = HibernateUtils.getCurrentSession();
Transaction tx = session.beginTransaction();
Criteria criteria = session.createCriteria(Customer.class);
criteria.setProjection(Projections.rowCount());
Number num = (Number) criteria.uniqueResult();
System.out.println(num);
tx.commit();
}