carmanager.java

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

package com.logistic.business;

import com.logistic.dao.ICarManagerDAO;
import com.logistic.model.CarInfo;
import java.util.Vector;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;

public class CarManager implements ICarManagerDAO {
	
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;
	
  public int AddCarManager(String carid,String driverid,String teamid){
		
		int flag=-10;
	  try{
		  
		  String cid=carid;
	 	  String did=driverid;
	 	  String tid=teamid;
		  String strsql="insert into carmanagetable(CarId,CarDriverId,CarTeamId)values('"+cid+"','"+did+"','"+tid+"')";
		  flag=dc.updata(strsql);
		  
		  if(flag>0){
			  System.out.print("车辆管理信息添加成功!");
		  }else{
			  System.out.print("车辆管理信息添加失败!");
		  }
		
	    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
		 
		 return flag;
	}
	
  public Vector CarSearch(String strsql,int page){
    	
		Vector items=new Vector();
		try{
			
			stat=dc.getStmtread();
			rs=stat.executeQuery(strsql);
			PageAble pgb=new PageAble(rs);
			pgb.setPagesize(5);
			pgb.setCurrentpage(1);
			pgb.gotoPage(page);
			
			rs.absolute(pgb.getRowscount());
			int i=0;
			do{
				items.add(new CarInfo(rs.getInt("ID"),rs.getString("CarId"),rs.getString("CarDriverId"),rs.getString("CarTeamId")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
		return items;
    }
       
  public int DelCar(String carid){
    	
		String delcar="delete from carmanagertable where CarId="+carid;
		
		int flag=0;
		
		try{
			flag=dc.updata(delcar);
			if(flag>0){
				System.out.println("车辆管理信息删除成功，编号:"+carid);
			   }else{
				System.out.println("车辆管理信息删除失败，编号:"+carid);
			         }
		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
	    return flag;
    }

  public int ModifyCarManager(int id,String carid,String driverid,String teamid){
	  
	  int flag=-10;
	  try{
		  int    mid=id;
		  String cid=carid;
		  String did=driverid;
		  String tid=teamid;
		  String strsql="update carmanagetable set CarId='"+cid+"',CarDriverId='"+did+"',CarTeamId='"+tid+"' where ID='"+mid+"'";
		  
          flag=dc.updata(strsql); 
		  if(flag>0){
			  System.out.println("编号="+mid+"的汽车信息更新成功!");
		  }else{
			  System.out.println("编号="+mid+"的汽车信息更新失败!");
		  }
	  }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
	 
	 return flag; 
  }

  public CarInfo CarSearchById(int id){
	  
	  String strsql="select * from carmanagetable where ID="+id;
	  CarInfo ci=new CarInfo();
	  try{		  
		  stat=dc.getStmtread();
		  rs  =stat.executeQuery(strsql);
		  while(rs.next()){
			  ci.setId(rs.getInt("ID"));
			  ci.setCarid(rs.getString("CarId"));
			  ci.setCardriverid(rs.getString("CarDriverId"));
			  ci.setCarteamid(rs.getString("CarTeamId"));
		  }		  
	  }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
  return ci;  
  }
}