Business源代码.docx
- 文档编号:13583665
- 上传时间:2023-06-15
- 格式:DOCX
- 页数:82
- 大小:33.49KB
Business源代码.docx
《Business源代码.docx》由会员分享,可在线阅读,更多相关《Business源代码.docx(82页珍藏版)》请在冰点文库上搜索。
Business源代码
Business类源代码
CarManager.java()
AddCarManager(String,String,String)
CarSearch(String,int)
CarSearchById(int)
DelCar(String)
ModifyCarManager(int,String,String,String)
packagecom.logistic.business;
importcom.logistic.dao.ICarManagerDAO;
importcom.logistic.model.CarInfo;
importjava.util.Vector;
importcom.logistic.data.DataConnect;
importjava.sql.Statement;
importjava.sql.ResultSet;
publicclassCarManagerimplementsICarManagerDAO{
DataConnectdc=newDataConnect();
Statementstat=null;
ResultSetrs=null;
publicintAddCarManager(Stringcarid,Stringdriverid,Stringteamid){
intflag=-10;
try{
Stringcid=carid;
Stringdid=driverid;
Stringtid=teamid;
Stringstrsql="insertintocarmanagetable(CarId,CarDriverId,CarTeamId)values('"+cid+"','"+did+"','"+tid+"')";
flag=dc.updata(strsql);
if(flag>0){
System.out.print("车辆管理信息添加成功!
");
}else{
System.out.print("车辆管理信息添加失败!
");
}
}catch(Exceptionex){ex.printStackTrace();}finally{dc.close();}
returnflag;
}
publicVectorCarSearch(Stringstrsql,intpage){
Vectoritems=newVector();
try{
stat=dc.getStmtread();
rs=stat.executeQuery(strsql);
PageAblepgb=newPageAble(rs);
pgb.setPagesize(5);
pgb.setCurrentpage
(1);
pgb.gotoPage(page);
rs.absolute(pgb.getRowscount());
inti=0;
do{
items.add(newCarInfo(rs.getInt("ID"),rs.getString("CarId"),rs.getString("CarDriverId"),rs.getString("CarTeamId")));
}while(rs.next()&&i }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnitems; } publicintDelCar(Stringcarid){ Stringdelcar="deletefromcarmanagetablewhereId="+carid; intflag=0; try{ flag=dc.updata(delcar); if(flag>0){ System.out.println("车辆管理信息删除成功,编号: "+carid); }else{ System.out.println("车辆管理信息删除失败,编号: "+carid); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } publicintModifyCarManager(intid,Stringcarid,Stringdriverid,Stringteamid){ intflag=-10; try{ intmid=id; Stringcid=carid; Stringdid=driverid; Stringtid=teamid; Stringstrsql="updatecarmanagetablesetCarId='"+cid+"',CarDriverId='"+did+"',CarTeamId='"+tid+"'whereID='"+mid+"'"; flag=dc.updata(strsql); if(flag>0){ System.out.println("编号="+mid+"的汽车信息更新成功! "); }else{ System.out.println("编号="+mid+"的汽车信息更新失败! "); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } publicCarInfoCarSearchById(intid){ Stringstrsql="select*fromcarmanagetablewhereID="+id; CarInfoci=newCarInfo(); 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(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnci; } } CarTeamManager.java AddCarTeam(String,String,String) CarTeamSearch(String,int) CarTeamSearchById(String) DelCarTeam(String) ModifyCarTeam(String,String,String) packagecom.logistic.business; importcom.logistic.dao.ICarTeamDAO; importcom.logistic.model.CarTeamInfo; importjava.util.Vector; importcom.logistic.data.DataConnect; importjava.sql.Statement; importjava.sql.ResultSet; publicclassCarTeamManagerimplementsICarTeamDAO{ DataConnectdc=newDataConnect(); Statementstat=null; ResultSetrs=null; publicintAddCarTeam(Stringcarteamid,Stringcarteamname,Stringchargeid){ intflag=-10; try{ Stringctid=carteamid; Stringctname=carteamname; Stringcid=chargeid; Stringstrsql="insertintocarteaminfotable(CarTeamId,CarTeamName,ChargeId)values('"+ctid+"','"+ctname+"','"+cid+"')"; flag=dc.updata(strsql); if(flag>0){ System.out.print("车队信息添加成功! "); }else{ System.out.print("车队信息添加失败! "); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } publicVectorCarTeamSearch(Stringstrsql,intpage){ Vectoritems=newVector(); try{ stat=dc.getStmtread(); rs=stat.executeQuery(strsql); PageAblepgb=newPageAble(rs); pgb.setPagesize(5); pgb.setCurrentpage (1); pgb.gotoPage(page); rs.absolute(pgb.getRowscount()); inti=0; do{ items.add(newCarTeamInfo(rs.getString("CarTeamId"),rs.getString("CarTeamName"),rs.getString("ChargeId"))); }while(rs.next()&&i }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnitems; } publicintDelCarTeam(Stringcarteamid){ Stringdelcarteam="deletefromcarteaminfotablewhereCarTeamId="+carteamid; intflag=0; try{ flag=dc.updata(delcarteam); if(flag>0){ System.out.println("车队信息删除成功,编号: "+carteamid); }else{ System.out.println("车队信息删除失败,编号: "+carteamid); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } publicintModifyCarTeam(Stringcarteamid,Stringcarteamname,Stringchargeid){ intflag=-10; try{ Stringctid=carteamid; Stringctname=carteamname; Stringchid=chargeid; Stringstrsql="updatecarteaminfotablesetCarTeamName='"+ctname+"',ChargeId='"+chid+"'whereCarTeamId="+ctid; flag=dc.updata(strsql); if(flag>0){ System.out.println("编号="+ctid+"的车队信息更新成功! "); }else{ System.out.println("编号="+ctid+"的车队信息更新失败! "); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } publicCarTeamInfoCarTeamSearchById(Stringcarteamid){ Stringstrsql="select*fromcarteaminfotablewhereCarTeamId="+carteamid; CarTeamInfocti=newCarTeamInfo(); 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(Exceptionex){ex.printStackTrace();}finally{dc.close();} returncti; } } DepartmentManager.java AddDepartment(String,String) DelDepartment(String) DepartmentSearch(String,int) packagecom.logistic.business; importcom.logistic.dao.IDepartmentDAO; importcom.logistic.data.DataConnect; importjava.util.Vector; importjava.sql.ResultSet; importjava.sql.Statement; importcom.logistic.model.DepartmentInfo; publicclassDepartmentManagerimplementsIDepartmentDAO{ DataConnectdc=newDataConnect(); Statementstat=null; ResultSetrs=null; //添加部门信息 publicintAddDepartment(Stringdepaid,Stringdepaname){ intflag=0; try{ Stringid=depaid; Stringname=depaname; Stringstrsqls="insertintodepartmentinfotable(DepartmentId,DepartmentName)values('"+id+"','"+name+"')"; flag=dc.updata(strsqls); if(flag>0){ System.out.println("部门信息插入成功! "); }else{ System.out.println("部门信息插入失败! "); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } //取得部门信息列表 publicVectorDepartmentSearch(Stringstrsql,intpage){ Vectoritems=newVector(); try{ stat=dc.getStmtread(); rs=stat.executeQuery(strsql); PageAblepgb=newPageAble(rs); pgb.setPagesize(5); pgb.setCurrentpage (1); pgb.gotoPage(page); rs.absolute(pgb.getRowscount()); inti=0; do{ items.add(newDepartmentInfo(rs.getString("DepartmentId"),rs.getString("DepartmentName"))); }while(rs.next()&&i }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnitems; } //根据部门编号删除指定部门 publicintDelDepartment(Stringdepaid){ Stringdeldepartment="deletefromdepartmentinfotablewhereDepartmentId="+depaid; intflag=0; try{ flag=dc.updata(deldepartment); if(flag>0){ System.out.println("部门信息删除成功,编号: "+depaid); }else{ System.out.println("部门信息删除失败,编号: "+depaid); } }catch(Exceptionex){ex.printStackTrace();}finally{dc.close();} returnflag; } } EmployeeManager.java AddEmployee(String,String,String,int,String,String,String,String,String,String,String,String,String) DelEmployee(String) EmployeeSearch(String,int) EmployeeSearchById(String) ModifyEmployee(String,String,String,int,String,String,String,String,String,String,String,String,String) packagecom.logistic.business; importjava.sql.Statement; importjava.sql.ResultSet; importcom.logistic.data.DataConnect; importcom.logistic.model.EmployeeInfo; importcom.logistic.dao.*; importjava.util.Vector; importcom.logistic.business.PageAble; publicclassEmployeeManagerimplementsIEmployeeDAO{ DataConnectdc=newDataConnect(); Statementstat=null; ResultSetrs=null; publicintAddEmployee(Stringemployeeid,Stringemployeename,Stringemployeesex,intemployeeage,Stringemployeeidencard,Stringemployeebirthdate,Stringemployeediploma,Stringemployeejoindate,Stringemployeeadd,Stringemployeephone,Stringemployeemobile,Stringdepartmentid,Stringjobsid){ intflag=-10; try{ Stringid=employeeid; Stringname=employeename; Stringsex=employeesex; intage=employeeage; Stringidencard=employeeidencard; Stringbirthdate=employeebirthdate; Stringdiploma=employeediploma; Stringjoindate=employeejoindate; Stringaddress=employeeadd; Stringphone=employeephone; Stringmobile=employeemobile; Stringdeparid=departmentid; Stringjobid=jobsid; System.out.print("EmployeeaManager"); System.out.print(name); Stringsqls="insertintoemployeeinfotable(Employe
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Business 源代码