Spring MVC and JDBC CRUD Example

This tutorial shows an example on how MVC(Model, View, Controller) works in Spring 4.x. In this tutorial you will also find how JDBC works with Spring MVC. We will also see how annotation like @Autowired works in Spring. You will also see how datasource is configured in Spring. This example shows how to integrate Spring 4 with Maven 3. You may also read Spring MVC and Spring JDBC Example

Spring MVC and JDBC CRUD with zero XML

For this tutorial we will create maven based web project in Eclipse.

If you already have an idea on how to create a maven project in Eclipse will be great otherwise I will tell you here how to create a maven project in Eclipse.

Prerequisites

The following configurations are required in order to run the application

Eclipse Kepler
JDK 1.8
Tomcat 8
Have maven 3 installed and configured
Spring 4 dependencies in pom.xml

Now we will see the below steps how to create a maven based project in Eclipse
Step 1. Create a maven based web project in Eclipse

Go to File -> New -> Other. On popup window under Maven select Maven Project. Then click on Next. Select the workspace location – either default or browse the location. Click on Next. Now in next window select the row as highlighted from the below list of archtypes and click on Next button.

maven-arctype-webapp

Now enter the required fields (Group Id, Artifact Id) as shown below

Group Id : com.roytuts
Artifact Id : spring-mvc-jdbc

The created project looks like below

spring mvc and jdbc

Step 2. Modify the pom.xml file as shown below.

Step 3. If you see JRE System Library[J2SE-1.5] then change the version by below process

Do right-click on the project and go to Build -> Configure build path, under Libraries tab click on JRE System Library[J2SE-1.5], click on Edit button and select the appropriate jdk 1.8 from the next window. Click on Finish then Ok.

Change also the Compiler compliance level as 1.8 from Java -> Compiler.

Step 4. Now when the build process finished then modify the web.xml file with below source code

Step 5. Create spring-config.xml file under src/main/resources directory with the below source code

Step 6. Create controllers.xml file under src/main/resources directory

Step 7. Create a directory called pages under webapp directory for putting created jsp views.

Step 8. Create MySQL table user_details in database cdcol

Step 9. Dump some data into the table

Step 10. Now create POJO class and mapper class which will map Java object to database table user_details

Mapper class

Step 11. Create DAO interface for querying database table

Step 12. Create the corresponding DAO implementation class

Step 13. Create the service interface for processing logic or business logic

Step 14. Create the corresponding service implementation class

Step 15. Create Spring controller class which will handle user request and response

Step 16. Now create user.jsp file under webapp/pages directory for displaying single user details

Step 17. Create users.jsp file under webapp/pages directory for displaying all users details

Step 18. Create add.jsp file under webapp/pages directory for adding new user

Step 19. Create update.jsp file under webapp/pages directory for updating new user

Step 20. Now run the application on Tomcat server 8 and when the application successfully deployed onto the server, please hit the URL http://localhost:8080/spring-mvc-jdbc/users , you will below output in the browser

spring mvc and jdbc

When you hit the URL http://localhost:8080/spring-mvc-jdbc/user in the browser, you will see the below output

spring mvc and jdbc

When you click on the update link on page http://localhost:8080/spring-mvc-jdbc/users in the browser, you will see the below output

spring mvc and jdbc

When you click on the delete link on page http://localhost:8080/spring-mvc-jdbc/users in the browser, you will see the below output

spring mvc and jdbc

When you hit the URL http://localhost:8080/spring-mvc-jdbc/addUser in the browser, you will see the below output

spring mvc and jdbc

After addition of user the page navigates automatically to the all users page

spring mvc and jdbc

The newly added user information is inserted into database

spring mvc and jdbc

Thanks for reading.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.