📚 Library Management System

A full-stack Library Management System built with Java, Spring Boot, Spring Security, Thymeleaf, JDBC, and MySQL.

The application provides a secure, role-based platform for managing books, librarians, and library operations. It follows the MVC architecture and demonstrates enterprise-level backend development practices using Spring Boot.

---

🚀 Features

👨‍💼 Admin

• Secure Admin Login
• Dashboard
• Add Librarian
• View Librarians
• Update Librarian Details
• Delete Librarian
• View Profile

👩‍💻 Librarian

• Secure Login
• Dashboard
• Add Books
• Update Books
• Delete Books
• Search Books
• View Book Details
• View Profile

📖 Library Operations

• Issue Books
• Return Books
• Manage Book Records
• Export Data to Excel
• BCrypt Password Encryption
• Role-Based Authentication using Spring Security

---

🛠️ Tech Stack

Technology	Description
Java	Programming Language
Spring Boot	Backend Framework
Spring Security	Authentication & Authorization
Thymeleaf	Server-side Templating
JDBC	Database Connectivity
MySQL	Relational Database
Maven	Build Tool
Bootstrap 5	Responsive UI
Apache POI	Excel Export

---

🏗️ Architecture

Browser
    │
    ▼
Spring Boot MVC
    │
    ▼
Controllers
    │
    ▼
Services
    │
    ▼
Repositories (JDBC)
    │
    ▼
MySQL Database

---

📂 Project Structure

LibraryManagementSystem
│
├── src
│   ├── main
│   │   ├── java
│   │   └── resources
│   │       ├── static
│   │       ├── templates
│   │       ├── application.properties
│   │       ├── schema.sql
│   │       └── data.sql
│   │
│   └── test
│
├── pom.xml
├── mvnw
└── README.md

---

📸 Application Screenshots

🔐 Login

---

👨‍💼 Add Librarian

---

👩‍💻 Librarian Dashboard

---

👥 View Librarians

---

📚 Add Book

---

📖 View Books

---

🏠 Home

⚙️ Installation

Clone the repository

git clone https://github.com/<your-username>/Library-management-system.git

Navigate to the project

cd Library-management-system

Run the application

./mvnw spring-boot:run

Open:

http://localhost:8081

---

🗄️ Database Setup

1. Create a MySQL database.
2. Update application.properties with your database credentials.
3. Run the application.
4. Spring Boot will initialize the schema and sample data automatically.

---

🔐 Authentication

The application uses:

• Spring Security
• BCrypt Password Encryption
• Role-Based Access Control

---

🌱 Future Enhancements

• REST API Integration
• JWT Authentication
• Email Notifications
• Book Reservation System
• Fine Management
• Docker Support
• Unit & Integration Tests
• CI/CD Pipeline

---

👨‍💻 Author

Sudhir Sahoo

Java Backend Developer

• Java
• Spring Boot
• Spring Security
• MySQL
• REST APIs
• Microservices

---

⭐ If you found this project useful, consider giving it a star!