Part A
1. We have uploaded a sample project on moodle(J2EEProject.zip). Extract and import the project into the eclipse workspace.The handout(Handout.pdf) is also uploaded on how to import the project. [Add the Screen shots of implementation] 10 Points
2. The project has been written using jsp/servlet. It takes student details from the jsp file and adds to
the database using servlet. Then displays the success message on the jsp file.
(Note : In the servlet code ,add your database name,mysql username and password
correctly in the jdbc url).
[Add the Screen shots of implementation] 10 Points
3. Execute the project and understand the execution flow. [Add the Screen shots of implementation]
Part B 5 Points
1. Library Management System
Task 1. Design the database Library and create tables:
a. book(book_id, title,category,author);
b. student(student_id,name,dept_name,year,semester);
c. issue(student_id,book_id,issue_date,return_date); 15 Points
[Submit the code and screenshots of the result ] Task 2. Load data into these tables:
a. 5-6 tuples in the book table.
b. 5-6 tuples in the student table.
c. 8-10 or more tuples in the issue table ensuring that the queries below will get some Results. 10 Points
[Submit the code and screenshots of the result ]
Task 3. Create a Java-J2EE project and do the following :
a. Home.jsp file to give two options “Add a book” and “Issue a book”.This should redirect to corresponding jsp file when clicked.
b. Add.jsp file to take input as book_id, title, category, author. Then check if the book_id already exists, otherwise add these book details to the book table using a servlet named AddServlet.java. Print “Book is added successfully” after adding in the new jsp page named AddResult.jsp.
c. Issue.jsp file to take input as student_id,book_id,issue_date.Then add these issue details in the issue table if and only if a student exists(check student_id in student table) using a servlet named IssueServlet.java. Print “Book issued successfully” after adding in the new jsp page named
IssueResult.jsp. (Here return_date can be null) 30 Points [Submit the project source code as zip file along with report containing implementation of the project]]
Demo:
[Demo will be taken on both Part-A and Part-B, you have to show the implementation of your project] 20 Points
How to Submit?
[Submit a <roll_number>.zip file which contains Part-A and Part-B in different folders with name Part-A and Part-B]
NOTE:
3. Mode of submission is moodle.
