Library System

Develop a Desktop Application (GUI) by Components forming part of [login to view URL] package that will connect to a database by JDBC API. This should be a library manager having the following functions; login and register with multiple system users concurrently, register new books, delete books and edit books, register new clients then can also edit or delete clients. Lend books to clients and returning books from clients. Showing the client lending history. Then searching for books by name/author/isbn. Searching for clients by name/email/card id no. Search for rented and also overdue books.

An audit trail needs to also be added where changes made by a system user to books and clients should be displayed on a separate text file called "[login to view URL]". This should also be capable of logging the searches being run against the database together with any issues that might cause the library manager application to halt operation. Therefore the audit trail will process two types of logging; information logging and error logging.

This Desktop application should support Multiple Document Interfaces which may use JFrames, JDialogs etc.. The system should also allow multiple concurrent system users to login by proving a login screen and register link for those who do not have an account.

When the software is run, it needs to first show a login screen form, then once logged in the main menu (with clients, books, lending, returning and search) is displayed. The user that is logged in needs to have their name written at the top (eg: Hello *name that has been logged in*). Then the system user can choose from the main menu what they would like to do next.

Books:

List of books should be kept in a database. This is the information needed for books: ISBN, Library Id, Name, Authors, Category, Purchase Date and Written Off Date. There might be multiple copies of a book in the library therefore a book will be kept multiple times however will have the same ISBN as its counterpart but a different Library Id. A book might have multiple authors and authors might have written multiple books. Also the books will fall under a specific category. New books can be registered within the application, modified and also removed.

Client:

List of Clients should be kept in a database. This is the information needed for clients: ID Card No, Name, Surname, Address, Email, Tel No. New clients can be registered within the application, modified and removed.

Lending:

Lending records should be kept when books are taken out by Clients. When lending a book the application should record this information: Lending Date, Book, Client, Due Date and Return Date. By default all books can be taken out for a maximum of 7 days.

Audit Trail:

Audit Trail will be processing two types of logging: Information logging and error logging. Should be persisted to disk on a text file called "[login to view URL]". The Audit Trail record should contain the Date, Time, Type, Message and System User.

(Ex: 1. 1/01/2015 10.00.00 - INFO: New Book Created with ISBN 123-0099887766 ([login to view URL])) etc..

Database:

This application should use MySQL and must contain these tables: Book, Client, Lending and System User however there is no limit to how much the library manager can be expanded.

Java MySQL Αρχιτεκτονική Λογισμικού

Ταυτότητα Εργασίας: #7318675

Σχετικά με την εργασία