buy.jsp~3~

这是本人刚刚得到的JBuilder9软件开发项目实践的源码

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><form action="/buyservlet.do" method="post">
        <table width="80%" border="0" align="center" cellpadding="0" cellspacing="2">
          <tr align="center">
            <td colspan="2">进货</td>
          </tr>
          <tr>
            <td width="246" align="right">供货商名称</td>
            <td width="388"><select name="supplierID" id="supplierID">
<%
    Connection conn = null;
    PreparedStatement stmt = null;
    ResultSet rs = null;

    conn = ConnectionManager.getConnection();
    stmt = conn.prepareStatement("select * from Supplier");

    rs = stmt.executeQuery();
    while (rs.next()) {
%>
                <option value="<%=rs.getString("supplierID")%>"><%=rs.getString("supplierName")%></option>
<%
    }
%>
              </select></td>
          </tr>
          <tr>
            <td align="right">商品名称</td>
            <td><select name="wareID" id="wareID">
<%
	  rs.close();
	  stmt.close();
      stmt = conn.prepareStatement("select * from Ware");

      rs = stmt.executeQuery();
      while (rs.next()) {
%>
                <option value="<%=rs.getString("wareID")%>"><%=rs.getString("wareName")%></option>
<%
    }
	rs.close();
	stmt.close();
	conn.close();
%>
              </select></td>
          </tr>
          <tr>
            <td align="right">商品价格</td>
            <td><input name="buyPrice" type="text" id="buyPrice"></td>
          </tr>
          <tr>
            <td height="24" align="right">购买数量</td>
            <td><input name="buyQty" type="text" id="buyQty"></td>
          </tr>
          <tr>
            <td align="right">购买时间(格式如2003-5-20)</td>
            <td><input name="buyDate" type="text" id="buyDate"></td>
          </tr>
          <tr>
            <td align="right">购买人</td>
            <td><input name="buyPerson" type="text" id="buyPerson"></td>
          </tr>
          <tr>
            <td>&nbsp;</td>
            <td><input type="submit" name="Submit" value="确定"> <input type="reset" name="Submit2" value="清空"></td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>