Library System for Staff & Students
Library System for Staff & Students
CHAPTER 1
INTRODUCTION
In our existing system all the transaction relating to borrowing the books are done
manually, taking more time for transaction like borrowing a book or returning a
book and also for searching of students and books.
Another major disadvantage is that to prepare the list of books borrowed and the
available books in the library will take more time. Currently it is being done as a
one day process for verifying all records.
This type of maintenance usually causes errors due to delay in updating and
mistakes during large data entry.
So after conducting the feasibility study we decided to make the manual Library
Management System to be computerized.
The problem in hand was to develop Windows based software to help the library
staff to maintain and organize a library. There is a need to develop a Library
Management System which provides an easy to use user interface to make the
existing system more efficient.
It is difficult to catch defaulters in a manual library system. LMS should solve this
problem by providing message to the administrator about the fine to be paid and
books to be returned.
When the administrator tries to issue a book to a student, LMS should check
whether the student is allowed to barrow books respective to his/her limit.
If the book has no restriction it should be issued to the student, and also the
students details should be updated with the books that he has just borrowed.
Administrator can search a book with its different attributes.
Result should be generated for available books, issued books or number of books
borrowed by each student.
1.4 OBJECTIVES
CHAPTER 2
LITERATURE SURVEY
Producing a literature survey may also be part of graduate and post-graduate student
work, including in the preparation of a thesis dissertation, or a journal article. Literature
surveys are also common in a research proposal or prospectus (the document that is
approved before a student formally begins a dissertation or thesis.
2. Java Swing, 2nd Edition By Robert Eckstein: This thoroughly covers all the
features available in Java 2 SDK 1.3 and 1.4.More than simply a reference, this new
edition take a particular approach. It is a book by developers for developers, with
hundreds of useful examples from beginning level to advanced, covering every
component available in swing. Whether you’re a seasoned Java developer or just trying to
fine out what Java can do, you’ll find Java Swing ,2nd edition an indispensible guide.
CHAPTER 3
SYSTEM REQUREMENTS
CHAPTER 4
SYSTEM ANALYSIS
System Analysis is a detailed study of the various operations performed by
a system and their relationship within and outside of the system. Here the key
question is what all problems exist in the present system? What must be done to
solve the problem? Analysis begins when a user or manager begins a study of the
program using existing system. During analysis, data collected on the various
files, decision points and transaction handled by the present system. The
commonly used tools in the system are Data Flow Diagram, interviews, etc.
Training, experience and common sense are required for collection of relevant
information needed to develop the system.
The success of the system depends largely on how clearly the problem is
defined, thoroughly investigated and properly carried out through the choice of
solution. A good analysis model should provide not only the mechanisms of
problem understanding but also the frame work of the solution. Thus it should be
studied thoroughly by collecting data about the system. Then the proposed system
should be analyzed thoroughly in accordance with needs.
Name Management
Year System
Branch 1
Username
Receipt no
Contact no
Email Security
question
Book can issue
Answers
Category
BorrowDate
2
te
ReturnDate Borrows
Fine
* Book
Accession no
Availability
Department
ISBN
Class number Edition
DESCRIPTION
When user clicks on add book/student menu item/tool then LMS will gives
internal frame of the addBook module. Then he will fill the information of the book then
those all information will be verified and stored in the database. After he got a dialog box
and it will show status of entered data.
DESCRIPTION
When user clicks on the list books/student menu item/tools. Then LMS will fetch
the book/student data, database will send that stored data to the LMS software that will be
display the stored book/student data.
DESCRIPTION
When user clicks on the borrow book menu item/tool then LMS will display the
internal frame for entering the information of the BookNo ,RegNo and finally click on
borrow button. LMS will be verify the save data for borrowing book to student in
database. After verifying saved data, database send the status to the LMS it will display
status to the user.
DESCRIPTION
When user clicks the return book menu item/tool, LMS will show the returnBook
internal frame for entering the information of the bookNo, RegNo, fine per day and
finally click return button, database will calculate the fine and it will send a status and
fine details to LMS software. LMS will display the fine of the student.
4.3.5 SEARCH
Select search criteria and enter search string Fetch data based on search string
DESCRIPTION
When user clicks on the Search menu item/tool, then LMS will display the search
internal frame then user can able to select search criteria and enter search string. Database
will search data based on searching string then it return search result to the LMS software,
software can display the searched result list.
4.3.6 EDIT
DESCRIPTION
When user clicks on the edit menu item, LMS will display edit internal frame for
entering the BookNo/RegNo and modifying the student/book details. Database will fetch
the details of book/student and send it to the LMS software, LMS will display the edit
form with pre-filled data, here user can able to make changes the data and save edit data
by clicking Save button. After clicking save button it will update the data in database, and
saved status will be displayed to user.
List Book/Student
Search Book/Student
LMS
Search Books
LMS
CHAPTER 5
TECHNOLOGY USED
The Library Management System is developed using the Java Swing API. Swing
is based on MVC Design pattern. A design pattern is a way of designing code that
benefits from experience of other developers. Design patterns are rules of thumb and
best practices. Swing components are designed as Model View Controller
components. It means separating the implementation of an application into layers or
components.
MVC Model
Encapsulate application states
Respond to state queries
Exposes application functionality
Notifies views of changes
State Query
Change
Notification
View Controller
Render the model Defines application behavior
View Selection Maps user action to model
Request updates from model
Sends user gestures to updates
controller User Gestures
Selects view for response
Allows controller to select view One for each functionality
Method Invocation
Events
DOS IN CS&E UBDTCE , Davangere Page 17
Library Management System
JFrame
JTabbedPanel
JMenuBar
JButton
JMenuItem
JComboBox
JTextField
JLabel
JTable
JPasswordField
5.2 XAMPP
An IDE is much more than a text editor. The NetBeans Editor indents lines,
matches words and brackets, and highlights source code syntactically and
semantically. It lets you easily refractor code, with a range of handy and powerful
tools, while it also provides code templates, coding tips, and code generators. It
automatically takes care of correct spacing and alignment, while supporting in-place
editing, as well. The GUI builder is very easy to use and intuitive. Since the cost of
buggy code increases the longer it remains unfixed, NetBeans provides static
analysis tools, especially integration with the widely used FindBugs tool, for
identifying and fixing common problems in Java code. NetBeans support for
multiple languages for development. It also provides cross platform support with rich
set of community provided plugins.
CHAPTER 6
SYSTEM IMPLEMENTATION
The Library Management System contains following entities and modules related to
those entities:
Book
Add Book
List All/Available/Issued Books
Edit a Book
Delete a Book
Search Book
Generate Book report
Student
Add Student
List All Students
Edit a Student
Delete a Student
Search Student
Add Staff
Borrow/Return
Borrow a Book
Return a Book
List Books Borrowed by a Student
List Books Returned by a Student
Search Book
Search Book by Name/AccessionNo/Department/ISBN
Search Student
Search Student by USN/Name/Department/Year
Adding data to the database: In this module a new data is added to the
database by getting the information from the user through forms containing
text fields. User enters the information about the book, student or staff and
the new information will be added to the database after making the necessary
checks.
Fetching the data and displaying as a list: In this module the data is fetched
from the database based on the menu selected. For example, user can select
list all books, list issued books, list of available books in the library, list of
books borrowed by the students etc. The corresponding data is fetched from
the database through database connection and the obtained ResultSet data is
directly fed to a table model present in the frame. The table model will get the
data as well as metadata of the ResultSet and the data will be displayed as a
scrollable table. The data present in the table is read only.
Editing the contents of database: In this module the user can edit the data
present in the database. The user might have entered a wrong data by
mistake. This can be rectified by editing the data based on the Book Number
and Register Number. User can delete the data from the tables. We can also
make the student eligible or ineligible based on whether they have taken
admission in the current academic year or not.
Borrowing and returning the books: In this module the library staff can
issue the books to the student or staff. The borrow details include the book
number, register number of the student, issue date and due date. The books
should be returned on or before the due date. If the book is returned after the
due date, fine will be calculated and displayed so that the fine amount can be
collected from the students.
1.Account:
2.Book:
3.Borrow:
4.Return details:
5.StudentBorrow:
6.StudentReturn:
7.StudentData:
8.StudentReg:
Class.forName("com.mysql.jdbc.Driver");
Connection
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/librarynew?z
eroDateTimeBehavior=convertToNull","root","");
return conn;
}catch(Exception e){
JOptionPane.showMessageDialog(null, e);
return null;
}
}
CHAPTER 7
TESTING
Software testing is a critical element of software quality assurance and
represents the ultimate review of specification, design and coding. Preparation of
the test data plays a vital role in the system testing. After preparation the test data,
the system under study is tested with those test data. Errors are found and
corrected by using the following testing steps and corrections are recorded for
future references. Thus, series of testing steps is performed on the system before it
is ready for implementation.
LOGIN FORM:
BORROW BOOK:
RETURN BOOK:
CHAPTER 8
8.1STAFF SIDE
8.1.1Login
8.1.2 HOMEPAGE(Staff)
8.2.1 LOGIN
8.2.4 HISTORY
CHAPTER 9
9.1 LIMITATIONS
CHAPTER 10
CONCLUSION
After we have completed the project we are sure the problems in the existing
system would overcome. The “LIBRARY MANAGEMENT SYSTEM” process made
computerized to reduce human errors and to increase the efficiency. The main focus of
this project is to lessen human efforts. The maintenance of the records is made efficient,
as all the records are stored in the ACCESS database, through which data can be retrieved
easily. The navigation control is provided in all the forms to navigate through the large
amount of records. If the numbers of records are very large then user has to just type in
the search string and user gets the results immediately. The editing is also made simpler.
The user has to just type in the required field and press the update button to update the
desired field.
The Books and Students are given a particular unique id no. So that they can be
accessed correctly and without errors. Our main aim of the project is to get the correct
information about a particular student and books available in the library.
The problems, which existed in the earlier system, have been removed to a large
extent. And it is expected that this project will go a long way in satisfying user’s
requirements. The computerization of the Library Management will not only improves the
efficiency but will also reduce human stress thereby indirectly improving human
recourses.
CHAPTER 11
REFERENCES
1. JTattoo-1.6.10.jar: JTattoo consists of several different Look and Feels for Swing
applications- http://www.jtattoo.net
BOOKS
1.Java Swing,2nd Edition By Marc Loy,Robert Eckstein,O Reilly Media
WEBSITES
1 http://www.oreilly.com/catalog/jswing2/
2 https://docs.oracle.com
3 http://www.stackoverflow.com