In this section, you will learn to use the "le" method. This is one of the most important method that is used to apply a "less than or equal" constraint to the named property.
Ads
TutorialsIn this section, you will learn to use the
"le" method. This is one of the most
important method that is used to apply a
"less than or equal" constraint to the named property.
Expressions: The Hibernate Criteria API supports a rich set of comparison operators. Some standard SQL operators are =, <, ?, >, ?. That supports le() method in Expression class.
In this tutorial, "le" is used with the
Integer object (invested_amount). It takes two parameters e.g. le("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 "le" Expression :
package roseindia.tutorial.hibernate;
|
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 Insurance Id: 6 Insurance Name: Life Insurance Insurance Amount: 900 Investement Date: 2003-01-01 00:00:00.0 |
Posted on: February 27, 2008 If you enjoyed this post then why not add us on Google+? Add us to your Circles
Advertisements
Ads
Ads
Discuss: Hibernate Criteria Expression (le) View All Comments
Post your Comment