Clinic-Management-System-Java-Servlet-MySQL

Developer

Name: Shwet Patel
Git-Hub: https://github.com/ShwetIsHere Linked In: https://www.linkedin.com/in/shwetishere/ Email: contactshwetishere@gmail.com

A comprehensive Java web application designed to streamline clinic operations including patient management, doctor handling, appointment scheduling, medical records, billing, and staff payroll. Built using Servlets, JSP, JDBC, and deployed on GlassFish Server 4.1.

Technologies Used

• Front-End: HTML5, CSS3, Bootstrap (extension is .jsp)
• Database: MySQL
• Libraries: gson-2.8.9.jar, jstl-l .2.jar, mysql-connector-j-9.0.0.jar
• Server: GlassFish Server 4.1
• IDE: Apache NetBeans

Just make sure this jar file must be in lib folder

• gson-2.8.9.jar
• jstl-l .2.jar
• mysql-connector-j-9.0.0.jar

---

Instruction for run this Project

when you run this project so database and all required SQL table will be created automatically from Back-End so you don't have to create sql table manually and here database name is 'medicare'. you can check all tabel from DatabaseConnection.java which is in storage package. replaced you MySQL password and Unser-name with this line-25,26 (stoarge.DatabaseConnection.java):

• private static final String DB_USER = "YOUR_USERNAME";
• private static final String DB_PASSWORD = "YOUR_PASSWORD";

and if you want to change database name you have to replaced you database name to medicare in this line-22 (stoarge.DatabaseConnection.java):

• private static final String DB_NAME = "YOUR_DATABASE_NAME";

and before every modification, you have to do clean and build project.

Key Features

• Patient, doctor, and staff registration
• Medical record tracking and viewing
• Appointment scheduling and status management
• Prescription handling
• Billing and revenue dashboard with graphs
• Staff salary disbursement
• Error handling with a custom error page
• Role-based dashboards for doctors, patients, and staff

For check, I add few hard coded data in database when you run project at first time.

---

JSP Pages Overview

JSP Page	Description
index.jsp	Landing page (Home)
aboutus.jsp	About Medicare clinic
appointment.jsp	Appointment request form
appointmenttable.jsp	Manage appointments (Pending, Done, Cancelled)
billing.jsp	Bill creation form
combill.jsp	Complete pending payments
allmedicalrecord.jsp	View all patients’ medical status with search
medicalrecord.jsp	View individual patient medical report
prescription.jsp	Add new prescription
patient.jsp	Register a new patient
patient-update.jsp	Update patient information
patient-dashboard.jsp	Dashboard view for a patient
patientcard.jsp	List of all registered patients (cards)
doctor.jsp	Add new doctor
doctor-update.jsp	Update doctor details
doctor-dashboard.jsp	Dashboard view for a doctor
doctorcard.jsp	List of all doctors (cards)
staff.jsp	Register new staff
staff-update.jsp	Update staff details
staff-dashboard.jsp	Dashboard view for staff
staff-payroll.jsp	Pay staff salary
staffcard.jsp	List of all staff (cards)
finance.jsp	Revenue dashboard with graphs
error.jsp	Generic error handler page

servlet page is for collect data from JSP amd model package is for storing data in MySQL database