Spring MVC and Hibernate Tutorial

Spring is a lightweight framework. it provides support to various frameworks such as Hibernate, Struts, Tapestry, EJB, JSF, etc.
Modules: IOC(Inversion of control),  AOP(Aspect Oriented Programming), DAO(Data Access Object), Context,ORM(Object-relational Mapping), Web, MVC(Model View Controller). etc.

This is a step-by-step tutorial that helps you build a Spring-Hibernate application easily in a clear and concise way. In this first part, we demonstrate how to code a simple Spring MVC application that displays a list of users from MySQL database.
1. Create Database Name is demo and Database Table name is springhibernet.
/* EMPLOYEE table */ CREATE TABLE `springhibernet` ( `employee_id` BIGINT( 10 ) NOT NULL AUTO_INCREMENT , `firstname` VARCHAR( 50 ) NULL DEFAULT NULL , `lastname` VARCHAR( 50 ) NULL DEFAULT NULL , `birth_date` DATE NOT NULL , `cell_phone` VARCHAR( 15 ) NOT NULL , PRIMARY KEY ( `employee_id` ) )
Open NetBeans See The Menu Bar go to the file Menu Click on the New Project(Ctrl+Shift+N) and Select Left site categories Java/java web and Project categories to Right Site Project java/web Application .You have to give The Program Name "SpringHibernateTutorial". if you wont to save Project Location you can Browse and File save on the direction place and Gone a default Place and Now uncheck/check the check box and click on the next button, select server settings and select The Spring Web MVC Framework 4.0 and Hibernate Framework 4.3 and go to the finish.

This is automatic generated page code with custom according to performance.  
2.applicationContext.xml
<?xml version='1.0' encoding='UTF-8' ?> <!-- was: <?xml version="1.0" encoding="UTF-8"?> --> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> <!--bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer" p:location="/WEB-INF/jdbc.properties" /> <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" p:driverClassName="${jdbc.driverClassName}" p:url="${jdbc.url}" p:username="${jdbc.username}" p:password="${jdbc.password}" /--> <!-- ADD PERSISTENCE SUPPORT HERE (jpa, hibernate, etc) --> </beans>
3.dispatcher-servlet.xml
<?xml version='1.0' encoding='UTF-8' ?> <!-- was: <?xml version="1.0" encoding="UTF-8"?> --> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd"> <bean class="org.springframework.web.servlet.mvc.support.ControllerClassNameHandlerMapping"/> <!-- Add view.class bean --> <bean class="com.spring.module.view" id="viewckey" /> <!-- Most controllers will use the ControllerClassNameHandlerMapping above, but for the index controller we are using ParameterizableViewController, so we must define an explicit mapping for it. --> <bean id="urlMapping" class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping"> <property name="mappings"> <props> <prop key="index.htm">indexController</prop> <!--Add view.htm --> <prop key="view.htm">viewckey</prop> </props> </property> </bean> <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver" p:prefix="/WEB-INF/jsp/" p:suffix=".jsp" /> <!-- The index controller. --> <bean name="indexController" class="org.springframework.web.servlet.mvc.ParameterizableViewController" p:viewName="index" /> </beans>
4.web.xml
<?xml version="1.0" encoding="UTF-8"?> <web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"> <context-param> <param-name>contextConfigLocation</param-name> <param-value>/WEB-INF/applicationContext.xml</param-value> </context-param> <listener> <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class> </listener> <servlet> <servlet-name>dispatcher</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <load-on-startup>2</load-on-startup> </servlet> <servlet-mapping> <servlet-name>dispatcher</servlet-name> <url-pattern>*.htm</url-pattern> </servlet-mapping> <session-config> <session-timeout> 30 </session-timeout> </session-config> <welcome-file-list> <welcome-file>redirect.jsp</welcome-file> </welcome-file-list> <jsp-config> </jsp-config> </web-app>
5.redirect.jsp
<%@page contentType="text/html" pageEncoding="UTF-8"%> <% response.sendRedirect("index.htm"); %>
There are default package with custom and controlling package classes.
6.default package
A. hibernate.cfg.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd"> <hibernate-configuration> <session-factory> <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property> <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property> <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/demo?zeroDateTimeBehavior=convertToNull</property> <property name="hibernate.connection.username">root</property> <property name="hibernate.current_session_context_class">thread</property> <property name="hibernate.show_sql">true</property> <mapping resource="com/pojo/file/Springhibernet.hbm.xml"/> </session-factory> </hibernate-configuration>
B. hibernate.reveng.xml
<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd"> <hibernate-reverse-engineering> <schema-selection match-catalog="demo"/> <table-filter match-name="springhibernet"/> </hibernate-reverse-engineering>
7. controlling package

1. This is the Bean class and hbm file package name is "com.pojo.file".

A. Springhibernet.java
package com.pojo.file; import java.util.Date; public class Springhibernet implements java.io.Serializable { private Long employeeId; private String firstname; private String lastname; private Date birthDate; private String cellPhone; public Springhibernet() { } public Springhibernet(Date birthDate, String cellPhone) { this.birthDate = birthDate; this.cellPhone = cellPhone; } public Springhibernet(String firstname, String lastname, Date birthDate, String cellPhone) { this.firstname = firstname; this.lastname = lastname; this.birthDate = birthDate; this.cellPhone = cellPhone; } public Long getEmployeeId() { return this.employeeId; } public void setEmployeeId(Long employeeId) { this.employeeId = employeeId; } public String getFirstname() { return this.firstname; } public void setFirstname(String firstname) { this.firstname = firstname; } public String getLastname() { return this.lastname; } public void setLastname(String lastname) { this.lastname = lastname; } public Date getBirthDate() { return this.birthDate; } public void setBirthDate(Date birthDate) { this.birthDate = birthDate; } public String getCellPhone() { return this.cellPhone; } public void setCellPhone(String cellPhone) { this.cellPhone = cellPhone; } }
B. Springhibernet.hbm.xml
<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://www.hibernate.org/dtd/hibernate-mapping-3.0.dtd"> <!-- Generated Sep 5, 2016 11:47:41 AM by Hibernate Tools 4.3.1 --> <hibernate-mapping> <class name="com.pojo.file.Springhibernet" table="springhibernet" catalog="demo" optimistic-lock="version"> <id name="employeeId" type="java.lang.Long"> <column name="employee_id" /> <generator class="identity" /> </id> <property name="firstname" type="string"> <column name="firstname" length="50" /> </property> <property name="lastname" type="string"> <column name="lastname" length="50" /> </property> <property name="birthDate" type="date"> <column name="birth_date" length="10" not-null="true" /> </property> <property name="cellPhone" type="string"> <column name="cell_phone" length="15" not-null="true" /> </property> </class> </hibernate-mapping>
c. HibernateUtil.java
package com.pojo.file; import org.hibernate.cfg.AnnotationConfiguration; import org.hibernate.SessionFactory; /** * Hibernate Utility class with a convenient method to get Session Factory * object. * * @author manoj kumar */ public class HibernateUtil { private static final SessionFactory sessionFactory; static { try { // Create the SessionFactory from standard (hibernate.cfg.xml) // config file. sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory(); } catch (Throwable ex) { // Log the exception. System.err.println("Initial SessionFactory creation failed." + ex); throw new ExceptionInInitializerError(ex); } } public static SessionFactory getSessionFactory() { return sessionFactory; } }
               2.  This is the view controlling package name is "com.spring.module".
A. view.java
package com.spring.module; import com.pojo.file.HibernateUtil; import org.springframework.web.servlet.mvc.SimpleFormController; import com.pojo.file.Springhibernet; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.hibernate.Session; import org.springframework.web.servlet.ModelAndView; /** * * @author manoj kumar */ public class view extends SimpleFormController{ public view() { setCommandClass(Springhibernet.class); setCommandName("view"); } @Override public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws Exception { ModelAndView mv=new ModelAndView("view"); String title="Spring and Hibernate Tutorial"; try { Session s=HibernateUtil.getSessionFactory().openSession(); s.beginTransaction(); List result=s.createQuery("From Springhibernet").list(); mv.addObject("view", result); s.getTransaction().commit(); } catch (Exception e) { e.printStackTrace(); } mv.addObject("message", title); return mv; } }
Web browser page index.jsp and view.jsp.
8.index.jsp
<%@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"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>Spring and Hibernate Tutorial</title> </head> <body> <p align="center"> <b>Hello! This is the default welcome page for a Spring and Hibernate Tutorial project.</b></p> <table align="center"> <tr><th> </th></tr> <th><a href="view.htm">View Information</a></th></tr> </table> </body> </html>





9. view.jsp

<%-- Document : view Created on : Sep 5, 2016, 10:53:07 AM Author : manoj kumar --%> <%@page contentType="text/html" pageEncoding="UTF-8"%> <%@taglib prefix="c" uri="http://java.sun.com/jstl/core_rt" %> <!DOCTYPE html> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>${message}</title> </head> <body> <p align="center"> <b>${message}</b></p> <table border="1" align="center"> <tr> <td>Employee Id</td> <td>Name</td> <td>Last Name</td> <td>DOB</td> <td>Mobil No.</td> </tr> <c:forEach items="${view}" var="view" > <tr> <td><c:out value="${view.employeeId}" /></td> <td><c:out value="${view.firstname}" /></td> <td><c:out value="${view.lastname}" /></td> <td><c:out value="${view.birthDate}" /></td> <td><c:out value="${view.cellPhone}" /></td> </tr> </c:forEach> </table> </body> </html>