- Login
- Add a book
- Search a Book based on Book Title
- Search Books based on Category
- Search Books based on Author
- List All Books along with author information
- Issue Book to Student
- List Books issued to Student based on USN number
- List books which are to be returned for current date
- A user can add book by providing the following information, title, ISBN (Book Number), category and Author information (Author Name and Phone Number).
- Book search can be based on book title, or category or Author, when a book is found, entire information has to be printed on the screen. Partial searches to be supported (for example, if user searches by ‘ja’, ‘Java Complete Reference’, ‘Head First Java’ books) should be displayed.
- A user can list all books present in the library and also the books issued to the students using their USN number.
- A book can be issued to a student by first selecting a book from list of books and then selecting the student from the list of partial or complete search result. Also the date of issue is saved while issuing and return date is calculated (i.e. 7 days from issue date).
- Also if the book is not in library, the user should be informed about the unavailability of the book.
| Book Table | - |
|---|---|
| Book ISBN | Primary key |
| Book Title | Varchar |
| Category | Varchar |
| No of Books | int |
| Author Table | - |
|---|---|
| Author Name | Varchar |
| Author Mail Id | Varchar |
| Book ISBN | Foreign KEY, References Book |
| Student Table | - |
|---|---|
| USN | Varchar, Primary Key |
| Name | Varchar |
| Book ISSUE Table | - |
|---|---|
| Issue ID | Auto Increment, Primary Key |
| USN | Foreign Key, References Student |
| Issued Date | Date |
| Return Date | Date |
| Book ISBN | Foreign Key, References Book |
| ADMIN Table | - |
|---|---|
| Admin Id | Varchar, Primary key |
| Password | Varchar |
- Login Screen
- Add new Book
- Search Book
- List all Books
- Issue Book-1
- Issue Book-2
- List Issued Books
- List Books to be returned on current Date
- Programming language → java 8
- Netbeans IDE
- MariaDB(MySqL) database
How to create a cardLayout with netbeans GUI Builder
- Install MariaDB and follow the steps given in this file.
- Now download this project and go to dist folder
- Double click on LibraryManagement.jar and here you go :)