Healthcare

PKU Management System

A comprehensive healthcare management solution for handling patient lifecycles, appointments, and staff records securely.

Java JSP/Servlets MySQL
View Code
Project Type Java App
My Role Backend Developer
Timeline October 2024 - Dec 2024
Status Archived

Overview

The PKU Management System is designed to digitize and streamline the administrative workflows of a healthcare facility. It transitions paper-based record keeping into a secure, centralized database architecture accessible via a web interface.

Key Features

Patient Management

Digital onboarding, continuous medical history tracking, and demographic record keeping stored securely.

Appointments

Calendar integration for booking, modifying, and tracking patient appointments with specific doctors.

Billing & Invoicing

Integrated financial modules for generating bills based on treatments and consultations.

Role-Based Access Control

Access boundaries are organized around receptionist, doctor, and administrator roles, limiting each role to the data and workflows it needs.

System Architecture Pipeline

Role-based healthcare operational flow routing administrative intake, clinical care, and transactional invoicing through secure servlet controllers to normalized clinical storage.

Clinical Operations & Billing Pipeline

Java 17 JSP & Servlets MySQL 8.0 Session Security Tomcat
01 / Clinical Actors
Receptionist Patient intake, registration & doctor appointment queue Front Desk Portal
Medical Doctor Clinical examination, diagnostic history & prescription entry Consultation Room
Clinic Admin Billing audits, staff privilege oversight & analytics Executive Audit
02 / Presentation
Role-Gated JSP Views Strict privilege boundary rendering across staff portals JSTL Templates
Session Guard Filter Interception filter preventing unauthorized URL escalation HTTP Servlet Filter
03 / App Dispatcher
Servlet Controllers Patient record dispatching & appointment state machines Java Servlets
Billing Ledger Engine Multi-item treatment, consultation & medication invoice calculation Atomic Ledger
04 / Relational Store
MySQL Healthcare DB Relational patient records, medical visits & invoices ACID Compliant
Referential Integrity Foreign key cascading safeguards preventing orphan records 3NF Integrity Guard
Privilege Model Role Separation (RBAC) Distinct view trees and authorization boundaries for Doctors, Staff & Admin
Record Integrity Relational Consistency Foreign key enforcement preserving clinical consultations & histories
Financial Engine Atomic Multi-Line Billing Direct itemized tallying of medicines, tests, and consultation tariffs
Container Runtime Apache Tomcat Deployment High-throughput connection-pooled servlet execution container