LIBRARY MANAGEMENT SYSTEM📚

#Project Overview:

This Library Management System is a web-based application designed to help manage a library’s book collection. It allows users to add, update, delete, and view books. Built using Java Servlet, JSP, and JDBC, this system provides a user-friendly interface for efficient management of books and their details.

#Technologies Used:

• Frontend: HTML, JSP (Java Server Pages)
• Backend: Java Servlets, JDBC (Java Database Connectivity)
• Database: MySQL
• Development Environment: NetBeans 8.2, XAMPP Server (for running MySQL)

#Features:

• Add Book: Users can add a new book to the library by providing details like book name, author, and category.
• Update Book: Users can update the details of an existing book.
• Delete Book: Users can delete a book from the list.
• View Books: Users can view a list of all books in the library, including their details.

#Database Schema: Books Table:

• BookId (INT) (Primary Key, Auto Increment)
• BookName (VARCHAR)
• AuthorName (VARCHAR)
• Category (VARCHAR)

#How to Run the Project:

1. Clone or download the project from GitHub.
2. Set up XAMPP and start the Apache and MySQL servers.
3. Create a database named library in MySQL.
4. Run the provided SQL script to create the books table in your library database.
5. Import the project into NetBeans and configure the MySQL connection using JDBC.
6. Deploy the project and access it in the browser at http://localhost:8080/LibraryManagementSystem.

#Output: