README

About

University Library Management System
You can read the requirements here.

Notes

JDK 11 is required in order to run this desktop app.

Dev Tools

• IntelliJ IDEA
• Scene Builder
• DB Browser for SQLite

Progress

UI Integration

• Books
• Subscribers
• Loan
• Disponibility

DB Operations

Books

• Search by id or title (id, title) // if matches any of the two, return it
• Insert (title)
• Update (id, title)
• Delete by id or title (id, title)

Subscribers

• Search by id and/or fullname (id, fullname)
• Insert (fullname)
• Update (id, fullname)
• Delete by id or fullname (id, fullname)

Loan

• Loan book (bookId, subscriberId)
• Return book (bookId, subscriberId)

Disponibility

• Get loaned books (joinSubscriber: boolean) -> bookId, bookTitle, subscriberId, subscriberFullname
• Get available books () -> bookId, bookTitle

Demo