Skip to content

Latest commit

 

History

History
141 lines (94 loc) · 3.97 KB

README.md

File metadata and controls

141 lines (94 loc) · 3.97 KB
Raw

Library Management System

The objective of this project is to learn Swing and jdbc.

The Library Management system provides following functionalities:

  • 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

Working

  • 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.

Database Design

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


Screenshots

  • Login Screen

picture alt



  • Add new Book

picture alt



  • Search Book

picture alt



  • List all Books

picture alt



  • Issue Book-1

picture alt



  • Issue Book-2

picture alt



  • List Issued Books

picture alt



  • List Books to be returned on current Date

picture alt



Tools and Technology used

  • Programming language → java 8
  • Netbeans IDE
  • MariaDB(MySqL) database

Reference Link:

How to create a cardLayout with netbeans GUI Builder

Demo

  • 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 :)