Struts Spring Hibernate

In this section, you will learn about the Struts, Spring and Hibernate Integration.

The tools & technology used is given below :

struts 2.1.8
spring 2.5.6
hibernate 3.2.7
dom4j 1.6.1
cglib 2.2
Eclipse 3.5

The SQL query used to create the employee table is given below :

CREATE TABLE `employee` ( 
	`EMPLOYEE_ID` bigint(20) unsigned NOT NULL auto_increment, 
	`NAME` varchar(45) NOT NULL, 
	`ADDRESS` varchar(255) NOT NULL, 
	`CREATED_DATE` datetime NOT NULL, 
	PRIMARY KEY (`EMPLOYEE_ID`) 
) ENGINE=InnoDB DEFAULT CHARSET=utf8

Three easy steps to integrate Struts, Spring and Hibernate :

Collect all the jar file needed into project lib.
To integrate Struts 2 with Spring, incorporate ContextLoaderListener.
To integrate Spring with Hibernate, incorporate LocalSessionFactoryBean.

Let us discuss these steps in detail using a example :

Example

The project structure is given below:

The jar file used is given below :

CODES

web.xml

In the below example, Listener class ContextLoaderListener loads SpringBeans.xml file(which load beans), and also interact with Struts. It also loads bean class LocalSessionFactoryBean which will deal with Hibernate.

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://java.sun.com/xml/ns/javaee" xmlns:web="http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
id="WebApp_ID" version="2.5">
<display-name>StrutsSpringHibernate</display-name>
<filter>
<filter-name>struts2</filter-name>
<filter-class>
org.apache.struts2.dispatcher.FilterDispatcher
</filter-class>
</filter>

<filter-mapping>
<filter-name>struts2</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>

<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/SpringBeans.xml</param-value>
</context-param>

<listener>
<listener-class>
org.springframework.web.context.ContextLoaderListener
</listener-class>
</listener>
</web-app>

SpringBeans.xml

<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">
<!-- Database Configuration -->
<bean
class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
<property name="location">
<value>/WEB-INF/properties/database.properties
</value>
</property>
</bean>

<bean id="dataSource"
class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.driverClassName}" />
<property name="url" value="${jdbc.url}" />
<property name="username" value="${jdbc.username}" />
<property name="password" value="${jdbc.password}" />
</bean>

<!-- Hibernate session factory -->
<bean id="sessionFactory" 
class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">

<property name="dataSource">
<ref bean="dataSource"/>
</property>

<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">true</prop>
</props>
</property>

<property name="mappingResources">
<list>
<value>net/roseindia/hibernate/Employee.hbm.xml</value>
</list>
</property>
</bean>
<!-- Beans Declaration -->
<bean id="employeeAction" class="net.roseindia.employee.action.EmployeeAction">
<property name="employeeDAO" ref="employeeDAO" />
</bean>

<bean id="employeeDAO" class="net.roseindia.employee.dao.impl.EmployeeDAOImpl" >
<property name="sessionFactory" ref="sessionFactory" />
</bean>

</beans>

struts.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE struts PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 2.0//EN"
"http://struts.apache.org/dtds/struts-2.0.dtd">

<struts>
<constant name="struts.devMode" value="true" />

<package name="default" extends="struts-default" namespace="/" >

<action name="addEmployeeAction" 
class="net.roseindia.employee.action.EmployeeAction" method="addEmployee" >
<result name="success">pages/employee.jsp</result>
</action>

<action name="listEmployeeAction"
class="net.roseindia.employee.action.EmployeeAction" method="listEmployee" >
<result name="success">pages/employee.jsp</result>
</action>
</package>

</struts>

Employee.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
<class name="net.roseindia.employee.model.Employee" 
table="employee">
<id name="employeeId" type="java.lang.Long">
<column name="EMPLOYEE_ID" />
<generator class="identity" />
</id>
<property name="name" type="string">
<column name="NAME" length="45" not-null="true" />
</property>
<property name="address" type="string">
<column name="ADDRESS" not-null="true" />
</property>
<property name="createdDate" type="timestamp">
<column name="CREATED_DATE" length="19" not-null="true" />
</property>
</class>
</hibernate-mapping>

Employee.java

package net.roseindia.employee.model;

import java.util.Date;

public class Employee implements java.io.Serializable {

private Long employeeId;
private String name;
private String address;
private Date createdDate;

public Employee() {
}

public Employee(Long employeeId, String name, String address,
Date createdDate) {
this.employeeId = employeeId;
this.name = name;
this.address = address;
this.createdDate = createdDate;
}

public Long getEmployeeId() {
return employeeId;
}

public void setEmployeeId(Long employeeId) {
this.employeeId = employeeId;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

public Date getCreatedDate() {
return createdDate;
}

public void setCreatedDate(Date createdDate) {
this.createdDate = createdDate;
}

}

EmployeeDAO.java

package net.roseindia.employee.model;

import java.util.Date;

public class Employee implements java.io.Serializable {

private Long employeeId;
private String name;
private String address;
private Date createdDate;

public Employee() {
}

public Employee(Long employeeId, String name, String address,
Date createdDate) {
this.employeeId = employeeId;
this.name = name;
this.address = address;
this.createdDate = createdDate;
}

public Long getEmployeeId() {
return employeeId;
}

public void setEmployeeId(Long employeeId) {
this.employeeId = employeeId;
}

public String getName() {
return name;
}

public void setName(String name) {
this.name = name;
}

public String getAddress() {
return address;
}

public void setAddress(String address) {
this.address = address;
}

public Date getCreatedDate() {
return createdDate;
}

public void setCreatedDate(Date createdDate) {
this.createdDate = createdDate;
}

}

EmployeeDAOImpl.java

package net.roseindia.employee.dao.impl;

import java.util.List;

import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import net.roseindia.employee.dao.EmployeeDAO;
import net.roseindia.employee.model.Employee;

public class EmployeeDAOImpl extends HibernateDaoSupport implements EmployeeDAO{

//add the customer
public void addEmployee(Employee employee){

getHibernateTemplate().save(employee);

}

//return all the customers in list
public List<Employee> listEmployee(){

return getHibernateTemplate().find("from Employee");

}

}

EmployeeAction.java

package net.roseindia.employee.action;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

import net.roseindia.employee.dao.EmployeeDAO;
import net.roseindia.employee.model.Employee;
import com.opensymphony.xwork2.ModelDriven;

public class EmployeeAction implements ModelDriven{

Employee employee = new Employee();
List<Employee> employeeList = new ArrayList<Employee>();

EmployeeDAO employeeDAO;

//Spring Dependency Injection
public void setEmployeeDAO(EmployeeDAO employeeDAO) {
this.employeeDAO = employeeDAO;
}

public Object getModel() {
return employee;
}

public List<Employee> getEmployeeList() {
return employeeList;
}

public void setEmployeeList(List<Employee> employeeList) {
this.employeeList = employeeList;
}

//saving employee record
public String addEmployee() throws Exception{ 
//save employee
employee.setCreatedDate(new Date());
employeeDAO.addEmployee(employee);

//reload the employee list
employeeList = null;
employeeList = employeeDAO.listEmployee();

return "success";
}

//list all customers
public String listEmployee() throws Exception{
employeeList = employeeDAO.listEmployee();
return "success";
}

}

database.properties

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://192.168.10.13:3306/company
jdbc.username=root
jdbc.password=root

employee.jsp

<%@ taglib prefix="s" uri="/struts-tags" %>
<html>
<head>
</head>

<body>
<h2><i>Integration Example - Struts 2,Spring & Hibernate</i></h2>
<hr></hr>
<h3><i>Add New Employee</i></h3>
<s:form action="addEmployeeAction" >
<s:textfield name="name" label="Employee Name" value="" size="37"/>
<s:textarea name="address" label="Employee Address" value="" cols="28" rows="3" />
<s:submit align="center"/>
</s:form>
<hr></hr>
<h3><i>Employee List</i></h3>

<s:if test="employeeList.size() > 0">
<table border="2px" cellpadding="8px">
<tr>
<th>Employee<br/>ID</th>
<th>Name</th>
<th>Address</th>
<th>Created Date</th>
</tr>
<s:iterator value="employeeList" status="userStatus">
<tr>
<td><s:property value="employeeId" /></td>
<td><s:property value="name" /></td>
<td><s:property value="address" /></td>
<td><s:date name="createdDate" format="dd/MM/yyyy" /></td>
</tr>
</s:iterator>
</table>
</s:if>
<br/>
<br/>

</body>
</html>