jdbc-connectivity-student

Project Structure

student-management-system/  
│
├── src/
│   └── main/
│       ├── java/  
│       │   └── com/
│       │       └── example/
│       │           └── studentmanagement/
│       │               ├── controller/
│       │               │   └── StudentController.java   # Handles HTTP requests
│       │               │
│       │               ├── model/
│       │               │   └── Student.java             # Entity representing Student
│       │               │
│       │               ├── repository/
│       │               │   └── StudentRepository.java   # Interface extending JpaRepository
│       │               │
│       │               ├── service/
│       │               │   ├── studentService.java      # Interface defining business logic
│       │               │   └── ConnectioService.java/
│       │               │       └── StudentServiceImpl.java # Service implementation
│       │               │
│       │               └── StudentManagementSystemApplication.java  # Main application class
│       │
│       └── resources/
│           ├── application.properties   # Application config (DB details, etc.)
│           └── data.sql                 # Sample data (optional)
│
└── pom.xml                              # Maven build file

Technical Details

In this project, we are going to use below set of versions for demonstrations.

Spring Boot - 3.3.4
Spring - 6.1.12
Lombok - 1.18.34

Building

The example can be built with

mvn clean install

Running the example in your local

mvn clean spring-boot:run

mysql Database

CREATE TABLE student1.student (
  studentId INT NOT NULL,
  studentName VARCHAR(45) NULL,
  studentAddress VARCHAR(45) NULL,
  PRIMARY KEY (studentId));

select table

SELECT * FROM student1.student;

Project Screen

mysql db Screen