Java Library Management System

This is a desktop Library Management System built in Java using JavaFX for the interface and MySQL (via JDBC) for data storage. It automates the day-to-day operations of a library through an admin login and an intuitive dashboard.

The system lets the librarian add, edit and search books, register members, issue books to members, record returns, and automatically calculate fines for late returns based on the due date. It maintains a full transaction history and shows the current status of every book (available or issued). Reports summarize issued books, overdue items and member activity.

The project follows a layered structure separating UI, business logic and database access using DAO classes and prepared statements. It is a classic academic Java project that clearly demonstrates OOP concepts, JDBC connectivity, JavaFX UI design and CRUD operations.

Detailed Project Description

Java Library Management System digitises the day-to-day records and workflows of an organisation so data is stored once, retrieved instantly and reported accurately.

How It Works
1. Role-based login separates admin, staff and end users.
2. Each module (records, bookings, transactions, reports) provides full CRUD operations with validation.
3. Data lives in a relational database with proper relationships between entities.
4. Reports and search views summarise the stored information.

Implementation Steps
1. Define requirements and draw the ER / class diagram and screen flow.
2. Set up the environment (JDK, JavaFX, MySQL) and create the project skeleton.
3. Design the database schema / data model and seed it with sample data.
4. Implement the core modules with validation and role-based access where needed.
5. Build the user interface and connect it to the backend / data layer.
6. Test each module (unit + manual), fix edge cases and secure inputs (SQL injection, XSS, auth).
7. Prepare documentation, screenshots and a demo build.

Key Features
- Role-based access
- CRUD modules
- Search and filters
- Reports / export
- Validation and error handling

Expected Output
On completion the student will have a multi-user application with organised records and printable/exportable reports.

Deliverables
- Complete source code with comments
- Database schema / data model and screen flow
- Project report with screenshots and results
- Demonstration-ready build