📄 goodssearch.jsp
字号:
<%@ page language="java" contentType="text/html; charset=GB2312" pageEncoding="GB2312"%>
<%@ page import="com.logistic.business.GoodsManager" %>
<%@ page import="com.logistic.model.GoodsInfo" %>
<%@ page import="java.sql.*" %>
<% 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>
<link href="../../cssjs/comcss.css" rel="stylesheet" type="text/css">
<jsp:useBean id="dblink" class="com.logistic.data.DataConnect" scope="page"/>
</head>
<body>
<%
String gid=(String)request.getParameter("goodsnumber");
%>
<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="goodssearch" method="post" action="goodssearch.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="goodsnumber" type="text" class="style9" id="goodsnumber" 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(gid!=null){
String goodscatename=null;
String supply =null;
String goodstype =null;
String stockadd =null;
String stockregion =null;
GoodsInfo gi=null;
GoodsManager gm=new GoodsManager();
gi=gm.GoodsSearchById(gid);
//取得商品分类名称
String sqlcommo="select *from commcatetable where CommodityId="+gi.getGoodscateid();
Statement statcommo=dblink.getStmtread();
ResultSet rscommo=statcommo.executeQuery(sqlcommo);
while(rscommo.next()){
goodscatename=rscommo.getString("CommodityName");
}
dblink.close();
//取得供应商名称
String sqlsupply="select *from supplytable where SupplyId="+gi.getGoodssupplyid();
Statement statsupply=dblink.getStmtread();
ResultSet rssupply=statsupply.executeQuery(sqlsupply);
while(rssupply.next()){
supply=rssupply.getString("SupplyName");
}
dblink.close();
//取得商品型号
String sqltype="select *from typetable where TypeId="+gi.getTypeid();
Statement stattype=dblink.getStmtread();
ResultSet rstype=stattype.executeQuery(sqltype);
while(rstype.next()){
goodstype=rstype.getString("TypeName");
}
dblink.close();
//取得商品存储地址
String sqlstockadd="select *from warehouseinfotable where WareHouseId="+gi.getGoodsstockid();
Statement statstockadd=dblink.getStmtread();
ResultSet rsstockadd=statstockadd.executeQuery(sqlstockadd);
while(rsstockadd.next()){
stockadd=rsstockadd.getString("WareHouseAdd");
}
dblink.close();
//取得商品在库位置
String sqlregion="select *from stockregioninfotable where StockRegionId="+gi.getStockregionid();
Statement statregion=dblink.getStmtread();
ResultSet rsregion=statregion.executeQuery(sqlregion);
while(rsregion.next()){
stockregion=rsregion.getString("StockRegionName");
}
dblink.close();
%>
<table width="681" height="160" border="1" align="center" cellpadding="1" cellspacing="0" bordercolor="#FF9999">
<tr>
<td width="95" height="27" align="right" valign="middle" class="style9">商品名称:</td>
<td width="174" height="27" align="center"><%=gi.getGoodsname() %></td>
<td width="126" align="right" valign="middle" class="style9">商品分类:</td>
<td colspan="4" align="center"><%=goodscatename %></td>
</tr>
<tr>
<td height="27" align="right" valign="middle" class="style9">供应商:</td>
<td height="12" align="center"><%=supply %></td>
<td align="right" valign="middle" class="style9">商品ABC分类:</td>
<td colspan="2" align="center"><%=gi.getGoodsabc() %></td>
<td align="right" valign="middle" class="code"> 商品型号:</td>
<td align="center"><%=goodstype %></td>
</tr>
<tr>
<td height="25" align="right" valign="middle" class="style9">商品产地省:</td>
<td align="center"><%=gi.getGoodsprovince() %></td>
<td align="right" valign="middle" class="style9">商品产地市:</td>
<td colspan="4" align="center"><%=gi.getGoodscity() %></td>
</tr>
<tr>
<td height="27" align="right" valign="middle" class="style9">商品储存地址:</td>
<td align="center"><%=stockadd %></td>
<td align="right" valign="middle" class="style9">商品单价:</td>
<td width="72" align="center"><%=gi.getGoodsprice() %></td>
<td width="25" align="center" class="style5">元</td>
<td width="69" align="right" class="code">商品单位:</td>
<td width="90" align="center"><%=gi.getGoodsunit() %></td>
</tr>
<tr>
<td height="26" align="right" valign="middle" class="style9">商品定购日期:</td>
<td align="center"><%=gi.getGoodsorderdate() %></td>
<td align="right" valign="middle" class="style9">商品入库量:</td>
<td colspan="4" align="center"><%=gi.getGoodsstocknumber() %></td>
</tr>
<tr>
<td height="24" align="right" valign="middle" class="style9">商品入库日期:</td>
<td align="center"><%=gi.getGoodsstockindate() %></td>
<td align="right" valign="middle" class="style9"> 所处仓库中的位置:</td>
<td colspan="4" align="center"><%=stockregion %></td>
</tr>
</table>
<%
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -