Hibernate Criteria Expression (gt)

In this section, you will learn to use the "gt" method. This is one of the most important method that is used to apply a "greater than" constraint to the named property

Expressions: The Hibernate Criteria API supports a rich set of comparison operators. Some standard SQL operators are =, <, ?, >, ?. That supports gt() method in Expression class.

In this tutorial, "gt" is used with the Long object (ID). It takes two parameters e.g. ge("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 "gt" Expression :


package roseindia.tutorial.hibernate;



import java.util.Iterator;

import java.util.List;



import org.hibernate.Criteria;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

import org.hibernate.criterion.Expression;



public class HibernateCriteriaQueryExpressionGt {



  /**

   * @param args

   */

  public static void main(String[] args) {

    // TODO Auto-generated method stub



    Session sess = null;

    try {

      SessionFactory fact = new 

Configuration().configure().buildSessionFactory();

      sess = fact.openSession();

      Criteria crit = 

sess.createCriteria(Insurance.class);

      crit.add(Expression.gt

("lngInsuranceId",new Long(3)));

      List list = crit.list();

      for (Iterator it = 

list.iterator();it.hasNext();){

        Insurance ins = 

(Insurance)it.next();

        System.out.println("

Insurance Id: "  + ins.getLngInsuranceId());

        System.out.println("

Insurance Name: " + ins.getInsuranceName());

        System.out.println("

Insurance Amount: " + ins.getInvestementAmount());

        System.out.println("

Investement Date: " + ins.getInvestementDate());

      }

      sess.close();

    }

    catch(Exception e){

      System.out.println(e.getMessage());

    }

  }

}

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_.ID>?

Insurance Id: 4

Insurance Name: Car Insurance

Insurance Amount: 2500

Investement Date: 2005-01-01 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

Insurance Id: 7

Insurance Name: Travel Insurance

Insurance Amount: 2000

Investement Date: 2005-02-02 00:00:00.0