carteammanager.java

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

package com.logistic.business;

import com.logistic.dao.ICarTeamDAO;
import com.logistic.model.CarTeamInfo;
import java.util.Vector;
import com.logistic.data.DataConnect;
import java.sql.Statement;
import java.sql.ResultSet;

public class CarTeamManager implements ICarTeamDAO {
	 
	DataConnect dc=new DataConnect();
	Statement   stat=null;
	ResultSet   rs=null;

	public int AddCarTeam(String carteamid,String carteamname,String chargeid){
		
		int flag=-10;
		  try{
			  
			  String ctid=carteamid;
		 	  String ctname=carteamname;
		 	  String cid=chargeid;
			  String strsql="insert into carteaminfotable(CarTeamId,CarTeamName,ChargeId)values('"+ctid+"','"+ctname+"','"+cid+"')";
			  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 CarTeamSearch(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 CarTeamInfo(rs.getString("CarTeamId"),rs.getString("CarTeamName"),rs.getString("ChargeId")));
			  
			   }while(rs.next()&&i<pgb.getCurrentPageRowsCount());
	
			}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
		return items;
		
	}

    public int DelCarTeam(String carteamid){
    	
		String delcarteam="delete from carteaminfotable where CarTeamId="+carteamid;
		
		int flag=0;
		
		try{
			flag=dc.updata(delcarteam);
			if(flag>0){
				System.out.println("车队信息删除成功，编号:"+carteamid);
			   }else{
				System.out.println("车队信息删除失败，编号:"+carteamid);
			         }
		    }catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
			
	    return flag;
    }

    public int ModifyCarTeam(String carteamid,String carteamname,String chargeid){
    	
    	int flag=-10;
    	try{
    		String ctid=carteamid;
    		String ctname=carteamname;
    		String chid=chargeid;
    		String strsql="update carteaminfotable set CarTeamName='"+ctname+"',ChargeId='"+chid+"' where CarTeamId="+ctid;
    		
    		flag=dc.updata(strsql);
    		if(flag>0){
    			System.out.println("编号="+ctid+"的车队信息更新成功!");
    		}else{
    			System.out.println("编号="+ctid+"的车队信息更新失败!");
    		}
    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
      return flag;	
    }

    public CarTeamInfo CarTeamSearchById(String carteamid){
    	
    	String strsql="select * from carteaminfotable where CarTeamId="+carteamid;
    	CarTeamInfo cti=new CarTeamInfo();
    	try{
    		stat=dc.getStmtread();
    		rs  =stat.executeQuery(strsql);
    		while(rs.next()){    			
    			cti.setCarteamid(rs.getString("CarTeamId"));
    			cti.setCarteamname(rs.getString("CarTeamName"));
    			cti.setChargeid(rs.getString("ChargeId"));    			
    		}
    		
    	}catch(Exception ex){ex.printStackTrace();}finally{dc.close();}
     return cti;	
    }
}