Hibernate Criteria Expression (lt)

In this section, you will learn to use the
"lt" method. This is one of the most
important method that is used to apply a
"less than" constraint to the named property.
Expressions: The
Hibernate Criteria API supports a rich set of comparison operators. Some
standard SQL operators are =, <, ?, >, ?. That supports lt() method
in Expression class.
In this tutorial, "lt" is used with the
Integer object (invested_amount). It takes two parameters e.g. lt("property_name",Object
val).
Table Name: insurance
| ID |
insurance_name |
invested_amount |
investement_date |
| 2 |
Life Insurance |
25000 |
0000-00-00 00:00:00 |
| 1 |
Givan Dhara |
20000 |
2007-07-30 17:29:05 |
| 3 |
Life Insurance |
500 |
2005-10-15 00:00:00 |
| 4 |
Car Insurance |
2500 |
2005-01-01 00:00:00 |
| 5 |
Dental Insurance |
500 |
2004-01-01 00:00:00 |
| 6 |
Life Insurance |
900 |
2003-01-01 00:00:00 |
| 7 |
Travel Insurance |
2000 |
2005-02-02 00:00:00 |
Here is the code of the class using "lt"
Expression :
package roseindia.tutorial.hibernate;
import java.util.Iterator;
import java.util.List;
import org.hibernate.Criteria;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import org.hibernate.criterion.Expression;
public class HibernateCriteriaQueryExpressionLt {
/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sess = null;
try {
SessionFactory fact = new
Configuration().configure().buildSessionFactory();
sess = fact.openSession();
Criteria crit =
sess.createCriteria(Insurance.class);
crit.add(Expression.lt
("investementAmount",new Integer(900)));
List list = crit.list();
for (Iterator it =
list.iterator();it.hasNext();){
Insurance ins =
(Insurance)it.next();
System.out.println("Insurance
Id: " + ins.getLngInsuranceId());
System.out.println("Insurance
Name: " + ins.getInsuranceName());
System.out.println("Insurance
Amount: " + ins.getInvestementAmount());
System.out.println("Investement
Date: " + ins.getInvestementDate());
}
sess.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}
|
Download
this code.
Output:
| log4j:WARN No appenders
could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: select this_.ID as ID0_0_,
this_.insurance_name as insurance2_0_0_, this_.invested_amount as
invested3_0_0_, this_.investement_date as investem4_0_0_ from insurance
this_ where this_.invested_amount<?
Insurance Id: 3
Insurance Name: Life Insurance
Insurance Amount: 500
Investement Date: 2005-10-15 00:00:00.0
Insurance Id: 5
Insurance Name: Dental Insurance
Insurance Amount: 500
Investement Date: 2004-01-01 00:00:00.0
|

|