This project implements a College Library Management System designed to streamline library operations for librarians and students.
Features:
- User Management:
- Separate login for librarians and students with role-based access control.
- Registration for new students and librarians.
- Book Management (Librarians):
- Add, edit, and delete book entries with details like title, author, category, etc.
- Search for books by title, author, or category.
- Track overdue fines(rs.10 per day).
- Student Management:
- Browse and search the library catalog for books.
- Borrow books (atmost three per student).
Tech Stack:
- Front-end: Java Swing
- Back-end: Java Database Connectivity (JDBC)
- Database: Designed to work with MySQL
Test Environment:
- Operating System: Windows
- Java Version: java 22.0.1 2024-04-16
Getting Started:
- Get Repository URL: Copy the URL to Library-Management-System repository.
- Open NetBeans: Choose Team > Git > Clone or Team > Remote > Clone from the main menu. This opens the Clone Repository wizard.
- Enter Repository URL: Paste the repository URL into the appropriate field and click Next.
- Select Branch: Choose the branch(es) you want to download to your local repository and click Next.
- Choose Directory: Enter or browse to the directory where you want to clone the repository on your hard drive.
- Set Clone Name: The default name for the local folder will be the name of the Git repository.
- Choose Branch: Select the branch you want to check out into your working tree.
- Set Remote Name: Typically, the default remote name "origin" is recommended for the original repository being cloned.
- Finish: Click Finish to clone this repository into the specified directory.
WorkFlow and Execution:
- Copying URL of the repository:
- Cloning the repository in NetBeans IDE:
- Executing the project in NetBeans IDE:
- HomePage provides login facilities to both Student and Librarian:
- Librarian Phone Number is the Librarian Login Password
-
New Librarians and Students can register themselves easily:
-
DataBase Used : Library.
-
Once logged in, a Librarian can efficiently access Librarian Dashboard with all of its features.
-
Once logged in, a Student can efficiently access Student Dashboard with all of its features.
- Points to remember
- Student and Librarian data is stored in Student and Librarian tables respectively.
- Books when searched, added, edited or deleted, are done from Books table in the Library Database.
- A book when issued, its entry is logged in issuebookrecord table.
- When the specified book is returned, its record is removed from issuebookrecord and finnaly logged in borrowing_history table.
- Any Librarian can issue book to any student.
- Atmost three books can be issue to one student.
- If a borrowed book is not returned within fifteen days, a fine of rs.10/day is imposed on the student.