Hibernate Criteria Query-Lessthan

Hibernate Criteria Expression- lessthan

Aim:

            To learn how to use lessthan in our hibernate.

Problem:

To get stuname from table student in navalady database who get less than 70 marks in tamil using lessthan criteria expression.

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 LessThanEx.jsp

Include following coding into the LessThanEx.jsp

< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Criteria Expression-Less Than < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria c=s.createCriteria(Student.class);
c.add(Expression.lt("tamil",new Integer("70")));

List list=c.list();
Iterator it=list.iterator();

while(it.hasNext())
{
Student s1=(Student)it.next();
out.println(s1.getStuname());
}


}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

Output:

Step 5:

Manually check using mysql query.

mysql > select stuname from student where tamil < 70;

Hibernate Criteria Query-GreaterThanEqual

Hibernate Criteria Expression- greater than and Equal

Aim:

            To learn how to use greater than and Equal in our hibernate.

Problem:

To get stuname from table student in navalady database who get greater than and Equal 70 marks in tamil using greater than and Equal criteria expression.

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 GreaterEqual.jsp

Include following coding into the GreaterEqual.jsp

< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Criteria Expression-GreaterThan Equal < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria c=s.createCriteria(Student.class);
c.add(Expression.ge("tamil",new Integer("70")));

List list=c.list();
Iterator it=list.iterator();

while(it.hasNext())
{
Student s1=(Student)it.next();
out.println(s1.getStuname());
}


}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

Output:

To check using mysql using following query

mysql > select stuname from student where tamil > =70;

Note:

All example programs in our blog are successfully run. So you copy program and paste to your IDE and run for your experience.

Hibernate Criteria Query-GreaterThan

Hibernate Criteria Expression- greater than

Aim:

            To learn how to use greater than in our hibernate.

Problem:

To get stuname from table student in navalady database who get greater than 70 marks in tamil using greater than criteria expression.

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 GreaterThan.jsp

Include following coding into the GreaterThan.jsp

< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Criteria Expression-Greater Than < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria c=s.createCriteria(Student.class);
c.add(Expression.gt("tamil",new Integer("70")));

List list=c.list();
Iterator it=list.iterator();

while(it.hasNext())
{
Student s1=(Student)it.next();
out.println(s1.getStuname());
}


}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

Output:

To check using mysql using following query

mysql > select stuname from student where tamil > 70;

Hibernate Criteria Expression- lessthanequal

Aim:

            To learn how to use lessthanequal in our hibernate.

Problem:

To get stuname from table student in navalady database who get less than and equal 77 marks in tamil using lessthan criteria expression.

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 LessThanEq.jsp

Include following coding into the LessThanEq.jsp

< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Criteria Expression-Less Than and Equal < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria c=s.createCriteria(Student.class);
c.add(Expression.le("tamil",new Integer("77")));

List list=c.list();
Iterator it=list.iterator();

while(it.hasNext())
{
Student s1=(Student)it.next();
out.println(s1.getStuname());
}


}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

Output:

To manually check using mysql query.

mysql > select stuname from student where tamil < =77;

Hibernate Criteria Query-Equal

Hibernate Criteria Expression- equal

Aim:

            To learn how to use equal in our hibernate.

Problem:

            To get stuname (jagan) records using equal.

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 EqualExp.jsp

Include following coding into the EqualExp.jsp

< %@page import="Hiber.Student"% >
< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="Hiber.Student" % >
< %@page import="java.util.*" % >
< %@page contentType="text/html" pageEncoding="UTF-8"% >

< html >
< head >
< title > Hibernate Criteria Expression Equal < /title >
< /head >
< body >
< %
try
{
SessionFactory sf=new Configuration().configure().buildSessionFactory();
Session ss=sf.openSession();

Criteria c=ss.createCriteria(Student.class);
c.add(Expression.eq("stuname","jagan"));
List list=c.list();
Iterator it=list.iterator();
while(it.hasNext())
{
Student s=(Student)it.next();
out.println(s.getStuname());
out.println(s.getStuno());
out.println(s.getTamil());
out.println(s.getEnglish());
out.println(s.getMaths());
out.println(s.getScience());
out.println(s.getSocialscience());
out.println(s.getJoindate());
}

}
catch(Exception e)
{

}
% >
< /body >
< /html >

Output:

To manually check using mysql query.

mysql > select * from student where stuname=’jagan’;

Hibernate Criteria Query-AND Clause

Hibernate Criteria Query – Using AND clause.

Aim:

            To check more than one condition using AND clause.

Example:

Problem:

            To get student name who get tamil mark between greater than 50 and less than70.

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 AndExample.jsp

Include following coding into the AndExample.jsp

< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Criteria Query-And Example < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria c=s.createCriteria(Student.class);
c.add(Expression.and(Expression.gt("tamil",new Integer(50)), Expression.lt("tamil", new Integer(70))));
List list=c.list();
Iterator it=list.iterator();
while(it.hasNext())
{
Student s1=(Student)it.next();
out.println(s1.getStuname());
}
}
catch(Exception e)
{

}
% >
< /body >
< /html >


Output:

We have to check manually using mysql database using query.

mysql > select stuname from student where tamil > 50 and tamil < 70;

Mysql- using Date function.

introduction:

                     we have to handle Date in our program. So we need to include Date function into our table student.

Step 1:

            Create Database I have created database as Navalady.

Note: No need to create Database. Because we have already created Database named as Navalady)

Step 2:

            Already we have created table name as student. So also no need to create table.

Step 3:

We have to use the date in our program. So we include joining date of student into our table.

How to add new field into our existing table?

Mysql > alter table table_name ADD(field_name field_type);

Mysql > alter table student ADD(joindate Date);

Step 4:

                Insert new records into student table.

Step 5:

Insert joining date into already include student.

Successfully we have included the join date to student.

Hibernate Criteria Query-BetweenDate

AIM:

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

Problem:

                        To get student who get admission between two dates.

Solution:

Made some changes in student table.

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 BetweenDate.jsp

Include following coding into the BetweenDate.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 Date < /title >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();

Criteria crit=s.createCriteria(Student.class);

Date startDate=new Date("1999/06/22");
Date endDate=new Date("1999/06/26");

crit.add(Expression.between("joindate", startDate,endDate));

crit.setMaxResults(4);
List list=crit.list();
Iterator iterator=list.iterator();
while(iterator.hasNext())
{
Student ss=(Student)iterator.next();
out.println(ss.getStuname());
}

}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >


Output:

To check manually using mysql query.

mysql > select stuname from student where joindate between ('1999/06/22') and (‘1999/06/26’);