stockininfoadmin.java

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

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 StockInInfoAdmin 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\" colspan=\"3\" 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 width=\"258\" height=\"18\" align=\"left\" class=\"code\">商品编号:"+siibean.getStockinid()+"</td>");
	        out.println("<td width=\"110\" align=\"center\">【编辑】/【删除】</td>");
	        out.println("<td width=\"161\" align=\"center\"><a href=\""+path+"/viewpage/datamodify/stockinmodify?siid="+siibean.getStockinid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;&nbsp;" +
	    	   		     "<a href=\"adminstockininfo.jsp?stockinid="+siibean.getStockinid()+"\" onClick=\"{if(confirm('此操作将删除当前记录!删除后将不能恢复,您确定执行的操作吗?')){return true;}return false;}\">" +
	    	   		     "<img src=\""+path+"/image/delete.gif\" border=\"0\"></a></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()+"&nbsp;"+goodsunit+"</td>");
	        
	        //输出商品类别信息
	        out.println("<td align=\"right\" 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=\"31\" 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=\"26\" align=\"left\" colspan=\"2\"><p class=\"code\">页次:"+currentpage+"/"+totalpages+"页&nbsp;每页5条信息"+count+"</p></td>");
	        
	        //输出入库单翻页标签
	        out.println("<td height=\"26\" colspan=\"2\"><a href=\"userstockininfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		      "<a href=\"userstockininfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		      "<a href=\"userstockininfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		      "<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;
	}
	
	

}