Scribd
Upload
6 views3 pages

Library Management System Java Guide

The document outlines two lab examination problem statements for a Library Management System using Java. The first requires implementing CRUD operations with JDBC on a database table, while the second involves using an ArrayList to manage books with functionalities for adding, borrowing, and returning. Both systems must include specific attributes and methods for managing book data effectively.

Uploaded by

asesinoakgnew
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
6 views3 pages

Library Management System Java Guide

The document outlines two lab examination problem statements for a Library Management System using Java. The first requires implementing CRUD operations with JDBC on a database table, while the second involves using an ArrayList to manage books with functionalities for adding, borrowing, and returning. Both systems must include specific attributes and methods for managing book data effectively.

Uploaded by

asesinoakgnew
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Process Manual for

Lab Examination Question Paper

ACTS TRAINING CENTRE – Bangalore Question Code : SRS

DBDA AUG 2024


Core Java
Date : 15.10.2024 Duration : 2 Hrs Max. Marks : 40

Problem Statement: Library Management System (Using


JDBC for CRUD perations with Business Logic)

You are tasked with creating a Library Management System using Java and
JDBC to perform CRUD (Create, Read, Update, Delete) operations on a
database table named Library. In addition to CRUD operations, you need to
implement one business logic query that performs a task beyond the basic
CRUD operations.

Database Table: Library


The Library table contains the following columns:

• int bookId: A unique identifier for each book (Primary Key).


• String title: The title of the book.
• String author: The author of the book.
• boolean isAvailable: Whether the book is available for borrowing.

Requirements

CRUD Operations:

• Create: Add a new book to the Library table.


• Read: Retrieve all books from the Library table.
• Update: Update details (e.g., title, author) of a specific book
based on bookId.
• Delete: Remove a book from the library using its bookId.
2. Business Logic Operation:

Find Books by Author: Implement a method to find all books by a


specific author and display them. This goes beyond the usual CRUD
operations
Process Manual for

Lab Examination Question Paper

ACTS TRAINING CENTRE – Bangalore Question Code : FRS

DBDA AUG 2024


Core Java
Date : 15.10.2024 Duration : 2 Hrs Max. Marks : 40

Problem Statement: Library


Management System (Using ArrayList
with Borrow/Return in Java)
Design and implement a Library Management System in Java using an
ArrayList to store and manage books. The system should support adding,
borrowing, and returning books. A class called Book should represent each
book in the library.

Requirements:
1. Book Class:

• Attributes:
• String title: The title of the book.
• String author: The author of the book.
• String ISBN: A unique identifier for each book.
• int numberOfPages: Total number of pages in the book.
• boolean isAvailable: Whether the book is currently
available for borrowing.
2. Library Class:

• The Library class should contain an ArrayList<Book> to manage


the collection of books.
3. Operations:

• Add a New Book:


• Implement a method addBook(Book book) that adds a new
book to the ArrayList.
• View All Books:
• Implement a method viewAllBooks() that displays the
details of all books in the library.
• Search for a Book by Title:
• Implement a method searchByTitle(String title) that
searches for a book by title and displays the details of the
matched book.

You might also like