Student Management System with JDBC & MySQL

Overview

This project is an upgraded version of my previous Student Management System project. While the earlier project focused only on basic CRUD operations using Java, this version integrates JDBC and MySQL Database Connectivity to store and manage student records permanently.

The application is a console-based system developed using Java, JDBC, and MySQL, allowing users to perform real-time database operations efficiently.

What's New in This Version?

• Database Integration using JDBC
• MySQL Connectivity
• Persistent Data Storage
• Real-Time CRUD Operations on Database
• Improved Backend Logic

Technologies Used

• Java
• JDBC
• MySQL
• IntelliJ IDEA

Features

• Add Student Records
• View All Students
• Search Student by ID
• Update Student Information
• Delete Student Records
• Database Connectivity with MySQL
• Console-Based User Interface

Project Structure

src/
│
├── StudentT3.java
├── StudentDAO.java
├── DBConnection.java
└── StudentAppT3.java

Database Setup

Create Database

CREATE DATABASE studentdb;

Select Database

USE studentdb;

Create Table

CREATE TABLE students (
    id INT PRIMARY KEY,
    name VARCHAR(100),
    age INT
);

---

JDBC Configuration

Update your MySQL credentials inside DBConnection.java:

private static final String URL =
        "jdbc:mysql://localhost:3306/studentdb";

private static final String USER = "root";

private static final String PASSWORD = "your_password";

---

How to Run

1. Install MySQL Server and MySQL Workbench
2. Create the database and table
3. Add MySQL Connector JAR to IntelliJ
4. Configure database credentials
5. Run StudentAppT3.java
6. Use the console menu for operations

Functionalities

• Insert student details into MySQL database
• Retrieve and display student records
• Search records using Student ID
• Update existing student information
• Delete records from database

Learning Outcomes

Through this project, I learned:

• JDBC database connectivity
• MySQL integration with Java
• CRUD operations using SQL queries
• PreparedStatement usage
• Exception handling
• Backend data management

Project Evolution

Previous Project

• Basic Java CRUD operations
• Temporary data handling
• No database connectivity

Current Project

• Integrated MySQL Database
• Persistent data storage
• JDBC connectivity
• Real-world database operations

Future Improvements

• GUI using Java Swing or JavaFX
• User Login Authentication
• Advanced Search Features
• Export Student Reports
• REST API Integration

Author

Developed as part of Java learning and internship practice.