<html>
<head>
    <title>FormServlet Test Page</title> 
</head>
<body  BGCOLOR="#FFFFFF">
<h1>FormServlet</h1> <h3>A Demonstration of SQL services</h3>
<hr>
<form action="/servlet/FormServlet" method="Post">
    <center>
        <b>Enter Students ID, Name, E-Mail, Grade, and Final Score.</b>
    </center>
    <table BORDER="8" ALIGN="CENTER" CELLSPACING="4" CELLPADDING="2">
        <tr>
            <td>Student ID</td>
            <td>Name</td>
            <td>E-Mail</td>
            <td>Grade</td>
            <td>Final Score</td>
        </tr>
        <tr>
            <td>
                <input type="text" name="ID" value=">0">
            </td>
            <td>
                <input type="text" name="name">
            </td>
            <td>
                <input type="text" name="e_mail">
            </td>
            <td>
                <input type="text" name="grade">
            </td>
            <td>
                <input type="text" name="final" value=">0">
            </td>

        </tr>
        <tr>
            <td>ID</td>
            <td>name</td>
            <td>e_mail</td>
            <td>grade</td>
            <td>final</td>

        </tr>

    </table>
    <br>
    <input type="hidden" name="USER" value="siegel">
    <!-- FormServlet retrieves user siegel's personal data
                . Oracle account
                . password
                . directory that contains my "SQLFile"
     -->
     

    <input type="hidden" name="SQLFile" value="SQLQuery.txt">
    <!-- The name of the SQL file. Must be free of special characters.
            FormServlet checks for control characters etc. in the name
    -->
     

    <input type="hidden" name="URLhead" value="/accounts/faculty/siegel/public_html/FormsTalk/sql/class_head.html">
    <input type="hidden" name="URLbody" value="/accounts/faculty/siegel/public_html/FormsTalk/sql/class_member.html">
    <input type="hidden" name="URLfoot" value="/accounts/faculty/siegel/public_html/FormsTalk/sql/class_foot1.html">
    <!-- 
        URLhead is rewritten and returned before the query file is run.
        URLbody is rewritten and returned  for each  line is the table that is returned
           by Oracle.
        URLfoot is rewritten and returned after the returned table is exausted.
    -->
     

    <p>
    <input type="submit" value="Send">
</form>
</body>
</html>