A library management java application with the complete CRUD operations
This project uses a mysql connector(mysql-connector-java-5.1.23-bin) and has a mysql file which should be imported to a localhost (xampp used in this project) in order to properly run the java file.
Classes: HomePage.java, LoginPage.java, SignupPage.java
Database Name: Library_db,
Database table: Library_Books, Library_Login
The LoginPage.java displays a login form in which when a user enters a login information, the values are being compared to the values in the database(Library_Login) to verify user details.
The SignupPage.java enables a user to signup and the user details is saved into the database (Library_Login).
The HomePage.java displays a list of books from database table (Library_Books) unto a table using the rs2xml.jar file In the HomePage, users can search for any record in the database using the search field provided below the name of user being logged in.
It also contains buttons used to navigate through different panels for various operations to be performed.
'All Books' button used to display all books in the database
'Add' button which is used to add a book record to the database
'Modify' button which is used to modify a record in the database
'Delete' button which is used to delete a record in the database
When the 'Add' button is clicked, it displays a panel to get the record of books to add to the database
When the 'Modify' button is clicked, it displays a panel to get the id of the record to be modified and then gets the details of the book relating to the id inserted
A user can also delete a book record by inserting the book id to be deleted into the provided field and a user could log out of their account
