My Projects

 Project Overview

This project is a Java-based Library Book Loan System, developed using IntelliJ IDEA. It utilizes Excel as a database to store and retrieve information about books and users. The system is designed to efficiently manage book borrowings and returns while maintaining an organized database structure.

 Key Features

• Book Loan Management: Users can borrow and return books with ease.

• Excel Database Integration: Book and user data are stored in an Excel sheet, making it lightweight and easy to manage.

• Data Structure Implementation: Uses ArrayLists and Abstract Data Types (ADTs) such as public/private access modifiers to ensure data security and proper encapsulation.

• User-Friendly Interface: Provides a simple console-based interface for users to interact with the system.

• Efficient Searching & Filtering: Books can be searched based on title, author, or availability.

• Error Handling & Validation: Ensures that users do not borrow more than allowed and that book information remains accurate.

 Technologies Used

• Programming Language: Java

• Development Environment: IntelliJ IDEA

• Database: Excel (Integrated using Apache POI for file manipulation)

• Data Structures: ArrayLists, Encapsulation (private/public access modifiers)

• File Handling: Read and write operations to Excel for data persistence