First of all, this application was realized in binomial as part of a database project of the second semester of DUT Informatique at the IUT of Vélizy. The aim of this project was to develop an application serving as an intermediary between users (librarian and students) and a library whose data are stored in a database. This project is coded in Java and uses a JDBC driver to access a database managed with PL/SQL.

Here are some screenshots of the application.

Here are the different steps necessary to use the application. I would like to point out that to run the project, it is necessary to have Java and JDK installed, and to have a database manager. Moreover, the project is executable on any operating system.

You must download the application file. To do this click on the Github logo below.

Then go to the green "code" button and select "download zip".

You need to rebuild the database using the files in the PL/SQL folder. Then modify the connection identifiers in the code, in the constructor of the Jdbc class. Finally, we will have to add the JDBC driver, it is in the lib folder, and it is called class12.jar. To do this, you must add it to the "BuildPath" of your project.

You will have to run the application. To avoid you to search, I specify that the main method is in the file WindowConnection.java. To do this, you must compile and then run the project. If everything went well, the application should have launched, you just have to test our application!

When you launch the application, you must connect to an account in the database. Then you have access to different features depending on whether you have logged in with a student or a librarian account.

The only functionality in common with these two types of account is the search for a book according to search criteria. A student account can also reserve a book. A librarian account can accept a book reservation, make a reservation into a loan, and record the return of a book in the database. In addition, a librarian account also allows for the display of out-of-date loans, the addition of new books, and the management of student accounts.

If you have a question or a problem, do not hesitate to contact us at the following email address: [email protected]

• Fix known bugs
• Prevent borrowing of a book already borrowed
• Fix the number of copies for each book
• Improve the application's interface

We welcome all kinds of contributions. People can propose changes through Github by submitting commits.

The authors of this project are the following:

• GACHE Antoine
• PELLEGRINI Arthur

We would also like to thank the following people for their help in developing this application:

• DELORME Nathan
• LENFANTIN Alexandre
• ZEITOUNI Karine

The development of this project was stopped after it was submitted to our University jury. But it is possible that the application will be improved afterwards.