# java-connects-to-access/access architecture

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

- Interactive diagram: https://gitdiagram.com/java-connects-to-access/access
- Repository: https://github.com/java-connects-to-access/access

## Overview

##### Main Components

a) Client Layer (GUI):
- Java Swing-based GUI (StudentRecords.form/java)
- Use a rectangle with rounded corners to represent the user interface

b) Application Layer:
- Main Java application logic
- Connection management components
- Using a rectangular component

c) Database Connector Layer:
- UCanAccess as the middleware
- Supporting libraries (commons-lang3, commons-logging, hsqldb, jackcess)

d) Database Layer:
- Microsoft Access database (StudentRecords.accdb)

##### Connection Flow

**[GUI Layer] ↔ [Application Layer] ↔ [UCanAccess Connector] ↔ [MS Access Database]**

##### Specific Implementation Details

Key components:
- GUI Components
- StudentRecords Form
- Database Operations
- CRUD Operations
- Connection Management
- External Libraries
- UCanAccess Stack
- Date Picker Component

## Diagram (Mermaid)

```mermaid
graph TB
    %% Title
    title[("Student Records Management System<br/>Architecture Overview")]:::title

    %% Main Layers
    subgraph GUI
        gui["Student Records GUI<br/>(Java Swing)"]
        click gui "https://github.com/java-connects-to-access/access/blob/main/src/finalproj/StudentRecords.form"
        datePicker["Date Picker Component"]
        click datePicker "https://github.com/java-connects-to-access/access/blob/main/lib/LGoodDatePicker-11.2.1.jar"
    end

    subgraph AppLayer["Application Layer"]
        appLogic["CRUD Operations &<br/>Connection Management"]
        config["Project Configuration"]
        click config "https://github.com/java-connects-to-access/access/blob/main/nbproject/project.properties"
    end

    subgraph Connector["Database Connector Layer"]
        ucanaccess["UCanAccess 5.0.1"]
        click ucanaccess "https://github.com/java-connects-to-access/access/blob/main/lib/ucanaccess/ucanaccess-5.0.1.jar"
        commons["Commons Libraries<br/>(Lang3 & Logging)"]
        click commons "https://github.com/java-connects-to-access/access/blob/main/lib/ucanaccess/commons-lang3-3.8.1.jar"
        hsqldb["HSQLDB"]
        click hsqldb "https://github.com/java-connects-to-access/access/blob/main/lib/ucanaccess/hsqldb-2.5.0.jar"
        jackcess["Jackcess"]
        click jackcess "https://github.com/java-connects-to-access/access/blob/main/lib/ucanaccess/jackcess-3.0.1.jar"
    end

    subgraph DB["Database Layer"]
        msaccess[(Microsoft Access<br/>Database)]
        click msaccess "https://github.com/java-connects-to-access/access/blob/main/StudentRecords.accdb"
    end

    %% Connections
    gui --> appLogic
    datePicker --> gui
    appLogic --> ucanaccess
    ucanaccess --> commons
    ucanaccess --> hsqldb
    ucanaccess --> jackcess
    ucanaccess --> msaccess
    config --> appLogic

    %% Error Flow
    appLogic -.- |Error Handling| gui

    %% Styles
    classDef title fill:#f9f,stroke:#333,stroke-width:4px
    classDef default fill:#fff,stroke:#333,stroke-width:2px
    classDef gui fill:#b9e0ff,stroke:#333
    classDef app fill:#90ee90,stroke:#333
    classDef connector fill:#ffd700,stroke:#333
    classDef db fill:#dda0dd,stroke:#333

    class gui,datePicker gui
    class appLogic,config app
    class ucanaccess,commons,hsqldb,jackcess connector
    class msaccess db

    %% Legend
    subgraph Legend
        gui_legend["GUI Components"]:::gui
        app_legend["Application Components"]:::app
        connector_legend["Connector Components"]:::connector
        db_legend["Database Components"]:::db
    end
```
