Big Data and Hadoop Training @$80 or Rs. 6,000 only - valid till Oct 17th Apply Now!

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

Ads
 
Tutorials   
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

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
 
 * 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 =
 
(Insuranceit.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

Ads

Ads