Hibernate's Built-in criterion: Between (using Integer)
In this tutorial,, you will learn to use
"between" with the Integer class. "Between" when used with
the Integer object, It takes three parameters e.g. between("property_name",min_int,max_int).
Restriction class provides built-in criterion via static factory methods. One important
method of the Restriction class is between
: which is used to
apply a "between" constraint to the named property
Here is the code of the class using
"between" with the Integer class :
package roseindia.tutorial.hibernate;
import org.hibernate.Session;
import org.hibernate.*;
import org.hibernate.criterion.*;
import org.hibernate.cfg.*;
import java.util.*;
/**
* @author vinod
Kumar
*
* http://www.roseindia.net
Hibernate Criteria Query Example
*
*/public class
HibernateCriteriaQueryBetweenTwoInteger {
public static void main(String[] args) {
Session session = null;
try {
// This step will read
hibernate.cfg.xml and prepare hibernate for
// use
SessionFactory
sessionFactory = new Configuration().configure()
.buildSessionFactory();
session =
sessionFactory.openSession();
//Criteria Query Example
Criteria crit =
session.createCriteria(Insurance.class);
crit.add(Expression.between("
investementAmount", new Integer(1000),
new Integer(2500))); //
Between condition
crit.setMaxResults(5); //
Restricts the max rows to 5
List insurances = crit.list();
for(Iterator it =
insurances.iterator();it.hasNext();){
Insurance insurance =
(Insurance) it.next();
System.out.println("
ID: " + insurance.getLngInsuranceId());
System.out.println("
Name: " + insurance.getInsuranceName());
System.out.println("
Amount: " + insurance.getInvestementAmount());
}
session.close();
} catch (Exception e) {
System.out.println(e.getMessage());
} finally {
}
}
}
|
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 between ? and ? limit ?
ID: 1
Name: Car Insurance
Amount: 1000
ID: 4
Name: Car Insurance
Amount: 2500
ID: 7
Name: Travel Insurance
Amount: 2000 |
