Posted in: Hibernate,Hibernate FAQ's
The Restriction Class: The Restrictions class is a static factory for Criterion instances.
Find a Employee by name with Equal:
Find a Employee by name with Equal:
Criteria criteria = session.createCriteria(Employee.class); criteria .add( Restrictions.eq("name", "David") );
Find a Employees by name with Matchmode:
Criteria criteria = session.createCriteria(Employee.class);
criteria.add(Restrictions.like("name", "David", MatchMode.START));
criteria.add(Restrictions.or(Restrictions.gt("Sal", new Long(10500)),
Restrictions.like("name", "jack", MatchMode.ANYWHERE)));
Order Class: The addOrder method can be used to order the results. The Order class has two static methods, asc and desc, which apply
ascending or descending ordering constraints using a specified
property as an input argument.
public Criteria addOrder(Order order);
List emps = session.createCriteria(Employee.class)
.addOrder( Order.asc("lastName") )
.list();
The Projections Class: Projections come from the
org.hibernate.criterion.Projections factory class.
Criteria crit = s.createCriteria(Employee.class); crit.setProjection( Projections.rowCount() ); List results = crit.list();
More than one projection can be applied to a criteria instance. To add multiple projections, the Projections class has a method called projectionList that returns an instance of the ProjectionList class.
Criteria criteria = session.createCriteria(PaymentModelImpl.class);
ProjectionList projectionList = Projections.projectionList();
projectionList.add(Projections.rowCount(), "count");
projectionList.add(Projections.sum("amount"), "totalAmount");
projectionList.add(Projections.groupProperty("customer"),"cust");
//Set the prijectionList obj into criteria object
criteria.setProjection(projectionList);
criteria.setResultTransformer(
Transformers.aliasToBean(CustomerPaymentInfo.class));