?? goodsadmin.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 GoodsAdmin extends TagSupport{
private static final long serialVersionUID = 7766184319541530720L;
DataConnect dc=new DataConnect();
Statement stat=null;
ResultSet rs=null;
String sqlgoods;
String goodscatename;
String supplyname;
String typename;
String stockaddress;
String stockname;
String stockregion;
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=\"845\" 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=\"845\" 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=\"3\">"+goodscatename+"</td>");
//輸出編輯、刪除鏈接
out.println("<td align=\"center\" colspan=\"2\">【編輯】/【刪除】</td>");
out.println("<td colspan=\"5\" align=\"center\"><a href=\""+path+"/viewpage/datamodify/goodsmanagemodify.jsp?gid="+gibean.getGoodsid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a> " +
"<a href=\"admingoods.jsp?goodsid="+gibean.getGoodsid()+"\" onClick=\"{if(confirm('此操作將刪除當前記錄!刪除后將不能恢復,您確定執行的操作嗎?')){return true;}return false;}\"><img src=\""+path+"/image/delete.gif\" border=\"0\"></a></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=\"845\" 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 + -