Hospital Management System

A comprehensive desktop application for managing hospital operations including patient records, doctor appointments, diagnoses, and prescriptions built with Java Swing and MySQL.

📋 Table of Contents

Overview
Features
Screenshots
Technologies Used
System Architecture
Database Schema
Installation
Usage
User Roles
Future Enhancements
Contributing
License
Contact

🎯 Overview

The Hospital Management System is a desktop application designed to streamline hospital operations and improve healthcare service delivery. Built using Java Swing for the GUI and MySQL for database management, this system provides a complete solution for managing patients, doctors, appointments, and medical records.

Key Highlights

🏥 Comprehensive Management: Handles patients, doctors, appointments, and medical records
👥 Multi-User Support: Different access levels for doctors, receptionists, and patients
🔐 Secure Authentication: User login system with role-based access control
💾 Persistent Storage: MySQL database for reliable data management
🖥️ User-Friendly Interface: Intuitive GUI built with Java Swing

✨ Features

1. User Management

✅ User registration and authentication
✅ Role-based access (Doctor, Receptionist, Patient)
✅ Secure password handling
✅ User profile management

2. Patient Management

✅ Add new patient records
✅ Edit existing patient information
✅ Remove patient records
✅ Search and filter patients
✅ View patient medical history
✅ Store diagnosis and prescription information

3. Doctor Management

✅ Add doctor profiles
✅ Update doctor information
✅ Assign doctors to rooms
✅ Manage doctor contact information
✅ View doctor schedules

4. Appointment Management

✅ Schedule appointments
✅ Assign patients to doctors
✅ Room allocation
✅ Appointment tracking
✅ Edit and cancel appointments
✅ Search appointments by patient name

5. Diagnosis & Prescription

✅ Record patient diagnoses
✅ Create prescriptions
✅ Update medical records
✅ Track treatment history

6. Reporting

✅ Generate patient reports
✅ View appointment history
✅ Track doctor-patient relationships

📸 Screenshots

Login Screen

Main Dashboard

Patient Management

Appointment Scheduling

Diagnosis & Prescription

🛠️ Technologies Used

Frontend

Java Swing: GUI framework for desktop application
NetBeans Form Designer: Visual form designer for UI components

Backend

Java SE: Core Java for application logic
JDBC: Database connectivity
MySQL Connector/J: MySQL driver for Java

Database

MySQL: Relational database management system

Tools

Apache NetBeans: Integrated Development Environment (IDE)
MySQL Workbench: Database design and management

🏗️ System Architecture

┌─────────────────────────────────────────┐
│         Presentation Layer              │
│  (Java Swing GUI Forms)                 │
│  - Login Form                           │
│  - Main Form                            │
│  - Patient Management Forms             │
│  - Appointment Forms                    │
│  - Diagnosis Forms                      │
└────────────────┬────────────────────────┘
                 │
┌────────────────▼────────────────────────┐
│         Business Logic Layer            │
│  (Java Classes)                         │
│  - Patients.java                        │
│  - Doctors.java                         │
│  - Appointments.java                    │
│  - create_user.java                     │
│  - DiagANDpres.java                     │
└────────────────┬────────────────────────┘
                 │
┌────────────────▼────────────────────────┐
│         Data Access Layer               │
│  - MyConnection.java (JDBC)             │
└────────────────┬────────────────────────┘
                 │
┌────────────────▼────────────────────────┐
│         Database Layer                  │
│  (MySQL Database)                       │
│  - Tables: patient, doctor,             │
│    appointment, create_user, etc.       │
└─────────────────────────────────────────┘

🗄️ Database Schema

Main Tables

1. patient Table

CREATE TABLE patient (
    ID INT PRIMARY KEY AUTO_INCREMENT,
    `Full Name` VARCHAR(100),
    `Phone.no` VARCHAR(20),
    `E-mail` VARCHAR(100),
    Complain TEXT,
    Diagnosis TEXT,
    Prescription TEXT
);

2. specification (Doctors) Table

CREATE TABLE specification (
    ID INT PRIMARY KEY AUTO_INCREMENT,
    `Doctor Name` VARCHAR(100),
    `Phone Number` VARCHAR(20),
    `Room Number` VARCHAR(10)
);

3. appointment Table

CREATE TABLE appointment (
    `Appointment no.` INT PRIMARY KEY AUTO_INCREMENT,
    `Doctor Name` VARCHAR(100),
    `Patient Name` VARCHAR(100),
    `Room no.` INT,
    FOREIGN KEY (`Doctor Name`) REFERENCES specification(ID) ON DELETE CASCADE,
    FOREIGN KEY (`Patient Name`) REFERENCES patient(ID) ON DELETE CASCADE
);

4. create_user Table

CREATE TABLE create_user (
    ID INT PRIMARY KEY AUTO_INCREMENT,
    `Full Name` VARCHAR(100),
    Username VARCHAR(50) UNIQUE,
    Password VARCHAR(100),
    Type ENUM('Doctor', 'Receptionist', 'Patient')
);

🚀 Installation

Prerequisites

Before you begin, ensure you have the following installed:

✅ Java Development Kit (JDK) 8 or higher
- Download from: https://www.oracle.com/java/technologies/downloads/
✅ MySQL Server 5.7 or higher
- Download from: https://dev.mysql.com/downloads/
✅ Apache NetBeans IDE (recommended) or any Java IDE
- Download from: https://netbeans.apache.org/download/
✅ MySQL Connector/J (JDBC Driver)
- Download from: https://dev.mysql.com/downloads/connector/j/

Step 1: Clone the Repository

git clone https://github.com/YOUR_USERNAME/hospital-management-system.git
cd hospital-management-system

Step 2: Set Up MySQL Database

Start MySQL Server

# On Windows
net start MySQL80

# On macOS/Linux
sudo service mysql start

Create Database
```
mysql -u root -p
```

Run the following SQL commands:

CREATE DATABASE hospital_db;
USE hospital_db;

-- Run the SQL script provided in database/schema.sql
SOURCE database/schema.sql;

Or manually create tables using the schema in Database Schema

Step 3: Configure Database Connection

Locate MyConnection.java in the src/hospitalmanagement/ folder

Update the database credentials:

public class MyConnection {
    private String url = "jdbc:mysql://localhost:3306/hospital_db";
    private String username = "root";  // Change to your MySQL username
    private String password = "your_password";  // Change to your MySQL password
    
    // Rest of the code...
}

Step 4: Add MySQL Connector to Project

Using NetBeans:

Right-click on Libraries in the project tree
Select Add JAR/Folder
Navigate to where you downloaded mysql-connector-j-x.x.x.jar
Select and add it

Using Command Line:

# Place mysql-connector-j.jar in lib/ folder
cp path/to/mysql-connector-j-x.x.x.jar lib/

Step 5: Build and Run

Using NetBeans:

Open the project in NetBeans
Right-click on the project
Select Clean and Build
Right-click again and select Run

Using Command Line:

# Compile
javac -cp "lib/*" -d build/classes src/hospitalmanagement/*.java

# Run
java -cp "build/classes:lib/*" hospitalmanagement.Hospital_Front_Form

💻 Usage

First Time Setup

Launch the application
- Run Hospital_Front_Form.java
Create a user account
- Click "Signup"
- Enter your details
- Select user type (Doctor/Receptionist/Patient)
- Create username and password
Login
- Click "Login"
- Enter your credentials
- Select your user type
- Click "Enter"

Using the System

For Receptionists:

Add New Patients
- Navigate to Patient Management
- Click "Add Patient"
- Fill in patient details
- Save
Schedule Appointments
- Go to Appointment Management
- Select patient and doctor
- Assign room
- Schedule appointment

For Doctors:

View Patient Information
- Access patient records
- Review medical history
Add Diagnosis and Prescription
- Open patient record
- Enter diagnosis
- Write prescription
- Save changes

For Patients:

View Appointments
- Check scheduled appointments
- View assigned doctor
- See room number
Update Personal Information
- Edit contact details
- Update complaints

👥 User Roles

1. Receptionist

Manage patient registration
Schedule appointments
View all appointments
Manage doctor information

2. Doctor

View assigned patients
Add diagnoses and prescriptions
Review patient medical history
Manage appointment schedule

3. Patient

View personal information
Check appointments
View diagnoses and prescriptions
Update contact information

📦 Project Structure

hospital-management-system/
│
├── src/
│   └── hospitalmanagement/
│       ├── Appointments.java              # Appointment management
│       ├── Appoinyment_Table.java         # Appointment viewing
│       ├── create_user.java               # User registration
│       ├── DiagANDpres.java               # Diagnosis & prescription logic
│       ├── Diagnosis_prescription.java    # Diagnosis form UI
│       ├── Doctors.java                   # Doctor management
│       ├── Fllin.java                     # Patient form filling
│       ├── Hospital_Front_Form.java       # Landing page
│       ├── HospitalManagement.java        # Main application entry
│       ├── Login.java                     # Login form
│       ├── MainForm.java                  # Main dashboard
│       ├── ManageAppointments.java        # Appointment management UI
│       ├── MyConnection.java              # Database connection (YOU NEED TO CREATE THIS)
│       ├── Patients.java                  # Patient management (YOU NEED TO CREATE THIS)
│       ├── User_Creation.java             # User creation form (YOU NEED TO CREATE THIS)
│       │
│       └── *.form                         # NetBeans form files
│
├── lib/
│   └── mysql-connector-j-x.x.x.jar        # MySQL JDBC driver
│
├── database/
│   └── schema.sql                         # Database schema
│
├── images/
│   ├── banner.png
│   └── logo.png
│
├── screenshots/
│   ├── login.png
│   ├── dashboard.png
│   └── ...
│
├── README.md
├── LICENSE
└── .gitignore

🔮 Future Enhancements

🤝 Contributing

Contributions are welcome! Please feel free to submit a Pull Request.

How to Contribute

Fork the repository
```
# Click the "Fork" button on GitHub
```

Clone your fork

git clone https://github.com/YOUR_USERNAME/hospital-management-system.git

Create a feature branch
```
git checkout -b feature/AmazingFeature
```
Make your changes and commit
```
git commit -m "Add some AmazingFeature"
```
Push to your fork
```
git push origin feature/AmazingFeature
```
Open a Pull Request

Contribution Guidelines

Follow Java naming conventions
Add comments to your code
Update README if adding new features
Test your changes thoroughly
Follow the existing code style

📝 License

This project is licensed under the MIT License - see the LICENSE file for details.

👤 Contact

Aya Abdel Moniem

📧 Email: Aya.abdelmoniem.afattah@gmail.com
💼 LinkedIn: linkedin.com/in/aya-abdel-moniem-737552214
🐙 GitHub: @YOUR_USERNAME
🌐 Portfolio: [Your Portfolio Website]

🙏 Acknowledgments

NetBeans IDE for the powerful development environment
MySQL for reliable database management
Java Swing for GUI components
The British University in Egypt for academic support

📊 Project Status

⚠️ Disclaimer

This is an educational project developed for learning purposes. While it demonstrates key concepts of hospital management systems, it should not be used in production medical environments without proper security audits, compliance checks, and professional validation.

For Medical Use: Consult with healthcare IT professionals and ensure compliance with HIPAA, GDPR, or other relevant healthcare data regulations in your region.

Made with ❤️ by Aya Abdel Moniem

_{A comprehensive hospital management solution for modern healthcare}

FilesExpand file tree

Hospital_README.md

Latest commit

History

Hospital_README.md

File metadata and controls

Hospital Management System

📋 Table of Contents

🎯 Overview

Key Highlights

✨ Features

1. User Management

2. Patient Management

3. Doctor Management

4. Appointment Management

5. Diagnosis & Prescription

6. Reporting

📸 Screenshots

Login Screen

Main Dashboard

Patient Management

Appointment Scheduling

Diagnosis & Prescription

🛠️ Technologies Used

Frontend

Backend

Database

Tools

🏗️ System Architecture

🗄️ Database Schema

Main Tables

1. patient Table

2. specification (Doctors) Table

3. appointment Table

4. create_user Table

🚀 Installation

Prerequisites

Step 1: Clone the Repository

Step 2: Set Up MySQL Database

Step 3: Configure Database Connection

Step 4: Add MySQL Connector to Project

Using NetBeans:

Using Command Line:

Step 5: Build and Run

Using NetBeans:

Using Command Line:

💻 Usage

First Time Setup

Using the System

For Receptionists:

For Doctors:

For Patients:

👥 User Roles

1. Receptionist

2. Doctor

3. Patient

📦 Project Structure

🔮 Future Enhancements

🤝 Contributing

How to Contribute

Contribution Guidelines

📝 License

👤 Contact

🙏 Acknowledgments

📊 Project Status

⚠️ Disclaimer