Spring MVC Hibernate MySQL CRUD example

In this post, we are going to see integration of Spring MVC, hibernate and mysql CRUD example.
We have already seen integration of Spring Rest with hibernate in previous tutorial.

Here are steps to create a project with Spring MVC , hibernate and mySQL crud example.

Github Source code:

1) Create a dynamic web project using maven in eclipse named “SpringMVCHibernateCRUDExample”

Maven dependencies

2) We are using Spring 4 and Hibernate 4 for this application. It should work with hibernate 3 also but we need to do small changes in hibernate configuration.

pom.xml

Spring application configuration:

3) Change web.xml as below:

4) create a xml file named spring-servlet.xml in /WEB-INF/ folder.
Please change context:component-scan if you want to use different package for spring to search for controller.Please refer to spring mvc hello world example for more understanding.

In Spring-servlet.xml, we have done hibernate configuration.
dataSource bean is used to specify java data source. We need to provide driver, URL , Username and Password.
transactionManager bean is used to configure hibernate transaction manager. hibernate4AnnotatedSessionFactory bean is used to configure FactoryBean that creates a Hibernate SessionFactory. This is the common way to set up a shared Hibernate SessionFactory in a Spring application context, so you can use this SessionFactory to inject in Hibernate data access objects.
Create a applicationcontext.xml in WEB-INF folder, this file is used for bean configuration as we are using spring-servlet.xml for bean configuration , we will keep this file empty.

Create bean class

4) Create a bean name “Country.java” in org.arpit.java2blog.bean.

@Entity is used for making a persistent pojo class.For this java class,you will have corresponding table in database. @Column is used to map annotated attribute to corresponding column in table. So Create Country table in mysql database with following code:

Create Controller

5) Create a controller named “CountryController.java” in package org.arpit.java2blog.controller

Create DAO class

Create a class CountryDAO.java in package org.arpit.java2blog.dao.  This class will execute hibernate statements while interacting with database.

@Repository is specialised component annotation which is used to create bean at DAO layer. We have use Autowired annotation to inject hibernate SessionFactory into CountryDAO class. We have already configured hibernate SessionFactory object in Spring-Servlet.xml file.

Create Service class

6) Create a class CountryService.java in package org.arpit.java2blog.service
It is service level class. It will call DAO layer class.
@Service is specialised component annotation which is used to create bean at Service layer.

Create view

Create view called countryDetails.jsp in WEB-INF/view/ folder.
8) It ‘s time to do maven build.

Right click on project -> Run as -> Maven build

Maven build in eclipse
9) Provide goals as clean install (given below) and click on run
Maven build in eclipse

Run the application

10) Right click on project -> run as -> run on server
Select apache tomcat and click on finish
11)  Now lets hit below URL to getAllCountries.
http://localhost:8080/SpringMVCHibernateCRUDExample/getAllCountries
You will get below screen:

Empty Country List Spring MVC hibernate

As you can see, we did not add any country to the list, so it is empty.
Lets add Country named India to country list and click submit.
Similarly we will add China , Bhutan and Nepal respectively and you will see below screen.

All Country List Spring MVC hibernate


Lets edit population of Bhutan to 15000. Click on edit button corresponds to Bhutan.


When you click on submit, you will get below screen.

Lets delete country China from above list, click on delete button corresponds to 2nd row.
You will see below screen.

As you can see, china got deleted from above list.

Project structure:

Spring MVC Hibernate CRUD example


We are done with Spring MVC hibernate MySQL CRUD example. If you are still facing any issue, please comment.

Was this post helpful?

Comments

  1. EXCELLENT tutorial! This is the best yet of any I've seen. Just wanted to take a minute to say thanks for putting this together, it was extremely helpful!

  2. Hi Friends

    It is very usefull doucment please folow all the steps you get a solution

    Thanks to Who has added post

  3. hi arpit , i like u tutos. Can u explain how updateCountry method on @Controller work? when link the url for edit a country.. to get an exception.

Leave a Reply

Your email address will not be published. Required fields are marked *