Way To J2ee Developer

Hibernate integrate with Struts-select records from table Example

2010-11-22T11:05:00.000-08:00

Hibernate integrate with Struts - select records from table

DataBase Design

Database Name: Hiber

Table Table: hiber

Step 1:

Create Database.

mysql > create database Hiber;

Step 2:

Create Table

Mysql > create table hiber(stuname varchar(40),stuno int,primary key(stuno));

I have inserted into two records into hiber table.

Step 1). How to create Project for Hibernate Struts integration.

1.1) Open netbean 6.9

1.2) Go to File – New Project(ctrl+shift+N).

New Project window will open.

Where we select

java web – under Categories

Web Application—under Projects

New web Application window will open.

Where we give Project name. I have given project name as HibernateStruts

Next

New window will open. Where we select server. I have select Apache Tomcat 6.0.26

New window will open

Where we select framework.

Here we select two frameworks. Because we integrate Hibernate with Struts.

Step 1:

Select Hibernate 3.2.5 in framework

Below Hibernate 3.2.5 Configuration

Select New Database Connection

After select New Database Connection

New Database Connection window will open.

Here we made some changes.

Driver Name: MySQL(Connector/J Driver)

Host : localhost

Database : hiber

User name : root

Password : sure

Display Name(Optional) : HiberDB

Select show JDBC URL

You can see.

Below Hibernate 3.2.5 Configuration

Database Connection: HiberDB

Step 2:

Select Struts 1.3.8 in framework

Below Struts 1.3.8 Configuration

Application Resource : Resources.ApplicationResource

Select Add Struts TLDs

Screen shot

Finish

Successfully Project Created.

Note:

We delete two jsp files such as index.jsp and welcomeStruts.jsp

************************************************************************

Step 2:

2.1). Folder Creation for storing jsp files.

Right click on web pages and Select New--Folder

New Folder window will open. Where we give Folder name as jsp.

Finish.

Folder named as jsp have been created successfully.

2.2). Folder Creation for Hibernate files named as Hiber

Folder name is Hiber.

Right Click on Source packages

New Folder window will open.

Finish

Hiber Folder for Hibernate successfully created.

2.3). Create Another Folder for ActionForm for Struts

named as ActionForms

Follow previous step to create Folder

2.4). Create another Folder for Action for struts

named as Actions

2.5). Create another Folder for Plugin for java class.

Named as Plugin

Step: 3

Creating ActionForms.

How to create ActionForm in Struts

Before creating ActionForms, we should analyze the property we need to create ActionForms.

I have used two property one is studentname and another one is studentno.

I have given actionform name as StudentForms

Insert the following coding into StudentForms

package ActionForms;

import javax.servlet.http.HttpServletRequest;

import org.apache.struts.action.ActionErrors;

import org.apache.struts.action.ActionMapping;

import org.apache.struts.action.ActionMessage;

public class StudentForms extends org.apache.struts.action.ActionForm

{

private String studentname;

private int studentno;

public String getStudentname()

{

return studentname;

}

public void setStudentname(String studentname)

{

this.studentname = studentname;

}

public int getStudentno()

{

return studentno;

}

public void setStudentno(int studentno)

{

this.studentno = studentno;

}

Step 4:

Create Plugin.

I have given name for Plugin java as HibernatePlugin.java

Include following coding into HibernatePlugin.java

package Plugin;

import java.net.URL;

import javax.servlet.ServletException;

import org.apache.struts.action.ActionServlet;

import org.apache.struts.action.PlugIn;

import org.apache.struts.config.ModuleConfig;

import org.hibernate.HibernateException;

import org.hibernate.MappingException;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

public class HibernatePlugin implements PlugIn

{

private Configuration config;

private SessionFactory factory;

private String path = "/hibernate.cfg.xml";

private static Class clazz = HibernatePlugin.class;

public static final String KEY_NAME = clazz.getName();

public void setPath(String path)

{

this.path = path;

}

public void init(ActionServlet servlet, ModuleConfig modConfig)

throws ServletException {

try {

//save the Hibernate session factory into serlvet context

URL url = HibernatePlugin.class.getResource(path);

config = new Configuration().configure(url);

factory = config.buildSessionFactory();

servlet.getServletContext().setAttribute(KEY_NAME, factory);

} catch (MappingException e) {

throw new ServletException();

} catch (HibernateException e) {

throw new ServletException();

}

public void destroy() {

try {

factory.close();

} catch (HibernateException e) {

e.printStackTrace();

}

Screen Shot

Step 5:

Add plugin into struts-config.xml

Step 6:

We have to create all files for Hibernate.

Such as Reverse Engineering and HibernateUtil and POJO class and Mapping files.

Step 6.1:

Create Hibernate Reverse Engineering wizard

Step 6.2:

Create HibernateUtil.java

Step 6.3:

Create POJO class and mapping files

How to create these files? Click

Step 7:

Creating Action

I have given name as StudentAction

Include following coding into StudentAction

package Actions;

import ActionForms.StudentForms;

import Plugin.HibernatePlugin;

import javax.servlet.ServletContext;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.struts.action.ActionForm;

import org.apache.struts.action.ActionForward;

import org.apache.struts.action.ActionMapping;

import org.hibernate.SessionFactory;

import org.hibernate.*;

import org.hibernate.cfg.*;

import org.hibernate.Criteria.*;

import Hiber.Hiber;

import java.util.List;

public class StudentAction extends org.apache.struts.action.Action

{

public ActionForward execute(ActionMapping mapping, ActionForm form,

HttpServletRequest request, HttpServletResponse response)

throws Exception

{

StudentForms sform=(StudentForms)form;

SessionFactory sessionFactory = (SessionFactory) servlet.getServletContext().getAttribute(HibernatePlugin.KEY_NAME);

Session session=sessionFactory.openSession();

Criteria crit=session.createCriteria(Hiber.class);

List list=crit.list();

request.setAttribute("slist",list);

return mapping.findForward("success");

}

Step 8:

Creating jsp files.

Step 8.1).
Home.jsp

Include following coding into Home.jsp

< %@taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" % >
< %@taglib uri="/WEB-INF/struts-html.tld" prefix="html" % >
< %@taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" % >
< html >
< head >
< title > JSP Page < /title >
< /head >
< body >
< html:form action="student" method="post" >

< html:submit value="OK"/ >

< /html:form >
< /body >
< /html >

Step 8.2).

To get records from Database

Create another jsp file named success.jsp

< %@page import="Hiber.Hiber"% >
< %@page import="ActionForms.StudentForms"% >
< %@page import="java.util.*"% >

< html >
< head >
< title > Hibernate with Struts Example < /title >
< /head >
< body >

< %
List list=(List)request.getAttribute("slist");
out.println(list.size());
Iterator it=list.iterator();
while(it.hasNext())
{
Hiber h=(Hiber)it.next();
out.println(h.getStuname());
out.println(h.getStuno());
}
% >
< /body >
< /html >

Step 9:

Made some changes in Struts-config.xml

- - - - -

< action-mappings >
< action
input="/"
name="StudentForms"
path="/student"
scope="session"
type="Actions.StudentAction" >
< forward name="success" path="/jsp/success.jsp"/ >
< /action >
< /action-mappings >

- - - - -

Step 10:

Run Home.jsp

Output

Click OK button

We have learned how to integrate Hibernate with Struts from this post.

Thank you .
By Yours
S.Sureshkumar, M.Sc, M.Phil,

Hibernate EntityQuery

2010-11-18T16:02:00.000-08:00

Hibernate-Entity Query:

Introduction:

Example:

Procedure:

Create Hibernate Project as HibernateNativepro.

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

Include following coding into the EntityPro.jsp

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

List list=s.createSQLQuery("select * from Student student").addEntity(Student.class).list();

Iterator it=list.iterator();
while(it.hasNext())
{
Student s2=(Student)it.next();
out.println(s2.getStuname());

}

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

Output:

Hibernate Project- SUM

2010-11-17T17:06:00.000-08:00

Hibernate Project- SUM

Introduction:

We are going to understand how to use sum in Projection.

Database:

Problem:

To get sum of all Tamil marks.

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 nameds as ProjectionSum.jsp

Include following coding into ProjectionSum.jsp

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

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

ProjectionList p=Projections.projectionList();
p.add(Projections.sum("tamil"));
crit.setProjection(p);

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

while(it.hasNext())
{
Object obj=(Object)it.next();
out.println(obj);
}

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

Output:

Hibernate Projection Example.

2010-11-17T16:18:00.000-08:00

Hibernate Projection Example.

Introduction:

Problem:

To get stuname and tamil mark from table(Student) in database(Navalady).

Database:

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

Include following coding into ProjectionExample.jsp

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

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

ProjectionList p=Projections.projectionList();
p.add(Projections.property("stuname"));
p.add(Projections.property("tamil"));

crit.setProjection(p);

List list=crit.list();
Iterator it=list.iterator();
% >
< table border="3" >
< tr >
< td > Student Name < /td >
< td > Tamil Mark < /td >
< /tr >
< %
while(it.hasNext())
{
Object[] obj=(Object[])it.next();
out.println("< tr > < td > ");
out.println(obj[0]);
out.println(" < /td > < td > ");
out.println(obj[1]);
out.println(" < /td > < /tr > ");
}
% >
< /table >
< %
}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

Output

Hibernate-Using SQLQuery(addScalar()).

2010-11-16T11:45:00.000-08:00

Hibernate-Using SQLQuery(addScalar()).

Use:

To get columns from table as we desired.

Hibernate will use ResultSetMetadata to deduce the actual order and types of the returned scalar values.

We use addScalar() to avoid the ResultSetMetadate and to order manually.

String sql=”select * from Student student;

Query query=session.createSQLQuery(sql)

.addScalar(“Stuname”,Hibernate.STRING)

.addScalar(“Tamil”,Hibernate.BIG_INTEGER)

.addScalar(“Science”,Hibernate.BIG_INTEGER);

It will return query.

Only these three columns (stuname,tamil,science) will be returned, although the query is using * . without addScalar(), the query is using * will return all columns.

Problem:

We use * in select query. But we only get three columns using addScalar().

Note:

Select * from student; it will return all columns.

Procedure:

Create Hibernate Project as HibernateNativepro.

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

Include following coding into the NativeSelectScalar.jsp

< %@page import="Hiber.Student"% >
< %@page import="java.util.Iterator"% >
< %@page import="java.util.List"% >
< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="org.hibernate.criterion.*" % >
< html >
< head >
< title > Hibernate NativeSQL addScalar Example < /title >
< meta name="keywords" content="Hibernate NativeSQL with addScalar"/ >
< /head >
< body >
< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session ss=sessionFactory.openSession();

String sql="select * from Student stu";

Query query=ss.createSQLQuery(sql)
.addScalar("Stuname",Hibernate.STRING)
.addScalar("Tamil",Hibernate.BIG_INTEGER)
.addScalar("Science",Hibernate.BIG_INTEGER);

List list=query.list();
Iterator it=list.iterator();
while(it.hasNext())
{
Object[] st=(Object[])it.next();
out.println("Studentname :"+st[0]);
out.println(" < br > ");
out.println("Tamil :"+st[1]);
out.println(" < br > ");
out.println("English :"+st[2]);
out.println(" < br > ");
}

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

Output:

Hibernate NativeSQL: Get Records From Table

2010-11-16T11:20:00.000-08:00

Hibernate NativeSQL: Get Records From Table

Using SQLQueries:

· Execution of native SQL queries is controlled via the SQLQuery interface,

· SQLQuery is calling through Session.createSQLQuery().

Example for SQLQuery:

String sql=”select * from Student student”;

List list=session.createSQLQuery(sql).list();

(OR)

String sql=”select student.stuname,student.stuno from Student student”;

List list=session.createSQLQuery(sql).list();

Procedure:

Create Hibernate Project as HibernateNativepro.

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

Include following coding into the NativeSelect.jsp

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

String sql="select * from Student stu";

List query=ss.createSQLQuery(sql).list();

Iterator it=query.iterator();
while(it.hasNext())
{
Object[] obj=(Object[])it.next();
out.println(obj[0]);
out.println(obj[1]);
out.println(obj[2]);
out.println(obj[3]);
out.println(obj[4]);
out.println(obj[5]);
out.println(obj[6]);
out.println(obj[7]);

}

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

Output:

Hibernate Insert records into table

2010-11-16T08:45:00.000-08:00

Problem:

To insert data into student table in navalady database.

Solution:

Procedure:

Step 1:

Create Hibernate Reverse Engineering wizard

Step 2:

Create HibernateUtil.java for Creating SessionFactory.

I have created HibernateUtil.java named as NewHibernateUtil.java.

Include following coding into NewHibernateUtil.java

package Hiber;

import java.sql.*;
import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
import java.io.*;

public class NewHibernateUtil
{
public static final SessionFactory sessionFact;
static
{
try
{
sessionFact = new Configuration().configure().buildSessionFactory();
}
catch(Throwable e)
{
System.out.println("SessionFactory creation failed." + e);
throw new ExceptionInInitializerError(e);
}
}
public static final ThreadLocal session = new ThreadLocal();

public static Session currentSession() throws HibernateException
{
Session sess = (Session) session.get();
if(sess == null)
{
sess = sessionFact.openSession();
session.set(sess);
}
return sess;
}
public static void SessionClose() throws Exception
{
Session s = (Session) session.get();
if (s != null)
{
s.close();
session.set(null);
}
}
}

Step 3:
Create POJO class and mapping files

Step 4:

Create jsp file named as HCQinsert.jsp

Include following coding into the HCQinsert.jsp

< %@page import="java.util.Date"% >
< %@page import="Hiber.Student"% >
< %@page import="org.hibernate.*" % >
< %@page import="org.hibernate.cfg.*" % >
< %@page import="Hiber.NewHibernateUtil" % >
< html >
< head >
< title > Hibernate Native SQL-Insert into table < /title >
< /head >
< body >
< %! Session sz; % >
< %
try
{
sz=NewHibernateUtil.currentSession();
Transaction tz=sz.beginTransaction();

Student st=new Student();
st.setStuname("Nithya");
st.setStuno(1003);
st.setTamil(69);
st.setEnglish(64);
st.setMaths(90);
st.setScience(79);
st.setSocialscience(87);
Date d=new Date("1999/06/25");
st.setJoindate(d);
sz.save(st);

out.println("Successfully Inserted into the Student table in Navalady Datebase");
tz.commit();

}
catch(Exception e)
{
sz.close();

out.println("Error Occur");
}

% >
< /body >
< /html >

output

Now we have to check using mysql database using following query.

mysql > select * from student;

Hibernate Insert records into table

2010-11-15T19:15:00.001-08:00

Problem:

To insert data into student table in navalady database.

Solution:

Procedure:

Step 1:

Create Hibernate Reverse Engineering wizard

Step 2:

Create HibernateUtil.java for Creating SessionFactory.

I have created HibernateUtil.java named as NewHibernateUtil.java.

Include following coding into NewHibernateUtil.java

package Hiber;

import java.sql.*;

import org.hibernate.HibernateException;

import org.hibernate.Session;

import org.hibernate.SessionFactory;

import org.hibernate.cfg.Configuration;

import java.io.*;

public class NewHibernateUtil

{

public static final SessionFactory sessionFact;

static

{

try

{

sessionFact = new Configuration().configure().buildSessionFactory();

}

catch(Throwable e)

{

System.out.println("SessionFactory creation failed." + e);

throw new ExceptionInInitializerError(e);

}

public static final ThreadLocal session = new ThreadLocal();

public static Session currentSession() throws HibernateException

{

Session sess = (Session) session.get();

if(sess == null)

{

sess = sessionFact.openSession();

session.set(sess);

}

return sess;

}

public static void SessionClose() throws Exception

{

Session s = (Session) session.get();

if (s != null)

{

s.close();

session.set(null);

}

Step 3:

Create POJO class and mapping files

Step 4:

Create jsp file named as HCQinsert.jsp

Include following coding into the HCQinsert.jsp

&lt %@page import="java.util.Date"% &gt

&lt %@page import="Hiber.Student"% &gt

&lt %@page import="org.hibernate.*" % &gt

&lt %@page import="org.hibernate.cfg.*" % &gt

&lt %@page import="Hiber.NewHibernateUtil" % &gt

&lt html &gt

&lt head &gt

&lt title &gt Hibernate Native SQL-Insert into table &lt /title &gt

&lt /head &gt

&lt body &gt

&lt %! Session sz; % &gt

&lt %

try

{

sz=NewHibernateUtil.currentSession();

Transaction tz=sz.beginTransaction();

Student st=new Student();

st.setStuname("Nithya");

st.setStuno(1003);

st.setTamil(69);

st.setEnglish(64);

st.setMaths(90);

st.setScience(79);

st.setSocialscience(87);

Date d=new Date("1999/06/25");

st.setJoindate(d);

sz.save(st);

out.println("Successfully Inserted into the Student table in Navalady Datebase");

tz.commit();

}

catch(Exception e)

{

sz.close();

out.println("Error Occur");

}

% &gt

&lt /body &gt

&lt /html &gt

Hibernate Criteria Query-OR Clause

2010-11-15T06:48:00.000-08:00

Hibernate Criteria Query – Using OR clause.

Aim:

To check more than one condition using OR clause.

Example:

Problem:

To get student name who get tamil mark between greater than 50 or 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 OrExample.jsp

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

Criteria c=s.createCriteria(Student.class);
c.add(Expression.or(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

To check using mysql database.

Using following mysql query

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

Hibernate Criteria Query-Lessthan

2010-11-14T20:38:00.000-08:00

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

2010-11-14T11:50:00.000-08:00

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

2010-11-14T11:28:00.000-08:00

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

2010-11-14T11:01:00.000-08:00

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

2010-11-14T08:12:00.000-08:00

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

2010-11-14T02:34:00.000-08:00

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;

Hibernate Criteria Query Between Date

2010-11-13T21:34:00.000-08:00

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’);

Hibernate Criteria Query-GreaterThan

2010-11-13T21:28:00.003-08:00

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

Hibernate Criteria Query-LessthanEqual

2010-11-13T20:39:00.001-08:00

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

Hibernate Criteria Query-Between

2010-11-12T02:34:00.000-08:00

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

Hibernate Criteria Query

2010-11-11T15:46:00.000-08:00

Hibernate Criteria Query

· Criteria interface allows us to create and execute object-oriented queries.

· The interface org.hibernate.Criteria is used to create the criterion for the search.

· Hibernate Criteria Query is better than Hibernate Query Language (HQL).

· Used to get all records from table without query.

Problem:

We are going to select all records from table student in navalady database.

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

Include following coding into the CriteriaExample.jsp

< %@page contentType="text/html" pageEncoding="UTF-8"% >

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

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

List list=crit.list();

Iterator it=list.iterator();
% >
< table border="1" >
< caption > Student Records < /caption >
< tr >
< td > Student Name < /td >
< td > Student No < /td >
< td > Tamil < /td >
< td > English < /td >
< td > Mathematics < /td >
< td > Science < /td >
< td > Social Science < /td >
< /tr >
< %
while(it.hasNext())
{
Student stu=(Student)it.next();
out.println(" < tr > < td > "+stu.getStuname()+" < /td > ");

out.println(" < td > "+stu.getStuno()+" < /td > ");

out.println(" < td > "+stu.getTamil()+" < /td > ");

out.println(" < td > "+stu.getEnglish()+" < /td > ");

out.println(" < td > "+stu.getMaths()+" < /td > ");

out.println(" < td > "+stu.getScience()+" < /td > ");

out.println(" < td > "+stu.getSocialscience()+" < /td > ");

}
% >
< /table >
< %

}
catch(Exception e)
{

}
% >
< /body >
< /html >

Step 5:

Run the program CriteriaExample.jsp

Step 6:

Get the Output

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

Goto the mysql

Give the following query

Mysql > select * from student;

Thank you

S.Sureshkumar, M.Sc, M.Phil.

Hibernate Query Language-Where clause

2010-11-11T08:48:00.000-08:00

Hibernate Query Language-where clause

Use:

We get records depending upon the given condition using where clause.

Problem:

To get student name who have passed in tamil.

We assume that the pass mark is above 50.

Procedure:

Note:

Already we have created project named as HibernateProject.
Also we have created Folder for storing jsp and Hibernate files.

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 WhereExam

Include following coding into WhereExam

< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="org.hibernate.SessionFactory" % >
< %@page import="org.hibernate.Session" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate where clause Example < /title >
< /head >
< body >

< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();
String sql="select stuname from Student student where tamil>50";

Query query=s.createQuery(sql);
List list=query.list();
out.println("Students who have passed in Tamil/n");
for(int i=0;i="" <=""

Check the result

Open mysql

Given below query

mysql > select stuname from Student where tamil>50;

Hibernate Query Language-Aggregate function-avg()

2010-11-10T13:54:00.000-08:00

Hibernate Query Language-Aggregate function-avg()

Use:

Sometime we want to get average value from table,at that time we have to use avg(aggregate function).

Problem:

To get average mark of tamil from student table in navalady database.

Procedure:

Note:

Already we have created project named as HibernateProject.
Also we have created Folder for storing jsp and Hibernate files.

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 AvgExam

Include following coding into AvgExam

< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="org.hibernate.SessionFactory" % >
< %@page import="org.hibernate.Session" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Avg(aggregate function)Example < /title >
< /head >
< body >

< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();
String sql="select avg(tamil) from Student student";

Query query=s.createQuery(sql);
List list=query.list();
out.println("Getting average TAMIL Mark : "+list.get(0));

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

Output:

Check the result

Open mysql

Given below query

mysql > select avg(tamil) from student;

Hibernate Query Language-Aggregate function-min()

2010-11-09T23:46:00.000-08:00

Hibernate Query Language-Aggregate function-min

Use:

Sometime we want to get lowest value from table,at that time we have to use max(aggregate function).

Problem:

To get minimum mark of tamil from student table in navalady database.

Procedure:

Note:

Already we have created project named as HibernateProject.
Also we have created Folder for storing jsp and Hibernate files.

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 MaxExam

Include following coding into MaxExam

< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="org.hibernate.SessionFactory" % >
< %@page import="org.hibernate.Session" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Min(aggregate function)Example < /title >
< /head >
< body >

< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();
String sql="select min(tamil) from Student student";

Query query=s.createQuery(sql);
List list=query.list();
out.println("Getting Minimum TAMIL Mark : "+list.get(0));

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

Output:

Check the result

Open mysql

Given below query

mysql > select * from Student;

Hibernate Query Language-max()

2010-11-09T22:54:00.001-08:00

Hibernate Query Language-Aggregate function-max

Use:

Sometime we want to get max value from table,at that time we have to use max(aggregate function).

Problem:

To get maximum mark of mathematics from student table in navalady database.

Procedure:

Note:

Already we have created project named as HibernateProject.
Also we have created Folder for storing jsp and Hibernate files.

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 MaxExam

Include following coding into MaxExam

< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="org.hibernate.SessionFactory" % >
< %@page import="org.hibernate.Session" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate Max(aggregate function)Example < /title >
< /head >
< body >

< %
try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();
String sql="select max(tamil) from Student student";

Query query=s.createQuery(sql);
List list=query.list();
out.println("Getting Maximum TAMIL Mark : "+list.get(0));

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

output:

Check the result

Open mysql

Given below query

mysql > select * from Student;

Hibernate Query Language-count

2010-11-08T07:23:00.000-08:00

Hibernate Query Language-count(Aggregate function)
Creating DataBase using Mysql

DataBase Name: Navalady

Table Name: Student

Open MYSQL command line Client

Step 1:

Create Database named as Navalady.

Syntax:

mysql > create Database Name;

mysql > create Navalady;

Step 2:

To use Created Database. We use the following statement.

Syntax:

mysql > use Database Name;

mysql > use Navalady;

Step 3:

Create Table named as Student.

Mysql > create table table_name(field_name datatypes,filed_name datatypes….);

Mysql > create table Student(stuname varchar(40),stuno int(20),tamil int(20),English int(20),maths int(20), science int(20),socialscience int(20),primary key(stuno));

Step 4:

Insert the records into Student table.

We have to insert five records.

Hibernate Query Language-Aggregate function-count.

There are many aggregate function available in hibernate. Such as count, sum, max, min etc,

Use:

Sometimes we want to get number of rows. At that time we use count() function to get total number of rows depending upon condition.

Example:

Already we have created database as Navalady and table name is Student.

Now we have to get how many students get hundred marks in mathematics.

Query is select count(*) from Student where maths=”100”;

Procedure:

Note:
· Already we have created project named as HibernateProject.· Also we have created Folder for storing jsp and Hibernate files.

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 CountExam

Include following coding into CountExam

< %@page contentType="text/html" pageEncoding="UTF-8"% >
< !DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
http://www.w3.org/TR/html4/loose.dtd >
< %@page import="org.hibernate.SessionFactory" % >
< %@page import="org.hibernate.Session" % >
< %@page import="org.hibernate.cfg.Configuration" % >
< %@page import="org.hibernate.*" % >
< %@page import="java.util.*" % >
< %@page import="Hiber.Student" % >
< html >
< head >
< title > Hibernate count(aggregate function)Example < /title >
< /head >
< body >
< %

try
{
SessionFactory sessionFactory=new Configuration().configure().buildSessionFactory();
Session s=sessionFactory.openSession();
String sql="select count(*) from Student student where maths=100";
Query query=s.createQuery(sql);
Iterator it=query.iterate();

while(it.hasNext())
{
out.println("Total Studnet get 100 in maths "+it.next());
}
s.close();
}
catch(Exception e)
{
out.println(e);
}
% >
< /body >
< /html >

OUTPUT:

The output is 0.

Because nobody get hundreds in mathematic subject.

Insert new records into the student table in navalady database;

Mysql > insert into Student values(‘Mahinda’,7,66,77,100,100,100);

Mysql > insert into Student values(‘Maahi’,8,66,77,100,100,100);

And Run the CountExam.jsp again.