Skip to content

Releases: Kamalisingaravelan/E-commerce_Management_System-UsingJDBC

E-Commerce Management System

06 Oct 16:38
462e542

Choose a tag to compare

                                                          **E-Commerce Management System**

Version: 1.0
Developer: Kamali Singaravelan

Overview

This release marks the initial stable version (v1.0) of the E-Commerce Management System, a console-based Java application designed to simulate key e-commerce operations. It provides a complete flow from user registration to product management, cart handling, and order tracking — implemented using DAO–Service–Model architecture for modular design and scalability.

New Features in v1.0

User Management
Register new users and maintain user details.

Product Management
Add, update, list, and delete products.
Real-time stock validation to prevent overselling.

Shopping Cart
Add products to user-specific cart.
View and remove items dynamically with quantity handling.

Order Processing
Place and list user orders.
Automatic total and revenue calculation.

Admin Functionalities
Secure admin login (password stored in db.properties).
View total revenue generated from all orders.

Configurable Settings
Externalized database credentials and admin password via db.properties.
ConfigUtil class for secure configuration loading.

Technical Highlights

Language: Java (JDK 17+)

Architecture: DAO → Service → CLI (App.java)

Persistence: In-memory / file-based DAO (extendable to JDBC)

Logging: Java Util Logging (java.util.logging.Logger)

Design: Modular, easy to maintain, and extend for GUI or web integration

Known Issues

Top-selling product list refreshes only after restarting session in some cases.

Current version runs fully in CLI (no GUI).

Planned Enhancements (v2.0 Roadmap)

Integration with JDBC/MySQL for persistent storage.

User authentication and roles (Customer/Admin separation).

Graphical interface or Spring Boot Web extension.

Reporting dashboard for sales analytics.

Conclusion

The E-Commerce Management System v1.0 successfully demonstrates an end-to-end e-commerce workflow with clean modular coding, secure configuration handling, and extensible design.
It serves as a solid foundation for future expansion into full-stack or enterprise-grade systems.