Library Management System using Java and JDBC

This project presents a simple Library Management System built using Java. The system is designed to manage library accounts, books, and devices. Users can create accounts and borrow or return books and devices.

The project applies Object-Oriented Programming concepts such as classes, constructors, methods, setters, and getters. It also includes a JDBC connection file that connects the Java application to a MySQL database.

Key Details

• Course: CS2132
• Tools: Java, OOP, JDBC, MySQL, UML Class Diagram
• Project Type: Library Management System
• Main Classes: Accounts, Books, Device, Library, myJDBC
• Main Features: Account management, book checkout, book return, device records
• OOP Concepts: Classes, constructors, setters, getters, and methods
• Database Connection: Java connected to MySQL using JDBC
• Database Name: librarypro
• Main Goal: Build a Java-based library system for managing users, books, and borrowable devices

Project Overview

The system is designed for students, library employees, visitors, and anyone interested in borrowing a book or a device from the library. The application allows users to create accounts, check out books or devices, and return borrowed items.

Main Features

• Create library accounts
• Manage account information
• Manage book records
• Manage device records
• Check out books
• Return books
• Represent borrowable devices
• Connect Java with a MySQL database using JDBC

Main Java Classes

• accounts.java — Represents user account information.
• books.java — Represents book information and includes book checkout and return functionality.
• device.java — Represents borrowable library devices.
• library.java — Main library system class.
• myJDBC.java — Handles the JDBC connection between Java and MySQL.

Database

The project includes a JDBC connection to a MySQL database named librarypro. The JDBC file is used to connect the Java application to the database and test whether the connection works successfully.

UML and Documentation

• UML.md — Contains the UML class diagram or UML-related documentation.
• project_summary_template.docx — Final project report with project summary, system design, UML diagrams, and screenshots.
• WhatsApp Image 2023-12-11 at 23.49.52_21641587.jpg — Project-related image or screenshot.

How to Run

1. Open the project in a Java IDE such as IntelliJ IDEA, Eclipse, or VS Code.
2. Make sure Java is installed.
3. Make sure MySQL is installed and running.
4. Create or import the required database named librarypro.
5. Add the MySQL Connector/J library to the project.
6. Update the database connection settings in myJDBC.java if needed.
7. Run the main Java file, usually library.java.

Project Scope

This project demonstrates a Java-based library management system using Object-Oriented Programming. It focuses on organizing users, books, and devices through classes and methods, while also showing how Java can connect to a MySQL database using JDBC.

Authors

Sana Rahmani
Rama Alkusair
Layan Albar

Effat University – CS2132