University Library Management System
You can read the requirements here.
JDK 11 is required in order to run this desktop app.
- IntelliJ IDEA
- Scene Builder
- DB Browser for SQLite
- Books
- Subscribers
- Loan
- Disponibility
- 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)
- Search by id and/or fullname (id, fullname)
- Insert (fullname)
- Update (id, fullname)
- Delete by id or fullname (id, fullname)
- Loan book (bookId, subscriberId)
- Return book (bookId, subscriberId)
- Get loaned books (joinSubscriber: boolean) -> bookId, bookTitle, subscriberId, subscriberFullname
- Get available books () -> bookId, bookTitle
