Library Management System
This library management system project is based on Java Swing and connected to the MySQL workbench database, displaying statistical results and storing data within the system. The main objective of this project is to effectively automate all the manual activities of the library. The system saves time for both the users and the administrators. With just one click, users can search for available books in the library. The software works on borrowing books, returning books, searching books, adding new users, announcements, book availability, etc.
Using Software Tools:
- Apache Net-beans IDE
- MySQL Workbench
Jar files:
Administrator module:
- Add users
- Update users
- Delete users
- Add books
- Manage books
- Borrow books
- Return books
- Announcements
User module:
- Register
- Borrow books
- Return books
- View Announcements
- Update account
- Delete account
Login activity diagram of library management system shows administrators and user login activity flow. Where administrators and users will be able to login using their email, password, and verification code. If the email and password match and provide an authentic verification code which is displayed on the login form then forwarded to the dashboard. A successful login allows administrators and users to manage all activities based on their roles.
Figure: login activity diagram
Use Case Diagram
A usage method that is used to identify "elaborate" in system analysis and to organize system requirements. The use case is made up of possible sequences of interactions between systems and users related to a specific environment and a specific goal. It is represented using ellipses. Actor is an external entity that makes use of the system being modeled.
Figure: use case diagram
Administrator modules:
Login- Administrator provide a correct email address
- Administrator provide a correct password
- Administrator also provides a verification code which will be displayed on the login form
If the administrator gives any wrong information then the administrator can't access this system.
Dashboard
- If the administrator successfully login the system automatically redirects the administrator to the dashboard form.
- Administrator can see all the statistics information about this system such as total users, pending users, categories of books, borrow books, overdue books and announcements.
- Here, administrator can manage all the functionality like manage books, add user, manage users, borrow books, return books, overdue return, return books view, overdue books view, and manage announcements.
Manage books
- Administrator can add new books
- Administrator can update books information
- Administrator can delete books
Add User
- Administrator can add new user
Manage Users
- Administrator can't update the user id, but all other information can be updated by the administrator.
- Administrator wants to update the email address or phone number. If the email address or phone number already exists then the administrator won't update it.
- Administrator can borrow books with a specific user ID.
- Administrator can return a book by selecting a specific user.
- Books can't be returned here if the due date is over then the return type is an overdue return.
- All books will be displayed here if the due date is over.
- If the administrator wants to return an overdue book "user will have to pay a fine"
- Here will display all return books in the table.
- Here will display all overdue return books in the table.
- Administrator can add announcements, update announcements and delete announcements.
- Administrator can send announcements by selecting a specific user or all users.
- Administrator can send a message by selecting a specific user or all users when the book returning deadline is exceeded.
User modules:
Register
- User can register a new account
- After registering, user needs to wait for administrator approval without administrator approval user can't access the system.
Login
- After administrator approval user can access this system.
- User needs to provide a correct email address.
- User needs to provide a correct password.
- User also needs to provide a verification code which will be displayed on the login form.
- User can borrow books
Return Books
- If the return deadline is not exceeded, the user can return the book.
Overdue Returns
- If the user wants to return an overdue book user will have to pay a fine.
- Here will display all return books in the table.
- Here will display all overdue return books in the table.
- User can't update the user id, but all other information can be updated.
- User wants to update the email address or phone number. If the email address or phone number already exists then the user won't update it.
Note: Project customization is available
