📚A library management system implement using concepts of OOP in JAVA, GUI desgined using Java Swing and MS SQL as database.
System Users/Actors
- Librarian
- Clerk
- Borrower
Functionalities
-Librarian
- can search book by title
- can search book by subject
- can search book by author name
- can view loan history of borrowers
- can add borrower
- can update personal information of borrower
- can checkout an item
- can checkin an item
- can record fine of borrower
- can increase quantity of book
- can decrease quantity of book
- can add new book
- can delete a book
- can update book info
-Clerk
- can search book by title
- can search book by subject
- can search book by author name
- can view loan history of borrowers
- can add borrower
- can update personal information of borrower
- can checkout an item
- can checkin an item
- can record fine of borrower
- can increase quantity of book
- can decrease quantity of book
-Borrower
- can search book by title
- can search book by subject
- can search book by author name
- can view loan history of borrowers
- request a loan
Run this project
-For running this project , you must have installed JDK and NetBeans.
-Create a new project using netbeans and include these files in source code folder.
-The include sqljdc driver.
-Change the connection string in dbConnectivity.java according to your system.
-Select LoginUI.java and click on run file.
For getting in touch or any help follow Minahil Imtiaz
If this project helped you, then follow me on @minaahilimtiaz and 🌟 this repository