📄 sale.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="jxc.ConnectionManager,java.sql.*" errorPage="" %>
<html>
<head>
<title>销售</title>
</head>
<body>
<%@ include file="header.jsp" %>
<table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form action="/jxc/saleservlet.do" method="post">
<table width="80%" border="0" cellpadding="0" cellspacing="2">
<tr align="center">
<td colspan="2">销售</td>
</tr>
<tr>
<td width="256" align="right">商品名称</td>
<td width="384"><select name="wareID">
<%
Connection conn = null;
PreparedStatement stmt = null;
ResultSet rs = null;
conn = ConnectionManager.getConnection();
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="salePrice" type="text" id="salePrice"></td>
</tr>
<tr>
<td align="right">销售数量</td>
<td><input name="saleQty" type="text" id="saleQty"></td>
</tr>
<tr>
<td align="right">销售时间(格式如2003-5-20)</td>
<td><input name="saleDate" type="text" id="saleDate"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="确定"> <input type="reset" name="Submit2" value="清空"></td>
</tr>
</table>
</form></td>
</tr>
</table>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -