📚 Library Management System

A backend mini project built using Spring Boot and Spring JDBC that demonstrates CRUD operations with a layered architecture and H2 Database.

---

🚀 Features

• ➕ Add a Book
• 📖 View All Books
• 🔍 Find Book by ID
• ✏️ Update Book Details
• ❌ Delete Book
• 👨‍💻 Search Books by Author
• 📘 Search Book by Title
• 📊 Count Total Books
• 🔤 Sort Books by Title
• ♻️ Reusable RowMapper Implementation

---

🛠️ Technologies Used

• Java 21
• Spring Boot
• Spring JDBC
• H2 Database
• Maven
• IntelliJ IDEA

---

📂 Project Structure

src
 ├── model
 │     └── Book.java
 │
 ├── repo
 │     └── BookRepository.java
 │
 ├── service
 │     └── BookService.java
 │
 ├── LibraryManagementApplication.java
 │
 └── resources
       ├── application.properties
       ├── schema.sql
       └── data.sql

---

📌 CRUD Operations

• Create Book
• Read All Books
• Read Book by ID
• Update Book
• Delete Book

---

🔎 Additional Features

• Search by Author
• Search by Title
• Count Books
• Sort Books by Title

---

💡 Concepts Practiced

• Spring IoC Container
• Dependency Injection
• JdbcTemplate
• RowMapper
• SQL Queries
• Layered Architecture
• H2 Database Integration

---

▶️ How to Run

1. Clone the repository.
2. Open the project in IntelliJ IDEA.
3. Build the project using Maven.
4. Run LibraryManagementApplication.java.
5. View the console output.

---

👨‍💻 Author

Nabin Gayak H

GitHub: https://github.com/NABINGAYAKH