<form name="purchase" action="Purchase" method="POST">
            <table border="1">
                <thead>
                    <tr>
                        <th></th>
                        <th></th>
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        <td>Product Number</td>
                        <td><input type="text" name="ProdNum" value="" maxlength="7" /></td>
                    </tr>
                    <tr>
                        <td>Quantity</td>
                        <td><input type="text" name="quantity" value="" /></td>
                    </tr>
                    <tr>
                        <td><input type="reset" value="Clear" name="clear" /></td>
                        <td><input type="submit" value="Purchase" name="purchase" /></td>
                    </tr>
                </tbody>
            </table>
 
        </form>

String ProdID = null;
        String ProdName = null;
        String Price1 = null;
        String Num = null;
        int cost,amt,value;
        try
        {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:Concept","admin","");
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery ("SELECT ProductID, PName, Price FROM Stock");
 
            while(rs.next())
            {
                ProdID = rs.getString("ProductID");
                if(ProdID.equals(request.getParameter("ProdNum")))
                {
                    ProdName = rs.getString("PName");
                    Price1 = rs.getString("Price");
                    value = Integer.parseInt(Price1);
                    Num = request.getParameter("quantity");
                    amt = Integer.parseInt(Num);
                    cost = amt*value;
                    out.print(ProdID +'\t');
                    out.print(ProdName + '\t');
                    out.print(Num + '\t');
                    out.print("K "+ cost);
                    out.println('\t'+"<a href = purchase.jsp>Back</a>");
                }
            }
            con.close();
            rs.close ();
            st.close ();
        }
        catch(Exception e)
        {
            System.out.print("Unable to find DB");
        }
    }