Student Management System

This Java-based Student Management System allows you to manage student records with functionalities to add, list, search, update, and delete student details. The system interacts with a MySQL database to store and retrieve student information.

Features

• Add Student: Add new students to the system with details like student ID, name, birthday, and email.
• List Students: Display a list of all students in the system.
• Search Student: Search for a student by name.
• Update Student: Update details of an existing student by entering their student ID.
• Delete Student: Remove a student from the system by entering their student ID.
• Exit: Terminate the application.

Prerequisites

• Java Development Kit (JDK) 8 or higher
• MySQL Server
• MySQL Connector/J

Database Setup

1. Install MySQL and start the MySQL server.
2. Create a database named student_management.
3. Create a students table with the following SQL script:

CREATE DATABASE student_management;

USE student_management;

CREATE TABLE students (
    student_id INT PRIMARY KEY,
    name VARCHAR(100),
    birthday DATE,
    email VARCHAR(100)
);

Getting Started

1- Clone the repository:

git clone https://github.com/yourusername/student-management-system.git
cd student-management-system

2- Configure the database connection:

• Open the StudentManagementSystem.java file.
• Update the URL, USER and PASSWORD variables with your MySQL database connection details:

private static final String URL = "jdbc:mysql://localhost:3306/student_management";
private static final String USER = "root";
private static final String PASSWORD = "YourPassword";

3- Add MySQL Connector/J to the project:

• Download the MySQL Connector/J from the official MySQL website.
• Add the JAR file to your project's build path.

4- Compile and run the application:

javac StudentManagementSystem.java Student.java
java StudentManagementSystem

Usage

Upon running the application (StudentManagementSystem.java), a menu will display with options to add, list, search, update, or delete student records. You can add a new student by entering their details, list all existing students, search for a student by name, update their information, delete a student by ID, or exit the application. Follow the on-screen prompts for each operation.

Input Validations and Error Handling

• Student ID:

  • Must be a numeric value.
  • The system checks for duplicate IDs to ensure each student has a unique ID.
  • Error message: "Please enter a valid numeric student ID."

• Name:

  • Must contain only letters and spaces.
  • Error message: "Invalid name. Name can only contain letters and spaces."

• Birthday:

  • Must be in the format YYYY-MM-DD.
  • Error message: "Invalid date format. Please enter the birthday in YYYY-MM-DD format."

• Email:

  • Must contain '@' and '.' to be considered valid.
  • Error message: "Invalid email. Please enter a valid email address."

• General Error Handling:

  • SQL exceptions are caught and displayed to the user with relevant messages.
  • Input mismatch exceptions are handled to prompt the user for correct input types.

🛠 Skills

MySQL, Java Programming & OOP

Connect with me: