Part -A
1. Using the handout (JDBC Handout.pdf) which is uploaded on moodle, try out the java+jdbc code.
[Add the screenshots of the output] 10 Points
[submit your program along with the screenshots of the output] 20 Points
3. Do the following preparedStatement : For a given building, find classrooms (room_no) with capacity more than 30 and in which no courses are scheduled this year and semester. A template has been made in the provided source code(Driver.java), you need to fill up the template.
[submit your program along with the screenshots of the output] 20 Points
Part -B
We have already shared the Java J2EE setup handout (J2EE Handout.pdf) with one servlet (StudentServlet.java) and html file (index.html). Do the setup, if not already done. Execute the StudentServlet file and index.html given with the handout.
1. Design a new html page to take advisor id as input. Write a servlet to display the department to which the advisor belongs using the Java and J2EE program. Output should contain advisor id and department name. [20+20+10]= 50 Points
[Submit both(html and servlet) programs and Screenshots of output]
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. Submit your .zip file named with your <roll_number>.zip
4. Mode of submission is moodle.
Instructions for Part-B :
You can refer to some of the following instructions :
1. Place the servlet mapping code in web.xml.
Example :Here ServletName is the name of your servlet file.
This following code snippet should be placed within <web-app></web-app> tags in the web.xml.
<?xml version="1.0" encoding="UTF-8"?>
<web-app>
<welcome-file-list>
<welcome-file>index.html</welcome-file>
</welcome-file-list>
<servlet>
<servlet-name>StudentServlet</servlet-name>
<servlet-class>StudentServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>StudentServlet</servlet-name>
<url-pattern>/StudentServlet</url-pattern>
</servlet-mapping>
</web-app>
2. You can create your own html page for reading advisor id as input.But put the name of your servlet file correctly inside the form element.
Example :
<form action=”StudentServlet”>
