📄 stockinsearch.jsp
字号:
<%@ page language="java" contentType="text/html; charset=gb2312" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="com.logistic.business.StockInManager" %>
<%@ page import="com.logistic.model.StockInInfo" %>
<% request.setCharacterEncoding("gb2312");%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>入库单查询</title>
<style type="text/css">
<!--
body {
background-color: #168AC2;
}
-->
</style>
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
<link href="../../cssjs/comcss.css" rel="stylesheet" type="text/css">
</head>
<body>
<%
String sid=request.getParameter("stockinid");
%>
<table width="375" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="369" align="center" class="style9">按入库单编号查询入库单信息</td>
</tr>
<tr>
<td height="30" align="center"><form name="stockin" method="post" action="stockinsearch.jsp">
<table width="350" border="0" cellpadding="1" cellspacing="0">
<tr>
<td width="103" height="21" align="right" class="code">请输入库单编号:</td>
<td width="163"><label>
<input name="stockinid" type="text" class="style9" id="stockinid" size="20" maxlength="20">
</label></td>
<td width="78" align="center"><label>
<input name="Submit" type="submit" class="buttonstyle" value="查询">
</label></td>
</tr>
</table>
</form></td>
</tr>
</table>
<%
if(sid!=null){
String charger =null;
String goods =null;
String goodscate =null;
String type =null;
StockInInfo sii=null;
StockInManager sim=new StockInManager();
sii=sim.StockInSearchById(sid);
//取得入库单负责人
String sqlemploy="select *from employeeinfotable where EmployeeId="+sii.getCharegid();
Statement statemploy=dblink.getStmtread();
ResultSet rsemploy=statemploy.executeQuery(sqlemploy);
while(rsemploy.next()){
charger=rsemploy.getString("EmployeeName");
}
dblink.close();
//取得入库商品名称
String sqlgoods="select *from goodsinfotable where GoodsId="+sii.getGoodsid();
Statement statgoods=dblink.getStmtread();
ResultSet rsgoods=statgoods.executeQuery(sqlgoods);
while(rsgoods.next()){
goods=rsgoods.getString("GoodsName");
}
dblink.close();
//取得商品分类名称
String sqlcate="select *from commcatetable where CommodityId="+sii.getCommodityid();
Statement statcate=dblink.getStmtread();
ResultSet rscate=statcate.executeQuery(sqlcate);
while(rscate.next()){
goodscate=rscate.getString("CommodityName");
}
dblink.close();
//取得商品型号名称
String sqltype="select *from typetable where TypeId="+sii.getTypeid();
Statement stattype=dblink.getStmtread();
ResultSet rstype=stattype.executeQuery(sqltype);
while(rstype.next()){
type=rstype.getString("TypeName");
}
dblink.close();
%>
<table width="512" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="87" height="22" align="right" class="style9">入库负责人:</td>
<td width="136" align="center"><%=charger %></td>
<td width="82" align="right" class="style9">商品名称:</td>
<td width="189" align="center"><%=goods %></td>
</tr>
<tr>
<td height="22" align="right" class="style9">入库数量:</td>
<td align="center"><%=sii.getGoodsinnumber() %></td>
<td align="right" class="style9">商品类别:</td>
<td align="center"><%=goodscate %></td>
</tr>
<tr>
<td height="22" align="right" class="style9">商品型号:</td>
<td align="center"><%=type %></td>
<td align="right" class="style9">入库日期:</td>
<td align="center" class="code"><%=sii.getStockindate() %></td>
</tr>
<tr>
<td height="22" colspan="2" align="center" class="style9">商品入库单备注信息如下:</td>
<td colspan="2" align="left" class="code"> </td>
</tr>
<tr>
<td height="77" colspan="4" align="center" class="code"><%=sii.getGoodsinmemo() %></td>
</tr>
</table>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -