---

📌 ** Java Library Management System (Swing + Oracle DB)**

Library Management System – Java (Swing + Oracle Database)

A complete library system built using Java Swing and Oracle SQL.
The system supports book loaning, returns, user management, authentication, and full database integration.

---

📚 Features Overview

🧑‍💻 Classes

• User
• Student
• Staff
• Book
• Book Loaning
• Book Return

---

🖥️ Graphic Interfaces (Swing)

1. Login
2. Admin Login
3. Register
4. Dashboard
5. Add Student
6. Add Staff
7. Add Book
8. Search Book
9. Loaning (Student)
10. Loaning (Staff)
11. Borrow for Staff
12. Borrow for Students
13. Return Book

---

🗄️ Database (Oracle SQL)

Created 8 main tables:

1. BOOKS
2. USERS
3. STUDENTS
4. STAFFS
5. BORROW_STAFF
6. BORROW_STUDENT
7. S_RETURNED_BOOKS
8. ST_RETURNED_BOOKS

SQL scripts can be uploaded inside a /database folder.

---

📂 Project Structure

/src ├── models/ ├── controllers/ ├── views/ ├── db/ └── Main.java /database └── tables.sql README.md

---

🛠️ Technologies Used

• Java Swing
• Oracle Database
• JDBC
• OOP Design
• SQL Queries

---

▶️ How to Run

1. Import the SQL tables into Oracle DB
2. Configure the JDBC connection in the db class
3. Run the project using IntelliJ/Eclipse
4. Login using admin or user credentials

---

👤 About Me

Momen Sarsour — Computer Systems Engineering
📧 Email: momensarsour5@gmail.com
📱 WhatsApp: +970567077179