# swam-6/expensetracker architecture

> Architecture diagram of the GitHub repository swam-6/expensetracker, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-03-11). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/swam-6/expensetracker
- Repository: https://github.com/swam-6/expensetracker

## Overview

##### What this project is (type + purpose)
This is a classic **Java EE-style (Jakarta/Servlet) monolithic web application** packaged as a **WAR**, deployed to **Apache Tomcat 10.1**, using **JSP for views** and **JDBC (PreparedStatement) to MySQL** for persistence. It implements an **Expense Tracker** with full CRUD, plus grouped/monthly/category summaries, using an explicit **MVC** split:
- **Controller:** `ExpenseServlet`
- **Model/Data access:** `ExpenseDAO`, `Expense` entity, `DBUtil`
- **View:** JSPs (`expense-list.jsp`, `expense-form.jsp`, `index.jsp`)

- **Runtime container** (Tomcat)
- **Request routing** (web.xml + servlet mapping)
- **MVC request lifecycle**
- **DB connectivity (JDBC)**
- **Deployment artifact and build pipeline (Maven → WAR)**

##### What the file tree tells you to include (structure → architecture)
From the tree:

##### Backend (Java)
- `com.expense.servlet.ExpenseServlet.java`
- `com.expense.dao.ExpenseDAO.java`
- `com.expense.util.DBUtil.java`
Own component for **connection management** (Driver, URL, username/password). Show it as the point where the JDBC driver is used.
- `com.expense.model.Expense.java`
Entity/DTO passed between servlet ↔ DAO ↔ JSP.

##### Frontend (JSP)
- `index.jsp`
Acts as entrypoint/redirect to listing route (per README). Show it as “landing/redirect view.”
- `expense-list.jsp`
View that renders grouped expenses. Important: it implies the servlet provides grouped/aggregated data (or raw list + JSP grouping).
- `expense-form.jsp`
View for add/edit.

##### Web configuration
- `WEB-INF/web.xml`

##### Build/packaging
- `pom.xml`, Maven wrapper
“Build: Maven → WAR artifact”.
- Runtime dependencies (implicit): **MySQL JDBC driver** via Maven (even if not shown in the tree).

Goal: show who uses it and what external systems exist.

**Include these nodes:**
- **User** (actor)
- **Browser**
- **MySQL Database** (`expense_tracker`, table `expense`)

- Browser ⇄ Web App (HTTP requests/responses)
- Web App ⇄ MySQL (JDBC / SQL)

Goal: show runtime containers and where code runs.

- **Client device**
- Browser (renders HTML/CSS from JSP output)
- **Application server host**
- **Apache Tomcat 10.1** (Servlet container)
- Deployed artifact: **`ExpenseTracker.war` / “war exploded”**
- **Database host**
- **MySQL 8.0** (schema `expense_tracker`)

**Connections:**
- Browser → Tomcat: HTTP
- Tomcat → MySQL: TCP + JDBC

- That JSPs are compiled/served by Tomcat (JSP engine) and servlets run in the same container.
- Environment separation if relevant (Dev machine often hosts both Tomcat + MySQL locally).

Goal: show MVC and internal boundaries as *separate components*, not just “Java app”.

**Web layer**
- `index.jsp` (entry / redirect)
- `expense-list.jsp` (list + grouping UI)
- `expense-form.jsp` (create/edit UI)
- `web.xml` (URL mapping / servlet config)

**Controller**
- `ExpenseServlet`

**Domain/model**
- `Expense` (POJO/DTO)

**Data access**
- `ExpenseDAO` (CRUD + queries)
- `DBUtil` (Connection factory / JDBC configuration)

**Database**
- MySQL table `expense(id, title, amount, category, date)`

- Browser → `index.jsp` → (redirect) → `ExpenseServlet`
- Browser → `ExpenseServlet` → (forward) → `expense-list.jsp` / `expense-form.jsp`
- `ExpenseServlet` → `ExpenseDAO`
- `ExpenseDAO` → `DBUtil` (get connection)
- `ExpenseDAO` → MySQL (SQL statements)
- `ExpenseServlet` → `Expense` (construct/parse)
- `ExpenseServlet` → JSP (sets request attributes / model)

Create at least these sequences:

##### List expenses (GET /expenses)
Browser → Tomcat → ExpenseServlet
ExpenseServlet → ExpenseDAO → MySQL (SELECT)
ExpenseDAO → ExpenseServlet (List<Expense> or grouped data)
ExpenseServlet → expense-list.jsp (forward + attributes)
expense-list.jsp → Browser (HTML)

##### Add expense (POST /expenses?action=add) (or equivalent)
Browser submits form → ExpenseServlet
ExpenseServlet validates/parses → ExpenseDAO.insert(expense) → MySQL (INSERT)
ExpenseServlet → Browser (redirect to list)

##### Edit/Delete similarly (UPDATE/DELETE + redirect)

In each sequence, label payloads:
- Request parameters: `title`, `amount`, `category`, `date`, `id`
- Response: HTML page or redirect

##### MVC is real here (not just a buzzword)
- **JSPs do not talk to DB directly** (they’re views).
- **Servlet owns orchestration** (routing, deciding which JSP, calling DAO).
- **DAO owns SQL** (and depends on DBUtil).
- **DBUtil owns connection details** (driver/url/user/pass).

##### “Single servlet handles all actions” is an architectural hotspot
Make that explicit:
- `ExpenseServlet` with internal “Action Router” responsibility:
- `list`
- `showForm(add/edit)`
- `create`
- `update`
- `delete`

##### Grouping and summary computation
- Either **DAO returns aggregated/grouped result sets** (SQL GROUP BY / ORDER BY)
- Or **Servlet groups in-memory** (maps by month/category)

- `ExpenseDAO` (if SQL-driven) or
- `ExpenseServlet` (if Java-driven)

Labels directly on nodes:
- **Java 17**
- **Servlet API / JSP**
- **Tomcat 10.1**
- **JDBC (PreparedStatement)**
- **MySQL 8.0**
- **Maven** (build → WAR)

- `ExpenseTracker:war exploded` (IntelliJ deployment) / WAR packaging

## Diagram (Mermaid)

```mermaid
flowchart TD
  %% =======================
  %% Level 1: System Context
  %% =======================
  subgraph "System Context (L1)"
    direction TB
    User(["User"]):::actor
    Browser(["Web Browser"]):::runtime
    AppCtx["Expense Tracker Web App\n(Java 17, Servlet/JSP)"]:::app
    MySQL[("MySQL 8.0\nSchema: expense_tracker\nTable: expense")]:::db

    User -->|"uses"| Browser
    Browser <-->|"HTTP(S): requests/responses"| AppCtx
    AppCtx <-->|"JDBC (TCP): SQL via PreparedStatement"| MySQL
  end

  %% ==================================
  %% Level 2: Container / Deployment (L2)
  %% ==================================
  subgraph "Container / Deployment (L2)"
    direction TB

    subgraph "Client Device"
      direction TB
      BrowserC(["Browser\n(renders HTML from JSP)"]):::runtime
    end

    subgraph "Application Server Host"
      direction TB
      Tomcat(["Apache Tomcat 10.1\n(Servlet Container + JSP engine)"]):::runtime
      WAR["ExpenseTracker.war\n(WAR exploded)"]:::artifact
      Tomcat -->|"deploys"| WAR
    end

    subgraph "Database Host"
      direction TB
      MySQLC[("MySQL 8.0\nexpense_tracker.expense")]:::db
    end

    BrowserC -->|"HTTP: GET/POST"| Tomcat
    Tomcat -->|"JDBC over TCP"| MySQLC

    subgraph "Build / Packaging"
      direction TB
      Maven["Maven Build\n(pom.xml)"]:::build
      WrapperDir["Maven Wrapper Dir\n(.mvn/wrapper/)"]:::build
      Mvnw["Maven Wrapper Script\n(mvnw)"]:::build
      MvnwCmd["Maven Wrapper Script\n(mvnw.cmd)"]:::build
      Maven -->|"packages"| WAR
      WrapperDir -->|"bootstraps"| Maven
      Mvnw -->|"bootstraps"| Maven
      MvnwCmd -->|"bootstraps"| Maven
    end
  end

  %% ======================================
  %% Level 3: Components (inside the WAR) (L3)
  %% ======================================
  subgraph "Application Components (L3) — inside ExpenseTracker WAR"
    direction TB

    subgraph "Web Configuration"
      direction TB
      WebXml["web.xml\n(Servlet mapping / URL routing)"]:::config
    end

    subgraph "Presentation Layer (JSP Views)"
      direction TB
      IndexJsp["index.jsp\n(landing/redirect)"]:::view
      ListJsp["expense-list.jsp\n(list + grouped summary UI)"]:::view
      FormJsp["expense-form.jsp\n(add/edit form)"]:::view
    end

    subgraph "Controller Layer"
      direction TB
      ExpenseServlet["ExpenseServlet\n(Front Controller + Action Router)\nlist/showForm/create/update/delete\nGrouping/Aggregation: DAO or Controller"]:::controller
    end

    subgraph "Domain Model"
      direction TB
      ExpenseModel["Expense\n(POJO/DTO)"]:::model
    end

    subgraph "Data Access Layer"
      direction TB
      ExpenseDAO["ExpenseDAO\n(CRUD + Queries)"]:::dao
      DBUtil["DBUtil\n(ConnectionFactory + JDBC config)"]:::dao
    end

    DB[("MySQL Table: expense\n(id,title,amount,category,date)")]:::db

    %% MVC wiring
    IndexJsp -.->|"redirect: GET /expenses"| ExpenseServlet
    WebXml -->|"maps URLs to servlet"| ExpenseServlet

    ExpenseServlet -->|"forward: expense-list.jsp\nset request attributes"| ListJsp
    ExpenseServlet -->|"forward: expense-form.jsp\nset request attributes"| FormJsp

    ExpenseServlet -->|"constructs/parses"| ExpenseModel
    ExpenseServlet -->|"calls CRUD methods"| ExpenseDAO
    ExpenseDAO -->|"getConnection()"| DBUtil
    ExpenseDAO -->|"JDBC: SELECT/INSERT/UPDATE/DELETE"| DB
  end

  %% ======================================
  %% Request Flows (Key Sequences summarized)
  %% ======================================
  subgraph "Key Request Flows (summary)"
    direction TB
    F1["1) List Expenses\nBrowser: GET /expenses\nServlet->DAO->DB: SELECT\nServlet->JSP: forward list\nJSP->Browser: HTML"]:::note
    F2["2) Add Expense\nBrowser: POST /expenses?action=add\nparams: title,amount,category,date\nServlet->DAO->DB: INSERT\nServlet->Browser: redirect /expenses"]:::note
    F3["3) Edit/Delete\nPOST/GET with id\nDAO->DB: UPDATE/DELETE\nredirect to list"]:::note
  end

  %% =======================
  %% Cross-level connections
  %% =======================
  Browser -->|"HTTP: GET /"| IndexJsp
  Browser -->|"HTTP: GET/POST /expenses"| ExpenseServlet
  ExpenseServlet -->|"HTTP 302 redirect"| Browser
  ListJsp -->|"HTML response"| Browser
  FormJsp -->|"HTML response"| Browser

  %% =======================
  %% Click Events (paths only)
  %% =======================
  click ExpenseServlet "https://github.com/swam-6/expensetracker/blob/main/src/main/java/com/expense/servlet/ExpenseServlet.java"
  click ExpenseDAO "https://github.com/swam-6/expensetracker/blob/main/src/main/java/com/expense/dao/ExpenseDAO.java"
  click DBUtil "https://github.com/swam-6/expensetracker/blob/main/src/main/java/com/expense/util/DBUtil.java"
  click ExpenseModel "https://github.com/swam-6/expensetracker/blob/main/src/main/java/com/expense/model/Expense.java"
  click IndexJsp "https://github.com/swam-6/expensetracker/blob/main/src/main/webapp/index.jsp"
  click ListJsp "https://github.com/swam-6/expensetracker/blob/main/src/main/webapp/expense-list.jsp"
  click FormJsp "https://github.com/swam-6/expensetracker/blob/main/src/main/webapp/expense-form.jsp"
  click WebXml "https://github.com/swam-6/expensetracker/blob/main/src/main/webapp/WEB-INF/web.xml"
  click Maven "https://github.com/swam-6/expensetracker/blob/main/pom.xml"
  click WrapperDir "https://github.com/swam-6/expensetracker/tree/main/.mvn/wrapper/"
  click Mvnw "https://github.com/swam-6/expensetracker/tree/main/mvnw"
  click MvnwCmd "https://github.com/swam-6/expensetracker/blob/main/mvnw.cmd"

  %% =======================
  %% Styles (color + shapes)
  %% =======================
  classDef actor fill:#0b1220,stroke:#93c5fd,color:#e5e7eb,stroke-width:1.5px
  classDef runtime fill:#111827,stroke:#9ca3af,color:#f9fafb,stroke-width:1.5px
  classDef app fill:#0b3b5a,stroke:#38bdf8,color:#e6f6ff,stroke-width:1.5px
  classDef artifact fill:#1f2937,stroke:#60a5fa,color:#f9fafb,stroke-width:1.5px

  classDef view fill:#0b4a6f,stroke:#38bdf8,color:#e6f6ff,stroke-width:1.5px
  classDef controller fill:#7c2d12,stroke:#fb923c,color:#fff7ed,stroke-width:1.5px
  classDef model fill:#064e3b,stroke:#34d399,color:#ecfdf5,stroke-width:1.5px
  classDef dao fill:#14532d,stroke:#86efac,color:#ecfdf5,stroke-width:1.5px
  classDef config fill:#334155,stroke:#a5b4fc,color:#eef2ff,stroke-width:1.5px
  classDef db fill:#3b0764,stroke:#c084fc,color:#faf5ff,stroke-width:1.5px
  classDef build fill:#312e81,stroke:#818cf8,color:#eef2ff,stroke-width:1.5px
  classDef note fill:#1f2937,stroke:#fbbf24,color:#fffbeb,stroke-width:1.5px,stroke-dasharray: 4 3
```
