Question: Question 2 - JSP Develop a JSP page that is a web version of the JDBC program in question 1. Specifically, the JSP page generates

Question 2 - JSP Develop a JSP page that is a web version of the JDBC program in question 1. Specifically, the JSP page generates a table for displaying the data in the Study database table. When an HTTP request parameter called "grade" exists, only those student records with their grades matched with the parameter value are sorted by name in ascending order and displayed. When the request parameter does not exist, message "Invalid input." is displayed. When there is no record matched, message "Record not found." is displayed. This screenshot shows the output of the JSP page when there is no grade parameter. eo localhost BOBOCOMPSB-Adignment2-922des Study Records Invalid input. These three screenshots show the output of the JSP page when there is a grade parameter. Develop a JDBC program called Courserade that finds and displays study records of students in a database table. The table, called Study, has three columns: Name CHAR(30), CourseTitle CHAR(30), and Grade CHAR(2). The following SQL file creates and populates the table. CREATE TABLE Study (Name CHAR(30), CourseTitle CHAR ( 30), Grade CHAR(2)); INSERT INTO Study VALUES ('Peter Chan', 'Database', 'B'); INSERT INTO Study VALUES ('David Lee', 'Java', 'B'); INSERT INTO Study VALUES ('Amy Au', 'Operating System', 'A'); INSERT INTO Study VALUES ('Mary Cheung', 'Software Engineering', 'C'); INSERT INTO Study VALUES ('Johnson Yeung', 'Database', 'C'); INSERT INTO Study VALUES ('Paul Leung', 'Java', 'A'); INSERT INTO Study VALUES ('May Lee', 'Operating System', 'B'); INSERT INTO Study VALUES ('John Lee', Software Engineering', 'B'); The program should prompt the user for grade, query the database table, and display the details of the matched records which are sorted by name in ascending order. If the user does not input anything (just press Enter), message "Invalid input." is displayed. If no record matched, message "Record not found." is displayed. Suders * + localhost COMPS3 Ile-de- Study Records Students who got A Name Course Title Aunty Au Operating System Paul Leung Wave + Colocalliest 800 COMP5311 Amadeograd Study Records Students who got B David Lee Java John Lee Sottware Engineering May Lee Operating System Peter Clan Database ColocalhostBICOMPS. gonta-onderde- Study Records Record not found
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
