Program 1
<%--
Document : SearchAll
Created on : Nov 8, 2023, 4:22:25 PM
Author : admin
--%>
<%@page import="java.util.ArrayList"%>
<%@page import="model.Product"%>
<%@page import="dao.ProductDAO"%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@include file="header.jsp"%>
<!DOCTYPE html>
<%
for(int i=1;i<=15;i++)
out.println("<br>");
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<center>
<%
ProductDAO pd=new ProductDAO();
ArrayList<Product>mylist=new ArrayList<Product>();
mylist=pd.searchAll();
out.println("<table border=1>");
out.println("<tr><th>Prod Id</th><th>Prod Name</th><th>Prod Qty</th><th>Prod Amount</th><th>Prod Type</th></tr>");
for(Product P:mylist)
{
out.println("<tr>");
out.println("<td>"+P.getProdid()+"</td>");
out.println("<td>"+P.getProdname()+"</td>");
out.println("<td>"+P.getProdqty()+"</td>");
out.println("<td>"+P.getProdamt()+"</td>");
out.println("<td>"+P.getProdtype()+"</td>");
out.println("</tr>");
}
out.println("</table>");
%>
</center>
</body>
</html>