and query by example (QBE).
Lets take an example of query by criteria
(QBC) using Expressions. This example is
taking the same table Insurance as we have
used in our previous issue.

Consider the following table Insurance having
such records:

Here is the code of the class using “eq” Expression:

package javajzzup.hibernate;

import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;
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
HibernateCriteriaQueryExpressionEq {

/**
* @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);
DateFormat format = new
SimpleDateFormat(“yyyy-MM-dd hh:mm:ss”);
Date date = (Date)format.parse(“2005-
01-01 00:00:00”);
crit.add(Expression.eq(“investementDate”,date));
List list = crit.list();
for(Iterator it =
list.iterator();it.hasNext();){
Insurance ins = (Insurance)it.next();
System.out.println(“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.clear();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}

In the above code the crit.add(Expression.eq (“investementDate”,date)); uses two parameter e.g. eq(“property_name”,Object val). It fetches those records from the table that meets the specified date.

The output of this program will be shown as: