Student Management System (Java Swing + MySQL)

Project Overview

A full CRUD (Create, Read, Update, Delete) application built with Java Swing and MySQL. This application allows users to manage student records (ID, Name, Mobile Number) with a graphical interface.

Developed as part of the ITJVA2-12 module at Eduvos.

Features

• Add Student: Insert new student records into the database.
• View Students: Display all students currently in the database.
• Search Student: Find a specific student by their ID.
• Delete Student: Remove a student record permanently.
• Database Integration: Connects to a local MySQL database using JDBC.

Screenshots

Add Student:

View All Students:

Search Student by ID:

Delete Student:

Prerequisites

• MySQL Server installed and running.
• MySQL Workbench (or similar tool) to create the database.
• Java JDK (version 8 or higher).
• Maven (for dependency management).

Setup Instructions

1. Open MySQL Workbench and run the following commands:

   CREATE DATABASE studentManage;
   USE studentManage;
   CREATE TABLE students (
       id VARCHAR(20) PRIMARY KEY,
       name VARCHAR(100),
       number VARCHAR(20)
   );

2. In the Java file (StManagementSyst.java), update the MySQL password on line 22 if yours is not obakeng.

3. Open the project in NetBeans and run StManagementSyst.java.

How to Run

Ensure your MySQL server is running.

Compile and run the project in NetBeans.

Use the GUI to Add, View, Search, or Delete students.

Author

Kamogelo Phale