📄 resquery.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/resquery.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> </td>
<td><input type="submit" name="Submit" value="确定"> <input type="reset" name="Submit2" value="清空"></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -