stockoutinfouser.java

基于J2EE的网络物流系统 用户操作： 1． 录入出库商品信息 2． 查询出库单信息 3． 录入入库商品信息 4． 查询入库单信息 5． 查询商品位置信息 6． 查询商品信息 7． 查

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()+"&nbsp;"+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\">&nbsp;</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\">&nbsp;</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+"页&nbsp;每页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>&nbsp;&nbsp;" +
	       		        "<a href=\"userstockoutinfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		        "<a href=\"userstockoutinfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		        "<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>&nbsp;</p>");
	 	     
		      
	    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	    
	    return SKIP_BODY;
	}
}