Introduction
In this software we have created a Management System for any Library. Keeping in mind the ease and requirements of user, this software has been created. We have tried to provide all the possible facilities that must be needed to organize any library database. This software is created in Visual J++ 6. You will enjoy the following facilities in this software.
Facilities
This software includes the following facilities:
THE DATABASE
This is the ER Diagram of the Database, which is working on the
Backhand of Our software. The snap below shows the relationship between the
tables of our Database. There are five tables in our Database.
In Publishers and Titles Table there is one to many relationship. In Titles
and Authors Table there is many to one relationship. In Titles and IssuedBooks
Table there is one to many relationship. In IssuedBooks and Student Table there
is many to one relationship.
THE MAIN FORMS
Main Page
This is the main interface of the software. Icons are specially designed to make the interface convenient to user. This form contains links to five other forms, which are connected to the main database through JDBC. These five forms are:
New Entry
This form provides 9 fields of Book Record. This form is directly
connected with the database where the entries are stored in the Table named
TITLES. For data navigation, DataNavigator tool is used. This tool is connected
with DataSource & DataBinder tools to achieve this task. There are buttons
to Add, Remove, Update & Refresh the entries.
Before entering a new record of a book, entries for Author and Publisher must
be made in the corresponding forms. For this purpose two buttons i.e. Author
Entry & Publisher Entry are provided. Pressing these buttons will show the
Author Entry and Publisher Entry forms, which are connected with the database.
User cannot add the record unless the entries for authors and publishers are
present in said forms.
Author and Publisher Entry
These are the two Author & Publisher entry forms. In these forms we can Add, Remove, Update or Refresh Author and Publisher data.
 |
 |
Student Record
This form provides 4 fields of Book Record. This form is directly
connected with the database where the entries are stored in the Table named
STUDENT. For data navigation, DataNavigator tool is used. This tool is connected
with DataSource & DataBinder tools to achieve this task. There are buttons
to Add, Remove, Update & Refresh the entries.In this form, you can enter
the student record. The most exciting feature in this form is the Password Entering.
Each student will be allocated a password, which will be used in future for
borrowing of books.
Issued Books
This form provides 6 fields of Book Issuing. This form is directly
connected with the database where the entries are stored in the Table named
Issued Books. For data navigation, DataNavigator tool is used. This tool is
connected with DataSource & DataBinder tools to achieve this task. There
are buttons to Add, Remove, Update & Refresh the entries. The Issue and
Due Dates are entered according to the system time.
In this form, you can enter the book issuing information. The most exciting
feature in this form is the Password Checking. When borrower enters his/her
enrolment number and password along with other fields, the checking facility
will automatically checks his/her enrolment number and password. If both are
OK, then he/she can borrow the book otherwise not.
Search
This is the Search Form with 7 fields. The users are allowed to search the book record and student record by any field regarding them. The DataGrid is used to show searched results. If the required field is found, then full information regarding that book will be shown. In case of negative result, the search may be continued or skipped.
Following figures shows the Search Form after finding some results.
List View
In this window, you are able to view the list of Books that are present in the record, arranged in fixed pattern. We can view the Tiles, Author Name, Publisher Name, ISBN, Edition Number, Pages, Price and Year Published. All these entries are coming from different tables. This is achieved using SQL queries.
About Us
This form provides information about the Programmers of this software.
PROGRAMMERS