# johnathaningle/cis-232-final-project architecture

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

- Interactive diagram: https://gitdiagram.com/johnathaningle/cis-232-final-project
- Repository: https://github.com/johnathaningle/cis-232-final-project

## Overview

This is a JavaFX computer-parts ordering application backed by an embedded Derby database. The main workflow starts in the desktop GUI: customers log in or register, browse parts or presets, build an order, check its total, and submit it; the GUI also provides order views. Startup resets and seeds the database before launching the interface. The graph separates UI, customer/order/catalog domain logic, database setup, and SQL access. Source excerpts show the main calls; connections for other controller operations follow their indexed imports, while unsampled implementation details are not inferred.

Main entry points: [`Source/src/main/java/MainGUI.java`](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/MainGUI.java) (JavaFX Interface), [`Source/src/main/java/Services/ExecuteSelect.java`](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteSelect.java) (Query Execution), [`Source/src/main/java/BootstrapDB/BootstrapDB.java`](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/BootstrapDB/BootstrapDB.java) (Database Bootstrap), [`Source/src/main/java/Services/ExecuteUpdate.java`](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteUpdate.java) (Update Execution)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_startup["Startup and Setup"]
  node_main["Application Launcher<br/>[Main.java]"]
  node_bootstrap["Database Bootstrap<br/>[BootstrapDB.java]"]
  node_ddl["Table Definitions"]
  node_seed["Initial Data"]
end

subgraph group_interface["Desktop Interface"]
  node_gui["JavaFX Interface<br/>[MainGUI.java]"]
end

subgraph group_domain["Ordering Domain"]
  node_customers["Customer Accounts"]
  node_parts["Parts Catalog"]
  node_presets["Build Presets"]
  node_orders["Order Management"]
end

subgraph group_persistence["Database Access"]
  node_config["Database Configuration<br/>[Config.java]"]
  node_create_db["Database Creation<br/>[CreateDB.java]"]
  node_generic["Generic SQL Execution"]
  node_select["Query Execution<br/>[ExecuteSelect.java]"]
  node_update["Update Execution<br/>[ExecuteUpdate.java]"]
end

node_customer(("Customer"))
node_db[("Embedded Derby")]

node_customer -->|"uses"| node_gui
node_main -->|"resets database"| node_bootstrap
node_main -->|"launches"| node_gui
node_bootstrap -->|"creates database"| node_create_db
node_bootstrap -->|"executes setup SQL"| node_generic
node_bootstrap -->|"reads definitions"| node_ddl
node_bootstrap -->|"reads seed data"| node_seed
node_gui -->|"handles accounts"| node_customers
node_gui -->|"shows catalog"| node_parts
node_gui -->|"shows presets"| node_presets
node_gui -->|"manages orders"| node_orders
node_customers -->|"queries"| node_select
node_customers -->|"writes account"| node_update
node_parts -->|"queries"| node_select
node_presets -->|"queries"| node_select
node_orders -->|"queries orders"| node_select
node_orders -->|"changes orders"| node_update
node_create_db -->|"uses settings"| node_config
node_generic -->|"uses settings"| node_config
node_select -->|"uses settings"| node_config
node_update -->|"uses settings"| node_config
node_create_db -->|"creates"| node_db
node_generic -->|"executes SQL"| node_db
node_select -->|"reads"| node_db
node_update -->|"writes"| node_db

click node_main "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Main.java"
click node_bootstrap "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/BootstrapDB/BootstrapDB.java"
click node_ddl "https://github.com/johnathaningle/cis-232-final-project/tree/master/Source/src/main/java/BootstrapDB/DDL"
click node_seed "https://github.com/johnathaningle/cis-232-final-project/tree/master/Source/src/main/java/BootstrapDB/INSERT"
click node_gui "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/MainGUI.java"
click node_customers "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/CustomersController.java"
click node_parts "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/PartsController.java"
click node_presets "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/PresetsController.java"
click node_orders "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/OrdersController.java"
click node_config "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Configuration/Config.java"
click node_create_db "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/CreateDB.java"
click node_generic "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteGeneric.java"
click node_select "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteSelect.java"
click node_update "https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteUpdate.java"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_main,node_bootstrap,node_ddl,node_seed toneBlue
class node_gui,node_db toneAmber
class node_customers,node_parts,node_presets,node_orders toneMint
class node_config,node_create_db,node_generic,node_select,node_update toneRose
class node_customer toneIndigo
```

## Components

### Startup and Setup

- [Application Launcher](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Main.java): `Source/src/main/java/Main.java`
- [Database Bootstrap](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/BootstrapDB/BootstrapDB.java): `Source/src/main/java/BootstrapDB/BootstrapDB.java`
- [Table Definitions](https://github.com/johnathaningle/cis-232-final-project/tree/master/Source/src/main/java/BootstrapDB/DDL): `Source/src/main/java/BootstrapDB/DDL`
- [Initial Data](https://github.com/johnathaningle/cis-232-final-project/tree/master/Source/src/main/java/BootstrapDB/INSERT): `Source/src/main/java/BootstrapDB/INSERT`

### Desktop Interface

- [JavaFX Interface](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/MainGUI.java): `Source/src/main/java/MainGUI.java`

### Ordering Domain

- [Customer Accounts](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/CustomersController.java): `Source/src/main/java/Controllers/CustomersController.java`
- [Parts Catalog](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/PartsController.java): `Source/src/main/java/Controllers/PartsController.java`
- [Build Presets](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/PresetsController.java): `Source/src/main/java/Controllers/PresetsController.java`
- [Order Management](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Controllers/OrdersController.java): `Source/src/main/java/Controllers/OrdersController.java`

### Database Access

- [Database Configuration](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Configuration/Config.java): `Source/src/main/java/Configuration/Config.java`
- [Database Creation](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/CreateDB.java): `Source/src/main/java/Services/CreateDB.java`
- [Generic SQL Execution](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteGeneric.java): `Source/src/main/java/Services/ExecuteGeneric.java`
- [Query Execution](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteSelect.java): `Source/src/main/java/Services/ExecuteSelect.java`
- [Update Execution](https://github.com/johnathaningle/cis-232-final-project/blob/master/Source/src/main/java/Services/ExecuteUpdate.java): `Source/src/main/java/Services/ExecuteUpdate.java`

### Other components

- **Customer**
- **Embedded Derby**

## Connections

- Customer → JavaFX Interface: uses
- Application Launcher → Database Bootstrap: resets database (evidence: `Source/src/main/java/Main.java`)
- Application Launcher → JavaFX Interface: launches (evidence: `Source/src/main/java/Main.java`)
- Database Bootstrap → Database Creation: creates database (evidence: `Source/src/main/java/BootstrapDB/BootstrapDB.java`)
- Database Bootstrap → Generic SQL Execution: executes setup SQL (evidence: `Source/src/main/java/BootstrapDB/BootstrapDB.java`)
- Database Bootstrap → Table Definitions: reads definitions (evidence: `Source/src/main/java/BootstrapDB/BootstrapDB.java`)
- Database Bootstrap → Initial Data: reads seed data (evidence: `Source/src/main/java/BootstrapDB/BootstrapDB.java`)
- JavaFX Interface → Customer Accounts: handles accounts (evidence: `Source/src/main/java/MainGUI.java`)
- JavaFX Interface → Parts Catalog: shows catalog (evidence: `Source/src/main/java/MainGUI.java`)
- JavaFX Interface → Build Presets: shows presets (evidence: `Source/src/main/java/MainGUI.java`)
- JavaFX Interface → Order Management: manages orders (evidence: `Source/src/main/java/MainGUI.java`)
- Customer Accounts → Query Execution: queries (evidence: `Source/src/main/java/Controllers/CustomersController.java`)
- Customer Accounts → Update Execution: writes account (evidence: `Source/src/main/java/Controllers/CustomersController.java`)
- Parts Catalog → Query Execution: queries (evidence: `Source/src/main/java/Controllers/PartsController.java`)
- Build Presets → Query Execution: queries (evidence: `Source/src/main/java/Controllers/PresetsController.java`)
- Order Management → Query Execution: queries orders (evidence: `Source/src/main/java/Controllers/OrdersController.java`)
- Order Management → Update Execution: changes orders (evidence: `Source/src/main/java/Controllers/OrdersController.java`)
- Database Creation → Database Configuration: uses settings (evidence: `Source/src/main/java/Services/CreateDB.java`)
- Generic SQL Execution → Database Configuration: uses settings (evidence: `Source/src/main/java/Services/ExecuteGeneric.java`)
- Query Execution → Database Configuration: uses settings (evidence: `Source/src/main/java/Services/ExecuteSelect.java`)
- Update Execution → Database Configuration: uses settings (evidence: `Source/src/main/java/Services/ExecuteUpdate.java`)
- Database Creation → Embedded Derby: creates (evidence: `Source/src/main/java/Services/CreateDB.java`)
- Generic SQL Execution → Embedded Derby: executes SQL (evidence: `Source/src/main/java/Services/ExecuteGeneric.java`)
- Query Execution → Embedded Derby: reads (evidence: `Source/src/main/java/Services/ExecuteSelect.java`)
- Update Execution → Embedded Derby: writes (evidence: `Source/src/main/java/Services/ExecuteUpdate.java`)
