caradmin.java

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

package com.logistic.taglib;

import com.logistic.data.DataConnect;
import com.logistic.business.CarManager;
import com.logistic.model.CarInfo;
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.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.Statement;

public class CarAdmin extends TagSupport{
	
	private static final long serialVersionUID = 7766184319541530720L;
	
	DataConnect dc=new DataConnect();
	Statement stat=null;
	ResultSet rs=null;
	String    drivername=null;
	String    carteamname=null;
	
	
	public int doEndTag() throws JspException{
		
		JspWriter out=pageContext.getOut();
		HttpServletRequest request=(HttpServletRequest)pageContext.getRequest();
		try {
			request.setCharacterEncoding("gb2312");
		} catch (UnsupportedEncodingException e) {e.printStackTrace();}
    
		String str=(String)request.getQueryString();
		int page;
		if(str==null||str.equals("")){
			page=1;
		}else{
			String[] aa=str.split("=");
			page=Integer.parseInt(aa[1]);
			System.out.println("page="+page);
		}
		
		try{
			
	    	String sqls=new String("select * from carmanagetable order by ID ASC");
	    	int totalpages=0;
	    	int count=dc.selectdata(sqls);
	    	if(count%5==0){
	    		totalpages=count/5;
	    		}else{
	    		totalpages=count/5+1;
	    		}
	    	int currentpage=1;
	    	if(page==-4){
	    		currentpage=totalpages;
	    	   }else if(page==-3){
	    		      if(currentpage==totalpages){
	      		    	currentpage=totalpages; 
	      		        }else{
	      		         currentpage=currentpage+1;
	      		        }
	    	   }else if(page==-2){
	    		   if(currentpage==1){
	    		      currentpage=1;
	    		   }else{
	    			   currentpage=currentpage-1; 
	    		   }
	    	   }else{
	    		   currentpage=1;
	    	   }
	    
	    CarManager cm=new CarManager();
	    Vector     items=cm.CarSearch(sqls, page);
	    
	    out.println("<table width=\"630\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
		out.println("<tr>");
		out.println("<td width=\"565\" 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++){
			
	    	CarInfo ci=(CarInfo)items.elementAt(i);
	    	
	    	try{
	    		String strsql="select * from employeeinfotable where EmployeeId="+ci.getCardriverid();
	    		stat=dc.getStmtread();
	    		rs  =stat.executeQuery(strsql);
	    		while(rs.next()){	    			
	    			drivername=rs.getString("EmployeeName");	    			
	    		}	    		
	    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	    	
	    	try{
	    		String strsql="select * from carteaminfotable where CarTeamId="+ci.getCarteamid();
	    		stat=dc.getStmtread();
	    		rs  =stat.executeQuery(strsql);
	    		while(rs.next()){
	    			carteamname=rs.getString("CarTeamName");
	    		}
	    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	    	
	    	
	    	out.println("<table width=\"630\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
	    	out.println("<tr>");
	    	out.println("<td width=\"42\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">编号:</td>");
	    	out.println("<td width=\"49\" align=\"center\">"+ci.getId()+"</td>");
	    	out.println("<td width=\"65\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">车辆牌号:</td>");
	    	out.println("<td width=\"67\" align=\"center\">"+ci.getCarid()+";</td>");
	    	out.println("<td width=\"60\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">司机姓名:</td>");
	    	out.println("<td width=\"62\" align=\"center\">"+drivername+"</td>");
	    	out.println("<td width=\"60\" align=\"right\" bgcolor=\"#FFCCCC\" class=\"code\">所属车队:</td>");
	    	out.println("<td width=\"75\" align=\"center\">"+carteamname+"</td>");
	    	out.println("<td width=\"112\" align=\"center\"><a href=\""+path+"/viewpage/datamodify/carmanagemodify.jsp?id="+ci.getId()+"\"><img src=\""+path+"/image/edit.gif\" border=\"0\"></a>&nbsp;&nbsp;&nbsp;" +
	    	   		    "<a href=\"admincarinfo.jsp?carid="+ci.getId()+"\" onClick=\"{if(confirm('此操作将删除当前记录!删除后将不能恢复,您确定执行的操作吗?')){return true;}return false;}\"><img src=\""+path+"/image/delete.gif\" border=\"0\"></a></td>");
	    	out.println("</tr>");
	    	out.println("</table>");
	    	
	    	j++;
	    	if(j==span)break;
		}
		
		    out.println("<table width=\"630\" height=\"22\" border=\"1\" align=\"center\" cellpadding=\"1\" cellspacing=\"0\" bordercolor=\"#666699\">");
		    out.println("<tr>");
		    out.println("<td width=\"164\" height=\"20\" align=\"left\">页次:"+currentpage+"/"+totalpages+"页;每页5条信息共"+count+"条</td>");
		    out.println("<td width=\"456\" height=\"20\" align=\"center\"><a href=\"admincarinfo.jsp?arg1=-1\"><img src=\""+path+"/image/begin.jpg\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admincarinfo.jsp?arg2=-2\"><img src=\""+path+"/image/1-prev.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admincarinfo.jsp?arg3=-3\"><img src=\""+path+"/image/1-next.gif\" border=\"0\"></a>&nbsp;&nbsp;" +
	       		          "<a href=\"admincarinfo.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;
	}
}