?? stockoutinfouser.java
字號:
package com.logistic.taglib;
import com.logistic.data.DataConnect;
import com.logistic.business.StockOutManager;
import com.logistic.model.StockOutInfo;
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 StockOutInfoUser extends TagSupport{
private static final long serialVersionUID = 7766184319541530720L;
DataConnect dc=new DataConnect();
Statement stat=null;
ResultSet rs=null;
String strsql;
String chargename; //出庫單負責人姓名
String goodsname; //出庫商品名稱
String goodstypename; //出庫商品型號
String goodsunit; //商品單位
String receivename; //商品接受人名稱
String commodityname; //商品分類名稱
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 stockoutinfotable order by StockOutId 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;
}
StockOutManager som=new StockOutManager();
Vector items=som.StockOutSearch(sqls, page);
//輸出商品出庫單數據列表表頭
out.println("<table width=\"532\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td align=\"center\" 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++){
StockOutInfo soi=(StockOutInfo)items.elementAt(i);
//根據指定的職員編號取得出庫單負責人姓名
try{
String sqlchargename="select * from employeeinfotable where EmployeeId="+soi.getChargeid();
stat=dc.getStmtread();
rs=stat.executeQuery(sqlchargename);
while(rs.next()){
chargename=rs.getString("EmployeeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//根據指定的職員編號取得山品接受人姓名
try{
String sqlreceivename="select * from employeeinfotable where EmployeeId="+soi.getGoodsreceiveid();
stat=dc.getStmtread();
rs=stat.executeQuery(sqlreceivename);
while(rs.next()){
receivename=rs.getString("EmployeeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//根據商品編號取得商品名稱
try{
String sqlgoodsname="select * from goodsinfotable where GoodsId="+soi.getGoodsid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlgoodsname);
while(rs.next()){
goodsname=rs.getString("GoodsName");
goodsunit=rs.getString("GoodsUnit");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//根據商品型號取得型號名稱
try{
String sqlgoodstype="select * from typetable where TypeId="+soi.getTypeid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlgoodstype);
while(rs.next()){
goodstypename=rs.getString("TypeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//根據商品分類編號取得商品分類的名稱
try{
String sqlcommcatename="select * from commcatetable where CommodityId="+soi.getCommodityid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlcommcatename);
while(rs.next()){
commodityname=rs.getString("CommodityName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//輸出商品出庫信息的內容
out.println("<table width=\"532\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\" bgcolor=\"#FF9999\">");
out.println("<tr>");
//輸出商品出庫單編號
out.println("<td align=\"left\" class=\"code\">出庫單編號:"+soi.getStockoutid()+"</td>");
out.println("</tr>");
out.println("</table>");
out.println("<table width=\"532\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td width=\"104\" height=\"23\" align=\"right\"><span class=\"code\">出庫負責人:</span></td>");
out.println("<td width=\"179\" align=\"left\">"+chargename+"</td>");
out.println("<td width=\"90\" align=\"right\"><span class=\"code\">商品名稱:</span></td>");
out.println("<td width=\"141\" align=\"left\">"+goodsname+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"23\" align=\"right\"><span class=\"code\">商品出庫數量:</span></td>");
out.println("<td align=\"left\">"+soi.getGoodsoutnumber()+" "+goodsunit+"</td>");
out.println("<td align=\"right\"><span class=\"code\">商品分類:</span></td>");
out.println("<td align=\"left\">"+commodityname+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"23\" colspan=\"2\" align=\"left\"><span class=\"code\">出庫商品備注信息如下:</span></td>");
out.println("<td colspan=\"2\" align=\"right\"> </td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"45\" colspan=\"4\" align=\"center\" class=\"code\">"+soi.getGoodsoutmemo()+"</td>");
out.println("</tr>");
out.println("<tr>");
out.println("<td height=\"23\" colspan=\"4\" bgcolor=\"#CCCCCC\"> </td>");
out.println("</tr>");
out.println("</table>");
j++;
if(j==span)break;
}
out.println("<table width=\"532\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\">");
out.println("<tr>");
out.println("<td width=\"165\" height=\"23\" align=\"left\"><p class=\"code\">頁次:"+currentpage+"/"+totalpages+"頁 每頁5條信息"+count+"</p></td>");
out.println("<td width=\"357\" align=\"center\"><a href=\"userstockoutinfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a> " +
"<a href=\"userstockoutinfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a> " +
"<a href=\"userstockoutinfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a> " +
"<a href=\"userstockoutinfo.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");
out.println("</tr>");
out.println("</table>");
out.println("<p> </p>");
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
return SKIP_BODY;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -