🏅 Student Management Information System (MIS) with Java and IntelliJ 🏅

🎯 Project Overview

This project focuses on developing a Student Management Information System (MIS) using Java with the IntelliJ IDE. The system uses a MySQL database to handle CRUD operations (Create, Read, Update, Delete) for managing student data. It also features a user-friendly GUI developed using Java Swing.

Key Features

Java Swing GUI: A graphical user interface designed using Java Swing within IntelliJ.
MySQL Integration: Connects to a MySQL database to handle student data.
LGoodDatePicker Integration: Implements LGoodDatePicker to enhance date selection in the GUI.
CRUD Operations: Enables users to perform Create, Read, Update, and Delete operations on student records.
Error Handling: Implements error handling with try-catch blocks to ensure smooth operation.

💪 Installation Guide

Follow these steps to set up and run the project:

Download MySQL Connector/J:
- Ensure that you have the MySQL Connector/J library for Java.
Download LGoodDatePicker:
- Include the LGoodDatePicker library in your project dependencies for advanced date handling.
Import into IntelliJ:
- Import the project into IntelliJ by setting up the project structure and adding necessary dependencies.
MySQL Database Setup:
- Import the provided MySQL database script into your MySQL server.
Run the Project:
- Execute the project via the IntelliJ GUI.

🏹 MySQL Scripting

The following script creates the necessary database and tables for the Student Management Information System:

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 02, 2024 at 12:45 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

-- Database: `java_activity_1`

-- Table structure for table `gender`
CREATE TABLE `gender` (
  `id` int(11) NOT NULL,
  `gender_name` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Insert data into `gender`
INSERT INTO `gender` (`id`, `gender_name`) VALUES
(1, 'Male'),
(2, 'Female'),
(3, 'Other');

-- Table structure for table `student`
CREATE TABLE `student` (
  `id` int(11) NOT NULL,
  `name_latin` varchar(200) NOT NULL,
  `name_khmer` varchar(200) NOT NULL,
  `gender_id` int(11) NOT NULL,
  `date_of_birth` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- Insert data into `student`
INSERT INTO `student` (`id`, `name_latin`, `name_khmer`, `gender_id`, `date_of_birth`) VALUES
(2, 'Jane Smith', 'ជាន ស្មិច', 2, '2001-02-20'),
(3, 'Alex Kim', 'អាលិច គីម', 3, '1999-05-30'),
(4, 'Test User', 'តេស', 1, '2024-08-08');

-- Indexes and constraints
ALTER TABLE `gender`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `student`
  ADD PRIMARY KEY (`id`),
  ADD KEY `gender_id` (`gender_id`);

ALTER TABLE `gender`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

ALTER TABLE `student`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

ALTER TABLE `student`
  ADD CONSTRAINT `student_ibfk_1` FOREIGN KEY (`gender_id`) REFERENCES `gender` (`id`);

COMMIT;

🔯 Demo

✍️ Citation

@misc{java_intellij_mis,
  author = {SOY TET},
  title = {Student Management Information System (MIS) with Java and IntelliJ},
  year = {2024},
  publisher = {GitHub},
  journal = {GitHub repository}
}