📄 goodsuser.java
字号:
package com.logistic.taglib;
import com.logistic.data.DataConnect;
import com.logistic.business.GoodsManager;
import com.logistic.model.GoodsInfo;
import java.util.Vector;
import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;
import java.sql.ResultSet;
import java.sql.Statement;
public class GoodsUser extends TagSupport{
private static final long serialVersionUID = 7766184319541530720L;
DataConnect dc=new DataConnect();
Statement stat=null;
ResultSet rs=null;
String sqlgoods=null;
String goodscatename=null;
String supplyname=null;
String typename=null;
String stockaddress=null;
String stockname=null;
String stockregion=null;
public int doEndTag() throws JspException{
JspWriter out=pageContext.getOut();
HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
String str=(String)request.getQueryString();
int page;
if(str==null||str.equals("")){
page=1;
}else{
String[] aa=str.split("=");
page=Integer.parseInt(aa[1]);
}
try{
String sqls=new String("select * from goodsinfotable order by GoodsId ASC");
int count=dc.selectdata(sqls);
int totalpages=0;
if(count%5==0){
totalpages=count/5;
}else{
totalpages=count/5+1;
}
int currentpage=1;
if(page==-4){
currentpage=totalpages;
}else if(page==-3){
currentpage=currentpage+1;
}else if(page==-2){
if(currentpage==1){
currentpage=1;
}else{
currentpage=currentpage-1;
}
}else{
currentpage=1;
}
GoodsManager gm=new GoodsManager();
Vector items=gm.GoodsSearch(sqls, page);
//输出商品管理信息表头
out.println("<table width=\"811\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td align=\"center\" valign=\"middle\" class=\"style14\">商品信息管理</td>");
out.println("</tr>");
out.println("</table>");
//输出商品信息内容
int span=5,j=0;//span标识每页显示5条信息，j是一个计数器
String path=request.getContextPath();
for(int i=0;i<items.size();i++){
GoodsInfo gibean=(GoodsInfo)items.elementAt(i);
//得到制定编号商品的商品分类名称
try{
String sqlcates="select * from commcatetable where CommodityId="+gibean.getGoodscateid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlcates);
while(rs.next()){
goodscatename=rs.getString("CommodityName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//得到指定编号商品的供应商名称
try{
String sqlsupply="select * from supplytable where SupplyId="+gibean.getGoodssupplyid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlsupply);
while(rs.next()){
supplyname=rs.getString("SupplyName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//得到指定编号商品的商品型号
try{
String sqltype="select * from typetable where TypeId="+gibean.getTypeid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqltype);
while(rs.next()){
typename=rs.getString("TypeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//得到指定编号商品的商品库存地址
try{
String sqlstockadd="select * from warehouseinfotable where WareHouseId="+gibean.getGoodsstockid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlstockadd);
while(rs.next()){
stockname=rs.getString("WareHouseName");
stockaddress=rs.getString("WareHouseAdd");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//得到指定编号商品的商品在仓库中位置
try{
String sqlstockregion="select * from stockregioninfotable where StockRegionId="+gibean.getStockregionid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlstockregion);
while(rs.next()){
stockregion=rs.getString("StockRegionName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//输出库存商品详细信息
//输出商品编号
out.println("<table width=\"811\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td height=\"20\" colspan=\"16\" align=\"left\" bgcolor=\"#6699CC\" class=\"code\">该商品编号为:"+gibean.getGoodsid()+"</td>");
out.println("</tr>");
//输出商品名称
out.println("<tr>");
out.println("<td width=\"98\" height=\"22\" align=\"right\" class=\"code\">商品名称:</td>");
out.println("<td colspan=\"4\" align=\"center\">"+gibean.getGoodsname()+"</td>");
//输出商品分类名称
out.println("<td width=\"118\" align=\"right\"><span class=\"code\">商品分类:</span></td>");
out.println("<td align=\"center\" colspan=\"6\" colspan=\"3\">"+goodscatename+"</td>");
//输出编辑、删除链接
out.println("<td align=\"center\"></td>");
out.println("<td align=\"center\"></td>");
out.println("</tr>");
//输出供应商名称
out.println("<tr>");
out.println("<td height=\"20\" align=\"right\" class=\"code\">供应商名称:</td>");
out.println("<td colspan=\"4\" align=\"center\">"+supplyname+"</td>");
//输出商品ABC分类
out.println("<td align=\"right\"><span class=\"code\">商品ABC分类:</span></td>");
out.println("<td width=\"92\" colspan=\"6\"align=\"center\">"+gibean.getGoodsabc()+"类商品</td>");
//输出商品型号
out.println("<td width=\"65\" align=\"center\"><span class=\"code\">商品型号:</span></td>");
out.println("<td width=\"150\" align=\"center\">"+typename+"</td>");
out.println("</tr>");
//输出商品产地省
out.println("<tr>");
out.println("<td height=\"21\" colspan=\"1\" align=\"right\" class=\"code\">商品产地省:</td>");
out.println("<td colspan=\"4\" align=\"center\">"+gibean.getGoodsprovince()+"</td>");
//输出商品产地市
out.println("<td align=\"right\"><span class=\"code\">商品产地市:</span></td>");
out.println("<td colspan=\"9\" align=\"center\">"+gibean.getGoodscity()+"</td>");
out.println("</tr>");
//输出商品储存地址
out.println("<tr>");
out.println("<td height=\"21\" colspan=\1\" align=\"right\"><span class=\"code\">商品储存地址:</span></td>");
out.println("<td colspan=\"5\" align=\"center\">"+stockname+":"+stockaddress+"</td>");
//输出商品单价
out.println("<td align=\"right\" colspan=\"2\"><span class=\"code\">商品单价:</span></td>");
out.println("<td align=\"left\">"+gibean.getGoodsprice()+"元</td>");
//输出商品的单位
out.println("<td align=\"right\" colspan=\"2\"><span class=\"code\">商品单位:</span></td>");
out.println("<td colspan=\"4\" align=\"left\">"+gibean.getGoodsunit()+"</td>");
out.println("</tr>");
//输出商品定购日期
out.println("<tr>");
out.println("<td height=\"22\" colspan=\"1\" align=\"right\"><span class=\"code\">商品定购日期:</span></td>");
out.println("<td colspan=\"5\" align=\"center\">"+gibean.getGoodsorderdate()+"</td>");
//输出商品入库数量
out.println("<td align=\"right\" colspan=\"3\"><span class=\"code\">商品入库量:</span></td>");
out.println("<td colspan=\"7\" align=\"center\">"+gibean.getGoodsstocknumber()+""+gibean.getGoodsunit()+"</td>");
out.println("</tr>");
//输出商品入库日期
out.println("<tr>");
out.println("<td height=\"23\" colspan=\"1\" align=\"right\"><span class=\"code\">商品入库日期:</span></td>");
out.println("<td colspan=\"5\" align=\"center\">"+gibean.getGoodsstockindate()+"</td>");
//输出商品在仓库中的位置
out.println("<td align=\"right\" colspan=\"3\" ><span class=\"code\">所处仓库中的位置:</span></td>");
out.println("<td colspan=\"7\" align=\"center\">"+stockregion+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"20\" colspan=\"16\" bgcolor=\"#FF9999\"> </td>");
out.println("</tr>");
out.println("</table>");
j++;
if(j==span)break;
}
out.println("<table width=\"811\" height=\"20\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td width=\"225\">页次:"+currentpage+"/"+totalpages+"页;每页5条信息共"+count+"</td>");
out.println("<td width=\"642\" align=\"center\"><a href=\"admingoods.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a> " +
"<a href=\"admingoods.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a> " +
"<a href=\"admingoods.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a> " +
"<a href=\"admingoods.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");
out.println("</table>");
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
return SKIP_BODY;
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -