A

Project Report on

“LIBARY MANAGEMENT SYSTEM”

For the partial fulfilment to award the degree of
BACHELOR OF COMPUTER APPLICATION
BY
Anjali Chaudhary
(Roll No. 210855106156)
Bhawana Saini
(Roll No. 210855106076)

Under The supervision of

Internal Guide: Mr. Vishwas Sharma Sir

Assistant Professor-Computer Application

Dep’t. Of Computer Application

Shri Ram College of Management,
Muzaffarnagar

MAA SHAKUBHARI UNIVERSITY, UP, INDIA

A
 Project Report on

“LIBARY MANAGEMENT SYSTEM”

For the partial fulfilment to award the degree of
BACHELOR OF COMPUTER APPLICATION
BY
Anjali Chaudhary
(Roll No. 210855106156)
Bhawana Saini
(Roll No. 210855106076)

Under The supervision of

Internal Guide: Mr. Vishwas Sharma Sir

Assistant Professor-Computer Application

Dep’t. Of Computer Application

Shri Ram College of Management,
Muzaffarnagar

MAA SHAKUBHARI UNIVERSITY, UP, INDIA

 DECLARATION

We Anjali, Bhawan hereby declare that the project report title

“LIBRARY MANAGEMENT SYSTEM” is an original work
carried out by us under the supervision of Mr. Vishwas Sharma
Sir We further declare that this work has not been submitted to
any other Institute/University for the award of the degree of
Bachelor of Computer Application.

Anjali
Chaudhary
(210855106156
)
Bhawana Saini
(210855106076
)
 FORWARDING LETTER

This is to certify that the project entitled “LIBARY

MANAGEMENT SYSTEM” which is being submitted for the
partial fulfillment for the award of Degree of Bachelor of
Computer Applications from MAA SHAKUBHARI
UNIVERSITY is an authentic work carried out by Miss
Anjali Chaudhary(Roll No. 210855106156) and Miss
Bhawana (Roll No. 210855106076) under the guidance of
Project Guide Mr. Vishwas Sharma Sir. The matter embodied in
this project work has not been submitted earlier for the award of
degree or diploma.

We wish him/her all the best for the future.

Mr. Vishwas Kumar Sharma Dr. Nishant Kumar Rathi

( Internal Guide ) (HOD-Computer Application)
 ACKNOWLEDGEMENT

We are students of BCA (3rdYear) here by submit our project.

Merely words to thank these people would be insufficient. We
thank to our project guide (Mr. Vishwas Sharma Sir) for
helping us to settle all the problems we had while our project
report under went for setting our quires. We are also very
thankful to our HOD (Dr. Nishant Kumar Rathi) to inspired us
during this period.

Finally but definitely not the last we are thankful to our family
for standing by us in our confusions and apprehensions.

Anjali Chaudhary
(210855106156
)
Bhawana Saini
(210855106076
)
 CONTENTS

1. Introduction

2. Limitation of Existing System

3. Advantage of Proposed

4. Hardware & software specification

5. Frontend & Backend

6. Modules

7. DFD

8. E-R Diagram

9. Database tables

10. Forms

11. Coding

12. Bibliography
 INTRODUCTION TO PRESENT
SYSTEM

Library Management System is a tool that it provides efficient

services to its Book and Library member. The various types of

operations and dealings take places in the Library. But we had

undertaken the work of Computerization of Generation of

Library Management System which covers the activities related

to Book and Library member etc. & All Types of activities

corresponds to the Member, these operations were manually

operated by the clerks and Operator and the operations were

really time consuming task to perform. The present system will

help them a lot.

 LIMITATIONS OF EXISTING SYSTEM
When the existing system of the Library Management System, we
found that some add on were required there so that problems
could be solved. Some of the problems or limitations in the
present system are: -

 To update each Book details with Student name

 While preparing the Reports statements the book have to manually

go through the Records Manually.

 There is no security of the database register i.e. any other person

can make changes in the database.

 Issue/return

 It is a time consuming task to maintain the data of previous Book

 Advantage of the project

This system is very simple in design and to implement . the

system require very low
System resources and the system will work in almost all
configurations. There are
Following advantages of the proposed system.-
1. Security of data.
2. Ensure data accuracy.
3. Reduce paper work.
4. Minimized manual data entry.
5. User friendly environment.
6. High efficiency
FRONT END & BACK END USED
WINDOWS 7 used as PLATFORM

Windows 7 is latest version of window and also GUI.This is best

then another Operating system and easy.

Windows 7 has come up with another bonanza, that is Network

Communication with other users. The users can connect with
other users to share data files and peripheral davices,like Printers.

The Communication tools of Window 7 include E-Mail and

connection to Internet.

JAVA used as FRONT END

Java is fully OBJECT ORIENTED PROGRAMMING

language developed by SUN MICROSYSTEM company of
USA in 1991. In these days, Java is used in networking fields.

Features of Java

 Object Oriented

 Case Sensitive

 Bottom to top Approach

 Compile and Interpreted

  Multithreaded

 Portable & Platform Independent

 Dynamic & Extensible

 Robust & Secure

Java uses front end programming because JAVA use back

ends like MICROSOFT ACCESS DATABASE.

In JAVA we can use easy database connectivity and design the

Form,Report,and other MDI application with the help of
Database.

MS-ACCESS 2000 used as BACK END

Ms-Access is a database and partially RDBMS. In Access we

can easily create Database design and give the validations.
Access allows the many types of relations between the tables.
Access used as Backend with the Visual Basic. Access allows
creating the Primary Key, Foreign Key and Unique Key. In
Access we can store the data in to the table for using the wizard
options
 HARDWARE SOFTWARE REQUIREMENT

Processor : Pentium 3 or higher processor

Operating System : Microsoft windows xp or7

Ram Memory : 512 Mb

Monitor : VGA or high resolution Monitor

Display : VGA card

Keyboard : 104 keys

Java : jdk1.5

Microsoft Access : 2007

 Modules
Number Of Modules

• Login Module

 Member Module

 Book Module

• Report Module

2. Process Logic Of Module

LOGIN MODULE- This is the main module in the project

The user can read and write information about any member

The user can also update create and delete records of books and members

The user can add the books, delete the book Add the details of members.

Cancel the record of member

This module is responsible to perform following operations

a) Authentication of a user

b) Changing password of sever

Member Module

Allow the user to register new member and update the member records, check
the orders of members and renew the member dats

Book Module-

Allow user books to enter book details update the book details, cancel the

Return Module

This module is responsible to generate following reports

List of students in a particular course.

Date wise report of admissions

All details of a particular student

 DATA FLOW DIAGRAM

A Data Flow Diagram (DFD) is a graphical tool

used to describe and analyze the movement of data
through a system - manual or automated including
the processes, stores of data and delays in the
system.

LOGIN MANAGEMENT CHECK USER LOGIN

BOOK MANAGEMENT GENERATE BOOK

REPORT

MEMBER MEMBER REPORT

MANAGEMENT LIBRARY

MANAGEMENT
ISSUE/RETURN ISSUE/RETURN
SYSTEM
MANAGEMENT REPORT

FINE MANAGEMENT
GENERATE FINE
REPORT

STUDENT
STUDENT REPORT
MANAGEMENT
 FIRST LEVEL DFD

CHECK
LOGIN
ROLL OF
TO ACCESS
SYSTE MANAGE USER LOGIN
M

MANAGE BOOK
REPORT

MANAGE MEMBER
LIBRARY
CHECK REPORT

CREDENTIALS MANAGEMENT
MANAG IISUE/RETURN
SYSTEM REPORT

MANAGE FINE REPORT

MANAGE STUDENT
REPORT

MANAGEM ROLL OF USER MANAGE USER PERMISSION

ENTITY – RELATIONSHIP DIAGRAM
 Output Screen
NAME ADDRESS
Edition Cost

Roll No BOOKNO
Author
Student
BOOK
Title
PHONE Publisher

Contains
Has

LIBRARY
DATABASE

Issue/Return
Book

Book no

Issue book

Periods

Date return
Member-
Id
CODING
LOGIN FORM CODING
class Login implements ActionListener
{
JFrame frm;
JLabel l1,l2;
JTextField txtid;
JPasswordField txtpassword;
JButton login,exit,reset;
Login()
{
frm=new JFrame("Add library");
frm.getContentPane().setBackground(Color.cyan);
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
l1=new JLabel("User Id");
l2=new JLabel("Password");
login=new JButton("Login");
login.setBackground(Color.GRAY);
frm.setLayout(null);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
reset=new JButton("Reset");
reset.setBackground(Color.GRAY);
txtid=new JTextField();
txtpassword=new JPasswordField();
l1.setBounds(20,50,150,30);
txtid.setBounds(180,50,150,30);
l2.setBounds(20,90,150,30);
txtpassword.setBounds(180,90,150,30);
login.setBounds(20,140,80,30);
exit.setBounds(250,140,80,30);
reset.setBounds(140,140,80,30);
frm.add(l1);
frm.add(txtid);
frm.add(l2);
 frm.add(txtpassword);
frm.add(login);
frm.add(exit);
frm.add(reset);
login.addActionListener(this);
exit.addActionListener(this);
reset.addActionListener(this);
frm.setSize(400,300);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==login)
{
String login,pass;
try
{
login=txtid.getText();
pass=txtpassword.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select * from logintable where
loginid='"+login+"'and password='"+pass+"'";
ResultSet res=stmt.executeQuery(query);
if(res.next())
{
Welcome obj=new Welcome();

//JOptionPane.showMessageDialog(null,"Correct");
}
else

JOptionPane.showMessageDialog(null,"Incorrect");
}
catch(Exception e1)
{}
 }
else if(e.getSource()==reset)
{
ChangePassword obj=new ChangePassword();
}
else
frm.dispose();
}
public static void main(String agrs[])
{
new Login();
}
}
CHANGE PASSWORD CODING
class ChangePassword implements ActionListener
{
JFrame frm;
JButton verify,change,exit;
JPasswordField
txtcurrentpassword,txtnewpassword,txtconfirmpassword;
JLabel l1,l2,l3;
ChangePassword()
{
frm=new JFrame("Change Password");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.cyan);
frm.setSize(500,400);
frm.setLayout(null);
l1=new JLabel("Current Password");
l2=new JLabel("New password");
l3=new JLabel("Confirm Password");
verify=new JButton("verify");
change=new JButton("Change");
exit=new JButton("EXIT");
txtcurrentpassword=new JPasswordField();
txtnewpassword=new JPasswordField();
txtconfirmpassword=new JPasswordField();
 l1.setBounds(20,50,150,30);
txtcurrentpassword.setBounds(180,50,150,30);
l2.setBounds(20,150,150,30);
txtnewpassword.setBounds(180,150,150,30);
l3.setBounds(20,200,150,30);
txtconfirmpassword.setBounds(180,200,150,30);
verify.setBounds(160,100,80,30);
change.setBounds(20,260,80,30);
exit.setBounds(250,260,80,30);
frm.add(l1);
frm.add(txtcurrentpassword);
frm.add(verify);
frm.add(l2);
frm.add(txtnewpassword);
frm.add(l3);
frm.add(txtconfirmpassword);
frm.add(change);
frm.add(exit);
change.setBackground(Color.gray);
verify.setBackground(Color.gray);
exit.setBackground(Color.gray);

change.setEnabled(false);
txtnewpassword.setEnabled(false);
txtconfirmpassword.setEnabled(false);

verify.addActionListener(this);
exit.addActionListener(this);
change.addActionListener(this);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==verify)
{
String verify;
try
{
 verify=txtcurrentpassword.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select * from logintable where
password='"+verify+"'";
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
//verify.equals(query);

JOptionPane.showMessageDialog(null,"password verified ");

change.setEnabled(true);
txtnewpassword.setEnabled(true);
txtconfirmpassword.setEnabled(true);
}
else
{

JOptionPane.showMessageDialog(null,"Incorrect");
}
}
catch(Exception e1)
{

JOptionPane.showMessageDialog(null,e1.getMessage());
}

}
else if(e.getSource()==change)
{
try
{
String newpswrd=txtnewpassword.getText();
String verify=txtcurrentpassword.getText();
String confirmpswrd=txtconfirmpassword.getText();
if(newpswrd.equals(confirmpswrd))
{
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="update logintable set
password='"+newpswrd+"' where password='"+verify+"'";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"Password
Changed");

txtcurrentpassword.setText("");
txtnewpassword.setText("");
txtconfirmpassword.setText("");
change.setEnabled(false);
txtnewpassword.setEnabled(false);
txtconfirmpassword.setEnabled(false);
}
else
{
JOptionPane.showMessageDialog(null,"Password
Mismatch");
}
}
catch(Exception e1)
{
JOptionPane.showMessageDialog(null,e1.getMessage());
}
}
else
{
frm.dispose();
}
}
}

WELCOME FORM
class Welcome implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6,l7,l8;
JButton b1;
Welcome()
{
frm=new JFrame("Welcome Form");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.pink);
frm.setSize(500,600);
frm.show();
frm.setLayout(null);
l1=new JLabel("Library");
l2=new JLabel("Management");
l3=new JLabel("System");
l4=new JLabel("Developed By");
l5=new JLabel("Mansi Poonia");
l6=new JLabel("Kajal Malik");
l7=new JLabel("Submitted to");
l8=new JLabel("Anuj");
b1=new JButton("C O N T I N U E");
Font f1=new Font("Algerian",Font.BOLD,40);
Font f2=new Font("Times new Roman",Font.BOLD,20);
Font f3=new Font("Monotype Corsiva",Font.ITALIC,20);
l1.setFont(f1);
l2.setFont(f1);
l3.setFont(f1);
l4.setFont(f2);
l7.setFont(f2);
l5.setFont(f3);
l6.setFont(f3);
l8.setFont(f3);
l1.setForeground(Color.black);
l2.setForeground(Color.black);
l3.setForeground(Color.black);
l4.setForeground(Color.red);
l5.setForeground(Color.blue);
 l6.setForeground(Color.blue);
l7.setForeground(Color.red);
l8.setForeground(Color.blue);
b1.setBackground(Color.gray);

l1.setBounds(150,10,300,50);
frm.add(l1);
l2.setBounds(130,70,300,50);
frm.add(l2);
l3.setBounds(180,130,300,50);
frm.add(l3);
l4.setBounds(50,300,200,50);
frm.add(l4);
l7.setBounds(300,300,200,50);
frm.add(l7);
l5.setBounds(50,340,100,40);
frm.add(l5);
l6.setBounds(50,360,100,40);
frm.add(l6);
l8.setBounds(300,340,100,40);
frm.add(l8);
b1.setBounds(120,420,260,40);
frm.add(b1);
b1.addActionListener(this);

}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
MainForm obj=new MainForm();
}
}
}
MAIN FORM
class MainForm implements ActionListener
{
JFrame frm;
 JButton b1,b2,b3,b4,b5;
JLabel l1,l2,l3,l4;
MainForm()
{
frm=new JFrame("MAIN FORM");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
frm.setSize(400,500);
b1=new JButton();
b2=new JButton();
b3=new JButton();
b4=new JButton();
b5=new JButton("BACK");
b5.setBackground(Color.GRAY);
frm.setLayout(null);
l1=new JLabel(" BOOKS DETAILS");
l2=new JLabel("MEMBERS");
l3=new JLabel("ISSUE BOOK");
l4=new JLabel("RETURN BOOK");
b1.setBounds(30,50,100,100);
b2.setBounds(220,50,100,100);
b3.setBounds(30,250,100,100);
b4.setBounds(220,250,100,100);
b5.setBounds(270,400,100,30);
l1.setBounds(30,160,120,20);
l2.setBounds(230,160,120,20);
l3.setBounds(40,360,120,20);
l4.setBounds(230,360,120,20);
frm.add(b1);
frm.add(l1);
frm.add(b2);
frm.add(l2);
frm.add(b3);
frm.add(l3);
frm.add(b4);
frm.add(l4);
frm.add(b5);
 b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
BookDetails obj=new BookDetails();
}
else if(e.getSource()==b2)
{
Member obj=new Member();
}
else if(e.getSource()==b3)
{
IssueBook obj=new IssueBook();
}
else if(e.getSource()==b4)
{
ReturnBook obj=new ReturnBook();
}
else
{
frm.dispose();
}
}
BOOK DETAIL
class BookDetails implements ActionListener
{
JFrame frm;
JButton b1,b2,b3,b4,b5;
BookDetails()
{
 frm=new JFrame("Book Details");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
frm.setSize(350,330);
b1=new JButton("ALL BOOKS");
b2=new JButton("ADD NEW BOOKS");
b3=new JButton("SEARCH BOOK");
b4=new JButton("MODIFY BOOK");
b5=new JButton("BACK");
b1.setBackground(Color.GRAY);
b2.setBackground(Color.GRAY);
b3.setBackground(Color.GRAY);
b4.setBackground(Color.GRAY);
b5.setBackground(Color.GRAY);
frm.setLayout(null);
b1.setBounds(70,30,180,30);
b2.setBounds(70,80,180,30);
b3.setBounds(70,130,180,30);
b4.setBounds(70,180,180,30);
b5.setBounds(250,230,70,30);
frm.add(b1);
frm.add(b2);
frm.add(b3);
frm.add(b4);
frm.add(b5);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
AllBook obj=new AllBook();
 }
else if(e.getSource()==b2)
{
AddBook obj=new AddBook();
}
else if(e.getSource()==b3)
{
SearchBook obj=new SearchBook();
}
else if(e.getSource()==b4)
{
ModifyBook obj=new ModifyBook();
}
else
{
frm.dispose();
}
}

ALL BOOK
class AllBook
{
JFrame frm;
AllBook()
{
frm=new JFrame("ALL BOOKS");
frm.setDefaultCloseOperation(frm.DISPOSE_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
frm.setBounds(300,100,400,500);
frm.setLayout(new FlowLayout(FlowLayout.CENTER,10,10));
JLabel l=new JLabel(" LIST OF BOOKS");
l.setFont(new Font("Area",Font.BOLD,30));
frm.add(l);
JTable jt=new JTable(0,3);
DefaultTableModel m=(DefaultTableModel) jt.getModel();
Object head[]={ "isbn","title","author"};
m.addRow(head);
frm.add(jt);
 frm.show();
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select *from Bookdetail";
ResultSet res=stmt.executeQuery(query);
while(res.next())
{
Object
newRow[]={res.getString("isbn"),res.getString("title"),res.getString("
author")};
m.addRow(newRow);
}
}
catch(Exception e)
{}

}
}

ADD BOOK
class AddBook implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6;
JTextField
txtISBN,txtTITLE,txtEDITION,txtCOST,txtAUTHOR,txtPUBLISHE
R;
JButton save,exit;
AddBook()
{
frm=new JFrame("ADD NEW BOOK");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
 l1=new JLabel("Enter ISBN ");
l2=new JLabel("Enter TITLE");
l3=new JLabel("Enter EDITION");
l4=new JLabel("Enter COST");
l5=new JLabel("Enter AUTHOR ");
l6=new JLabel("Enter PUBLISHER");
save=new JButton("Save");
save.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
txtISBN=new JTextField(20);
txtTITLE=new JTextField(20);
txtEDITION=new JTextField(20);
txtCOST=new JTextField(20);
txtAUTHOR=new JTextField(20);
txtPUBLISHER=new JTextField(20);
frm.setLayout(new GridLayout(7,2));
frm.add(l1);
frm.add(txtISBN);
frm.add(l2);
frm.add(txtTITLE);
frm.add(l3);
frm.add(txtEDITION);
frm.add(l4);
frm.add(txtCOST);
frm.add(l5);
frm.add(txtAUTHOR);
frm.add(l6);
frm.add(txtPUBLISHER);
frm.add(save);
frm.add(exit);
save.addActionListener(this);
exit.addActionListener(this);
frm.setSize(300,300);
frm.show();
}
public void actionPerformed(ActionEvent e)
 {
if(e.getSource()==save)
{
String TITLE,AUTHOR,EDITION,PUBLISHER;
int ISBN,COST;
try
{

TITLE=txtTITLE.getText();
EDITION=txtEDITION.getText();
AUTHOR=txtAUTHOR.getText();
PUBLISHER=txtPUBLISHER.getText();
ISBN=Integer.parseInt(txtISBN.getText());
COST=Integer.parseInt(txtCOST.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="insert into Bookdetail
values("+ISBN+",'"+TITLE+"','"+EDITION+"',"+COST+",'"+AUTH
OR+"','"+PUBLISHER+"')";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"SAVED");
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
frm.dispose();

}
}

SEARCH BOOK
class SearchBook implements ActionListener
{
JFrame frm;
 JLabel l1,l2,l3,l4,l5,l6,l7;
JTextField
txtISBN,txtTITLE,txtEDITION,txtCOST,txtAUTHOR,txtPUBLISHE
R,txtAUTHOR1;
JButton ok,exit;
SearchBook()
{
frm=new JFrame("ADD NEW BOOK");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
l1=new JLabel("ENTER AUTHOR NAME");
l2=new JLabel("ISBN ");
l3=new JLabel("TITLE");
l4=new JLabel("EDITION");
l5=new JLabel("COST");
l6=new JLabel("AUTHOR ");
l7=new JLabel("PUBLISHER");
ok=new JButton("OK");
ok.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
txtISBN=new JTextField(20);
txtTITLE=new JTextField(20);
txtEDITION=new JTextField(20);
txtCOST=new JTextField(20);
txtAUTHOR=new JTextField(20);
txtPUBLISHER=new JTextField(20);
txtAUTHOR1=new JTextField(20);
frm.setLayout(new GridLayout(8,2));
frm.add(l1);
frm.add(txtAUTHOR1);
frm.add(ok);
frm.add(exit);
frm.add(l2);
frm.add(txtISBN);
frm.add(l3);
frm.add(txtTITLE);
 frm.add(l4);
frm.add(txtEDITION);
frm.add(l5);
frm.add(txtCOST);
frm.add(l6);
frm.add(txtAUTHOR);
frm.add(l7);
frm.add(txtPUBLISHER);
ok.addActionListener(this);
exit.addActionListener(this);
frm.setSize(300,300);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==ok)
{
String AUTHOR;

try
{

AUTHOR=txtAUTHOR1.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select * from bookdetail where
author='"+AUTHOR+"'";
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
txtISBN.setText(rs.getString("isbn"));
txtTITLE.setText(rs.getString("title"));
txtEDITION.setText(rs.getString("edition"));
txtCOST.setText(rs.getString("cost"));

txtAUTHOR.setText(rs.getString("AUTHOR"));
 txtPUBLISHER.setText(rs.getString("publisher"));
//AUTHOR=txtAUTHOR.getText("");

}
else
{
JOptionPane.showMessageDialog(null,"NOT FOUND");

}
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
{
frm.dispose();
}
}
}
MODIFY BOOK
class ModifyBook implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6,l7;
JTextField
txtISBN,txtTITLE,txtEDITION,txtCOST,txtAUTHOR,txtPUBLISHE
R,txtAUTHOR1;
JButton ok,exit,delete,update;
ModifyBook()
{
frm=new JFrame("MODIFY BOOK");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
l1=new JLabel("ENTER AUTHOR ");
l2=new JLabel(" ISBN ");
l3=new JLabel("TITLE");
 l4=new JLabel("EDITION");
l5=new JLabel("COST");
l6=new JLabel(" AUTHOR");
l7=new JLabel("PUBLISHER");
ok=new JButton("Ok");
ok.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
update=new JButton("Update");
update.setBackground(Color.GRAY);
delete=new JButton("Delete");
delete.setBackground(Color.GRAY);
txtISBN=new JTextField(20);
txtTITLE=new JTextField(20);
txtEDITION=new JTextField(20);
txtCOST=new JTextField(20);
txtAUTHOR1=new JTextField(20);
txtAUTHOR=new JTextField(20);
txtPUBLISHER=new JTextField(20);
frm.setLayout(new GridLayout(9,2));
frm.add(l1);
frm.add(txtAUTHOR1);
frm.add(ok);
frm.add(exit);
frm.add(l2);
frm.add(txtISBN);
frm.add(l3);
frm.add(txtTITLE);
frm.add(l4);
frm.add(txtEDITION);
frm.add(l5);
frm.add(txtCOST);
frm.add(l6);
frm.add(txtAUTHOR);
frm.add(l7);
frm.add(txtPUBLISHER);
frm.add(update);
 frm.add(delete);
ok.addActionListener(this);
exit.addActionListener(this);
delete.addActionListener(this);
update.addActionListener(this);
frm.setSize(300,300);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==ok)
{
String AUTHOR;

try
{

AUTHOR=txtAUTHOR1.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select * from bookdetail where
author='"+AUTHOR+"'";
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
txtISBN.setText(rs.getString("isbn"));
txtTITLE.setText(rs.getString("title"));
txtEDITION.setText(rs.getString("edition"));
txtCOST.setText(rs.getString("cost"));

txtAUTHOR.setText(rs.getString("AUTHOR"));

txtPUBLISHER.setText(rs.getString("publisher"));
//AUTHOR=txtAUTHOR.getText("");

}
 else
{
JOptionPane.showMessageDialog(null,"NOT FOUND");

}
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else if(e.getSource()==update)
{
String TITLE,AUTHOR,EDITION,PUBLISHER;
int ISBN,COST;
try
{

TITLE=txtTITLE.getText();
EDITION=txtEDITION.getText();
AUTHOR=txtAUTHOR.getText();
PUBLISHER=txtPUBLISHER.getText();
ISBN=Integer.parseInt(txtISBN.getText());
COST=Integer.parseInt(txtCOST.getText());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="update Bookdetail set
title='"+TITLE+"',edition='"+EDITION+"',author='"+AUTHOR+"',co
st="+COST+",isbn="+ISBN+",publisher='"+PUBLISHER+"'where
author='"+AUTHOR+"'";
stmt.executeUpdate(query);

JOptionPane.showMessageDialog(null,"RECORD
UPDATED");
}
catch(Exception e1)
 {JOptionPane.showMessageDialog(null,e1.getMessage());}
}

else if(e.getSource()==delete)
{
String AUTHOR;

try
{
AUTHOR=txtAUTHOR1.getText();

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="delete from bookdetail where
author='"+AUTHOR+"'";
stmt.executeUpdate(query);

JOptionPane.showMessageDialog(null,"RECORD
DELETED");

}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
{
frm.dispose();
}
}
}

MEMBER
class Member implements ActionListener
{
JFrame frm;
JButton b1,b2,b3,b4,b5;
Member()
{
frm=new JFrame(" MEMBERS");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
frm.setSize(350,330);
b1=new JButton("ALL MEMBER");
b2=new JButton("ADD NEW MEMBER");
b3=new JButton("SEARCH MEMBER");
b4=new JButton("MODIFY MEMBER");
b5=new JButton("BACK");
frm.setLayout(null);
b1.setBounds(70,30,180,30);
b2.setBounds(70,80,180,30);
b3.setBounds(70,130,180,30);
b4.setBounds(70,180,180,30);
b5.setBounds(250,230,70,30);
b1.setBackground(Color.GRAY);
b2.setBackground(Color.GRAY);
b3.setBackground(Color.GRAY);
b4.setBackground(Color.GRAY);
b5.setBackground(Color.GRAY);
frm.add(b1);
frm.add(b2);
frm.add(b3);
frm.add(b4);
frm.add(b5);
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
frm.show();
}
 public void actionPerformed(ActionEvent e)
{
if(e.getSource()==b1)
{
AllMember obj=new AllMember();
}
if(e.getSource()==b2)
{
AddMember obj=new AddMember();
}
else if(e.getSource()==b3)
{
SearchMember obj= new SearchMember();
}
else if(e.getSource()==b4)
{
ModifyMember obj=new ModifyMember();
}
else
frm.dispose();
}

ALL MEMBER
class AllMember
{
JFrame frm;
AllMember()
{
frm=new JFrame("ALL MEMBERS");
frm.setDefaultCloseOperation(frm.DISPOSE_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
frm.setBounds(300,100,400,500);
frm.setLayout(new FlowLayout(FlowLayout.CENTER,10,10));
JLabel l=new JLabel(" LIST OF MEMBERS");
l.setFont(new Font("Area",Font.BOLD,30));
frm.add(l);
JTable jt=new JTable(0,3);
 DefaultTableModel m=(DefaultTableModel) jt.getModel();
Object head[]={ "id","name","course"};
m.addRow(head);
frm.add(jt);
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select *from Registrationtable";
ResultSet res=stmt.executeQuery(query);
while(res.next())
{
Object
newRow[]={res.getString("id"),res.getString("name"),res.getString("c
ourse")};
m.addRow(newRow);
}
}
catch(Exception e)
{}
frm.show();
}
}

ADD MEMBER
class AddMember implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6;
JTextField txtid,txtname,txtcourse,txtaddress,txtphn,txtses;
JButton save,exit;
AddMember()
{
frm=new JFrame("Registration Form");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
 frm.getContentPane().setBackground(Color.CYAN);
l1=new JLabel("Enter Student Id");
l2=new JLabel("Enter Name");
l3=new JLabel("Enter Course");
l4=new JLabel("Session");
l5=new JLabel("Address");
l6=new JLabel("Contact no.");
save=new JButton("Save");
save.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
txtid=new JTextField(20);
txtname=new JTextField(20);
txtses=new JTextField(20);
txtcourse=new JTextField(20);
txtaddress=new JTextField(20);
txtphn=new JTextField(20);
frm.setLayout(new GridLayout(7,2));
frm.add(l1);
frm.add(txtid);
frm.add(l2);
frm.add(txtname);
frm.add(l3);
frm.add(txtcourse);
frm.add(l4);
frm.add(txtses);
frm.add(l5);
frm.add(txtaddress);
frm.add(l6);
frm.add(txtphn);
frm.add(save);
frm.add(exit);
save.addActionListener(this);
exit.addActionListener(this);
frm.setSize(300,300);
frm.show();
}
 public void actionPerformed(ActionEvent e)
{
if(e.getSource()==save)
{
String name,course,address,phn,session;
int id;
try
{
name=txtname.getText();
course=txtcourse.getText();
address=txtaddress.getText();
phn=txtphn.getText();
session=txtses.getText();
id=Integer.parseInt(txtid.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="insert into registrationtable
values("+id+",'"+name+"','"+course+"','"+address+"','"+phn+"','"+sess
ion+"')";
stmt.executeUpdate(query);

JOptionPane.showMessageDialog(null,"SAVED");
}
catch(Exception e1)
{}
}
else
frm.dispose();

}
}

SEARCH MEMBER
class SearchMember implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6,l7;
JTextField txtid,txtname,txtcourse,txtaddress,txtphn,txtses,txtid2;
JButton ok,exit;
SearchMember()
{
frm=new JFrame("SEARCH MEMBER");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN);
l1=new JLabel("Enter Student Id");
l2=new JLabel("Id");
l3=new JLabel("Enter Name");
l4=new JLabel("Enter Course");
l5=new JLabel("Session");
l6=new JLabel("Address");
l7=new JLabel("Contact no.");
ok=new JButton("OK");
ok.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
txtid=new JTextField(20);
txtname=new JTextField(20);
txtses=new JTextField(20);
txtcourse=new JTextField(20);
txtaddress=new JTextField(20);
txtphn=new JTextField(20);
txtid2=new JTextField(20);
frm.setLayout(new GridLayout(8,2));
frm.add(l1);
frm.add(txtid2);
frm.add(ok);
frm.add(exit);
frm.add(l2);
frm.add(txtid);
frm.add(l3);
frm.add(txtname);
frm.add(l4);
frm.add(txtcourse);
 frm.add(l5);
frm.add(txtses);
frm.add(l6);
frm.add(txtaddress);
frm.add(l7);
frm.add(txtphn);
ok.addActionListener(this);
exit.addActionListener(this);
frm.setSize(300,230);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==ok)
{
int id;
try
{
id=Integer.parseInt(txtid2.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select *from registrationtable where
id="+id;
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
txtid.setText(rs.getString("id"));
txtname.setText(rs.getString("name"));
txtcourse.setText(rs.getString("course"));
txtaddress.setText(rs.getString("address"));
txtphn.setText(rs.getString("phn"));
txtses.setText(rs.getString("session"));
}
else
{
 JOptionPane.showMessageDialog(null,"NOT FOUND");

}
//id2=txtid2.setText("");

}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
{
frm.dispose();
}
}
}
MODIFY MEMBER
class ModifyMember implements ActionListener
{
JFrame frm;
JLabel l1,l2,l3,l4,l5,l6,l7;
JTextField txtid,txtname,txtcourse,txtaddress,txtphn,txtses,txtid2;
JButton ok,exit,update,delete;
ModifyMember()
{
frm=new JFrame("Modify MEMBER");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.CYAN); l1=new
JLabel("Enter Student Id :");
l2=new JLabel("Id :");
l3=new JLabel("Enter Name :");
l4=new JLabel("Enter Course :");
l5=new JLabel("Session :");
l6=new JLabel("Address :");
l7=new JLabel("Contact no. :");
ok=new JButton("OK");
ok.setBackground(Color.GRAY);
exit=new JButton("Exit");
exit.setBackground(Color.GRAY);
update=new JButton("update");
update.setBackground(Color.GRAY);
delete=new JButton("delete");
delete.setBackground(Color.GRAY);
txtid=new JTextField(20);
txtname=new JTextField(20);
txtses=new JTextField(20);
txtcourse=new JTextField(20);
txtaddress=new JTextField(20);
txtphn=new JTextField(20);
txtid2=new JTextField(20);
frm.setLayout(new GridLayout(9,2));
frm.add(l1);
frm.add(txtid2);
frm.add(ok);
frm.add(exit);
frm.add(l2);
frm.add(txtid);
frm.add(l3);
frm.add(txtname);
frm.add(l4);
frm.add(txtcourse);
frm.add(l5);
frm.add(txtses);
frm.add(l6);
frm.add(txtaddress);
frm.add(l7);
frm.add(txtphn);
frm.add(update);
frm.add(delete);
ok.addActionListener(this);
update.addActionListener(this);
delete.addActionListener(this);
exit.addActionListener(this);
frm.setSize(300,230);
frm.show();
 }
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==ok)
{
int id;
try
{
id=Integer.parseInt(txtid2.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select *from registrationtable where
id="+id;
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
txtid.setText(rs.getString("id"));
txtname.setText(rs.getString("name"));
txtcourse.setText(rs.getString("course"));
txtaddress.setText(rs.getString("address"));
txtphn.setText(rs.getString("phn"));
txtses.setText(rs.getString("session"));
}
else
{
JOptionPane.showMessageDialog(null,"NOT FOUND");

}
//id2=txtid2.setText("");

}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else if(e.getSource()==update)
 {
int id;
String name,course,address,phone,ses;
try
{
id=Integer.parseInt(txtid2.getText());
name=txtname.getText();
course=txtcourse.getText();
address=txtaddress.getText();
phone=txtphn.getText();
ses=txtses.getText();
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query=" update registrationtable set
name='"+name+"',address='"+address+"',course='"+course+"',phn='"+
phone+"',session='"+ses+"' where id="+id+" ";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"RECORD
UPDATED");
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else if(e.getSource()==delete)
{
int id;
try
{
id=Integer.parseInt(txtid2.getText());
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="delete from registrationtable where
id="+id;
 stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"RECORD DELETED");
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
frm.dispose();
}
}
}

ISSUE BOOK
class IssueBook implements ActionListener
{
JFrame frm;
JButton submit,cancel;
JTextField txtISBN,txtID,txtPERIODS,txtDATE;
JLabel l1,l2,l3,l4;
IssueBook()
{
frm=new JFrame("ISSUE BOOK");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.cyan);
frm.setSize(500,400);
frm.setLayout(null);
l1=new JLabel(" ENTER ISBN :");
l2=new JLabel(" ENTER STUDENT ID :");
l3=new JLabel("PERIOD (DAYS) :");
l4=new JLabel("ISSUED DATE :");
submit=new JButton("submit");
submit.setBackground(Color.GRAY);
cancel=new JButton("cancel");
cancel.setBackground(Color.GRAY);
txtISBN=new JTextField();
txtID=new JTextField();
txtPERIODS=new JTextField();
 txtDATE=new JTextField();
l1.setBounds(20,50,150,30);
txtISBN.setBounds(180,50,150,30);
l2.setBounds(20,100,150,30);
txtID.setBounds(180,100,150,30);
l3.setBounds(20,150,150,30);
txtPERIODS.setBounds(180,150,150,30);
l4.setBounds(20,200,150,30);
txtDATE.setBounds(180,200,150,30);
submit.setBounds(60,280,80,30);
cancel.setBounds(250,280,80,30);
frm.add(l1);
frm.add(txtISBN);
frm.add(l2);
frm.add(txtID);
frm.add(l3);
frm.add(txtPERIODS);
frm.add(l4);
frm.add(txtDATE);
frm.add(submit);
frm.add(cancel);
submit.addActionListener(this);
cancel.addActionListener(this);
frm.show();
}

public void actionPerformed(ActionEvent e)

{
if(e.getSource()==submit)
{
try
{
int ISBN,STDID;
String ISSUEDATE,PERIOD;
ISBN=Integer.parseInt(txtISBN.getText());
STDID=Integer.parseInt(txtID.getText());
ISSUEDATE=txtDATE.getText();
PERIOD=txtPERIODS.getText();
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="insert into issuetable
values("+ISBN+","+STDID+",'"+ISSUEDATE+"','"+PERIOD+"')";
stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"RECORD
INSERTED");
}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
{
frm.dispose();
}
}
}
}

RETURN BOOK
class ReturnBook implements ActionListener

{
JFrame frm;
JButton RETURN,CANCEL,CLICK;
JTextField txtID,txtISBN,txtDATE,txtPERIOD;
JLabel l1,l2,l3,l4;
ReturnBook()
{
frm=new JFrame("RETURN BOOK");
frm.setDefaultCloseOperation(frm.EXIT_ON_CLOSE);
frm.getContentPane().setBackground(Color.cyan);
frm.setSize(350,400);
frm.setLayout(null);
l1=new JLabel(" ENTER STUDENT ID :");
 l2=new JLabel(" ISBN :");
l3=new JLabel(" PERIOD(DAYS) :");
l4=new JLabel(" ISSUE DATE :");

RETURN=new JButton("return");
CLICK=new JButton("click");
CANCEL=new JButton("cancel");
txtID=new JTextField();
txtISBN=new JTextField();
txtPERIOD=new JTextField();
txtDATE=new JTextField();

l1.setBounds(20,50,150,30);
txtID.setBounds(170,50,150,30);
CLICK.setBounds(100,100,100,30);

l2.setBounds(20,150,150,30);
txtISBN.setBounds(170,150,150,30);
l3.setBounds(20,200,150,30);
txtPERIOD.setBounds(170,200,150,30);
l4.setBounds(20,250,150,30);
txtDATE.setBounds(170,250,150,30);

RETURN.setBounds(40,300,100,30);
CANCEL.setBounds(190,300,100,30);
RETURN.setBackground(Color.GRAY);
CANCEL.setBackground(Color.GRAY);
frm.add(l1);
frm.add(txtID);
frm.add(CLICK);
CLICK.setBackground(Color.GRAY);
frm.add(l2);
frm.add(txtISBN);
frm.add(l3);
frm.add(txtPERIOD);
frm.add(l4);
frm.add(txtDATE);
frm.add(RETURN);
 frm.add(CANCEL);

RETURN.addActionListener(this);
CANCEL.addActionListener(this);
CLICK.addActionListener(this);
frm.show();
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==CLICK)
{
try
{
int Id;

Id=Integer.parseInt(txtID.getText());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="select * from issuetable where
studentid="+Id;
ResultSet rs=stmt.executeQuery(query);
if(rs.next())
{
txtISBN.setText(rs.getString("isbn"));
txtDATE.setText(rs.getString("issuedate"));
txtPERIOD.setText(rs.getString("timeperiod"));
}
else
{
JOptionPane.showMessageDialog(null,"NOT FOUND");

}
catch(Exception e1)
 {JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else if(e.getSource()==RETURN)
{
try
{
int Id;
Id=Integer.parseInt(txtID.getText());

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection
con=DriverManager.getConnection("jdbc:odbc:lib");
Statement stmt=con.createStatement();
String query="delete from issuetable where
studentid="+Id;
stmt.executeUpdate(query);
JOptionPane.showMessageDialog(null,"BOOK
RETURNED");

}
catch(Exception e1)

{JOptionPane.showMessageDialog(null,e1.getMessage());}
}
else
{
frm.dispose();
}
}
}
 Future Scope
1. Enhance efficiency

Monitoring daily data on the total number of volumes issued,

unreturned, reissued, and available can be a time-consuming chore for
a librarian. A school library management system boosts the
effectiveness of a library by enabling all tasks to be accomplished
with a single click, making the work of a librarian easier.

Signing into individual accounts allows students to access the

catalogue, their book status, and other information. In addition to that,
they can be informed of due dates for returning books, notifications to
pay late fines, and more through SMS.

2.Keep track of data

Any educational institution requires data, and library books are a vital
asset. Manual data management raises risks such as data
misplacement and data input errors. Using a library management
system, the whole catalogue can be maintained along with the details
of library books, reissued, unreturned, and available. They can be
retrieved with a few easy clicks. This functionality also makes it easy
for management to keep track of all existing materials. For example,
if the librarian requires the current number of a specific genre, the
system can instantly provide the count.

Because it is computer-based, this programme keeps a more accurate

record of the available materials. It enables the librarian to organise
the books by title, author, publication date, or whatever works best for
the library.

3. Boost productivity

Having a management system in libraries can significantly streamline

overall efficiency. With records of the books available with a single
click, a portal for real-time analysis, and a direct connection with
students, the system can handle the majority of the tasks, saving the
team a substantial amount of time.

4. Saves time

The conventional way of managing library activities can take a while.

During the examination period, the number of students using the
library surges, causing students to wait even longer than usual. At this
time, using library management software can be incredibly
advantageous. The library team can issue books to students promptly
while also using their track record to efficiently distribute the books.
Students can also check the catalogue to see if the book they require is
presently available. This can save both students and the library staff a
significant amount of time.

The future scope of library management systems will relieve the

stress of manual labour by automating complex activities and saving
time.

5. Economical

Educational institutions have a budget for technological investments.

As a result, some institutes may regard such systems as a significant
financial investment. The sheer volume of materials in a library
makes it difficult for librarians to physically track books and other
publications. But, technology automates this type of labour. This
saves labour costs in addition to having low maintenance costs and
efficiency.
6. Management of resources

Managing the demand and availability of books can be difficult for

librarians. With the assistance of a library management system, they
can swiftly verify the records, see the history, and issue the books
accordingly. They can make book issuance and return faster and
smarter with the help of SMS notifications and alerts.

7. Effective collection of late fee

Late fines from students who fail to return books on time make it
difficult for the librarian to collect. This system enables students to
get automated SMS notifications and messages regarding books
issued, late library fees, due dates, and more. As a result, the library
can verify a student's book record and issue payments the next time
they come to pay their fees.

8. Safety

System updates and maintenance are performed on a regular basis to

guarantee that user databases are always confidential and safe. A
library management system is regularly upgraded to ensure that it is
error-free and can handle large user increases.

9. Improves reporting and monitoring

Self-updating records in an automated library management system

offer dynamic reporting and oversight. It enables more efficient
bookings, distribution of material, and user tracking.

10. Both ends find it easier to use

The benefits of using a library management system extend beyond

management. This tool will also help end users. Furthermore, the
library management system allows both parties to view materials in
circulation as well as their current state. This improves
communication and the flow of procedures in the library.

.
 BIBLOGRAPHY

The following are the books references that have been studied
in the duration of making of this project.

 Java 2 Black Book

 Microsoft office

WEB REFRENCES
www.microsoft.com