Hibernate – Query By Criteria

One of the ways to retrieve Objects from the databases is using Query By Criteria

         Example :

session.createCriteria(Employees.class)

Comparison Operators for Criteria Queries

In Criteria queries, all the operators are available via the Expression class:

Example :

session.createCriteria(Employees.class)

.add( Expression.between(“salary”,

new BigDecimal(5000),

new BigDecimal(10000))

).list();

 

session.createCriteria(Employees.class)

.add( Expression.gt(“salary”, new

BigDecimal(1000) ) )

.list();

 

String[] empIds= { “E-100″,”E-200” };

session.createCriteria(Employees.class)

.add( Expression.in(“empID”, empIds) )

.list();

 

String matching

session.createCriteria(Employees.class).add( Expression.like(“firstname”, “A%”) ).list();

Or

session.createCriteria(Employees.class).add( Expression.like(“firstname”, “A”,MatchMode.START) ).list();

Ordering query results

List results =session.createCriteria(Employees.class)

.addOrder( Order.asc(“firstName”) )

.addOrder( Order.asc(“lastName”) )

.list();