Hospital Management System – Java + Swing UI + JDBC + SQLite

Build a simple and complete Hospital Management System desktop application using Java 17, Java Swing, JDBC and SQLite.

This project is specially designed for BCA, BSc, BTech, B.E. and other Computer Science / Computer Engineering students who need a ready-to-run Java desktop mini project for learning, practical work and academic demonstration.

🚀 Project Features

• Admin Login
• Dashboard
• Patient Registration
• Add Patient
• Update Patient
• Delete Patient
• Auto-generated Patient ID
• Patient Record Management
• Doctor Management
• Add Doctor
• Update Doctor
• Delete Doctor
• Doctor Specialization
• Department Selection
• Prescription Management
• Search Patient by Name or Patient ID
• Select Doctor
• Add Multiple Medicines to Prescription
• Medicine Frequency
• Medicine Duration
• Prescription History
• Pharmacy Module
• Search Patient Prescription
• Medicine Management
• Add Medicine
• Update Medicine
• Delete Medicine
• View Database
• Delete Selected Database Records
• Reports
• All Patients Report
• All Doctors Report
• Today's Visits Report
• All Visits Report
• Prescription History Report
• Input Validation
• SQLite Database
• Data Persistence
• JDBC Database Connectivity
• Transaction & Rollback Handling

🛠 Technologies Used

• Java 17
• Java Swing
• JDBC
• SQLite
• IntelliJ IDEA
• SQLite JDBC Driver

📦 What You Will Get

The ZIP package includes:

• Complete Java source code
• Project files
• SQLite database support
• SQLite JDBC Driver
• All required Java classes
• Login Module
• Dashboard
• Patient Management Module
• Doctor Management Module
• Prescription Module
• Pharmacy Module
• Medicine Management Module
• Database Viewer
• Reports Module

📚 Documentation Included

The package also includes documentation to help students understand, run and present the project:

• How to Run Guide PDF
• Project Report PDF
• PPT Presentation Content PDF
• Viva Questions & Answers PDF

The documentation is prepared in a simple format so students can easily understand the project flow and prepare for their college presentation and viva.

💻 Easy to Run

The project uses SQLite, so you do not need to install or configure a separate MySQL database server.

Simply extract the ZIP, open the project in IntelliJ IDEA, configure Java 17, add the SQLite JDBC driver if required, and run:

Main.java

The SQLite database file hospital.db is automatically created and initialized when the application starts.

🔐 Default Login

Username: admin

Password: admin123

Use these credentials to access the application during demonstration.

🏥 Project Workflow

The basic application flow is:

Login → Dashboard → Patient Registration → Doctor Management → Prescription → Pharmacy → Reports / Database

A registered patient can be selected while creating a prescription. The prescription stores the selected doctor, medicines, frequency and duration. The pharmacy module can then display prescription details for the selected patient.

🎓 Suitable For

This project is suitable for:

• BCA Mini Project
• BSc Computer Science Project
• BSc IT Project
• BTech Mini Project
• B.E. Computer Engineering Project
• Computer Science Practical Project
• Java Desktop Application Project
• JDBC & Database Project
• SQLite Database Project
• College Mini Project
• Academic Demonstration Project

⭐ Why This Project?

• Simple Java-based desktop application
• Easy-to-understand technology stack
• Java 17 based project
• User-friendly Swing interface
• Lightweight SQLite database
• No separate MySQL server required
• Complete CRUD operations
• Patient and doctor management
• Prescription and medicine management
• Pharmacy-related prescription viewing
• Reports included
• Database viewer included
• Documentation included
• Viva preparation included

📖 What Students Can Learn

By studying this project, students can understand:

• Java OOP concepts
• Java Swing GUI development
• JFrame, JTable, JComboBox and other Swing components
• JDBC database connectivity
• SQLite database management
• CRUD operations
• SQL queries
• Primary Keys and Foreign Keys
• Database relationships
• Input validation
• Transactions and rollback
• Modular Java application development

⚠️ Important Note

This is an educational/college project intended for learning, demonstration, practical work and academic purposes.

Students can study and customize the project according to their college requirements, project guidelines and learning objectives.

This project is not intended to replace a production-level hospital management system or be used for real clinical operations without further development, testing, security and compliance work.

📌 Project Summary

Project: Hospital Management System

Platform: Desktop Application

Language: Java 17

GUI: Java Swing

Database: SQLite

Connectivity: JDBC

IDE: IntelliJ IDEA

Download the ZIP, follow the How to Run Guide, run the project and explore the complete Hospital Management System.

🔎 Keywords

Hospital Management System, Hospital Management Project, Java Hospital Management System, Java Swing Project, Java 17 Project, JDBC Project, SQLite Project, Java Desktop Application, BCA Project, BSc Computer Science Project, BSc IT Project, BTech Project, BE Computer Engineering Project, College Mini Project, Hospital Project, Patient Management System, Doctor Management System, Prescription Management System, Pharmacy Management System, Medicine Management System, Java JDBC SQLite, College Project Source Code, Java Mini Project, Computer Science Project