BCSL 57 Web Programming Lab

IGNOU BCSL-57 (July 2025 – January 2026) Assignment Questions

Q1. Project: Community Library Management Website
You are required to design and implement a dynamic web application for a “Community Library”. The website will allow users to browse available books and submit a request to borrow a book.
The website must consist of three pages, all following the layout shown in Figure 1

Part A: HTML, CSS, and Client-Side Scripting

(i) Create Three HTML Pages:
Create three separate HTML files: index.html (Home), books.jsp (Available Books), and borrow.html (Borrow). All three pages must share the same layout as described in Figure 1, with a common Top Division for navigation.

(ii) CSS Styling:
Create an external CSS file (style.css) and link it to all three pages. This file should define the following styles:
• The Top Division should have a dark background color (#333) with white text for the navigation links.
• The Information Division should have a light grey background (#f4f4f4).
• The currently active navigation link should be highlighted (e.g., with a different background color or an underline).
• Use appropriate fonts, margins, and padding to make the layout clean and readable.

(iii) Home Page (index.html):
The Information Division of the Home page should display:
• A welcoming headline, e.g., “Welcome to the Community Library”.
• A brief description of the library’s mission and operating hours.
• An image of a library or books.

(iv) Borrow Page (borrow.html) and JavaScript Validation:
The Information Division of the Borrow page should contain a form for users to request a book. The form must include fields for:
• Full Name (Text input)
• Email Address (Email input)
• Book ID (Text input, referring to the ID from the “Available Books” page)
• Borrow Date (Date input)
Create a JavaScript function to validate this form on submission:
• All fields must not be empty.
• The Email Address must be in a valid format (e.g., contain ‘@’ and ‘.’).
• The Book ID must be a number.
• If validation fails, display an alert message and prevent the form from submitting.

Part B: JSP and Database Connectivity 

(v) Database Setup:
Create a database (e.g., in MySQL or Oracle) named library_db. Inside this database, create a table named books with the following schema:
• BookID (INT, Primary Key)
• Title (VARCHAR(100))
• Author (VARCHAR(100))
• Genre (VARCHAR(50))
• Status (VARCHAR(20), e.g., ‘Available’ or ‘Borrowed’)
Insert at least five sample records into the books table.

(vi) Available Books Page (books.jsp):
This page must be a JSP page. The Information Division should dynamically generate a table of all books from the library_db database.
• Use JSP scriptlets (<% … %>) to connect to the database.
• Execute a SQL query to fetch all records from the books table.
• Use a loop to display the data in an HTML table with the columns: Book ID, Title, Author, Genre, and Status.
• Only books with the status ‘Available’ should have a green background color for the status cell. Books with ‘Borrowed’ status should have a red background.

(vii) Submission Handling (Optional, for higher marks):
(You are not required to write the full server-side code for processing the borrow form, but describing the logic is encouraged.) Briefly explain how you would create a JSP page (process_borrow.jsp) to handle the form submission from borrow.html. The explanation should cover:
• Retrieving form data using request.getParameter().
• Connecting to the database.
• Updating the status of the requested book in the books table from ‘Available’ to ‘Borrowed’.
• Displaying a success or failure message to the user.

Submission Checklist:

1. A report containing:
o Screenshots of all three web pages (Home, Available Books, Borrow).
o The complete code for index.html, borrow.html, books.jsp, and style.css.
o The JavaScript validation code.
o The SQL CREATE TABLE statement and INSERT statements for your database.
2. All source files should be included in the submission package.

IGNOU BCSL-57 (July 2024 – January 2025) Assignment Questions

IGNOU BCSL-57 (July 2023 – January 2024) Assignment Questions