Library Management System
A comprehensive Java-based Library Management System that demonstrates two different implementation approaches: using Java Collections and JDBC with MySQL database.
📚 Overview
This Library Management System provides a complete solution for managing library operations, including book management, user administration, and transaction handling. The system offers two distinct implementations:
Collections-based implementation - Uses Java Collections Framework for data storage
JDBC-based implementation - Uses MySQL database with JDBC connectivity
✨ Features
Core Functionality
Book Management: Add, remove, search, and list books
User Management: Admin and user role-based access
Transaction Handling: Issue and return books
Search Operations: Search by book ID, title, or author
Admin Features
View admin and user details
Manage book inventory
Add/remove users
Monitor issued books
Complete library administration
User Features
Browse available books
Issue and return books
Search books using multiple criteria
View issued books
🛠️ Technologies Used
Java - Core programming language
Java Collections Framework - For in-memory data storage
JDBC - Database connectivity
MySQL - Database management system
Scanner Class - For user input handling
📋 Prerequisites
Before running this project, ensure you have:
Java Development Kit (JDK) 8 or higher
MySQL Server installed and running
MySQL Connector/J (JDBC driver)
IDE (Eclipse, IntelliJ IDEA, or any Java IDE)