Description

Pharmacy Shop Automation System using Java, JSP, and MySQL

The Pharmacy Shop Automation System project has been created utilizing Java and JSP, with data stored in a MySQL database. This project aims to transition the manual system of a Medical Shop into a computerized system, allowing for efficient and accurate management of medical records. Various modules have been developed for this project, including medicine management, stock management, and inventory management. Students can access and download Java projects with source code for free to aid in their learning.

Below the description, you can find screens and a demo of the project for further details.

Modules and Description of Pharmacy Shop Automation System Project:

Medicine Module:

The primary objective of this module is to manage medicine data efficiently. This module is the core of the Pharmacy Shop Automation System, developed using Java, JSP, and MySQL. Admin can manage all medicines, while customers can view the available medicines. Features of the Medicine Module include:

• Admin can manage medicines
• Admin can edit/delete medicines
• Admin can view a list of all medicines
• Customers can view available medicines

Company Module:

The purpose of this module is to manage company data. Admin can manage all companies, and customers can view the company information. Features of the Company Module include:

• Admin can manage companies
• Admin can edit/delete companies
• Admin can view a list of all companies
• Customers can view company details

Sales Module:

This module is designed to manage customer sales records. Admin can oversee all sales transactions. Features of the Sales Module include:

• Admin can manage sales
• Admin can edit/delete sales
• Admin can view a list of all sales
• Customers can view their sales history

Medicine Stock Module:

The purpose of this module is to manage customer medicine stock. Admin can handle all medicine stock records. Features of the Medicine Stock Module include:

• Admin can manage medicine stock
• Admin can edit/delete medicine stock
• Admin can view a list of all medicine stock
• Customers can view their medicine stock

Functionality performed by Admin:

• Login for Admin
• Change Password for Admin
• Edit Profile for Admin
• Manage Medicine
  • Add New Medicine
  • Edit Existing Medicine
  • List all Medicines
• Manage Stocks
  • Add Stocks
  • List all Medicine Stocks
  • Edit Stock
• Manage Company
  • Add Company for the medicine
  • Edit company
  • List all companies
• Manage Sales
  • Add Sales
  • List Sales
  • View Sales Details
• Manage Users
  • Add Users
  • List Users
  • View User Details
• Reports in the Project
  • Report of all Medicines
  • Report of all Stocks
  • Report of all Sales
  • Report of all Companies
  • Report of all Users

Static Pages and Other Sections:

These static pages are available in the project:

• Home Page with a user-friendly interface
• Animated slider for image banners on the Home Page
• About Us page describing the project
• Contact Us page for project inquiries

Technology Used in the Project (Pharmacy Shop Automation System):

The project was developed using the following technologies:

• HTML: Page layout designed in HTML
• CSS: Styling done using CSS
• JavaScript: Validation tasks and animations implemented with JavaScript
• JSP: Front-end logic written in JSP
• Java: Business logic written in Java
• MySQL: Database management using MySQL
• Tomcat: Project hosted on Tomcat server

Supported Operating Systems:

This project can be configured on the following operating systems:

• Windows: Compatible with Windows OS, requiring Tomcat 7, JDK 7, MySQL 5 for setup
• Linux: Can run on various Linux distributions
• Mac: Configurable on Mac OS