# tungnguyensnk/projectquanlydancu architecture

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

- Interactive diagram: https://gitdiagram.com/tungnguyensnk/projectquanlydancu
- Repository: https://github.com/tungnguyensnk/projectquanlydancu

## Overview

##### Project type and purpose
- This is a standalone Java desktop application built with JavaFX (FXML + controllers), backed by a MySQL database.
- It manages “nhân khẩu” (population) data, household registrations, complaints/cases (Case1..Case4), health declarations, and daily records.
- It uses external libraries: JDBC (for MySQL), JSON API, Apache POI (for reading/writing .xlsx), and JavaFX.

##### File structure
- src/com/project1/Main – contains Main.java, controllers (Controller.java, Alert.java, GiaoTiep.java), FXMLs (login.fxml, menu.fxml, alert.fxml).
- src/com/project1/Case1–Case4 – each “Case#” folder holds FXML view files and Java classes (controllers and models) for specific functionality (e.g., ChinhSuaNhanKhau, ToKhaiYTeHangNgay).
- src/com/project1/img + center.css, table.css – resources for UI styling and images.
- META-INF/MANIFEST.MF – packaging metadata.
- Top-level SQL/Excel/Word files (danso.sql, hokhau.xlsx, nhankhau.xlsx, etc.) are data fixtures or templates.

##### Key insights from README
- Requires JDBC, JSON API, Apache POI, JavaFX libraries on the classpath.
- MySQL database schema is provided in danso.sql.

##### Components
a. UI Layer (JavaFX)
– FXML view files (login.fxml, menu.fxml, change1.fxml, Case41.fxml, etc.)
– CSS files (center.css, table.css)
– Images (img folder)
b. Controller Layer (MVC Controllers)
– Main controllers (Controller, Alert, GiaoTiep)
– Case-specific controllers (Change1.java, Case41Controller.java, etc.)
c. Service / Business Logic Layer
– Data validation, transformation, JSON processing
– Health-declaration logic (ToKhaiYTeHangNgayGiaoTiep)
d. Data Access Layer (DAO)
– JDBC connector classes (HoKhau.java, NhanKhau.java, LichSH.java)
– CRUD operations to MySQL
e. External Libraries
– JDBC driver (mysql-connector)
– JSON API (parsing/serialization)
– Apache POI (reading/writing .xlsx)
– JavaFX runtime
f. Database
– MySQL (tables for nhân khẩu, hộ khẩu, cases, health logs)
– Schema imported from danso.sql

##### Relationships and interactions
- UI (FXML) → Controller: user events (clicks, form submissions)
- Controller → Service: business-rule execution, JSON parsing
- Service → DAO: data persistence and retrieval (via JDBC)
- DAO → MySQL: SQL queries, result sets
- Service → Apache POI: import/export Excel data
- Controller → Alert: pop-up dialogs (Alert.java)
- Main → Case modules: navigation (Menu → Case1..Case4 modules)

##### Architectural patterns
- MVC: FXML views (View), Controller classes (Controller), Model/DAO (Data)
- Layered architecture: UI → Controllers → Services → DAO → Database
- Resource separation: static assets (CSS, images) are in dedicated folders

##### Essential architectural elements to capture
- The MVC layering and flow from View → Controller → Service → DAO → Database
- How FXML files map to specific Controller classes in each Case module
- The use of Apache POI and JSON API in the Service layer
- The JDBC-based DAO connecting to MySQL tables from danso.sql
- Navigation component (Menu) orchestrating Case1–Case4 modules

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% UI Layer
    subgraph "UI Layer"
        direction TB
        Login["login.fxml"]:::ui
        MenuFXML["menu.fxml"]:::ui
        AlertFXML["alert.fxml"]:::ui
        Case1FXML["Case1 FXML Views"]:::ui
        Case2FXML["Case2 FXML Views"]:::ui
        Case3FXML["Case3 FXML Views"]:::ui
        Case4FXML["Case4 FXML Views"]:::ui
        CenterCSS["center.css"]:::resource
        TableCSS["table.css"]:::resource
        IMG["img/"]:::resource
    end

    %% Controller Layer
    subgraph "Controller Layer"
        direction TB
        MainControllers["Main Controllers"]:::controller
        CaseControllers["Case-specific Controllers"]:::controller
    end

    %% Service Layer
    subgraph "Service Layer"
        direction TB
        JSONHelper["GiaoTiep (JSON/API helper)"]:::service
        HealthDaily["ToKhaiYTeHangNgayGiaoTiep"]:::service
        HealthRecord["SucKhoeNguoiDanGiaoTiep"]:::service
    end

    %% DAO Layer
    subgraph "DAO Layer"
        direction TB
        HoKhau["HoKhau DAO"]:::dao
        NhanKhau["NhanKhau DAO"]:::dao
        LichSH["LichSH DAO"]:::dao
    end

    %% Database
    DB["MySQL Database"]:::db

    %% External Libraries
    subgraph "External Libraries"
        direction TB
        JDBC["JDBC Driver"]:::external
        JSONAPI["JSON API"]:::external
        POI["Apache POI"]:::external
        JavaFX["JavaFX Runtime"]:::external
    end

    %% Relationships
    Login -->|"loadFXML()"| MainControllers
    MenuFXML -->|"loadFXML()"| MainControllers
    AlertFXML -->|"loadFXML()"| MainControllers
    Case1FXML -->|"loadFXML()"| CaseControllers
    Case2FXML -->|"loadFXML()"| CaseControllers
    Case3FXML -->|"loadFXML()"| CaseControllers
    Case4FXML -->|"loadFXML()"| CaseControllers
    CenterCSS -->|"styles applied"| Login
    CenterCSS -->|"styles applied"| MenuFXML
    TableCSS -->|"styles applied"| Case1FXML
    IMG -->|"resources loaded"| Login

    MainControllers -->|"invoke()"| JSONHelper
    MainControllers -->|"navigate()"| CaseControllers
    CaseControllers -->|"useService()"| JSONHelper
    CaseControllers -->|"useService()"| HealthDaily
    CaseControllers -->|"useService()"| HealthRecord

    JSONHelper -->|"validate/transform()"| HoKhau
    HealthDaily -->|"dailyLogic()"| NhanKhau
    HealthRecord -->|"recordLogic()"| LichSH

    HoKhau -->|"executeQuery()"| DB
    NhanKhau -->|"executeQuery()"| DB
    LichSH -->|"executeQuery()"| DB

    JSONHelper -.->|"parsing"| JSONAPI
    HealthDaily -->|"exportExcel()"| POI
    JSONHelper -->|"parse/serialize"| JSONAPI
    HoKhau -->|"connect()"| JDBC
    NhanKhau -->|"connect()"| JDBC
    LichSH -->|"connect()"| JDBC

    DB -.->|"schema imported"| danso_sql

    JavaFX -.-> Login
    JavaFX -.-> MenuFXML
    JavaFX -.-> AlertFXML
    JavaFX -.-> Case1FXML
    JavaFX -.-> Case2FXML
    JavaFX -.-> Case3FXML
    JavaFX -.-> Case4FXML

    %% Click Events
    click Login "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/login.fxml"
    click MenuFXML "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/menu.fxml"
    click AlertFXML "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/alert.fxml"
    click Case1FXML "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case1/"
    click Case2FXML "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case2/"
    click Case3FXML "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case3/"
    click Case4FXML "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case4/"
    click CenterCSS "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/center.css"
    click TableCSS "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/table.css"
    click IMG "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/img/"
    click MainControllers "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/Controller.java"
    click MainControllers "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/Alert.java"
    click MainControllers "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/GiaoTiep.java"
    click MainControllers "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/Menu.java"
    click CaseControllers "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case1/"
    click CaseControllers "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case2/"
    click CaseControllers "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case3/"
    click CaseControllers "https://github.com/tungnguyensnk/projectquanlydancu/tree/master/src/com/project1/Case4/"
    click JSONHelper "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/GiaoTiep.java"
    click HealthDaily "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Case4/ToKhaiYTeHangNgayGiaoTiep.java"
    click HealthRecord "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Case4/SucKhoeNguoiDanGiaoTiep.java"
    click HoKhau "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/HoKhau.java"
    click NhanKhau "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/NhanKhau.java"
    click LichSH "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/src/com/project1/Main/LichSH.java"
    click danso_sql "https://github.com/tungnguyensnk/projectquanlydancu/blob/master/danso (5).sql"

    %% Styles
    classDef ui fill:#E8F4FC,stroke:#333,stroke-width:1px
    classDef controller fill:#FDEBD0,stroke:#333,stroke-width:1
```
