criteria查询
简单查询
Criteria criteria=session.createCriteria(Customer.class);
List<Customer> list=criteria.list();
排序查询
Criteria criteria=session.createCriteria(Customer.class);
criteria.addOrder(Order.asc("cust_id")); //升序
criteria.addOrder(Order.desc("cust_id")); //降序
List<Customer> list=criteria.list();
分页查询
Criteria criteria=session.createCriteria(Customer.class);
criteria.setFirstResult(0);
criteria.setMaxResults(10);
List<Customer> list=criteria.list();
条件查询(= eq, > gt,>= ge,< lt,<=le, <> ne)
Criteria criteria=session.createCriteria(Customer.class);
criteria.add(Restrictions.eq("cust_source","属性值"));
criteria.add(Restrictions.like("cust_name","程%"));
List<Customer> list=criteria.list();
统计查询
Criteria criteria=session.createCriteria(Customer.class);
/*
* add 普通的条件查询
* addOrder 排序
* setProjection :聚合函数和group by having
*/
criteria.setProjection(Projections.rowCount());
long num=(long) criteria.uniqueResult();
criteria查询
最新推荐文章于 2022-12-08 15:51:22 发布