A modern web-based Pharmacy Management System built using Java, Servlet, JSP, and MySQL to digitally manage pharmacy operations such as medicine inventory, billing, and stock tracking.
The system replaces traditional manual registers with an efficient digital workflow, helping pharmacy staff manage medicines, track stock levels, and generate bills quickly and accurately.
⚠️ This project is developed for learning, demonstration, and academic purposes.
- Add new medicines
- Update medicine details
- Delete medicines
- Manage medicine categories
- Track manufacturer and batch details
- Real-time stock tracking
- Low stock detection
- Expiry date monitoring
- Prevent negative stock during billing
- Generate pharmacy bills
- Automatic GST calculation
- Patient information support
- Bill history tracking
- Invoice print support
- Total medicines count
- Low stock alerts
- Total bills
- Daily sales overview
- Search medicines instantly
- View detailed medicine inventory
- Manage stock efficiently
- Secure login system
- Session management
- Admin / Staff access
Displays pharmacy overview including medicine inventory, low stock alerts, and daily sales statistics.
View all medicines with details such as:
- Medicine Name
- Type
- Manufacturer
- Batch Number
- Expiry Date
- Price
- GST
- Stock Quantity
Add new medicines with:
- Manufacturer
- Batch Number
- Expiry Date
- Unit Price
- GST Percentage
- Stock Quantity
Generate medicine bills with:
- Patient details
- Medicine selection
- Quantity calculation
- GST calculation
- Automatic bill summary
Generate a clean printable invoice including:
- Pharmacy details
- Patient information
- Medicine list
- GST breakdown
- Grand total
The system allows pharmacy staff to:
- Maintain medicine inventory
- Track stock availability
- Process medicine sales
- Generate invoices
- Store billing records
It is designed to be simple, fast, and easy to use, making it ideal for small pharmacies and academic demonstrations.
- Java
- Servlet
- JSP
- JDBC
- HTML
- CSS
- JavaScript
- MySQL
- Apache Tomcat
MVC (Model – View – Controller)
Client (Browser)
↓
JSP (View Layer)
↓
Servlet (Controller Layer)
↓
DAO / Service Layer
↓
MySQL Database
- Separation of concerns
- Modular architecture
- Maintainable codebase
- Scalable structure
E:\PharmaManagement
| README.md
|
\---SpringBootApp
| .classpath
| .gitattributes
| .gitignore
| .project
| mvnw
| mvnw.cmd
| pom.xml
|
+---.mvn
| \---wrapper
| maven-wrapper.properties
|
+---.settings
| org.eclipse.core.resources.prefs
| org.eclipse.jdt.core.prefs
| org.eclipse.m2e.core.prefs
|
+---src
| +---main
| | +---java
| | | \---com
| | | \---myspringboot
| | | \---SpringBootApp
| | | | SpringBootAppApplication.java
| | | |
| | | +---config
| | | | AuthInterceptor.java
| | | | WebConfig.java
| | | |
| | | +---controller
| | | | BillingController.java
| | | | HelloController.java
| | | | LoginController.java
| | | | MedicineController.java
| | | | SignUpController.java
| | | |
| | | +---dto
| | | | BillingForm.java
| | | |
| | | +---model
| | | | Billing.java
| | | | BillingItem.java
| | | | BillingItemForm.java
| | | | Medicine.java
| | | | MedicineType.java
| | | | User.java
| | | |
| | | +---repo
| | | | BillingRepository.java
| | | | MedicineRepository.java
| | | | UserRepository.java
| | | |
| | | \---Service
| | | BillingService.java
| | | MedicineService.java
| | |
| | \---resources
| | | application.properties
| | |
| | +---static
| | | +---css
| | | | style.css
| | | |
| | | \---js
| | | billing-autocomplete.js
| | |
| | \---templates
| | | index.html
| | |
| | +---pages
| | | add_medicine.html
| | | billing_list.html
| | | billing_new.html
| | | billing_view.html
| | | dashboard.html
| | | med_edit.html
| | | show_medicine.html
| | |
| | \---user_auth
| | index.html
| | user_login.html
| | user_signup.html
| |
| \---test
| \---java
| \---com
| \---myspringboot
| \---SpringBootApp
| SpringBootAppApplicationTests.java
|
\---target
+---classes
| | application.properties
| |
| +---com
| | \---myspringboot
| | \---SpringBootApp
| | | SpringBootAppApplication.class
| | |
| | +---config
| | | AuthInterceptor.class
| | | WebConfig.class
| | |
| | +---controller
| | | BillingController.class
| | | HelloController.class
| | | LoginController.class
| | | MedicineController.class
| | | SignUpController.class
| | |
| | +---dto
| | | BillingForm.class
| | |
| | +---model
| | | Billing$BillingStatus.class
| | | Billing.class
| | | BillingItem.class
| | | BillingItemForm.class
| | | Medicine.class
| | | MedicineType.class
| | | User.class
| | |
| | +---repo
| | | BillingRepository.class
| | | MedicineRepository.class
| | | UserRepository.class
| | |
| | \---Service
| | BillingService.class
| | MedicineService.class
| |
| +---META-INF
| | | MANIFEST.MF
| | |
| | \---maven
| | \---com.myspringboot
| | \---SpringBootApp
| | pom.properties
| | pom.xml
| |
| +---static
| | +---css
| | | style.css
| | |
| | \---js
| | billing-autocomplete.js
| |
| \---templates
| | index.html
| |
| +---pages
| | add_medicine.html
| | billing_list.html
| | billing_new.html
| | billing_view.html
| | dashboard.html
| | med_edit.html
| | show_medicine.html
| |
| \---user_auth
| index.html
| user_login.html
| user_signup.html
|
+---generated-sources
| \---annotations
+---generated-test-sources
| \---test-annotations
+---maven-status
| \---maven-compiler-plugin
| +---compile
| | \---default-compile
| | createdFiles.lst
| | inputFiles.lst
| |
| \---testCompile
| \---default-testCompile
| createdFiles.lst
| inputFiles.lst
|
+---surefire-reports
| 2026-03-05T23-32-50_562.dumpstream
| 2026-03-05T23-38-02_507.dumpstream
| 2026-03-05T23-47-08_673.dumpstream
| com.myspringboot.SpringBootApp.SpringBootAppApplicationTests.txt
| TEST-com.myspringboot.SpringBootApp.SpringBootAppApplicationTests.xml
|
\---test-classes
\---com
\---myspringboot
\---SpringBootApp
SpringBootAppApplicationTests.class
git clone https://github.com/rezaul-code/pharmacy-management-system.git
Open the project in:
- IntelliJ IDEA
- Eclipse
- VS Code (with Java extensions)
Create a MySQL database:
CREATE DATABASE pharmacy_db;
Import the provided SQL file.
Update:
DBConnection.java
jdbc:mysql://localhost:3306/pharmacy_db
username: root
password: yourpassword
Deploy on:
Apache Tomcat Server
Access the application:
http://localhost:8080/pharmacy-management-system
- Session-based authentication
- Input validation
- Secure logout
- Controlled admin access
- Expiry alerts
- Low stock notifications
- Role-based access control
- Export invoices to PDF
- REST API integration
- Spring Boot migration
- Cloud deployment
- Android application version
Rezaul Karim Khan
Software Engineer | Java | Spring Boot | Full Stack Development
🌐 Portfolio https://rezaul.online
💻 GitHub https://github.com/rezaul-code
🔗 LinkedIn https://linkedin.com/in/rezaul-khan
This project is licensed for educational and demonstration purposes.
If you like this project, please star the repository ⭐ on GitHub.