SpringMVC3 Hibernate CRUD Sample Application

cent

浏览: 13249 次
性别:
来自: 广州

最近访客更多访客>>

vaxyne

fmbobin

colcool

博主相关

博客

微博

相册

留言

关于我

文章分类

社区版块

存档分类

博客分类：

springMVC3
hibernate
mysql

springMVC3 hibernate mysql

To learn any web framework starting with a HelloWorld application is a good idea. Once you have some familiarity with the framework configuration, it's better to do a CRUD(Create,Read,Update,Delete) application which covers various aspects of a web framework like Validation, Request URL Mappings, Request Parameter Binding, Pre-populating forms etc.

Now I am going to explain how to write a Simple CRUD application using SpringMVC3, Hibernate and MySQL.
Our Application is ContactsManagement where you can view or search contacts, create new contacts, edit or delete existing contacts.

Step#1: Create the CONTACTS Table

CREATE TABLE  CONTACTS

(

id int(10) unsigned NOT NULL AUTO_INCREMENT,

name varchar(45) NOT NULL,

address varchar(45) DEFAULT NULL,

gender char(1) DEFAULT 'M',

dob datetime DEFAULT NULL,

email varchar(45) DEFAULT NULL,

mobile varchar(15) DEFAULT NULL,

phone varchar(15) DEFAULT NULL,

PRIMARY KEY (id)

);

Step#2: Copy the SpringMVC, Hibernate and their dependent jars into WEB-INF/lib folder.
If you are using Maven you can mention the following dependencies.

<dependencies>

<dependency>

<groupId>junit</groupId>

<artifactId>junit</artifactId>

<version>4.8.1</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-web</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-core</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

<exclusions>

<exclusion>

<artifactId>commons-logging</artifactId>

<groupId>commons-logging</groupId>

</exclusion>

</exclusions>

</dependency>

<dependency>

<groupId>log4j</groupId>

<artifactId>log4j</artifactId>

<version>1.2.14</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-tx</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>jstl</groupId>

<artifactId>jstl</artifactId>

<version>1.1.2</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>taglibs</groupId>

<artifactId>standard</artifactId>

<version>1.1.2</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-webmvc</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-aop</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>commons-digester</groupId>

<artifactId>commons-digester</artifactId>

<version>2.1</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>commons-collections</groupId>

<artifactId>commons-collections</artifactId>

<version>3.2.1</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.hibernate</groupId>

<artifactId>hibernate-core</artifactId>

<version>3.3.2.GA</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>javax.persistence</groupId>

<artifactId>persistence-api</artifactId>

<version>1.0</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>c3p0</groupId>

<artifactId>c3p0</artifactId>

<version>0.9.1.2</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>3.0.5.RELEASE</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-api</artifactId>

<version>1.6.1</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.slf4j</groupId>

<artifactId>slf4j-log4j12</artifactId>

<version>1.6.1</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>cglib</groupId>

<artifactId>cglib-nodep</artifactId>

<version>2.2</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>org.hibernate</groupId>

<artifactId>hibernate-annotations</artifactId>

<version>3.4.0.GA</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>jboss</groupId>

<artifactId>javassist</artifactId>

<version>3.7.ga</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>5.1.14</version>

<type>jar</type>

<scope>compile</scope>

</dependency>

</dependencies>

Step#3: Configure SpringMVC

a) Configure DispatcherServlet in web.xml

<servlet>

<servlet-name>dispatcher</servlet-name>

<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>

<load-on-startup>1</load-on-startup>

</servlet>

 

<servlet-mapping>

<servlet-name>dispatcher</servlet-name>

<url-pattern>*.do</url-pattern>

</servlet-mapping>

 

<listener>

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

</listener>

<context-param>

<param-name>contextConfigLocation</param-name>

<param-value>classpath:applicationContext.xml</param-value>

</context-param>

b) Configure View Resolver in WEB-INF/dispatcher-servlet.xml

<bean id="viewResolver"class="org.springframework.web.servlet.view.InternalResourceViewResolver"

p:prefix="/jsp/" p:suffix=".jsp">

</bean>

c) Configure Annotation support, PropertyPlaceHolderConfigurer, ResourceBundleMessageSource in WEB-INF/classes/applicationContext.xml

<context:annotation-config></context:annotation-config>

 

<context:component-scan base-package="com.sivalabs"></context:component-scan>

 

<mvc:annotation-driven> </mvc:annotation-driven >

 

<context:property-placeholder location="classpath:config.properties"></context:property-placeholder>

 

<bean     id="messageSource"

class="org.springframework.context.support.ResourceBundleMessageSource"

p:basename="Messages">

</bean>

Step#4: Configure JDBC connection parameters and Hibernate properties in config.properties

################### JDBC Configuration ##########################

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/sivalabs

jdbc.username=root

jdbc.password=admin

 

################### Hibernate Configuration ##########################

hibernate.dialect=org.hibernate.dialect.MySQLDialect

hibernate.show_sql=true

#hibernate.hbm2ddl.auto=update

hibernate.generate_statistics=true

Step#5: Configure DataSource, SessionFactory, TransactionManagement support in WEB-INF/classes/applicationContext.xml

<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}">

</bean>       

 

<bean id="sessionFactory"class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">

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

<property name="hibernateProperties">

<props>       

<prop key="hibernate.dialect">${hibernate.dialect}</prop>         

<prop key="hibernate.show_sql">${hibernate.show_sql}</prop>

</props>

</property>

<property name="packagesToScan" value="com.sivalabs"></property>

</bean>

 

 

<bean     id="transactionManager"

class="org.springframework.orm.hibernate3.HibernateTransactionManager"

p:sessionFactory-ref="sessionFactory">

</bean>

 

<tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>



Step#6: Configure the Labels, error messages in WEB-INF/classes/Messages.properties

App.Title=SivaLabs

typeMismatch.java.util.Date={0} is Invalid Date.

dob=DOB

Step#7: Create the Entity class Contact.java

package com.sivalabs.contacts;

 

import java.util.Date;

 

import javax.persistence.Column;

import javax.persistence.Entity;

import javax.persistence.GeneratedValue;

import javax.persistence.GenerationType;

import javax.persistence.Id;

import javax.persistence.Table;

 

import org.apache.commons.lang.builder.ToStringBuilder;

 

@Entity

@Table(name="CONTACTS")

public class Contact

{

@Id

@GeneratedValue(strategy = GenerationType.AUTO)

private int id;

@Column    private String name;

@Column private String address;

@Column private String gender;

@Column private Date dob;

@Column private String email;

@Column private String mobile;

@Column private String phone;

 

@Override

public String toString()

{

return ToStringBuilder.reflectionToString(this);

}

//setters & getters   

}

Step#8: Create the ContactsDAO.java which performs CRUD operations on CONTACTS table.

package com.sivalabs.contacts;

 

import java.util.List;

 

import org.hibernate.Criteria;

import org.hibernate.SessionFactory;

import org.hibernate.criterion.Restrictions;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

import org.springframework.transaction.annotation.Transactional;

 

@Repository

@Transactional

public class ContactsDAO

{

@Autowired

private SessionFactory sessionFactory;

 

public Contact getById(int id)

{

return (Contact) sessionFactory.getCurrentSession().get(Contact.class, id);

}

 

@SuppressWarnings("unchecked")

public List<Contact> searchContacts(String name)

{

Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Contact.class);

criteria.add(Restrictions.ilike("name", name+"%"));

return criteria.list();

}

 

@SuppressWarnings("unchecked")

public List<Contact> getAllContacts()

{

Criteria criteria = sessionFactory.getCurrentSession().createCriteria(Contact.class);

return criteria.list();

}

 

public int save(Contact contact)

{

return (Integer) sessionFactory.getCurrentSession().save(contact);

}

 

public void update(Contact contact)

{

sessionFactory.getCurrentSession().merge(contact);

}

 

public void delete(int id)

{

Contact c = getById(id);

sessionFactory.getCurrentSession().delete(c);

}

}

Step#9: Create ContactFormValidator.java which performs the validations on saving/updating a contact.

package com.sivalabs.contacts;

 

import org.springframework.stereotype.Component;

import org.springframework.validation.Errors;

import org.springframework.validation.ValidationUtils;

import org.springframework.validation.Validator;

 

@Component("contactFormValidator")

public class ContactFormValidator implements Validator

{

@SuppressWarnings("unchecked")

@Override

public boolean supports(Class clazz)

{

return Contact.class.isAssignableFrom(clazz);

}

 

@Override

public void validate(Object model, Errors errors)

{

ValidationUtils.rejectIfEmptyOrWhitespace(errors,"name","required.name", "Name is required.");

}

}

Step#10: Create ContactsControllers.java which processes all the CRUD requests.

package com.sivalabs.contacts;

 

import java.text.SimpleDateFormat;

import java.util.Date;

import java.util.List;

 

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.propertyeditors.CustomDateEditor;

import org.springframework.stereotype.Controller;

import org.springframework.validation.BindingResult;

import org.springframework.web.bind.WebDataBinder;

import org.springframework.web.bind.annotation.InitBinder;

import org.springframework.web.bind.annotation.ModelAttribute;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.bind.annotation.RequestMethod;

import org.springframework.web.bind.annotation.RequestParam;

import org.springframework.web.bind.support.SessionStatus;

import org.springframework.web.servlet.ModelAndView;

 

@Controller

public class ContactsControllers

{

@Autowired

private ContactsDAO contactsDAO;

 

@Autowired

private ContactFormValidator validator;

 

@InitBinder

public void initBinder(WebDataBinder binder)

{

SimpleDateFormat dateFormat = new SimpleDateFormat("dd-MM-yyyy");

dateFormat.setLenient(false);

binder.registerCustomEditor(Date.class, newCustomDateEditor(dateFormat, true));

}

 

@RequestMapping("/searchContacts")

public ModelAndView searchContacts(@RequestParam(required= false, defaultValue="") String name)

{

ModelAndView mav = new ModelAndView("showContacts");

List<Contact> contacts = contactsDAO.searchContacts(name.trim());

mav.addObject("SEARCH_CONTACTS_RESULTS_KEY", contacts);

return mav;

}

 

@RequestMapping("/viewAllContacts")

public ModelAndView getAllContacts()

{

ModelAndView mav = new ModelAndView("showContacts");

List<Contact> contacts = contactsDAO.getAllContacts();

mav.addObject("SEARCH_CONTACTS_RESULTS_KEY", contacts);

return mav;

}

 

@RequestMapping(value="/saveContact", method=RequestMethod.GET)

public ModelAndView newuserForm()

{

ModelAndView mav = new ModelAndView("newContact");

Contact contact = new Contact();

mav.getModelMap().put("newContact", contact);

return mav;

}

 

@RequestMapping(value="/saveContact", method=RequestMethod.POST)

public String create(@ModelAttribute("newContact")Contact contact, BindingResult result, SessionStatus status)

{

validator.validate(contact, result);

if (result.hasErrors())

{               

return "newContact";

}

contactsDAO.save(contact);

status.setComplete();

return "redirect:viewAllContacts.do";

}

 

@RequestMapping(value="/updateContact", method=RequestMethod.GET)

public ModelAndView edit(@RequestParam("id")Integer id)

{

ModelAndView mav = new ModelAndView("editContact");

Contact contact = contactsDAO.getById(id);

mav.addObject("editContact", contact);

return mav;

}

 

@RequestMapping(value="/updateContact", method=RequestMethod.POST)

public String update(@ModelAttribute("editContact") Contact contact, BindingResult result, SessionStatus status)

{

validator.validate(contact, result);

if (result.hasErrors()) {

return "editContact";

}

contactsDAO.update(contact);

status.setComplete();

return "redirect:viewAllContacts.do";

}

 

@RequestMapping("deleteContact")

public ModelAndView delete(@RequestParam("id")Integer id)

{

ModelAndView mav = new ModelAndView("redirect:viewAllContacts.do");

contactsDAO.delete(id);

return mav;

}   

}

Step#11: Instead of writing the JSTL tag library declerations in all the JSPs, declare them in one JSP and include that JSP in other JSPs.

taglib_includes.jsp

<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>

<%@taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>

 

<%@taglib uri="http://www.springframework.org/tags/form" prefix="form"%>

<%@taglib uri="http://www.springframework.org/tags" prefix="spring"%>

Step#12: Create the JSPs.

a)showContacts.jsp

<%@include file="taglib_includes.jsp" %>

 

<html>

<head>

 

<title><spring:message code="App.Title"></spring:message> </title>

<script type="text/javascript" src="js/contacts.js"></script>

</head>

<body style="font-family: Arial; font-size:smaller;">

<center>

<form action="searchContacts.do" method="post">       

<table style="border-collapse: collapse;" border="0"bordercolor="#006699" width="500">

<tr>

<td>Enter Contact Name</td>

<td><input type="text" name="name"/>

<input type="submit" value="Search"/>

<input type="button" value="New Contact"onclick="javascript:go('saveContact.do');"/>

</td></tr>

</table>

</form>

 

<table style="border-collapse: collapse;" border="1"bordercolor="#006699" width="500">

<tr bgcolor="lightblue">

<th>Id</th>

<th>Name</th>           

<th>Address</th>   

<th>Mobile</th>

<th></th>

</tr>

<c:if test="${empty SEARCH_CONTACTS_RESULTS_KEY}">

<tr>

<td colspan="4">No Results found</td>

</tr>

</c:if>

<c:if test="${! empty SEARCH_CONTACTS_RESULTS_KEY}">

<c:forEach var="contact"items="${SEARCH_CONTACTS_RESULTS_KEY}">       

<tr>

<td><c:out value="${contact.id}"></c:out></td>

<td><c:out value="${contact.name}"></c:out></td>

<td><c:out value="${contact.address}"></c:out> </td>

<td><c:out value="${contact.mobile}"></c:out></td>

<td>

<a href="updateContact.do?id=${contact.id}">Edit</a>

<a href="javascript:deleteContact('deleteContact.do?id=${contact.id}');">Delete</a>

</td>

</tr>

</c:forEach>

</c:if>               

</table>   

</center>

 

</body>

</html>

b)newContact.jsp

<%@include file="taglib_includes.jsp" %>

 

<html>

<head>

<script type="text/javascript" src="js/contacts.js"></script>

<title><spring:message code="App.Title"></spring:message> </title>

</head>

<body style="font-family: Arial; font-size:smaller;">

 

<table  bgcolor="lightblue" width="750" height="500" align="center"style="border-collapse: collapse;" border="1" bordercolor="#006699" >

<tr>

<td align="center"><h3>Edit Contact Form</h3></td>

</tr>

<tr valign="top" align="center">

<td align="center">

<form:form action="saveContact.do" method="post"commandName="newContact">

 

<table width="500" style="border-collapse: collapse;"border="0" bordercolor="#006699" cellspacing="2"cellpadding="2">   

<tr>

<td width="100" align="right">Name</td>

<td width="150">

<form:input path="name"/></td>

<td align="left">

<form:errors path="name" cssStyle="color:red"></form:errors>

</td>

</tr>

 

<tr>

<td width="100" align="right">DOB</td>

<td><form:input path="dob"/></td>

<td align="left"><form:errors path="dob"cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Gender</td>

<td>                       

<form:select path="gender">

<form:option value="M" label="Male"/>

<form:option value="F" label="Female"/>

</form:select>                       

</td>

<td>

</td>                       

</tr>

<tr>

<td width="100" align="right">Address</td>

<td><form:input path="address"/></td>

<td align="left">

<form:errors path="address" cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Email</td>

<td><form:input path="email"/></td>

<td align="left"><form:errors path="email"cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Mobile</td>

<td><form:input path="mobile"/></td>

<td align="left">

<form:errors path="mobile" cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td colspan="3" align="center">

<input type="submit" name="" value="Save">

 

<input type="reset" name="" value="Reset">

 

<input type="button"  value="Back"onclick="javascript:go('viewAllContacts.do');">

</td>

</tr>                   

</table>           

</form:form>

</td>   

</tr>

</table>

</body>

</html>

c)editContact.jsp

<%@include file="taglib_includes.jsp" %>

 

<html>

<head>

<script type="text/javascript" src="js/contacts.js"></script>

<title><spring:message code="App.Title"></spring:message> </title>

</head>

<body style="font-family: Arial; font-size:smaller;">

 

<table  bgcolor="lightblue" width="750" height="500" align="center"style="border-collapse: collapse;" border="1" bordercolor="#006699" >

<tr>

<td align="center"><h3>Edit Contact Form</h3></td>

</tr>

<tr valign="top" align="center">

<td align="center">

<form:form action="updateContact.do" method="post"commandName="editContact">

<table width="500" style="border-collapse: collapse;"border="0" bordercolor="#006699" cellspacing="2"cellpadding="2">                   

<tr>

<td width="100" align="right">Id</td>

<td width="150">

<form:input path="id" readonly="true"/></td>

<td align="left">

<form:errors path="id" cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Name</td>

<td>

<form:input path="name"/></td>

<td align="left">

<form:errors path="name" cssStyle="color:red"></form:errors>

</td>

</tr>

 

<tr>

<td width="100" align="right">DOB</td>

<td><form:input path="dob"/></td>

<td align="left"><form:errors path="dob"cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Gender</td>

<td>                       

<form:select path="gender">

<form:option value="M" label="Male"/>

<form:option value="F" label="Female"/>

</form:select>                       

</td>

<td>

</td>                       

</tr>

<tr>

<td width="100" align="right">Address</td>

<td><form:input path="address"/></td>

<td align="left">

<form:errors path="address" cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Email</td>

<td><form:input path="email"/></td>

<td align="left"><form:errors path="email"cssStyle="color:red"></form:errors>  </td>

</tr>

<tr>

<td width="100" align="right">Mobile</td>

<td><form:input path="mobile"/></td>

<td align="left">

<form:errors path="mobile" cssStyle="color:red"></form:errors>  </td>

</tr>

<tr valign="bottom">

<td colspan="3" align="center">

<input type="button"  value="Delete"onclick="javascript:deleteContact('deleteContact.do?id=${editContact.id}');">

 

<input type="submit" name=""value="Save">                       

 

<input type="button"  value="Back"onclick="javascript:go('viewAllContacts.do');">

</td>

</tr>

 

</table>               

</form:form>

</td>   

</tr>

</table>

 

 

</body>

</html>

Step#13: Write the javascript file js/contacts.js containing the utility methods

function go(url)

{

window.location = url;

}

 

function deleteContact(url)

{

var isOK = confirm("Are you sure to delete?");

if(isOK)

{

go(url);

}

}

Step#14: The welcome file index.jsp

<%

response.sendRedirect("viewAllContacts.do");

%>

Step#15: Start the server and point your browser URL to http://localhost:8080/SpringMVCHibernate

http://java.dzone.com/articles/springmvc3-hibernate-crud

分享到：

maven环境快速搭建 | 交流的工具

2013-10-05 04:13
浏览 1736
评论(0)
分类:互联网
查看更多

发表评论

您还没有登录,请您登录后再发表评论

最近访客更多访客>>

博主相关

文章分类

社区版块

存档分类

最新评论