Inspiration
As I use the library a lot of times and checkout books, I wanted to do my javafx project which does the same functionalities of the university's library website.
What it does
It is a role-based platform with two roles: an admin or a customer. If a user logins, the username and password are authenticated using the information from the database by which we can also find out if it is a customer who is trying to login or an admin.
Admins are given functionalities like view accounts of all the customers, adding a book, viewing books, updating books and deleting books. All the changes the admin does with these functionalities are also changed in the database in the server.
The customer has different functionalities from the admin like a customer can view only his accounts, add an account to his accounts, update an account, delete an account and view and reserve books. The books he selects from the books table displayed to him will be reserved and added to the reservation table in the database in the server which can then be checked out.
And the customer or the admin have also the option to logout anytime.
How I built it
I built it with JavaFX using Model-View-Controller (MVC) architecture. I designed the database models using ERD and hosted it on the server. The data from the database in the server will then later be retrieved in javafx for use.
Challenges I ran into
I ran into some challenges like I didn't know how to retrieve the information from the database using queries in my JavaFX project because of my lack of knowledge of SQL.
Log in or sign up for Devpost to join the conversation.