📄 stockinadd.jsp
字号:
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@page import="com.wl.dbconnection.DBManager"%>
<%@page import="java.sql.ResultSet"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>My JSP 'stockinadd.jsp' starting page</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<form action="" method="post">
<table border="1" width="640" align="center">
<tr>
<td colspan="4" align="center">
入库单信息录入
</td>
</tr>
<tr>
<td>
负责人：
</td>
<td>
<select name="stockincharge">
<option value="">
负责人
</option>
<%
String sql = "select *from employeeinfotable";
DBManager db = new DBManager();
db.openDB();
db.ps = db.conn.prepareStatement(sql);
ResultSet rs = db.ps.executeQuery();
while (rs.next()) {
String employeeid = rs.getString("EmployeeId");
String employeename = rs.getString("EmployeeName");
out.print("<option value=" + employeeid);
out.print(">" + employeename + "</option>");
}
%>
</select>
<font color="red"><b>*</b></font> <font size="2">带* 的为必填信息</font>
</td>
<td>
商品名称:
</td>
<td>
<select name="goodsname">
<option value="">
商品名称
</option>
<%
String sqlgoods = "select * from GoodsInfoTable";
db.ps = db.conn.prepareStatement(sqlgoods);
ResultSet rsgoods = db.ps.executeQuery();
while (rsgoods.next()) {
String GoodsId = rsgoods.getString("GoodsId");
String GoodsName = rsgoods.getString("GoodsName");
out.print("<option value=" + GoodsId);
out.print(">" + GoodsName + "</option>");
}
%>
</select>
<font color="red"><b>*</b></font>
</td>
</tr>
<tr>
<td>
入库数量：
</td>
<td>
<input type="text" name="stockinnum" size="10" maxlength="20" />
<font color="red"><b>*</b></font>
</td>
<td>
商品类别：
</td>
<td>
<select name="goodstype">
<option value="">
商品类别
</option>
<%
String sqlgoodstype = "select * from commcatetable";
db.ps = db.conn.prepareStatement(sqlgoodstype);
ResultSet rscomm = db.ps.executeQuery();
while (rscomm.next()) {
String commid = rscomm.getString("CommodityId");
String commname = rscomm.getString("CommodityName");
out.print("<option value=" + commid);
out.print(">" + commname + "</option>");
}
%>
</select>
<font color="red"><b>*</b></font>
</td>
</tr>
<tr>
<td>
商品型号：
</td>
<td>
<select name="type">
<option value="">
商品型号
</option>
<%
String sqltype = "select *from typetable";
db.ps = db.conn.prepareStatement(sqltype);
ResultSet rstype = db.ps.executeQuery();
while (rstype.next()) {
String typeid = rstype.getString("TypeId");
String typename = rstype.getString("TypeName");
out.print("<option value=" + typeid);
out.print(">" + typename + "</option>");
}
db.closeDB();
%>
</select>
<font color="red"><b>*</b></font>
</td>
<td colspan="2">
商品入库单备注信息（填写在下面空白处）
</td>
</tr>
<tr>
<td colspan="4">
<textarea name="remarkinfo" cols="80" rows="7"></textarea>
</td>
</tr>
<tr>
<td colspan="4" align="center">
<input type="submit" name="ok" value="确认提交" />
<input type="reset" name="no" value="重写填写" />
</td>
</tr>
<tr>
<td colspan="4"></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -