# disha-satpute/library-managment architecture

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

- Interactive diagram: https://gitdiagram.com/disha-satpute/library-managment
- Repository: https://github.com/disha-satpute/library-managment

## Overview

Step 1 – Identify Project Type and Purpose
- This is a standalone Java-based Library Management desktop application.
- It comes in two flavors (MySQL and Oracle 10g) but shares the same 3-tier architecture:
– Presentation (UI forms & dashboards)
– Data access layer (DAO classes)
– Database (MySQL or Oracle)

Step 2 – Analyze the File Structure
- Top-level folders “Librarymgmt_MySql” and “Librarymgmt_Oracle10g” each contain:
– bin/ (compiled classes grouped into dao, model, ui)
– src/ (Java source packages: dao, model, ui, plus Main.java)
– lib/ (JDBC driver .jar)
– database.sql (schema & seed data)
- The src packages follow a classic Model-DAO-UI separation.
- Presence of Main.java in src indicates a single-process desktop application.

Step 3 – Examine README for Insights
- Confirms two supported database backends (MySQL & Oracle).

a. Main Components
1. Presentation Layer (Java Swing or AWT UIs):
- LoginForm, AdminDashboard, StudentDashboard, Profile forms
2. Business/Data-Access Layer (DAO classes):
- UserDAO, BookDAO, IssueDAO, DBConnection factory
3. Domain Model (POJOs):
- User, Book, Issue
4. Database Server (MySQL or Oracle 10g)
5. External Dependency: JDBC Driver (.jar)

b. Relationships & Interactions
- UI layer calls methods in DAO classes via Main.java orchestration.
- DAO layer uses DBConnection to open a JDBC connection (through the driver) to the target database.
- DAO methods perform CRUD operations on model objects and map result sets to POJOs.
- UI components display POJOs and send user actions back to DAOs.

c. Architectural Patterns / Principles
- Layered Architecture (Presentation → DAO → Database)
- DAO Pattern isolates persistence logic.
- POJO-based Domain Model.
- Single application process with pluggable JDBC driver for DB choice.

d. Key Technologies & Frameworks
- Java SE (Swing/AWT for UI)
- JDBC (Connector-Java & OJDBC)
- MySQL or Oracle 10g Express
- Standard Java packaging (bin vs. src)

- Because this is a desktop full-stack app (not web), emphasize:
– Pluggable driver as a side-component
- No microservices or REST/API layer – everything runs locally in one JVM.

Step 6 – Diagramming Guidelines
– UI → DAO → Database
– DAO → Model (for object mapping)
– Blue for UI components
– Green for DAO & Model
– Orange for external systems (DB & driver)

Step 7 – Emphasize Detail
- Every package and its responsibility.
- That Main.java is the application entry-point.
- That “database.sql” defines schema used by both DB options.
- Call out that switching between MySQL/Oracle is done by swapping the JDBC driver and connection URL in DBConnection.java.

## Diagram (Mermaid)

```mermaid
flowchart TD
    %% Application Process Container
    subgraph "Application Process"
        direction TB
        Main["Main.java"]:::ui

        subgraph "Presentation Layer"
            direction TB
            LoginForm["LoginForm"]:::ui
            AdminDashboard["AdminDashboard"]:::ui
            AdminProfile["AdminProfile"]:::ui
            StudentDashboard["StudentDashboard"]:::ui
            StudentProfile["StudentProfile"]:::ui
        end

        subgraph "Data Access Layer"
            direction TB
            UserDAO["UserDAO"]:::dao
            BookDAO["BookDAO"]:::dao
            IssueDAO["IssueDAO"]:::dao
            DBConnection["DBConnection"]:::dao
        end

        subgraph "Domain Model"
            direction TB
            User["User"]:::model
            Book["Book"]:::model
            Issue["Issue"]:::model
        end
    end

    %% External Components
    Database["MySQL or Oracle 10g\n(database.sql)"]:::external
    Driver["JDBC Driver"]:::external

    %% Relationships
    Main -->|启动 UI| LoginForm
    LoginForm -->|"calls"| UserDAO
    AdminDashboard -->|"calls"| BookDAO
    StudentDashboard -->|"calls"| IssueDAO
    AdminProfile -->|"calls"| UserDAO
    StudentProfile -->|"calls"| UserDAO

    UserDAO -->|"use"| DBConnection
    BookDAO -->|"use"| DBConnection
    IssueDAO -->|"use"| DBConnection

    UserDAO -->|"map ResultSet →"| User
    BookDAO -->|"map ResultSet →"| Book
    IssueDAO -->|"map ResultSet →"| Issue

    DBConnection -->|"connect()"| Database
    Driver -->|"provides JDBC"| DBConnection

    %% Click Events
    click Main "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/Main.java"
    click LoginForm "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/ui/LoginForm.java"
    click AdminDashboard "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/ui/AdminDashboard.java"
    click AdminProfile "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/ui/AdminProfile.java"
    click StudentDashboard "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/ui/StudentDashboard.java"
    click StudentProfile "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/ui/StudentProfile.java"

    click UserDAO "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/dao/UserDAO.java"
    click BookDAO "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/dao/BookDAO.java"
    click IssueDAO "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/dao/IssueDAO.java"
    click DBConnection "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/dao/DBConnection.java"

    click User "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/model/User.java"
    click Book "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/model/Book.java"
    click Issue "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/src/model/Issue.java"

    click Database "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/database.sql"
    click Driver "https://github.com/disha-satpute/library-managment/blob/main/Librarymgmt_MySql/lib/mysql-connector-java-8.0.30.jar"

    %% Styles
    classDef ui fill:#ADD8E6,stroke:#000
    classDef dao fill:#90EE90,stroke:#000
    classDef model fill:#98FB98,stroke:#000
    classDef external fill:#FFD580,stroke:#000
    class Main,LoginForm,AdminDashboard,AdminProfile,StudentDashboard,StudentProfile ui
    class UserDAO,BookDAO,IssueDAO,DBConnection dao
    class User,Book,Issue model
    class Database,Driver external
```
