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();
Leave a Reply