Develop a menu-based console application to assess your proficiency in Core Java, MySQL, and JDBC. The application will simulate an inventory management system for a pharmaceutical company, allowing users to manage medications, suppliers, and inventory levels.
- Install MySQL and create a database using the provided SQL script.
- Update the
JdbcConnection
class with your MySQL credentials. - Compile and run the
InventoryManagementSystem
class.
-
Medication Management:
- Add a new medication
- View medication details
- Update medication information
- Delete a medication
-
Supplier Management:
- Add a new supplier
- View supplier details
- Update supplier information
- Delete a supplier
-
Inventory Management:
- Update inventory levels
- View inventory levels
- Generate low-stock alerts
- Java SE Development Kit (JDK)
- MySQL Database
- JDBC Driver for MySQL
- Sayan Khanra
├── src
│ └── MainCode
│ ├── DAO
│ │ ├── InventoryDAO.java
│ │ ├── MedicationDAO.java
│ │ └── SupplierDAO.java
│ ├── MOD
│ │ ├── Inventory.java
│ │ ├── Medication.java
│ │ └── Supplier.java
│ ├── DB
│ │ └── JdbcConnection.java
│ ├── Menu.java
│ └── InventoryManagementSystem.java
└── lib
└── mysql-connector-j-8.0.25.jar