# devanshumarkam/airline_management_system architecture

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

- Interactive diagram: https://gitdiagram.com/devanshumarkam/airline_management_system
- Repository: https://github.com/devanshumarkam/airline_management_system

## Overview

##### Project type and purpose
- This is a standalone desktop “full-stack” airline management system written in Java Swing/AWT, using a MySQL backend.
- It supports two user roles (Admin, Customer) for adding customers, booking/canceling flights, viewing journey details, and generating boarding passes.

##### File structure
Top-level Java classes (each one is a Swing form + controller logic):
- Login.java
- Home.java
- AddCustomer.java
- Flightinfo.java
- BookFlight.java
- JourneyDetails.java
- Cancel.java
- BoardingPass.java
Data-access helper:
- Conn.java (manages JDBC connection & executes SQL)
UI resources folder:

##### README insights
- Technologies: Java Swing/AWT (presentation), MySQL (storage), NetBeans (IDE)
- Workflow: CRUD operations on customer, flight, reservation, cancellation, boarding pass; PNR generation; lookups by Aadhaar/PNR.

##### Main components
a. Presentation Layer (Desktop Client)
- Sub-components: Login Screen, Home Dashboard, Customer Form, Flight Search, Booking Form, Journey Details Viewer, Cancellation Form, Boarding Pass Generator
- Resource bundle: Images/
b. Data Access Layer
- Conn.java (JDBC Connection Pool or singleton)
- SQL operations: INSERT (customers, reservations), SELECT (flight list, customer data, journey details), UPDATE/DELETE (cancellations)
c. Database
- MySQL Server
- Schema with tables: login, customer, flight, reservation (PNR), cancellation, boarding_pass
d. External/Infrastructure
- MySQL JDBC Driver
- NetBeans Project configuration (build scripts, library references)

##### Relationships & data flow
- User interacts with a Swing form → form logic invokes Conn.java → Conn opens JDBC socket to MySQL → executes SQL → returns ResultSet → form renders data or confirmation.
- PNR generator resides in BookFlight.java (business logic).
- Cancellation and boarding-pass screens fetch all data from DB using PNR.

##### Architectural patterns & principles
- Layered Architecture: UI layer (Swing) → Data Access layer (Conn.java) → Database
- Single-process monolith: no microservices or HTTP/API.
- MVC‐inspired separation: Forms = view + controller, Conn.java = model/DAO.

## Diagram (Mermaid)

```mermaid
flowchart TD
  subgraph "Presentation Layer"
    direction TB
    Login["Login Screen"]:::presentation
    Home["Home Dashboard"]:::presentation
    AddCustomer["Add Customer Form"]:::presentation
    Flightinfo["Flight Search"]:::presentation
    BookFlight["Booking Form (PNR Generation)"]:::presentation
    JourneyDetails["Journey Details Viewer"]:::presentation
    Cancel["Cancellation Form"]:::presentation
    BoardingPass["Boarding Pass Generator"]:::presentation
    Images["UI Resources (Images/)"]:::external
  end

  Conn["Conn.java - JDBC DAO"]:::dao
  MySQL["MySQL DB"]:::db
  Driver["MySQL JDBC Driver"]:::external
  NetBeans["NetBeans IDE"]:::external

  %% UI to DAO calls and returns
  Login -->|"JDBC call"| Conn
  Conn -->|"ResultSet → UI render"| Login

  Home -->|"JDBC call"| Conn
  Conn -->|"ResultSet → UI render"| Home

  AddCustomer -->|"JDBC call"| Conn
  Conn -->|"ResultSet → UI render"| AddCustomer

  Flightinfo -->|"JDBC call"| Conn
  Conn -->|"ResultSet → UI render"| Flightinfo

  BookFlight -->|"JDBC call (includes PNR generation)"| Conn
  Conn -->|"ResultSet → UI render"| BookFlight

  JourneyDetails -->|"JDBC call (PNR lookup)"| Conn
  Conn -->|"ResultSet → UI render"| JourneyDetails

  Cancel -->|"JDBC call (cancellation)"| Conn
  Conn -->|"ResultSet → UI render"| Cancel

  BoardingPass -->|"JDBC call (boarding pass)"| Conn
  Conn -->|"ResultSet → UI render"| BoardingPass

  %% Resources to UI
  Images -.-> Login
  Images -.-> Home
  Images -.-> AddCustomer
  Images -.-> Flightinfo
  Images -.-> BookFlight
  Images -.-> JourneyDetails
  Images -.-> Cancel
  Images -.-> BoardingPass

  %% DAO to DB
  Conn -->|"SQL query/response"| MySQL
  MySQL -->|"ResultSet"| Conn

  %% External dependencies
  Driver --> Conn
  NetBeans --> Login

  %% Click Events
  click Login "https://github.com/devanshumarkam/airline_management_system/blob/master/Login.java"
  click Home "https://github.com/devanshumarkam/airline_management_system/blob/master/Home.java"
  click AddCustomer "https://github.com/devanshumarkam/airline_management_system/blob/master/AddCustomer.java"
  click Flightinfo "https://github.com/devanshumarkam/airline_management_system/blob/master/Flightinfo.java"
  click BookFlight "https://github.com/devanshumarkam/airline_management_system/blob/master/BookFlight.java"
  click JourneyDetails "https://github.com/devanshumarkam/airline_management_system/blob/master/JourneyDetails.java"
  click Cancel "https://github.com/devanshumarkam/airline_management_system/blob/master/Cancel.java"
  click BoardingPass "https://github.com/devanshumarkam/airline_management_system/blob/master/BoardingPass.java"
  click Images "https://github.com/devanshumarkam/airline_management_system/tree/master/Images/"
  click Conn "https://github.com/devanshumarkam/airline_management_system/blob/master/Conn.java"

  %% Styles
  classDef presentation fill:#cfe2f3,stroke:#036; 
  classDef dao fill:#d5ead1,stroke:#090; 
  classDef db fill:#f9cb9c,stroke:#f60; 
  classDef external fill:#eeeeee,stroke:#999;
```
