How abinashrath003/stockmanagementsystem works
Main Components
• GUI Layer: MainFrame.java (Java Swing)
• Business Logic / Domain Modules: Vendor.java, Product.java, Order.java, Transaction.java
• Data Access Layer: JDBC connector + SQL QUERIES.txt
• Database: MySQL instance
Interactions & Data Flow
• User Actions (clicks, form entries) flow from the user’s desktop into the MainFrame (UI Layer).
• The MainFrame dispatches requests to the appropriate domain module (e.g., Product, Order).
• Domain modules use JDBC calls (prepared statements / queries defined in SQL QUERIES.txt) to perform CRUD operations.
• JDBC channel communicates over TCP/IP to the MySQL database.
• Results (e.g., ResultSet data) flow back up through JDBC → domain module → MainFrame → user.
Architectural Patterns & Design Principles
• Layered architecture: Separation of Concerns
• Presentation Layer (GUI)
• Application / Business Layer (domain classes)
• Data Access Layer (JDBC)
• Persistence Layer (MySQL DB)
• Single MainFrame acting as Controller for UI navigation
• Each domain class encapsulates its own CRUD logic
• SQL QUERIES.txt centralizes raw SQL for maintainability
Technologies & Frameworks
• Java Swing (UI)
• JDBC (data connectivity)
• MySQL (relational database)
• SQL files for queries