Library Management System

By Assistance Solutions

Description

The main aim of this project is to provide an easy to handle, automated library management system, which includes features for maintaining librarian records, students' history of issues, fines etc. This library management system helps to make a organnized library which facilitates quick and effortless searching of books, calculation of fines, checking history of book issues/returns etc.

Project Features

Librarian Functions

• Add a book
• Issue a book
• Return a book
• Add a student
• Review Statistics
• Review Book Details
• Review Fine Details
• Review Student Details
• Review Book Request Details

Student/Faculty Functions

• Request Books
• Search Books
• Review Their Statistics
• Review Their Details
• View the Book List

Extra Features Added

• No duplicate logins
• Student/Faculty can only login with a unique username given to them, once added into the system by the librarian
• One book is issued per student in a day
• Only issued books are returned
• Calender UI fixed
• Minor Bugs Fixed

Getting Started

Dependencies

• JDK 11, Download
• NetBeans 12.5, Download
• MySQL 8.x, Download OR MySQL 5.x, Download
• WampServer 3.2.3, Download
• mysql-connector-java-8.0.21.jar, Download OR mysql-connector-java-5.1.49.jar, Download
• Library Management System V1.0, Download

Installation

• Download JDK and add bin to the path in environment variables
• Install NetBeans and open project Library Management System V1.0
• Resolve two issues by adding mysql-connector-java-8.0.21.jar and by creating a new library MySQLDriver
• Open conn.java and replace password with the root user password in the following statement, c =DriverManager.getConnection("jdbc:mysql:///lbms","root","password");
• Install and open Wamp Server and login as a root user with your MySQL server

Execution

• In the wamp server, copy the following codes to create a required database for the project:

show databases;
create database lbms;
use lbms;
create table account(username varchar(20), name varchar(25), password varchar(25), sec_q varchar(25), sec_ans varchar(25));
alter table account add primary key (username);
create table account_srf(student_id varchar(20), password varchar(25), sec_q varchar(25), sec_ans varchar(25));
create table book(book_id varchar(10), name varchar(40),author varchar(20), publisher varchar(30), edition varchar(10), price varchar(10), pages varchar(10));
alter table book add primary key (book_id);
create table fine(student_id varchar(10), sname varchar(40), bname varchar(40), dateOfIssue varchar(15), dateOfReturn varchar(15), fine varchar(10));
create table issuebook(book_id varchar(10), student_id varchar(10), bname varchar(40), sname varchar(40), course varchar(20), branch varchar(10), dateofIssue date);
create table requestbook(book_id varchar(10), student_id varchar(10), name varchar(40), author varchar(20), publisher varchar(30), edition varchar(10), price varchar(10), pages varchar(10));
create table returnbook(book_id varchar(10), student_id varchar(10), bname varchar(40), sname varchar(40), course varchar(20), branch varchar(10), dateOfIssue varchar(30), dateOfReturn varchar(30));
create table student(student_id varchar(10), name varchar(25), father varchar(25), course varchar(10), branch varchar(10), year varchar(10), semester varchar(10));
alter table student add primary key (student_id);
alter table account_srf add foreign key (student_id) references student(student_id) on delete cascade;

Authors

• Samya Bose GitHub, E-mail: [email protected]
• Junaid Ahmed GitHub, E-mail [email protected]
• Ditipriya Seal GitHub, E-mail: [email protected]
• Namisha Gupta GitHub, E-mail: [email protected]