Hibernate Criteria Query-Between

Hibernate Criteria Query-Between

AIM:

                        From this post we will learn how to use between to get result.

Problem:

                        To get English marks between 60 and 75.

Solution:

Step 1:

            Create Hibernate Reverse Engineering wizard

Step 2:

            Create HibernateUtil.java

Step 3:

            Create POJO class and mapping files

Step 4:

            Create jsp file named as BetweenInteger.jsp

Include following coding into the BetweenInteger.jsp

< %@page import="java.util.*"% >
< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="Hiber.Student" % >

< html >
< head >
< title > Criteria Example-Between < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria crit=s.createCriteria(Student.class);
crit.add(Expression.between("english", new Integer(50),new Integer(80)));
crit.setMaxResults(4);
List list=crit.list();
Iterator iterator=list.iterator();
while(iterator.hasNext())
{
Student ss=(Student)iterator.next();
out.println(ss.getEnglish());
}

}
catch(Exception e)
{

}
% >
< /body >
< /html >

Output:

If you want to check the result is right or wrong.

Goto the mysql

Give the following query