hibernate中的查询
2017-08-20 本文已影响0人
jose_dl
HQL
- 查询所有
String hql = "from Customer";
Query query = session.createQuery(hql);
List list = query.list();
- 条件查询
String hql = "from Customer where cust_id=:cust_id";
Query query = session.createQuery(hql);
query.setParameter("cust_id", 2l);
Object uniqueResult = query.uniqueResult();
- 分页查询
String hql = "from Customer";
Query query = session.createQuery(hql);
query.setFirstResult(0);
query.setMaxResults(2);
List list = query.list();
Criteria
- 查询所有
Criteria criteria = session.createCriteria(Customer.class);
List list = criteria.list();
- 条件查询
Criteria criteria = session.createCriteria(Customer.class);
criteria.add(Restrictions.idEq(2l));
Object uniqueResult = criteria.uniqueResult();
- 分页查询
Criteria criteria = session.createCriteria(Customer.class);
criteria.setFirstResult(0);
criteria.setMaxResults(2);
List list = criteria.list();
- 查询总记录
Criteria criteria = session.createCriteria(Customer.class);
criteria.setProjection(Projections.rowCount());
Object uniqueResult = criteria.uniqueResult();
