Home

Library Management System Documentation

This documentation provides an overview of the Java-based Library Management System. The system is designed to manage a library's book inventory, member information, and book borrowing/returning activities.

---

Table of Contents
Introduction
Setup
Functionality

1. Add New Book
2. Update Book Information
3. Check Book Availability
4. Delete Book
5. Display All Books
6. Borrow Book
7. Return Book
8. Generate Reports
9. Add Member
10. Delete Member
11. Update Member Information
    Usage
    Closing the Application

Introduction

The Library Management System is implemented in Java and uses a MySQL database to store book and member information. It provides a menu-based interface for users to interact with the system. The system includes features such as adding, updating, deleting, and displaying books, borrowing and returning books, generating reports, and managing member information.

Setup

Before using the Library Management System, ensure that you have set up a MySQL database named "library" with appropriate tables. Update the database connection details in the LibraryManagement constructor:

Copy code
connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/library", "root", "<password>");

Functionality

1. Add New Book
   This option allows users to add a new book to the library inventory. Users are prompted to enter the book's title, author, publisher, date of issue, and issue status.

2. Update Book Information
   Users can update information for an existing book by providing the book ID. They can modify the title, author, publisher, date of issue, and issue status.

3. Check Book Availability
   Users can check the availability of a book by entering its ID. The system displays whether the book is currently issued or available on the shelf.

4. Delete Book
   This option allows users to delete a book from the library inventory by providing its ID.

5. Display All Books
   Users can view a list of all books in the library, including details such as book ID, title, author, publisher, date of issue, and issue status.

6. Borrow Book
   Members can borrow a book by entering their member ID and the book ID. The system checks if the book is available and updates its status to "Issued." The book is then assigned to the member.

7. Return Book
   Members can return a book by providing their member ID. The system retrieves the book ID borrowed by the member, updates the book status to "InShelf," and removes the book from the member's records.

8. Generate Reports
   This option generates a report showing the count of books for each author in the library.

9. Add Member
   Users can add a new member to the system by entering their member ID and name.

10. Delete Member
    Users can delete a member from the system by providing their member ID.

11. Update Member Information
    Users can update a member's information by entering their member ID and providing the new member name.

Usage

To use the Library Management System, run the main method in the LibraryManagement class. The system will present a menu with various options. Enter the corresponding number to access the desired functionality.

Closing the Application

To close the application and release resources, select option 12 from the menu. The system will close the database connection and exit the program.

Feel free to explore and modify the code to meet your specific requirements. Enjoy using the Library Management System!

Check out the documenta