论文终极版（改电大）- 副本(9)

唐山广播电视大学毕业设计

pstmt.setString(14, bean.getApprover_Time()); pstmt.setInt(15, bean.getApprover_Status()); pstmt.setString(16, bean.getComment_Info()); pstmt.setInt(17, bean.getStatus()); pstmt.setInt(18, bean.getId()); if (pstmt.executeUpdate() > 0) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } return flag; } public List findAll(Connection conn) { List list = new ArrayList(); String sql = \ list = this.findBySql1(sql, conn); return list; } public VehicleApplicantForm findById(int id, Connection conn) { VehicleApplicantForm bean = new VehicleApplicantForm(); String sql = \ try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); rs = pstmt.executeQuery(); if (rs.next()) { bean.setId(rs.getInt(1)); bean.setApplicant_Number(rs.getString(2)); bean.setApplicant_Name(rs.getString(3)); bean.setTelephone_Number(rs.getString(4)); bean.setDivision_Name(rs.getString(5)); bean.setCompany_Name(rs.getString(6)); bean.setDepartment_Name(rs.getString(7)); bean.setApplicant_Leaving_Date(rs.getString(8)); bean.setPlaned_Return_Time(rs.getString(9)); bean.setDestination(rs.getString(10)); bean.setUsing_Reason(rs.getString(11)); bean.setApplication_Time(rs.getString(12)); bean.setApprover_ID(rs.getString(13)); bean.setApprover_Name(rs.getString(14)); bean.setApprover_Time(rs.getString(15)); bean.setApprover_Status(rs.getInt(16)); bean.setComment_Info(rs.getString(17)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } return bean; }

车辆维修保养管理模块：

public boolean MaintainInfo_Delete_ById(int id,Connection conn) { boolean flog = false; String sql = \ try {

35

唐山广播电视大学毕业设计

pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } return flog; } //插入记录 public boolean MaintainInfo_Insert(MaintainInfo bean,Connection conn) { boolean flog = false; String sql = \

MaintainInfo_table(Plate_Number,DrivingLicense_Number,\ \ \Name,\ \_Labor_Cost,\

\\ \ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setString(2, bean.getDrivingLicense_Number()); pstmt.setString(3, bean.getDivision_Name()); pstmt.setString(4, bean.getCompany_Name()); pstmt.setInt(5, bean.getMaintenance_Type()); pstmt.setString(6, bean.getMaintenance_Date()); pstmt.setString(7, bean.getLeave_Factory_Date()); pstmt.setString(8, bean.getMaintenance_Factory()); pstmt.setFloat(9, bean.getVKT_Before_Maintenance()); pstmt.setString(10, bean.getProject_Name()); pstmt.setString(11, bean.getProject_Detail()); pstmt.setString(12, bean.getResults_of_Transaction()); pstmt.setString(13, bean.getProject_Balance_Date()); pstmt.setFloat(14, bean.getMaintenance_Labor_Cost()); pstmt.setFloat(15, bean.getOutfit_Cost()); pstmt.setFloat(16, bean.getCleaning_Cost()); pstmt.setFloat(17, bean.getTyre_Cost()); pstmt.setFloat(18, bean.getOther_Cost()); pstmt.setFloat(19, bean.getTotal_Cost()); pstmt.setString(20, bean.getComment_Info()); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } return flog; } //修改方法 public boolean MaintainInfo_Update(MaintainInfo bean,Connection conn) { boolean flog = false;

36

唐山广播电视大学毕业设计

String sql = \Plate_Number=?,DrivingLicense_Number=?,\ \+ \oject_Name=?,\ \enance_Labor_Cost=?,\ \where id=? \ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setString(2, bean.getDrivingLicense_Number()); pstmt.setString(3, bean.getDivision_Name()); pstmt.setString(4, bean.getCompany_Name()); pstmt.setInt(5, bean.getMaintenance_Type()); pstmt.setString(6, bean.getMaintenance_Date()); pstmt.setString(7, bean.getLeave_Factory_Date()); pstmt.setString(8, bean.getMaintenance_Factory()); pstmt.setFloat(9, bean.getVKT_Before_Maintenance()); pstmt.setString(10, bean.getProject_Name()); pstmt.setString(11, bean.getProject_Detail()); pstmt.setString(12, bean.getResults_of_Transaction()); pstmt.setString(13, bean.getProject_Balance_Date()); pstmt.setFloat(14, bean.getMaintenance_Labor_Cost()); pstmt.setFloat(15, bean.getOutfit_Cost()); pstmt.setFloat(16, bean.getCleaning_Cost()); pstmt.setFloat(17, bean.getTyre_Cost()); pstmt.setFloat(18, bean.getOther_Cost()); pstmt.setFloat(19, bean.getTotal_Cost()); pstmt.setInt(20, bean.getId()); System.out.println(bean.getId()); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } return flog; } //调用findBySql（）方法来查询全部 public List findAll(Connection conn) { List beans = new ArrayList(); beans = this.findBySql(\ return beans ; }

车辆用油管理模块：

public boolean Journey_Delete_ById(int id,Connection conn) { boolean flag = false; // conn = db.getConnection(); String sql = \ try {

37

唐山广播电视大学毕业设计

pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); if (pstmt.executeUpdate() > 0) { flag = true; }

} catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { this.close(); }

return flag; }

public boolean Journey_Insert(Journey bean,Connection conn) { //conn = db.getConnection(); String sql = \

Journey_table(Plate_Number,DrivingLicense_Number,Division_Name,Company_Name,Stat_Date,Journey,Comment_Info)values(?,?,?,?,?,?,?)\ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setString(2, bean.getDrivingLicense_Number()); pstmt.setString(3, bean.getDivision_Name()); pstmt.setString(4, bean.getCompany_Name()); pstmt.setString(5, bean.getStat_Date()); pstmt.setFloat(6, bean.getJourney()); pstmt.setString(7, bean.getComment_Info()); if (pstmt.executeUpdate() > 0) { return true; } } catch (SQLException e) { e.printStackTrace(); } finally { this.close(); } return false; } public boolean Journey_Update(Journey bean,Connection conn) { boolean flag = false; //conn = db.getConnection(); String sql = \

Plate_Number=?,DrivingLicense_Number=?,Division_Name=?,Company_Name=?,Stat_Date=?,Journey=?,Comment_Info=? where id=?\ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setString(2, bean.getDrivingLicense_Number()); pstmt.setString(3, bean.getDivision_Name()); pstmt.setString(4, bean.getCompany_Name()); pstmt.setString(5, bean.getStat_Date()); pstmt.setFloat(6, bean.getJourney()); pstmt.setString(7, bean.getComment_Info()); pstmt.setInt(8, bean.getId()); if (pstmt.executeUpdate() > 0) { flag = true; } } catch (SQLException e) { e.printStackTrace(); } finally {

38

唐山广播电视大学毕业设计

this.close(); } return flag; } public List findAll(int currpage, int pagers,Connection conn) { List list = new ArrayList(); String sql = \ list = this.findBySql(currpage,pagers,sql,conn); return list; } public Journey findById(int id,Connection conn) { Journey bean = new Journey(); // conn = db.getConnection(); String sql = \ try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); rs = pstmt.executeQuery(); if (rs.next()) { bean.setId(rs.getInt(1)); bean.setPlate_Number(rs.getString(2)); bean.setDrivingLicense_Number(rs.getString(3)); bean.setDivision_Name(rs.getString(4)); bean.setCompany_Name(rs.getString(5)); bean.setStat_Date(rs.getString(6)); bean.setJourney(rs.getFloat(7)); bean.setComment_Info(rs.getString(8)); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } finally { this.close(); } return bean; } public List findBySql(int currpage, int pagers,String sql,Connection conn) { //conn = db.getConnection(); List list = new ArrayList(); //String sqls = \ String sqls=\t1 where rownum<=? and \ //sqls = sqls + sql; //System.out.println(\的语法是：==========================\ int startPage=(currpage - 1) * pagers ; int endPage=startPage+pagers; try { PreparedStatement prs=conn.prepareStatement(sqls); prs.setInt(1,endPage); prs.setInt(2,startPage); rs=prs.executeQuery(); while (rs.next()) { Journey bean = new Journey(); bean.setId(rs.getInt(2)); bean.setPlate_Number(rs.getString(3));

39