LIBRARY MANAGEMENT SYSTEM
INTRODUCTION
- Our Web Application is about Library Management System and we covered major area like java server pages, Servlets, Java beans, and JDBC.
- We develop our application using NETBEANS 8.2 Version.
- We used session via cookies.
- In this application we have provide users to register member, add book, search book, issue book, return book, view books and we have provided login and signup from to staff to login in to the page and logout to leave the page.
- And we included form to register member details to issue books.
- We designed database using MYSQL workbench.
- We used MVC design pattern to design this application.
- We used Hibernate which is a Java framework to interact with the database.
- We used HeidiSQL to browse and edit data, create and edit tables, views, procedures, triggers and scheduled events.
OBJECTIVES
- Our object is to handle the entire activity inside the library.
- The system keep track about the book details, staff details, member details and book issued and return details.
USE CASE DIAGRAM
ER DIAGRAM
1.LOGIN PAGE
If the user register as a staff member, he or she can login to the system.
2.STAFF SIGN UP PAGE
If the user didn’t register as the staff member he or she must sign in as the staff member.
3.STAFF PROFILE
After login to the system, this is the page that user see.
4.REGISTER NEW BOOK PAGE
- MEMBER REGISTRATION PAGE
6.ISSUE BOOK PAGE
7.RETURN BOOK PAGE
8.BOOK TABLE IN THE DATABASE
9.DATA OF BOOKS IN THE DATABASE
10.BOOK CATEGORY TABLE IN THE DATABASE
11.BOOK CATEGORY DATA IN THE DATABASE
12.MAMBER TABLE IN THE DATABASE
13.MEMBER DATA IN THE DATABASE
14.STAFF TABLE IN THE DATABASE
15.STAFF DATA IN THE DATABASE
16.MEMBER HAS BOOK TABLE IN THE DATABASE
17.MEMBER HAS BOOK DATA IN THE DATABASE
TECHNOLOGISE USED –
- MYSQL WORKBENCH
- HEIDISQL
- HIBRENET FREAMWORK
- NETBEANS IDE 8.2 VESION
LANGUAGES WE USED -
- HTML & CSS
- JAVA SERVER PAGES(JSP)
- JAVA CLASS (SERVLETS)
- JAVA CLASS (BEAN CLASS)
- MYSQL
METHODS WE USED –
- SESSION& COOKIES
- GETTERS AND SETTERS
- GET & POST
- PROCESS REQUIEST SO ON.