Java Book Loan Management App

I need a Java application to manage book loans, developed in phases for a little school project.

Phase 1: Console Programming
- Input and manage books, users, and loans
- Operations: Add, update, delete records; Search and filter records
- Book details: Title, author, genre, ISBN, publication year, number of copies, availability status

Phase 2: Oracle Database Integration
- Store data with JDBC
- Execute simple and advanced SQL queries (averages, filters, sorting)
- Create log files recording user actions

Phase 3: Graphical User Interface (Swing)
- Develop complete GUI for:
- Adding, modifying, consulting users
- Displaying loans
- Generate results file with metrics (e.g., number of users per birth year, average loan duration)

Ideal Skills and Experience:
- Proficiency in Java and object-oriented programming
- Experience with JDBC and Oracle databases
- SQL query writing skills using SQL Developer
- Familiarity with Swing for GUI development

I will provide you with all the necessary access to my SQLDeveloper database made available for the project. I will also provide you with the sample programs afterward.

In summary, the goal is to create a Java program that generates a menu with several functions:

Add a book
Add a user
Add a loan
Display all books
Display all users
Display all loans
Delete a book
Delete a user
Display the number of users by year of birth
Display the average actual duration of loans
Search for the number of books containing a specific word in their title.