V3I11P12

Design and Implementation of a Web-Based Medicine Reminder System Using Spring Boot, JPA/Hibernate and MySQL for Medication Adherence Support

M. Elakkiya1*, S. Bhuvaneshwari2, D. Gopika3, V. Bharathapriya4

Abstract

Missed and delayed doses are a leading cause of reduced treatment effectiveness in long-term therapy. This paper presents the design, implementation and functional verification of a web-based Medicine Reminder System that helps users register, record medicine details (name, disease, dosage, type, start/end date, daily time and expiry date), receive time-triggered reminders with AM/PM scheduling, and keep a history of doses marked as taken, skipped or missed. The system follows a layered client–server architecture: an HTML/CSS/JavaScript front end communicates through REST APIs with a Spring Boot back end, which persists data in MySQL through Spring Data JPA and Hibernate. A four-table relational schema (User, Medicine, Schedule, Medication History) and a three-level data flow model are described. The implementation was exercised with unit, integration, functional, validation and user-acceptance test designs, and its working screens and start-up behaviour are reported. The dashboard computes per-user indicators such as total medicines, doses taken, doses missed and an adherence percentage, and flags medicines approaching expiry. Limitations of the current browser-based reminder mechanism are discussed, together with a roadmap towards push notifications, automatic missed-dose marking, caregiver alerts and security hardening.

Keywords:

Medication adherence; Medicine reminder; mHealth; Spring Boot; REST API; JPA/Hibernate; MySQL; Web application