# vinay6697/product-management-system-spring-jdbc architecture

> Architecture diagram of the GitHub repository vinay6697/product-management-system-spring-jdbc, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-10). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/vinay6697/product-management-system-spring-jdbc
- Repository: https://github.com/vinay6697/product-management-system-spring-jdbc

## Overview

This is a console-based product and inventory manager. The user selects CRUD, category-search, low-stock, or stock-adjustment actions; Main gathers input and delegates to the service, which validates requests before the DAO performs JDBC operations against PostgreSQL. Product is the shared domain record, and Spring configuration supplies the JDBC infrastructure. The README documents the product capabilities and layered design; the source excerpts show the console, service, DAO, model, and wiring. The database connection is documented, but no PostgreSQL runtime implementation is included in the excerpts.

Main entry points: [`src/main/java/com/product/main/Main.java`](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/main/Main.java) (Menu and input), [`src/main/java/com/product/config/MyConfig.java`](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java) (JdbcTemplate), [`src/main/java/com/product/service/ServiceDAO.java`](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/service/ServiceDAO.java) (Validation and operations), [`src/main/java/com/product/dao/ProductDAO.java`](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/dao/ProductDAO.java) (Product queries and updates)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_console["Console interface"]
  node_main["Menu and input<br/>[Main.java]"]
end

subgraph group_spring["Spring wiring"]
  node_config["Application config<br/>[MyConfig.java]"]
end

subgraph group_domain["Product domain"]
  node_service["Validation and operations<br/>[ServiceDAO.java]"]
  node_product["Product record<br/>[Product.java]"]
end

subgraph group_persistence["Persistence"]
  node_dao["Product queries and updates<br/>[ProductDAO.java]"]
  node_datasource["Database connection<br/>[MyConfig.java]"]
  node_jdbc["JdbcTemplate<br/>[MyConfig.java]"]
end

node_operator(("Console user"))
node_postgres[("PostgreSQL products store")]

node_operator -->|"enters choices"| node_main
node_main -->|"starts context"| node_config
node_main -->|"dispatches operations"| node_service
node_main -->|"creates and displays"| node_product
node_config -->|"configures"| node_datasource
node_config -->|"creates"| node_jdbc
node_service -->|"delegates operations"| node_dao
node_service -->|"validates records"| node_product
node_dao -->|"maps records"| node_product
node_dao -->|"executes SQL"| node_jdbc
node_jdbc -->|"queries and updates"| node_postgres
node_jdbc -->|"uses connection"| node_datasource

click node_main "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/main/Main.java"
click node_config "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java"
click node_service "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/service/ServiceDAO.java"
click node_product "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/entity/Product.java"
click node_dao "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/dao/ProductDAO.java"
click node_datasource "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java"
click node_jdbc "https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_main,node_operator toneBlue
class node_config,node_postgres toneAmber
class node_service,node_product toneMint
class node_dao,node_datasource,node_jdbc toneRose
```

## Components

### Console interface

- [Menu and input](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/main/Main.java): `src/main/java/com/product/main/Main.java`

### Spring wiring

- [Application config](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java): `src/main/java/com/product/config/MyConfig.java`

### Product domain

- [Validation and operations](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/service/ServiceDAO.java): `src/main/java/com/product/service/ServiceDAO.java`
- [Product record](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/entity/Product.java): `src/main/java/com/product/entity/Product.java`

### Persistence

- [Product queries and updates](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/dao/ProductDAO.java): `src/main/java/com/product/dao/ProductDAO.java`
- [Database connection](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java): `src/main/java/com/product/config/MyConfig.java`
- [JdbcTemplate](https://github.com/vinay6697/product-management-system-spring-jdbc/blob/main/src/main/java/com/product/config/MyConfig.java): `src/main/java/com/product/config/MyConfig.java`

### Other components

- **Console user**
- **PostgreSQL products store**

## Connections

- Console user → Menu and input: enters choices (evidence: `src/main/java/com/product/main/Main.java`)
- Menu and input → Application config: starts context (evidence: `src/main/java/com/product/main/Main.java`)
- Menu and input → Validation and operations: dispatches operations (evidence: `src/main/java/com/product/main/Main.java`)
- Menu and input → Product record: creates and displays (evidence: `src/main/java/com/product/main/Main.java`)
- Application config → Database connection: configures (evidence: `src/main/java/com/product/config/MyConfig.java`)
- Application config → JdbcTemplate: creates (evidence: `src/main/java/com/product/config/MyConfig.java`)
- Validation and operations → Product queries and updates: delegates operations (evidence: `src/main/java/com/product/service/ServiceDAO.java`)
- Validation and operations → Product record: validates records (evidence: `src/main/java/com/product/service/ServiceDAO.java`)
- Product queries and updates → Product record: maps records (evidence: `src/main/java/com/product/dao/ProductDAO.java`)
- Product queries and updates → JdbcTemplate: executes SQL (evidence: `src/main/java/com/product/dao/ProductDAO.java`)
- JdbcTemplate → PostgreSQL products store: queries and updates (evidence: `README.md`)
- JdbcTemplate → Database connection: uses connection (evidence: `src/main/java/com/product/config/MyConfig.java`)