<!-- An example JSP that accesses the database -->
<%@ page language="java" contentType="text/html" %>

<html>
<head>
  <title>Talking to the Database</title>
</head>
<body>

  <!-- Create an instance of the 
       SimpleCustFormatter bean -->
  <jsp:useBean id="list" class="SimpleCustFormatter">
    <jsp:setProperty name="list" property="*"/>
  </jsp:useBean>

  <!-- Create a form containing a customer chooser 
       and an input field for the minimum quantity. -->
  <FORM METHOD="GET">

    Choose Customer:
    <jsp:getProperty name="list" property="custchooser"/>
    <BR>

    Minimum Quantity:
    <jsp:getProperty name="list" property="qtyinputfield"/>
    <BR>

    <INPUT TYPE="SUBMIT" VALUE="Set Filter">

  </FORM>

  <!-- Display an HTML table 
       with the SQL query results -->
  <jsp:getProperty name="list" property="table"/>
   
</body>
</html>