Library Management System

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:

Function available for Teacher:

Function available for Student:

Registration:

Student Menu: