Enter Product No:Part B$)$ Web Application with JSP interacting with MySQL

$1.$ Develop the following JSP page called $$AddProductForm$.$jsp$$

Product No:

Product Name

Product Type

Home Appliance Computer Hardware Game Console Clothing

Manufacturer:

Price:

Weight:And add JSP Expressions below to print the data when the user clicks Add Product, $($The data

should be printed below the same form in the same JSP file, hint: don$$t provide action in form

tag$)$

The following information is received

Product No is AB$101$

Product Name is Washing Machine

Product Type is Home Appliance

Manufacturer is LG

Price is $599\mathrm{.}99$

Weight is $322.$ Save $$AddProductForm$.$jsp$$ as $$InsertRecords$.$jsp$,$ remove the below JSP Expressions for

printing details and add the below points instead.

a$.$ When user clicks Add Product button, read the data and add it to products table.

b$.$ Execute form validation to ensure the price of each product is between $$100-$ $$900$

c$.$ The program should display all existing products in HTML Table format below the form.

Note: the page shouldn$$t insert any record until user press the Add Product button.

However, when user opens the page, the form and the existing records can be displayed!

$3.$ Develop a JSP page called $$DeleteRecords$.$jsp$,$ which displays the following form and delete the

product based on product no provided. Just like above the program should display all the

existing products below the form.Part C$)$ Develop a JSP file called $$Format$.$jsp$$ with the following code, $($to run it successfully, add jstl jar

to WED$-$INF$/$lib folder, find the jar in BB $>$ jars$)$ and answer the following questions.

JSTL fmt:formatNumber Tag

Formatted Number: step $1$: step $2$: step $3$: $$\{$p$\}$ $$\{$q$\}$