Untitled

<%--
    Document   : Response
    Created on : Mar 21, 2017, 3:54:46 PM
    Author     : 1337
--%>

<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean" %>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html" %>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>Product Data</title>
    </head>
    <body>
        <h1>Products</h1>
         <sql:setDataSource var="snapshot" driver="org.apache.derby.jdbc.ClientDriver"
                           url="jdbc:derby://localhost:1527/myDatabase"
                           user="mis320"  password="mis320"/>

        <sql:query dataSource="${snapshot}" var="result">
            SELECT * from Product
        </sql:query>

        <table border="1" width="100%">
            <tr>
                <th>Order Number</th>
                <th>Customer ID</th>
                <th>Product ID</th>
                <th>Quantity</th>
                <th>Shipping Cost</th>
                <th>Sales Date</th>
                <th>Shipping Date</th>

            </tr>
            <c:forEach var="row" items="${result.rows}">
                <tr>
                    <td><c:out value="${row.ORDER_NUM}"/></td>
                    <td><c:out value="${row.CUSTOMER_ID}"/></td>
                    <td><c:out value="${row.PRODUCT_ID}"/></td>
                    <td><c:out value="${row.QUANTITY}"/></td>
                    <td><c:out value="${row.SHIPPING_COST}"/></td>
                    <td><c:out value="${row.SALES_DATE}"/></td>
                    <td><c:out value="${row.SHIPPING_DATE}"/></td>

                </tr>
            </c:forEach>
        </table>
        <html:form action="/delete" method="get">

        Order Number To Delete:
        <html:text property="orderNumber" size="50" /><br><br>

        <html:submit>Delete</html:submit>
        <br><br>
    </html:form>

    </body>
</html>