?? stockininfouser.java
字號:
package com.logistic.taglib;
import com.logistic.data.DataConnect;
import com.logistic.business.StockInManager;
import com.logistic.model.StockInInfo;
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 StockInInfoUser 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 commodityname; //商品分類名稱
String goodstypename; //商品類型名稱
String goodsunit; //商品單位
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 stockininfotable order by StockInId 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;
}
StockInManager sm=new StockInManager();
Vector items=sm.StockInSearch(sqls, page);
out.println("<table width=\"543\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
out.println("<td height=\"26\" 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++){
StockInInfo siibean=(StockInInfo)items.elementAt(i);
//取得指定編號的職員的名稱即入庫單負責人
try{
String sqlchargename="select * from employeeinfotable where EmployeeId="+siibean.getCharegid();
stat=dc.getStmtread();
rs=stat.executeQuery(sqlchargename);
while(rs.next()){
chargename=rs.getString("EmployeeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//取得指定編號的商品的名稱
try{
String sqlgoodsname="select * from goodsinfotable where GoodsId="+siibean.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 sqlcommcatename="select * from commcatetable where CommodityId="+siibean.getCommodityid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlcommcatename);
while(rs.next()){
commodityname=rs.getString("CommodityName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
//取得商品的類型名稱
try{
String sqlgoodstype="select * from typetable where TypeId="+siibean.getTypeid();
stat=dc.getStmtread();
rs =stat.executeQuery(sqlgoodstype);
while(rs.next()){
goodstypename=rs.getString("TypeName");
}
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
out.println("<table width=\"543\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\" bgcolor=\"#FF9966\">");
out.println("<tr>");
//輸出商品的編號
out.println("<td height=\"22\" align=\"left\" class=\"code\">商品編號為:"+siibean.getStockinid()+"</td>");
out.println("</tr>");
out.println("</table>");
out.println("<table width=\"543\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
out.println("<tr>");
//輸出入庫單負責人名字
out.println("<td width=\"107\" height=\"22\" align=\"right\" class=\"code\">入庫負責人:</td>");
out.println("<td width=\"147\" align=\"left\" class=\"code\">"+chargename+"</td>");
//輸出商品名稱
out.println("<td width=\"84\" align=\"right\" class=\"code\">商品名稱:</td>");
out.println("<td width=\"187\" align=\"left\" class=\"code\">"+goodsname+"</td>");
out.println("</tr>");
out.println("<tr>");
//輸出商品的入庫數量
out.println("<td height=\"21\" align=\"right\" class=\"code\">入庫數量:</td>");
out.println("<td align=\"left\" class=\"code\">"+siibean.getGoodsinnumber()+" "+goodsunit+"</td>");
//輸出商品分類的名稱
out.println("<td align=\"right\" class=\"code\">商品類別:</td>");
out.println("<td align=\"left\" class=\"code\">"+commodityname+"</td>");
out.println("</tr>");
out.println("<tr>");
//輸出商品的型號名稱
out.println("<td height=\"20\" align=\"right\" class=\"code\">商品型號:</td>");
out.println("<td align=\"left\" class=\"code\">"+goodstypename+"</td>");
//輸出入庫單的備注信息
out.println("<td colspan=\"2\" align=\"left\" class=\"code\">商品入庫單備注信息如下:</td>");
out.println("</tr>");
out.println("<tr class=\"code\">");
out.println("<td height=\"35\" colspan=\"4\" align=\"center\" class=\"code\">"+siibean.getGoodsinmemo()+"</td>");
out.println("</tr>");
out.println("<tr align=\"center\">");
out.println("<td height=\"18\" colspan=\"4\" bgcolor=\"#996699\"></td>");
out.println("</tr>");
j++;
if(j==span)break;
}
out.println("<tr align=\"center\">");
//輸出入庫單頁次信息
out.println("<td height=\"25\" align=\"left\" colspan=\"2\"><p class=\"code\">頁次:"+currentpage+"/"+totalpages+"頁 每頁5條信息"+count+"</p></td>");
//輸出入庫單翻頁標簽
out.println("<td height=\"25\" colspan=\"2\"><a href=\"userstockininfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a> " +
"<a href=\"userstockininfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a> " +
"<a href=\"userstockininfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a> " +
"<a href=\"userstockininfo.jsp?arg4=-4\"><img src=\""+path+"/image/end.jpg\" border=\"0\"></a></td>");
out.println("</tr>");
out.println("</table>");
}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
return SKIP_BODY;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -