📚 LibraryPro

Advanced Library Management System

A professional, feature-rich desktop application for day-to-day library operations.

---

✨ Features

Feature	Description
🔐 Authentication	Database-backed login with role support (admin / librarian)
📊 Live Dashboard	Real-time stats — total books, active members, issued books, overdue count
📚 Catalog Management	Add, edit, delete books with full-text search across title, author, ISBN, category
👥 Member Management	Register members with auto-generated IDs (LIB0001…), edit, search, deactivate
🔄 Circulation	Issue & return books with a 14-day loan window and ₹1/day overdue fine calculation
📋 Transaction History	Complete audit log with color-coded status: Returned / Active / Overdue
📂 Bulk Import	Import book records from CSV or Excel (.xlsx) with preview and duplicate skipping
🌙 Modern UI	FlatLaf dark theme with the Catppuccin Mocha color palette
💾 Persistent Storage	Local SQLite database (library.db) — no server setup required

---

🖥️ Screenshots

Add screenshots here by replacing the placeholder paths below.

Login	Dashboard
(Add screenshot)	(Add screenshot)

Books Catalog	Circulation
(Add screenshot)	(Add screenshot)

---

🚀 Quick Start

Prerequisites

Tool	Minimum Version	Download
Java JDK	11	Adoptium or Oracle
Git	Any	git-scm.com

1. Clone the repository

git clone https://github.com/adityatawde9699/LibraryPro.git
cd LibraryPro

2. Download dependencies

Windows (PowerShell):

powershell -ExecutionPolicy Bypass -File download_libs.ps1

Linux / macOS:

chmod +x build.sh
./build.sh deps

3. Compile

Windows:

compile.bat

Linux / macOS:

./build.sh compile

4. Run

Windows:

run.bat

Linux / macOS:

./build.sh run

Default credentials

Username	Password	Role
admin	admin	Administrator

⚠️ Change the default password after your first login via the settings panel.

---

📁 Project Structure

LibraryPro/
├── .github/
│   ├── workflows/
│   │   └── ci.yml              # GitHub Actions CI/CD pipeline
│   ├── ISSUE_TEMPLATE/
│   │   ├── bug_report.md
│   │   └── feature_request.md
│   └── PULL_REQUEST_TEMPLATE.md
│
├── models/                     # Plain data models (POJO)
│   ├── Book.java
│   ├── Member.java
│   ├── Transaction.java
│   └── User.java
│
├── database/                   # Data Access Objects + schema bootstrap
│   ├── DatabaseHelper.java     # Schema creation & DB connection
│   ├── BookDAO.java
│   ├── MemberDAO.java
│   ├── TransactionDAO.java
│   └── UserDAO.java
│
├── ui/                         # Swing views and dialogs
│   ├── UIUtils.java            # Shared styling constants (color palette, fonts)
│   ├── LoginView.java
│   ├── MainDashboard.java
│   ├── DashboardPanel.java
│   ├── BooksPanel.java
│   ├── BookFormDialog.java
│   ├── MembersPanel.java
│   ├── MemberFormDialog.java
│   ├── CirculationPanel.java
│   ├── HistoryPanel.java
│   └── ImportBooksDialog.java  # CSV + Excel bulk import
│
├── LibraryApp.java             # Application entry point
│
├── compile.bat                 # Windows build script
├── run.bat                     # Windows launch script
├── download_libs.ps1           # Windows dependency downloader
├── build.sh                    # Linux/macOS build + run script
│
├── .gitignore
├── CHANGELOG.md
├── CONTRIBUTING.md
├── LICENSE
├── SECURITY.md
└── README.md

---

📦 Dependencies

All dependencies are fetched from Maven Central by download_libs.ps1 / build.sh. They live in lib/ which is git-ignored — no bloated repository.

Library	Version	Purpose
SQLite JDBC	3.45.3.0	Local database engine
FlatLaf	3.4.1	Modern dark look-and-feel
SLF4J API	2.0.12	Logging facade (required by SQLite JDBC)
SLF4J Simple	2.0.12	Lightweight logging backend
Apache POI	5.3.0	Excel .xlsx file import
Apache POI OOXML	5.3.0	Excel Open XML support
XMLBeans	5.2.1	POI dependency
Commons Compress	1.26.1	POI dependency
Commons Collections 4	4.4	POI dependency
Commons Codec	1.16.1	POI dependency
Log4j API	2.23.1	POI dependency
Commons IO	2.15.1	POI dependency
CurvesAPI	1.08	POI dependency
SparseBitSet	1.3	POI dependency

---

📄 CSV Import Format

For bulk-importing books, prepare a .csv file with the following structure:

Title,Author,ISBN,Category,Year,Quantity
The Great Gatsby,F. Scott Fitzgerald,9780743273565,Fiction,1925,3
Clean Code,Robert C. Martin,9780132350884,Technology,2008,2

Rules:

• First row must be the header row.
• Title and Author are required. All other columns are optional.
• Column order does not matter.
• Duplicate ISBNs are automatically skipped (no overwriting existing records).
• Supported formats: .csv and .xlsx

---

🏗️ Architecture

The project follows a clean, layered MVC (Model-View-Controller) architecture.

graph TD
    %% Node Definitions
    UI["💻 UI Layer (View)<br/><font size=2>javax.swing + FlatLaf</font>"]
    DAO["🗄️ Data Access Layer (Controller)<br/><font size=2>JDBC + DAO Pattern</font>"]
    DB[("💾 Database<br/><font size=2>library.db (SQLite)</font>")]
    Model["📦 Models (POJO)<br/><font size=2>Book, Member, User...</font>"]

    %% Relationships
    UI -->|invokes| DAO
    DAO -->|reads/writes| DB
    DAO -.->|populates| Model
    Model -.->|displayed by| UI

    %% Styling
    classDef ui fill:#89b4fa,stroke:#313244,stroke-width:2px,color:#11111b;
    classDef dao fill:#a6e3a1,stroke:#313244,stroke-width:2px,color:#11111b;
    classDef db fill:#f38ba8,stroke:#313244,stroke-width:2px,color:#11111b;
    classDef model fill:#fab387,stroke:#313244,stroke-width:2px,color:#11111b;

    class UI ui;
    class DAO dao;
    class DB db;
    class Model model;

Loading

Note: No external framework controller is used. Each Swing panel acts as its own controller, keeping the codebase approachable for contributors familiar only with standard Java SE.

---

🤝 Contributing

We welcome contributions! Please read CONTRIBUTING.md before submitting a pull request.

1. Fork the repository
2. Create a feature branch: git checkout -b feature/your-feature-name
3. Commit your changes: git commit -m "feat: add your feature"
4. Push to your fork: git push origin feature/your-feature-name
5. Open a Pull Request

---

🔒 Security

Found a security vulnerability? Please read SECURITY.md before filing a public issue.

---

📝 Changelog

See CHANGELOG.md for a full version history.

---

📜 License

This project is licensed under the MIT License — see LICENSE for details.

---

Made with ❤️ by the LibraryPro contributors