Book Inventory System

Description

The Book Inventory System is a GUI-based desktop application developed using JavaFX and MySQL to manage book records efficiently. It provides an intuitive and interactive interface for users to maintain a small library or personal book collection.

---

Key Features

• Add, Update, Delete Books: Perform all CRUD operations through a clean and user-friendly JavaFX interface.
• Search Function: Quickly search for books by title or author for faster access.
• Database Connectivity: All data is stored in a MySQL database using JDBC, ensuring reliability and real-time updates.

---

System Design

• Frontend (JavaFX): Handles the user interface, including buttons, text fields, and a TableView for displaying book records.
• Backend (Java + DAO): Manages data processing and performs operations such as inserting or retrieving records.
• Database Layer (MySQL): Stores book details including title, author, and borrowed status.

---

Purpose & Learning Outcome

This project demonstrates how to integrate a graphical interface with a database backend. Key learning outcomes include:

• Enhancing Java programming skills
• Working with JDBC for database connectivity
• Handling events and UI interactions in JavaFX
• Understanding modular coding and MVC architecture for maintainability

---

Getting Started

Prerequisites

• Java JDK 17+
• JavaFX SDK
• MySQL Database
• IDE (VS Code, IntelliJ, Eclipse, etc.)

Setup

1. Clone this repository:

   git clone https://github.com/AidanAmaral/MiniBookManagement.git

2. Set up the MySQL database and update the connection details in your project.
3. Build and run the application using your IDE or JavaFX commands.