Share on Google+Share on Google+

Hibernate's Built-in criterion: Between (using Integer)

In this tutorial,, you will learn to use "between" with the Integer class

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
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 = 
new Configuration().configure()
  session = 
  //Criteria Query Example
  Criteria crit = 
new Integer(1000),
new Integer(2500)))//
Between condition

Restricts the max rows to 5

  List insurances = crit.list();
  for(Iterator it = 
  Insurance insurance =
ID: " 
+ insurance.getLngInsuranceId());
Name: " 
+ insurance.getInsuranceName());
Amount: " 
+ insurance.getInvestementAmount());
  catch (Exception e) {
  finally {

Download this code:


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


Posted on: May 24, 2009 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Share this Tutorial Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Discuss: Hibernate's Built-in criterion: Between (using Integer)   View All Comments

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image