goodstypeadmin.java

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

package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.GoodsTypeManager;
import com.logistic.model.GoodsTypeInfo;
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 GoodsTypeAdmin extends TagSupport{
	
	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	String    goodsname=null;
	String    catename=null;
	
	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 typetable order by TypeId 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;
	    	   }
	    	
	    	GoodsTypeManager gtm=new GoodsTypeManager();
	        Vector items=gtm.GoodsTypeSearch(sqls, page);
	        
	        //输出商品型号信息列表头
	        out.println("<table width=\"670\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	        out.println("<tr>");
	        out.println("<td height=\"20\" 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++){
	        	
	        	GoodsTypeInfo gti=(GoodsTypeInfo)items.elementAt(i);
	        	
	        	//根据商品型号取得和其相对应的商品的名称
	        	try{
	        		
	        		String strgn="select * from goodsinfotable where TypeId="+gti.getTypeid();	        		
	        		stat=dc.getStmtread();
	        		rs=stat.executeQuery(strgn);
	        		while(rs.next()){
	        			
	        			  goodsname=rs.getString("GoodsName");
	        		}
	        		
	        	    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	        	    
	           //根据商品的分类编号取得商品的分类名称
	        	try{
	        		
	        		String strcn="select * from commcatetable where CommodityId="+gti.getCategoryid();
	        		stat=dc.getStmtread();
	        		rs=stat.executeQuery(strcn);
	        		while(rs.next()){
	        			
	        			catename=rs.getString("CommodityName");
	        		}
	        		   		
	        	    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}    
	           
	           //输出商品型号详细信息
	           out.println("<table width=\"670\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");	  
	           out.println("<tr>");
	           out.println("<td width=\"35\" align=\"right\" class=\"code\">编号:</td>");
	           out.println("<td width=\"55\" align=\"center\">"+gti.getTypeid()+"</td>");
	           out.println("<td width=\"60\" align=\"right\" class=\"code\">商品名称:</td>");
	           out.println("<td width=\"98\" height=\"23\" align=\"center\">"+goodsname+"</td>");
	           out.println("<td width=\"66\" align=\"right\" class=\"code\">商品分类:</td>");
	           out.println("<td width=\"69\" align=\"center\">"+catename+"</td>");
	           out.println("<td width=\"62\" align=\"left\" class=\"code\">型号名称:</td>");
	           out.println("<td width=\"97\" align=\"center\">"+gti.getTypename()+"</td>");
	           out.println("<td width=\"90\" align=\"left\"><a href=\"#?goodstypeid="+gti.getTypeid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;&nbsp;" +
	    	   		       "<a href=\"admingoodstype.jsp?goodstypeid="+gti.getTypeid()+"\" 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=\"670\" height=\"7\" border=\"0\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\" bgcolor=\"#CCCCCC\">");
	           out.println("<tr>");
	           out.println("<td height=\"7\">&nbsp;</td>");
	           out.println("</tr>");
	           out.println("</table>");
	           
	           j++;
	           if(j==span)break;	           	    
	        }
	        
	         //输出页次和翻页链接信息
	          out.println("<table width=\"670\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	          out.println("<tr>");
	          out.println("<td width=\"163\" height=\"20\">页次:"+currentpage+"/"+totalpages+"页;每页"+span+"条信息共"+count+"</td>");
	          out.println("<td width=\"497\" height=\"20\" align=\"center\" ><a href=\"usergoodstype.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"usergoodstype.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"usergoodstype.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"usergoodstype.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;
	}
	
}