Pharmacy Management System
Admin appointment booking system with MySQL database integration
Desktop (Java)
Platform
MySQL
Database
MVC
Pattern
Admin-Only
Access
The Problem
Small clinics and pharmacies rely on paper-based or spreadsheet records for managing appointments, leading to scheduling conflicts, lost patient records, and inefficient daily operations.
The Solution
An admin-use-only system designed to streamline the scheduling and management of doctor appointments. Built using Java in Eclipse IDE, with all doctor and patient data managed directly in a MySQL database for secure and centralized record-keeping.
System Architecture
Desktop application built with Java Swing for the UI layer, connected to a MySQL database via MySQL Connector/J (JDBC). The system follows a traditional MVC pattern — Java handles business logic and UI rendering, while MySQL stores and manages all persistent data for doctors, patients, and appointments.
Key Features
Book appointments based on doctor availability
Update or delete existing appointments
View all appointment records with filtering
Direct MySQL data management for doctors and patients
Secure admin-only access control
Centralized database for all clinic records
My Role
Sole developer — designed the database schema, built the Java Swing interface, and implemented the appointment management logic.