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

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


What is difference between Hibernate 4 and 5? Hibernate 5.3 features Hibernate 5 JPA Configuration Hibernate 5 persistence.xml example Hibernate 5 JPA Tutorial Hibernate and JPA Example How properties of a class are mapped to the columns of a database table in Hibernate? Hibernate 5 Annotations Maven dependency Hibernate 5 annotationconfiguration Doctype Hibernate-configuration 5 Hibernate 5 Dialect Hibernate 5 configuration dtd Hibernate 5 Hello World Getting started with Hibernate 5 Hibernate 5.2.10 jar Download Hibernate 5.2.10 Maven Dependency Hibernate 5 Maven Dependency Hibernate 5 native query example Hibernate 5 query deprecated When should you use Hibernate? What's new in Hibernate 5? How much time it takes to learn Hibernate? Hibernate envers custom revinfo table Hibernate 5 Envers Hibernate Envers get all revisions Hibernate Examples Hibernate 5 build SessionFactory Example Hibernate 5 SessionFactory Example Hibernate 5 Annotation Example How to download Hibernate 5.x? Hibernate 5 Features Hibernate 5 Tutorials Learning Hibernate ORM - Free Training/Tutorial videos of Hibernate ORM with Java How to write hello world example program in Hibernate? How to create one to one relationship in Hibernate 4 with Annotation? How to calculate minimum in Hibernate using the min() Function Hibernate ORM 4.2.21.Final Released - Create CURD application in latest Hibernate Hibernate ORM 4.2.21 Tutorial - Learn Hibernate ORM Framework Hibernate Error: Failed to create sessionFactory object.java.lang.NoClassDefFoundError How to create Hibernate Project in Eclipse?

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 = 
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