# carlxsmedina/proyectoprg4 architecture

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

- Interactive diagram: https://gitdiagram.com/carlxsmedina/proyectoprg4
- Repository: https://github.com/carlxsmedina/proyectoprg4

## Overview

##### Project Type & Purpose
- This is a monolithic Java web application (“Sistema de Gestión de Usuarios”) that provides full CRUD and authentication over user records.
- Built with JSP for the front-end views, a single Java DAO class for persistence, and MySQL as the backing store. Deployed on Apache Tomcat.

##### File‐Structure Analysis
- Top‐Level:
- build.xml + nbproject/ → Ant build + NetBeans metadata
- src/conf/MANIFEST.MF → WAR metadata
- src/java/datos/Conexion.java → JDBC‐based Data Access Object
- web/ → JSP pages under the web content root
– web/META-INF/context.xml → JNDI or resource configuration
– JSPs: login.jsp, index.jsp, agregarUsuario.jsp, buscar.jsp, confirmar.jsp
- No separate “controllers” folder—JSPs likely embed both view and controller logic.

##### Key Architecture Points from README
- Layers: Presentation (JSP + Bootstrap), Persistence (JDBC via Conexion.java)
- Tech stack: Java 8+, JSP/Servlet container (Tomcat 8.5+), MySQL 5.7+, Bootstrap 5
- DB auto‐creation on first run, connector jar in WEB-INF/lib

##### Main Components
a. Presentation Layer
- Browser (Chrome/Firefox)
- HTTP(S) frontend → JSPs (login, index, register/edit, search, confirm)
b. Application Server
- Tomcat Container
- JSP Engine + Servlet API
- Ant (build.xml) / NetBeans deployment
c. Business/DAO Layer
- src/java/datos/Conexion.java
- Manages JDBC connections, executes SQL for CRUD
d. Database Layer
- MySQL Server (sistema_usuarios schema, usuarios table)
- JDBC Driver (mysql-connector-java.jar)
e. Infrastructure/Config
- context.xml (JNDI DataSource or resource-ref)
- build.xml / project.properties (build & deploy steps)

##### Relationships & Data Flows
- ① HTTP Request: Browser → Tomcat
- ② JSP invokes Conexion.java methods (via scriptlet or custom tag)
- ③ JDBC Call: Conexion → MySQL
- ④ Query Results: MySQL → Conexion → JSP
- ⑤ HTTP Response: JSP → Browser

##### Architectural Patterns & Principles
- Layered Pattern (Presentation → Business/DAO → Data)
- Implicit MVC: JSPs double as View + Controller, DAO as Model
- Use of resource configuration (context.xml) for decoupling DB creds

##### Final Checklist
- Call out configuration artifacts (context.xml, build.xml)
- 5 JSP pages as view endpoints or group them logically

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Presentation Layer
    subgraph "Presentation Layer"
        Browser["Browser\n(Chrome/Firefox)"]:::ui
        subgraph "JSP Views"
            Login["login.jsp"]:::ui
            Index["index.jsp"]:::ui
            Agregar["agregarUsuario.jsp"]:::ui
            Buscar["buscar.jsp"]:::ui
            Confirmar["confirmar.jsp"]:::ui
        end
    end

    %% Application Server & DevOps
    subgraph "Application Server"
        Tomcat["Tomcat Container\n(JSP Engine + Servlet API)"]:::server
        Build["Ant Build\n(build.xml)"]:::devops
        NB["NetBeans Metadata"]:::devops
    end

    %% Business/DAO Layer
    subgraph "Business/DAO Layer"
        DAO["Conexion.java"]:::dao
    end

    %% Infrastructure & Config
    subgraph "Infrastructure/Config"
        Manifest["MANIFEST.MF"]:::infra
        Context["context.xml"]:::infra
        Driver["mysql-connector-java.jar"]:::infra
    end

    %% Database Layer
    DB["MySQL Database\n(sistema_usuarios schema)"]:::db

    %% DevOps / Docs
    README["README.md"]:::devops

    %% Data Flows
    Browser -->|"HTTP GET/POST"| Tomcat
    Tomcat -->|"serves JSP"| Login
    Tomcat -->|"serves JSP"| Index
    Tomcat -->|"serves JSP"| Agregar
    Tomcat -->|"serves JSP"| Buscar
    Tomcat -->|"serves JSP"| Confirmar

    Login -->|"calls DAO methods"| DAO
    Index -->|"calls DAO methods"| DAO
    Agregar -->|"calls DAO methods"| DAO
    Buscar -->|"calls DAO methods"| DAO
    Confirmar -->|"calls DAO methods"| DAO

    DAO -->|"JDBC SELECT/INSERT/UPDATE/DELETE"| DB
    DB -->|"result set"| DAO
    DAO -->|"returns data"| Login
    DAO -->|"returns data"| Index
    DAO -->|"returns data"| Agregar
    DAO -->|"returns data"| Buscar
    DAO -->|"returns data"| Confirmar

    Login -->|"HTTP Response"| Browser
    Index -->|"HTTP Response"| Browser
    Agregar -->|"HTTP Response"| Browser
    Buscar -->|"HTTP Response"| Browser
    Confirmar -->|"HTTP Response"| Browser

    %% Config & Dependencies
    Context -->|"provides DataSource"| Tomcat
    Context -->|"provides DataSource"| DAO
    Driver -->|"loaded by"| Tomcat
    Manifest -->|"packaged in WAR"| Tomcat

    %% Build & Deployment
    Build -->|"builds WAR"| Tomcat
    NB -->|"deployment metadata"| Tomcat
    README -->|"build & run docs"| Build

    %% Click Events
    click Login "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/login.jsp"
    click Index "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/index.jsp"
    click Agregar "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/agregarUsuario.jsp"
    click Buscar "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/buscar.jsp"
    click Confirmar "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/confirmar.jsp"
    click Build "https://github.com/carlxsmedina/proyectoprg4/blob/main/build.xml"
    click NB "https://github.com/carlxsmedina/proyectoprg4/blob/main/nbproject/project.properties"
    click NB "https://github.com/carlxsmedina/proyectoprg4/blob/main/nbproject/ant-deploy.xml"
    click NB "https://github.com/carlxsmedina/proyectoprg4/blob/main/nbproject/build-impl.xml"
    click NB "https://github.com/carlxsmedina/proyectoprg4/blob/main/nbproject/genfiles.properties"
    click NB "https://github.com/carlxsmedina/proyectoprg4/blob/main/nbproject/project.xml"
    click DAO "https://github.com/carlxsmedina/proyectoprg4/blob/main/src/java/datos/Conexion.java"
    click Manifest "https://github.com/carlxsmedina/proyectoprg4/blob/main/src/conf/MANIFEST.MF"
    click Context "https://github.com/carlxsmedina/proyectoprg4/blob/main/web/META-INF/context.xml"
    click README "https://github.com/carlxsmedina/proyectoprg4/blob/main/README.md"

    %% Styles
    classDef ui fill:#D0E8FF,stroke:#0288D1,color:#000;
    classDef server fill:#D0F8D8,stroke:#2E7D32,color:#000;
    classDef dao fill:#FFF9C4,stroke:#F9A825,color:#000;
    classDef db fill:#FFE0B2,stroke:#EF6C00,color:#000;
    classDef infra fill:#E0E0E0,stroke:#9E9E9E,color:#000;
    classDef devops fill:#F3E5F5,stroke:#6A1B9A,color:#000;
```
