<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>