supplyadmin.java

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

package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.SupplyManager;
import com.logistic.model.SupplyInfo;
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 SupplyAdmin extends TagSupport {
	
	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=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 supplytable order by SupplyId 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;
	    	   }
	    	SupplyManager gm=new SupplyManager();
	        Vector items=gm.SupplySearch(sqls, page);
	        
	        //输出供应商信息列表的表头
	        out.println("<table width=\"648\" 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标识每页显示10条信息，j是一个计数器
		 	String path=request.getContextPath();
		    for(int i=0;i<items.size();i++){
		    	
		    	SupplyInfo supplyinfo=(SupplyInfo)items.elementAt(i);
		    	
		    	//输出供应商编号和编辑删除链接
		        out.println("<table width=\"648\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\" bgcolor=\"#FF9966\">");
		        out.println("<tr>");
		        out.println("<td width=\"321\" align=\"left\" bgcolor=\"#FF9999\" class=\"code\">"+supplyinfo.getSupplyid()+"</td>");
		        out.println("<td width=\"139\" align=\"center\" bgcolor=\"#FF9999\">【编辑】/【删除】</td>");
		        out.println("<td width=\"174\" align=\"center\" bgcolor=\"#FF9999\"><a href=\""+path+"/viewpage/datamodify/supplymodify.jsp?sid="+supplyinfo.getSupplyid()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;" +
	    	   		       "<a href=\"adminsupply.jsp?supplyid="+supplyinfo.getSupplyid()+"\" 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=\"648\" height=\"155\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
		        out.println("<tr>");
		        out.println("<td width=\"103\" height=\"25\" align=\"right\" valign=\"middle\" class=\"code\">供应商名称:</td>");
		        out.println("<td width=\"214\" height=\"25\" align=\"left\">"+supplyinfo.getSupplyname()+"</td>");
		       
		        //输出供应商负责人
		        out.println("<td width=\"140\" align=\"right\" class=\"code\">供应商负责人:</td>");
		        out.println("<td width=\"173\" align=\"left\">"+supplyinfo.getSupplycharge()+"</td>");
		        out.println("</tr>");
		        
		        //输出供应商地址
		        out.println("<tr>");
		        out.println("<td height=\"25\" align=\"right\" class=\"code\">供应商地址:</td>");
		        out.println("<td colspan=\"3\" align=\"left\">"+supplyinfo.getSupplyaddress()+"</td>");
		        out.println("</tr>");
		        
		        //输出供应商固定电话
		        out.println("<tr>");
		        out.println("<td height=\"27\" align=\"right\" class=\"code\">供应商固定电话:</td>");
		        out.println("<td align=\"left\">"+supplyinfo.getSupplyphone()+"</td>");
		        
		        //输出供应商移动电话
		        out.println("<td align=\"right\" class=\"code\">供应商移动电话:</td>");
		        out.println("<td align=\"left\">"+supplyinfo.getSupplymobile()+"</td>");
		        out.println("</tr>");
		        
		        //输出供应商传真
		        out.println("<tr>");
		        out.println("<td height=\"26\" align=\"right\" class=\"code\">供应商传真:</td>");
		        out.println("<td align=\"left\">"+supplyinfo.getSupplyfax()+"</td>");
		        
		        //输出供应商邮件
		        out.println("<td align=\"right\" class=\"code\">供应商邮件:</td>");
		        out.println("<td>"+supplyinfo.getSupplyemail()+"</td>");
		        out.println("</tr>");
		        
		        out.println("<tr>");
		        out.println("<td height=\"25\" align=\"right\" class=\"code\">供应商网址:</td>");
		        out.println("<td colspan=\"2\" align=\"left\">"+supplyinfo.getSupplyhttp()+"</td>");
		        out.println("<td>&nbsp;</td>");
		        out.println("</tr>");
		        out.println("<tr align=\"center\">");
		        out.println("<td height=\"25\" colspan=\"4\" bgcolor=\"#CCCCCC\">&nbsp;</td>");
		        out.println("</tr>");
		        out.println("</table>");
		        
		        j++;
		        if(j==span)break;
		        
		    }
		    
	           out.println("<table width=\"648\" height=\"23\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	           out.println("<tr>");
	           out.println("<td width=\"165\" align=\"left\" height=\"23\">页次:"+currentpage+"/"+totalpages+"页&nbsp;每页5条信息"+count+"</td>");
	           out.println("<td width=\"357\" align=\"center\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"adminsupply.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		           "<a href=\"adminsupply.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		           "<a href=\"adminsupply.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		           "<a href=\"adminsupply.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;
	}
	
}