# swam-6/collegeevent architecture

> Architecture diagram of the GitHub repository swam-6/collegeevent, 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/collegeevent
- Repository: https://github.com/swam-6/collegeevent

## Overview

This is a **classic server-rendered Java web app** packaged as a **WAR** and deployed to **Apache Tomcat**. It implements **CRUD** for “college events” using:

- **JSP/JSTL** for server-side views
- **Servlet** as the HTTP controller/router
- **DAO pattern** for persistence
- **MySQL via JDBC** for storage

##### Controller (HTTP entrypoint)
- `src/main/java/com/college/events/EventServlet.java`
- `WEB-INF/web.xml` (deployment descriptor) defines servlet mapping (even if annotations are used, web.xml is present, so include it as config)

##### Domain Model
- `Event.java` — POJO representing an event; include as “Domain Model / DTO” in the backend layer

##### Persistence layer (Data Access)
- `EventDAO.java` — CRUD logic (SQL operations)
- `DBConnection.java` — connection factory/utility (JDBC URL/user/password live here)

##### Database
- `database.sql` — schema/bootstrap script
- MySQL connector present in `target/.../mysql-connector-j-8.0.33.jar`

##### Build/Packaging/Deployment
- `pom.xml` — Maven build producing `target/CollegeEvents.war`
- `target/CollegeEvents/...` — exploded WAR (output artifact), shows runtime libs and web resources

##### User Browser sends HTTP request
- `GET /CollegeEvents/events`
- `GET /events?action=new`
- `GET /events?action=edit&id=...`
- `GET /events?action=delete&id=...`
- `POST /events` (create/update)
##### EventServlet
- Parses query params (`action`, `id`) and/or POST body
- Invokes **EventDAO** methods (e.g., `list`, `insert`, `update`, `delete`, `findById`)
##### EventDAO
- Uses **DBConnection** to obtain a JDBC `Connection`
- Executes SQL against **MySQL**
##### Results return upward
- DAO returns `Event` / `List<Event>` to Servlet
- Servlet sets request attributes and forwards to **JSP** (`index.jsp` / `event-form.jsp`)
##### JSP renders HTML (with JSTL) → Tomcat returns HTML response to Browser.

- HTTP request: `action`, `id`, form fields
- Domain objects: `Event`, `List<Event>`
- SQL: `SELECT/INSERT/UPDATE/DELETE`
- Response: HTML

##### Architectural patterns/principles to highlight (make it explicit)

- **MVC-ish separation**
- View: JSP/JSTL
- Controller: Servlet
- Model: POJO (`Event`)
- **DAO pattern**
- `EventDAO` isolates SQL/JDBC from servlet logic
- **Layering**
- Presentation → Controller → Persistence → Database
- **Packaging**
- WAR deployed to Tomcat; dependencies bundled via Maven

##### “Don’t overthink it” detail checklist (separate into as many components as possible)
To maximize detail for this small project, include these extra callouts:
- **Action routing logic** in Servlet (`action=new/edit/delete`) as a note near EventServlet
- **Connection details**: JDBC URL points to `jdbc:mysql://localhost:3306/college_events`
- **Libraries at runtime** (from `target/.../WEB-INF/lib/`): JSTL, MySQL connector (as “runtime dependencies” annotation)
- **Deployment**: “WAR → Tomcat webapps/ → context path /CollegeEvents”

## Diagram (Mermaid)

```mermaid
flowchart TD

%% =========================
%% Container-level (Runtime)
%% =========================
subgraph "Container-level architecture (runtime)"
direction TB

Browser["Browser (User)"]:::client

subgraph "Apache Tomcat (Servlet Container)"
direction TB
WAR["CollegeEvents.war (Web App)"]:::runtime
Context["Context path: /CollegeEvents"]:::note
end

MySQL[("MySQL Database\nSchema: college_events")]:::datastore

Browser -->|"HTTP GET/POST\n/events?action=...&id=...\nform fields"| WAR
WAR -->|"HTML response\n(server-rendered JSP)"| Browser

WAR -->|"JDBC over TCP\nPreparedStatement"| MySQL
MySQL -->|"ResultSet\n(Event / List<Event>)"| WAR

WAR --- Context
end

%% =========================
%% Build/Packaging/Deployment
%% =========================
subgraph "Build & packaging (build-time)"
direction TB
Dev["Developer / CI"]:::client
Maven["Maven (pom.xml)"]:::build
Artifact["WAR artifact\n(target/CollegeEvents.war)"]:::build
Exploded["Exploded WAR\n(target/CollegeEvents/)"]:::build
Deploy["Deploy to Tomcat webapps/\n=> /CollegeEvents"]:::build

Dev -->|"mvn package"| Maven
Maven -->|"produces"| Artifact
Artifact -->|"exploded/installed as"| Exploded
Artifact -->|"copied to"| Deploy
Deploy -->|"runs as"| WAR
end

%% ==================================
%% Component-level (Inside the WAR)
%% ==================================
subgraph "Component-level (inside CollegeEvents.war)"
direction TB

subgraph "Presentation (View) - JSP/JSTL"
direction TB
IndexJSP["index.jsp (List/Views)"]:::view
FormJSP["event-form.jsp (Create/Edit Form)"]:::view
JSTL["JSTL Taglibs (runtime)"]:::lib
end

subgraph "Controller (Servlet)"
direction TB
WebXML["web.xml (Servlet Mapping)"]:::config
Servlet["EventServlet.java (Controller)\nRoutes: action=new/edit/delete\nHandles: GET/POST /events"]:::controller
end

subgraph "Domain Model (Model/DTO)"
direction TB
EventPOJO["Event.java (POJO / DTO)"]:::model
end

subgraph "Persistence (DAO Pattern)"
direction TB
DAO["EventDAO.java (DAO)\nCRUD: list/findById/insert/update/delete"]:::dao
DBConn["DBConnection.java (JDBC Connection Factory)\nURL: jdbc:mysql://localhost:3306/college_events"]:::dao
MySQLDriver["MySQL Connector/J (runtime)"]:::lib
end

%% View <-> Controller flow
Browser -->|"HTTP GET /events\nHTTP GET /events?action=new\nHTTP GET /events?action=edit&id=...\nHTTP GET /events?action=delete&id=..."| Servlet
FormJSP -->|"HTTP POST /events\n(form fields)"| Servlet

WebXML -->|"maps /events -> servlet"| Servlet

Servlet -->|"forward/include\nrequest attrs: events, event"| IndexJSP
Servlet -->|"forward/include\nrequest attrs: event"| FormJSP

IndexJSP ---|"uses"| JSTL
FormJSP ---|"uses"| JSTL

%% Controller <-> DAO flow
Servlet -->|"calls DAO methods"| DAO
DAO -->|"returns Event / List<Event>"| Servlet

%% DAO <-> DB flow
DAO -->|"getConnection()"| DBConn
DBConn ---|"uses"| MySQLDriver
DAO -->|"SQL SELECT/INSERT/UPDATE/DELETE"| MySQL
MySQL -->|"ResultSet -> Event/List<Event>"| DAO

%% Model usage
DAO -->|"maps rows to"| EventPOJO
Servlet ---|"passes via request attrs"| EventPOJO

end

%% =========================
%% Legend / Notes (vertical)
%% =========================
subgraph "CRUD endpoints (legend)"
direction TB
Legend["Endpoints:\n- GET /events (list)\n- GET /events?action=new (new form)\n- GET /events?action=edit&id=... (edit form)\n- GET /events?action=delete&id=... (delete)\n- POST /events (create/update)"]:::note
end

%% =========================
%% Click Events (component mapping)
%% =========================
click IndexJSP "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/webapp/index.jsp"
click FormJSP "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/webapp/event-form.jsp"
click Servlet "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/java/com/college/events/EventServlet.java"
click WebXML "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/webapp/WEB-INF/web.xml"
click EventPOJO "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/java/com/college/events/Event.java"
click DAO "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/java/com/college/events/EventDAO.java"
click DBConn "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/src/main/java/com/college/events/DBConnection.java"
click Maven "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/pom.xml"
click Exploded "https://github.com/swam-6/collegeevent/tree/Main/CollegeEvents/target/CollegeEvents/"
click JSTL "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/target/CollegeEvents/WEB-INF/lib/jakarta.servlet.jsp.jstl-3.0.1.jar"
click MySQLDriver "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/target/CollegeEvents/WEB-INF/lib/mysql-connector-j-8.0.33.jar"
click Legend "https://github.com/swam-6/collegeevent/blob/Main/CollegeEvents/database.sql"

%% =========================
%% Styles
%% =========================
classDef client fill:#D9D9D9,stroke:#444,stroke-width:1px,color:#111;
classDef runtime fill:#B7D8FF,stroke:#1E5AA8,stroke-width:1px,color:#0B2A4A;
classDef view fill:#BFE8C2,stroke:#2E7D32,stroke-width:1px,color:#0F3D14;
classDef controller fill:#9FE3B2,stroke:#1B5E20,stroke-width:1px,color:#0B2A10;
classDef model fill:#CDEFCF,stroke:#2E7D32,stroke-width:1px,color:#0F3D14;
classDef dao fill:#A7E7A9,stroke:#2E7D32,stroke-width:1px,color:#0F3D14;
classDef datastore fill:#FFD39A,stroke:#C77700,stroke-width:1px,color:#4A2C00;
classDef build fill:#D9C2FF,stroke:#6A3FA0,stroke-width:1px,color:#2A0F4A;
classDef config fill:#C7F0FF,stroke:#0077A8,stroke-width:1px,color:#003B52;
classDef lib fill:#E6F7D9,stroke:#5A8A2B,stroke-width:1px,color:#1F3A0A;
classDef note fill:#FFF2B3,stroke:#C7A600,stroke-width:1px,color:#4A3C00;
```
