Pharmaceutical Supply Chain & Counterfeit Detection System

Full-stack Java Swing + MySQL desktop application simulating end-to-end medicine traceability across manufacturers, distributors, pharmacies, regulators, and customers.

🌟 Key Features

• 5 Role-based Dashboards (Manufacturer, Distributor, Pharmacist, Regulator, Customer)
• Stored Procedures for secure batch transfer, verification, and anomaly detection
• Triggers for automatic audit logging and risk flagging
• Transaction Safety with COMMIT/ROLLBACK
• Counterfeit Detection using temperature, humidity, expiry, and authenticity scoring
• Audit Trail and Compliance Reports
• Real-world Indian pharma dataset

📁 Project Structure

PharmaSupplyChain/
├── src/pharma/
│   ├── db/DBConnection.java
│   └── ui/          # All Swing frames (Login, Manufacturer, etc.)
├── lib/mysql-connector-j-8.3.0.jar
├── scripts/
│   ├── compile.ps1
│   └── run.ps1
├── sql/
│   ├── pharma_supply_chain.sql
│   └── real_world_dataset.sql
└── docs/
    ├── DEMO_SCRIPT.md
    └── PROJECT_BRIEF.md