Functionalities for student, teacher and administrator of
the library. Used SQL for querying the database(MySQL) using JDBC which is a
Java-based data access technology used for Java database connectivity.
Used Java-Swing for designing the GUI.
Attached Screenshot of few windows for preview.
Database Schema
Login Form:
Function available for admin: login ID and Password for admin is "admin".
"Reset database" Button will drop the current the database and create a new one with all the required tables in it.
When you click on any button which shows data, it almost looks similiar to this one: