# abinashrath003/stockmanagementsystem architecture

> Architecture diagram of the GitHub repository abinashrath003/stockmanagementsystem, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-05-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/abinashrath003/stockmanagementsystem
- Repository: https://github.com/abinashrath003/stockmanagementsystem

## Overview

##### 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

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% Actors
    User((User)):::actor

    %% Presentation Layer
    MainFrame["MainFrame\n(Java Swing)"]:::ui

    %% Business Logic Layer
    subgraph "Business Logic Layer"
        Vendor["Vendor"]:::logic
        Product["Product"]:::logic
        Order["Order"]:::logic
        Transaction["Transaction"]:::logic
    end

    %% Data Access Layer
    DataAccess["JDBC Data Access\n(Uses SQL QUERIES.txt)"]:::dataAccess

    %% Persistence Layer
    MySQL[(MySQL Database)]:::db

    %% Flows
    User -->|"user action"| MainFrame
    MainFrame -->|"create/findVendor()"| Vendor
    MainFrame -->|"findProductById()"| Product
    MainFrame -->|"createOrder()/updateOrder()"| Order
    MainFrame -->|"updateTransaction()"| Transaction

    Vendor -->|"executeQuery()"| DataAccess
    Product -->|"executeQuery()"| DataAccess
    Order -->|"executeQuery()"| DataAccess
    Transaction -->|"executeQuery()"| DataAccess

    DataAccess -->|"TCP/IP port 3306"| MySQL
    MySQL -->|"ResultSet data"| DataAccess
    DataAccess -->|"map ResultSet"| Vendor
    DataAccess -->|"map ResultSet"| Product
    DataAccess -->|"map ResultSet"| Order
    DataAccess -->|"map ResultSet"| Transaction
    Vendor -->|"return data"| MainFrame
    Product -->|"return data"| MainFrame
    Order -->|"return data"| MainFrame
    Transaction -->|"return data"| MainFrame

    %% Click Events
    click MainFrame "https://github.com/abinashrath003/stockmanagementsystem/blob/main/MainFrame.java"
    click Vendor "https://github.com/abinashrath003/stockmanagementsystem/blob/main/Vendor.java"
    click Product "https://github.com/abinashrath003/stockmanagementsystem/blob/main/Product.java"
    click Order "https://github.com/abinashrath003/stockmanagementsystem/blob/main/Order.java"
    click Transaction "https://github.com/abinashrath003/stockmanagementsystem/blob/main/Transaction.java"
    click DataAccess "https://github.com/abinashrath003/stockmanagementsystem/blob/main/SQL QUERIES.txt"

    %% Styles
    classDef actor fill:#E1E1E1,stroke:#333,stroke-width:1px
    classDef ui fill:#CFE2F3,stroke:#333,stroke-width:1px
    classDef logic fill:#B6D7A8,stroke:#333,stroke-width:1px
    classDef dataAccess fill:#FFE599,stroke:#333,stroke-width:1px,stroke-dasharray: 5 5
    classDef db fill:#F4B084,stroke:#333,stroke-width:1px,shape:cylinder
```
