It is just implementation on DSA and OPPs concept.

📚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.