Spring MVC Integration with MySQL

Last Updated : 04 Oct, 2025

Spring MVC is a widely used Java framework for building scalable web applications. When combined with MySQL, it becomes a robust platform for developing data-driven applications. This tutorial covers database setup, project configuration, DAO layer implementation, and CRUD operations in a Spring MVC + MySQL application.

Database Setup

We will create a database named test and a table studentsdetails to store student information.

Step 1: Create the Database

CREATE DATABASE test;
USE test;

2. Create the Table

CREATE TABLE studentsdetails (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(25),
caste VARCHAR(25),
neet_marks INT,
gender VARCHAR(10)
);

3. Insert Sample Records

INSERT INTO studentsdetails(name, caste, neet_marks, gender) VALUES
('Geek1', 'OBC', 600, 'Female'),
('Geek2', 'General', 700, 'Female'),
('Geek3', 'General', 600, 'Male'),
('Geek4', 'OBC', 670, 'Male'),
('Geek5', 'SC', 600, 'Female'),
('Geek6', 'SC', 500, 'Male');

4. Verify Records

SELECT * FROM studentsdetails;

The below image demonstrates a database table showing student data, including their names, caste, NEET marks and gender

Spring MVC Application Setup

Project Structure:

The project structure for the Spring MVC application is as follows:

Step 1: Maven Dependencies (pom.xml)

The pom.xml file includes the necessary dependencies for Spring MVC, MySQL, and other libraries.

XML

<dependencies>
    <!-- Spring Web MVC -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-webmvc</artifactId>
        <version>5.3.18</version>
    </dependency>

    <!-- Spring JDBC -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-jdbc</artifactId>
        <version>5.3.18</version>
    </dependency>

    <!-- MySQL Connector -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.28</version>
    </dependency>

    <!-- JUnit for testing -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.13.2</version>
        <scope>test</scope>
    </dependency>
</dependencies>

Step 2: Spring Configuration (spring-servlet.xml)

The spring-servlet.xml file is used to configure the Spring MVC application context and database connection.

XML

<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       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.xsd
           http://www.springframework.org/schema/context 
           http://www.springframework.org/schema/context/spring-context.xsd
           http://www.springframework.org/schema/mvc 
           http://www.springframework.org/schema/mvc/spring-mvc.xsd">

    <context:component-scan base-package="com.students.controllers"/>
    <mvc:annotation-driven/>

    <!-- Database Configuration -->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.cj.jdbc.Driver"/>
        <property name="url" value="jdbc:mysql://localhost:3306/test?useSSL=false&amp;serverTimezone=UTC"/>
        <property name="username" value="root"/>
        <property name="password" value="yourpassword"/>
    </bean>

    <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
        <property name="dataSource" ref="dataSource"/>
    </bean>

    <!-- DAO Configuration -->
    <bean id="studentDao" class="com.students.dao.StudentDao">
        <property name="template" ref="jdbcTemplate"/>
    </bean>

    <!-- View Resolver -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"/>
        <property name="suffix" value=".jsp"/>
    </bean>
</beans>

Student.java (Bean Class)

The Student class maps to the studentsdetails table.

Java

package com.students.beans;

public class Student {
    private int id;
    private String name;
    private String caste;
    private int neetMarks;
    private String gender;

    // Getters and Setters
    public int getId() { return id; }
    public void setId(int id) { this.id = id; }

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

    public String getCaste() { return caste; }
    public void setCaste(String caste) { this.caste = caste; }

    public int getNeetMarks() { return neetMarks; }
    public void setNeetMarks(int neetMarks) { this.neetMarks = neetMarks; }

    public String getGender() { return gender; }
    public void setGender(String gender) { this.gender = gender; }
}

StudentDao.java (DAO Class)

The StudentDao class handles database operations.

Java

package com.students.dao;

import com.students.beans.Student;
import org.springframework.jdbc.core.BeanPropertyRowMapper;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.dao.EmptyResultDataAccessException;

import java.util.List;

public class StudentDao {
    private JdbcTemplate template;

    public void setTemplate(JdbcTemplate template) {
        this.template = template;
    }

    public Student getStudentById(int id) {
        try {
            return template.queryForObject(
                "SELECT * FROM studentsdetails WHERE id=?",
                new Object[]{id},
                new BeanPropertyRowMapper<>(Student.class)
            );
        } catch (EmptyResultDataAccessException e) {
            return null;
        }
    }

    public Student getStudentByName(String name) {
        try {
            return template.queryForObject(
                "SELECT * FROM studentsdetails WHERE name=?",
                new Object[]{name},
                new BeanPropertyRowMapper<>(Student.class)
            );
        } catch (EmptyResultDataAccessException e) {
            return null;
        }
    }

    public List<Student> getStudentsByCaste(String caste) {
        return template.query(
            "SELECT * FROM studentsdetails WHERE caste=?",
            new Object[]{caste},
            new BeanPropertyRowMapper<>(Student.class)
        );
    }

    public List<Student> getStudentsByNeetMarks(int neetMarks) {
        return template.query(
            "SELECT * FROM studentsdetails WHERE neet_marks=?",
            new Object[]{neetMarks},
            new BeanPropertyRowMapper<>(Student.class)
        );
    }
}

Controller Class (`StudentController.java`)

The StudentController class handles HTTP requests.

Java

package com.students.controllers;

import com.students.beans.Student;
import com.students.dao.StudentDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
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.servlet.ModelAndView;

@Controller
public class StudentController {

    private final StudentDao dao;

    @Autowired
    public StudentController(StudentDao dao) {
        this.dao = dao;
    }

    @RequestMapping("/studentsearchform")
    public String showSearchForm(Model model) {
        model.addAttribute("command", new Student());
        return "studentsearchform";
    }

    @RequestMapping(value = "/checkByNeetMarks", method = RequestMethod.POST)
    public ModelAndView checkByNeetMarks(@ModelAttribute("student") Student student) {
        ModelAndView mav = new ModelAndView("welcome");
        Student studentData = dao.getStudentByName(student.getName());

        if (studentData != null) {
            boolean isEligible = false;
            String caste = studentData.getCaste();
            int neetMarks = studentData.getNeetMarks();

            if (caste.equalsIgnoreCase("General") && neetMarks >= 600) isEligible = true;
            else if (caste.equalsIgnoreCase("OBC") && neetMarks >= 500) isEligible = true;
            else if (caste.equalsIgnoreCase("SC") && neetMarks >= 400) isEligible = true;

            mav.addObject("name", studentData.getName());
            mav.addObject("caste", caste);
            mav.addObject("neetMarks", neetMarks);
            mav.addObject("eligibility", isEligible ? "Eligible for Medical Seat" : "Not eligible");
        } else {
            mav.addObject("name", student.getName());
            mav.addObject("eligibility", "Student not found");
        }

        return mav;
    }
}

JSP Views

1. studentsearchform.jsp

HTML

<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<html>
<body>
    <form action="checkByNeetMarks" method="post">
        Name: <input type="text" name="name" /><br/>
        <input type="submit" value="Check Eligibility" />
    </form>
</body>
</html>

2. welcome.jsp

HTML

<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<html>
<body>
<h2>Student: ${name}</h2>
<p>Caste: ${caste}</p>
<p>NEET Marks: ${neetMarks}</p>
<p>Status: ${eligibility}</p>
</body>
</html>

Deployment and Testing

Package as WAR and deploy to Tomcat.
Access:

http://localhost:8080/SpringMVCMedicalSeatAvailabilityBasedOnNEETMarks/

After clicking the link, we will get output as below:

Check for the url change. All should be aligned with controller

Usecase:

Enter student name to check eligibility.

According to the logic written, we are getting results, here:

Geek1 is the name given for the search. It will be checked against the "studentsdetails" table
Circled one indicates the name of the request mapping.

Advantages of This Integration

Provides a data-driven web application architecture.
Uses Spring MVC for clean separation of concerns.
Leverages JdbcTemplate for simplified database operations.
Flexible for adding new features like CRUD or advanced queries.

priyarajtt

Improve

Article Tags :

Spring MVC Integration with MySQL

Database Setup

Step 1: Create the Database

2. Create the Table

3. Insert Sample Records

4. Verify Records

Spring MVC Application Setup

Project Structure:

Step 1: Maven Dependencies (pom.xml)

Step 2: Spring Configuration (spring-servlet.xml)

Student.java (Bean Class)

StudentDao.java (DAO Class)

Controller Class (StudentController.java)

JSP Views

1. studentsearchform.jsp

2. welcome.jsp

Deployment and Testing

Usecase:

Advantages of This Integration

Explore

Java Enterprise Edition

Multithreading

Concurrency

JDBC (Java Database Connectivity)

Java Frameworks

JUnit

Thank You!

What kind of Experience do you want to share?

Controller Class (`StudentController.java`)