# vikas7075/crud-operation-in-java-jdbc architecture

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

- Interactive diagram: https://gitdiagram.com/vikas7075/crud-operation-in-java-jdbc
- Repository: https://github.com/vikas7075/crud-operation-in-java-jdbc

## Overview

##### Project type and purpose
- This is a simple full-stack Java console application that performs CRUD operations on an Employees table in a MySQL database.
- The user interacts via the console; the application uses JDBC to connect to a local XAMPP-hosted MySQL server.

##### File structure
- Top level:
- README.md – project description
- crud/ – IntelliJ project folder
- Inside crud/:
- src/Main.java – single entry point and UI + logic
- lib/mysql-connector-java-8.0.11.jar – JDBC driver
- out/production/crud – compiled classes
- No separate “data access” or “service” packages, so the layers are co-located in Main.java.

##### README for additional insights
- Technology stack: Java 8, Java Console, XAMPP, MySQL, JDBC API
- Process steps: loading driver, establishing connection, creating statement, executing query, closing connection

##### Detail
- Five JDBC steps in the data access layer as sub-steps or annotations.
- Localhost network connection (TCP port 3306) between the Connector/J and MySQL server.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% User
    U(User):::user

    %% Presentation Tier
    subgraph "Presentation Tier"
        CU("Console UI Module"):::java
        CM("Connection Manager"):::java
        SE("SQL Executor"):::java
    end

    %% Data Access Tier
    subgraph "Data Access Tier"
        JDBC["JDBC API"]:::java
        CJ["Connector/J Library"]:::lib
    end

    %% Database Tier
    subgraph "Database Tier"
        MS[(MySQL Server)]:::db
        ET[(Employees Table)]:::dbtable
    end

    %% Project Files
    subgraph "Project Files"
        RD["README.md"]:::doc
        IM["crud.iml"]:::resources
        OUT["out/production/crud"]:::resources
    end

    %% Relationships
    U -->|"keyboard input / menu"| CU
    CU -->|"invokes Connection Manager"| CM
    CU -->|"invokes SQL Executor"| SE
    CM -->|"uses JDBC API"| JDBC
    SE -->|"uses JDBC API"| JDBC
    JDBC -->|"loads driver\nconnects\ncreate stmt\nexecute\nclose"| CJ
    CJ -->|"TCP:3306 SQL queries"| MS
    MS -->|"result sets / acknowledgements"| JDBC
    JDBC -->|"returns results"| SE
    SE -->|"forwards data"| CU
    CU -->|"displays results"| U

    CU -.->|"depends on"| CJ

    %% Click Events
    click CU "https://github.com/vikas7075/crud-operation-in-java-jdbc/blob/main/crud/src/Main.java"
    click CJ "https://github.com/vikas7075/crud-operation-in-java-jdbc/blob/main/crud/lib/mysql-connector-java-8.0.11.jar"
    click RD "https://github.com/vikas7075/crud-operation-in-java-jdbc/blob/main/README.md"
    click IM "https://github.com/vikas7075/crud-operation-in-java-jdbc/blob/main/crud/crud.iml"
    click OUT "https://github.com/vikas7075/crud-operation-in-java-jdbc/tree/main/crud/out/production/crud"

    %% Styles
    classDef java fill:#ADD8E6,stroke:#000;
    classDef lib fill:#FFA500,stroke:#000;
    classDef db fill:#90EE90,stroke:#000;
    classDef dbtable fill:#32CD32,stroke:#000;
    classDef user fill:#F0E68C,stroke:#000;
    classDef doc fill:#EEE8AA,stroke:#000;
    classDef resources fill:#D3D3D3,stroke:#000;
```
