hibernate中的Criteria查询

本文主要是介绍hibernate中的Criteria查询，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

Criteria查询API 不需要写查询语句，比较适应单表查询

public void fun1(){

Session session = HibernateUtils.openSession();

Transaction tx = session.beginTransaction();

Criteria criteria = session.createCriteria(Customer.class);

List<Customer> list = criteria.list();//查询所有的Customer对象

tx.commit();

session.close();

}

1.Criteria普通条件查询

Criteria criteria = session.createCriteria(Customer.class);

criteria.add(Restrictions.eq("cust_id", 1l));

Customer c = (Customer) criteria.uniqueResult();

2.Criteria分页查询&升序查询

Criteria criteria = session.createCriteria(Customer.class);

criteria.setFirstResult(1);

criteria.setMaxResults(2);

criteria.addOrder(Order.asc("cust_id"));//升序查询

List<Customer> list = criteria.list();

3.Criteria查询总行数

Criteria criteria = session.createCriteria(Customer.class);

criteria.setProjection(Projections.rowCount());

Long count = (Long) criteria.uniqueResult();

这篇关于hibernate中的Criteria查询的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---