Library Management System

A full stack Library Management System built using Core Java, JDBC, MySQL, Node.js, HTML and CSS.

Technologies Used

• Core Java
• JDBC
• MySQL
• Node.js
• HTML5
• CSS3
• JavaScript

Features

• Add Book
• View All Books
• Issue Book to Student
• Return Book
• Search Book by Title
• Delete Book
• Full website with navigation

Database Setup

CREATE DATABASE library_management;

CREATE TABLE books ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(100), author VARCHAR(100), category VARCHAR(50), quantity INT, available INT );

CREATE TABLE issued_books ( id INT AUTO_INCREMENT PRIMARY KEY, book_id INT, student_name VARCHAR(100), student_email VARCHAR(100), issue_date DATE, return_date DATE, status VARCHAR(20), FOREIGN KEY (book_id) REFERENCES books(id) );

How to Run

1. Create MySQL database using above SQL commands
2. Update MySQL password in DatabaseConnection.java
3. Update MySQL password in server.js
4. Add MySQL connector JAR to Eclipse build path
5. Run Main.java for Java console application
6. Run "node server.js" for website
7. Open http://localhost:3000 in browser