Capstone Project SAMPLE

CAPSTONE PROJECT: Library System Using: *JDBC *JSP *Java Servlet

Problem Statement Description of the problem To create an E-Library System as a Web App by using JDBC, JSP, and Java Servlet.

Objectives Purpose of this project The purpose of this project is to get hands-on experience in applying Java technologies, Such as JDBC, JSP, and Java Servlets in order to design an E-Library System.

Application Requirements What you should ensure… 1. Java Program to show web contents 2. Basics of SQL along with Java Program basics 3. JSP Basics 4. Use HTML & CSS for frontend (GUI) of the website 5. Utilize Bootstrap for a better GUI 6. Website Login should be Admin or Student 7. For Admin give administrative rights like add book, create course, etc. 8. For Students give options like Register, Login, Book Submit etc.

Tools Requirements What you should have… 1. JDK (1.8) 2. IDE: NetBeans 3. Java EE Version 8 4. Oracle or My SQL as DB 5. Glassfish Server / Tomcat Server

Guidelines Steps or hints to solve this project The steps to develop this project: 1. Do the project setup first (use Net Beans as an open source IDE) 2. Evaluate the different tools being utilized 3. Create Java Servlets 4. Create Login Methods in Java Servlets 5. Establish Database Connection Method 6. Create Controlling Servlets 7. Apply the JSP Basics 8. Use Database Basics 9. Utilize Java Servlet and JDBC Connections 10. Implement the Deployment on Server 11. Create the final HTML pages by deploying web app on server

Learning Outcome What you gain out of this project: ❑ Application of JDBC ❑ Application of JSP ❑ Utilization of Java Servlet

Project Code Project Code can be downloaded from here Download the code file <Elibrary+Code+files.zip> from the LMS.

Model Answer Outcome of the project should look like this ADMIN Login:

Model Answer Outcome of the project should look like this Add Librarian:

Model Answer Outcome of the project should look like this Add Librarian Details:

Model Answer Outcome of the project should look like this View Librarian:

Model Answer Outcome of the project should look like this Librarian Login:

Model Answer Outcome of the project should look like this Add Book:

Model Answer Outcome of the project should look like this Add Book Form:

Model Answer Outcome of the project should look like this View Book:

Model Answer Outcome of the project should look like this Issue Book:

Model Answer Outcome of the project should look like this View Issued Book:

Model Answer Outcome of the project should look like this Return Book:

Submission Guidelines Once you complete the project: Click on the button Insert the link of the output in the box provided against ‘Online Text’ Now click on ‘Save Changes’.

Happy Learning!