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

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

}

this.close(); }

pageBean.setEntitys(beans); return pageBean;

// 无条件查询出全部并分页

public PageBean findAll(int currpage, int recordsCount, int pagers, Connection conn) { List beans = new ArrayList(); String sql = \ + (currpage - 1) * pagers + \ try { pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { VehicleInfo bean = new VehicleInfo(); bean.setId(rs.getInt(1)); bean.setPlate_Number(rs.getString(2)); bean.setVehicle_Type(rs.getInt(3)); bean.setFrame_Number(rs.getString(4)); bean.setFactory_Number(rs.getString(5)); bean.setBrand_Model(rs.getString(6)); bean.setRegistration_time(rs.getString(7)); bean.setExamination_time(rs.getString(8)); bean.setDivision_Name(rs.getString(9)); bean.setCompany_Name(rs.getString(10)); bean.setComment_Info(rs.getString(11)); beans.add(bean); }

} catch (Exception e) { e.printStackTrace(); } finally { this.close(); }

pageBean.setEntitys(beans); return pageBean;

}

// 按id号删除记录

public boolean VehicleInfo_Delete_ById(int id, Connection conn) { boolean flog = false; String sql = \ try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } finally { this.close(); } return flog; }

// 添加方法

public boolean VehicleInfo_Insert(VehicleInfo bean, Connection conn) { boolean flog = false;

30

\

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

String sql = \VehicleInfo_table(Plate_Number,Vehicle_Type,Frame_Number,Factory_Number,Brand_Model,Registration_time,Examination_time,Rated_Passengers,Division_Name,Company_Name,Comment_Info) \ + \ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setInt(2, bean.getVehicle_Type()); pstmt.setString(3, bean.getFrame_Number()); pstmt.setString(4, bean.getFactory_Number()); pstmt.setString(5, bean.getBrand_Model()); pstmt.setString(6, bean.getRegistration_time()); pstmt.setString(7, bean.getExamination_time()); pstmt.setString(8, bean.getRated_Passengers()); pstmt.setString(9, bean.getDivision_Name()); pstmt.setString(10, bean.getCompany_Name()); pstmt.setString(11, bean.getComment_Info()); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } finally { this.close(); } return flog; } // 修改方法 public boolean VehicleInfo_Update(VehicleInfo bean, Connection conn) { boolean flog = false; String sql = \

Plate_Number=?,Vehicle_Type=?,Frame_Number=?,Factory_Number=?,Brand_Model=?,Registration_time=?,Examination_time=?,Rated_Passengers=?,Division_Name=?,Company_Name=?,Comment_Info=? where id =?\ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getPlate_Number()); pstmt.setInt(2, bean.getVehicle_Type()); pstmt.setString(3, bean.getFrame_Number()); pstmt.setString(4, bean.getFactory_Number()); pstmt.setString(5, bean.getBrand_Model()); pstmt.setString(6, bean.getRegistration_time()); pstmt.setString(7, bean.getExamination_time()); pstmt.setString(8, bean.getRated_Passengers()); pstmt.setString(9, bean.getDivision_Name()); pstmt.setString(10, bean.getCompany_Name()); pstmt.setString(11, bean.getComment_Info()); pstmt.setInt(12, bean.getId()); if (pstmt.executeUpdate() > 0) { flog = true; } } catch (Exception e) { e.printStackTrace(); } finally { this.close(); } return flog; }

31

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

public PageBean findAll(Connection conn) { PageBean beans = new PageBean(); beans = this.findBySql(\ return beans; } public VehicleInfo findById(int id, Connection conn) { VehicleInfo bean = null; String sql = \ try { pstmt = conn.prepareStatement(sql); pstmt.setInt(1, id); rs = pstmt.executeQuery(); if (rs.next()) { bean = new VehicleInfo(); bean.setId(rs.getInt(1)); bean.setPlate_Number(rs.getString(2)); bean.setVehicle_Type(rs.getInt(3)); bean.setFrame_Number(rs.getString(4)); bean.setFactory_Number(rs.getString(5)); bean.setBrand_Model(rs.getString(6)); bean.setRated_Passengers(rs.getString(9)); bean.setRegistration_time(rs.getString(7)); bean.setExamination_time(rs.getString(8)); bean.setDivision_Name(rs.getString(10)); bean.setCompany_Name(rs.getString(11)); bean.setComment_Info(rs.getString(14)); } } catch (Exception e) { e.printStackTrace(); } finally { this.close(); } return bean; }

// 按条件查询

public PageBean findBySql(String sql, Connection conn) { List beans = new ArrayList(); String sqlstr = \ sqlstr = sqlstr + sql; try { smt = conn.createStatement(); rs = smt.executeQuery(sqlstr); while (rs.next()) { VehicleInfo bean = new VehicleInfo(); bean.setId(rs.getInt(1)); bean.setPlate_Number(rs.getString(2)); bean.setVehicle_Type(rs.getInt(3)); bean.setFrame_Number(rs.getString(4)); bean.setFactory_Number(rs.getString(5)); bean.setBrand_Model(rs.getString(6)); bean.setRated_Passengers(rs.getString(9)); bean.setRegistration_time(rs.getString(7)); bean.setExamination_time(rs.getString(8)); bean.setDivision_Name(rs.getString(10)); bean.setCompany_Name(rs.getString(11)); bean.setComment_Info(rs.getString(14)); beans.add(bean);

}

32

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

}

} catch (Exception e) { e.printStackTrace(); } finally { this.close(); }

pageBean.setEntitys(beans);

return pageBean; }

public List findBySqli(String sql, Connection conn) { List beans = new ArrayList(); String sqlstr = \ sqlstr = sqlstr + sql; try { smt = conn.createStatement(); rs = smt.executeQuery(sqlstr); while (rs.next()) { VehicleInfo bean = new VehicleInfo(); bean.setId(rs.getInt(1)); bean.setPlate_Number(rs.getString(2)); bean.setVehicle_Type(rs.getInt(3)); bean.setFrame_Number(rs.getString(4)); bean.setFactory_Number(rs.getString(5)); bean.setBrand_Model(rs.getString(6)); bean.setRated_Passengers(rs.getString(9)); bean.setRegistration_time(rs.getString(7)); bean.setExamination_time(rs.getString(8)); bean.setDivision_Name(rs.getString(10)); bean.setCompany_Name(rs.getString(11)); bean.setComment_Info(rs.getString(14)); beans.add(bean); } } catch (Exception e) { e.printStackTrace(); } finally { this.close(); } return beans; }

public List findAlli(Connection conn) { List beans = new ArrayList(); beans = this.findBySqli(\ return beans; }

车辆调度管理模块：

public PageBean findBySqls(int currpage, int pagers, String sql, Connection conn) { pageBean.setRs(this.getRecordsCount(sql, conn)); pageBean.setPages(getPagesCount(pagers)); pageBean.setCs(currpage); pageBean.setPagers(pagers); String sqls = \t2.* from(select rownum r,t1.* from (select t3.* from vehicleapplicantform_table t3 where 1=1 \ + ((currpage - 1) * pagers+pagers) + \t2 where t2.r>\+ (currpage - 1) * pagers + \ List beans = this.findBySql2(sqls, conn);

33

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

System.out.println(sqls + sql); pageBean.setEntitys(beans); return pageBean; } public boolean VehicleApplicantForm_Insert(VehicleApplicantForm bean, Connection conn) { String sql = \

VehicleApplicantForm_table(Applicant_Number,Applicant_Name,Telephone_Number,Division_Name,Company_Name,Department_Name,Applicant_Leaving_Date,Planed_Return_Time,Destination,Using_Reason,Application_Time,Approver_ID,Approver_Name,Approver_Time,Approver_Status)values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)\ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getApplicant_Number()); pstmt.setString(2, bean.getApplicant_Name()); pstmt.setString(3, bean.getTelephone_Number()); pstmt.setString(4, bean.getDivision_Name()); pstmt.setString(5, bean.getCompany_Name()); pstmt.setString(6, bean.getDepartment_Name()); pstmt.setString(7, bean.getApplicant_Leaving_Date()); pstmt.setString(8, bean.getPlaned_Return_Time()); pstmt.setString(9, bean.getDestination()); pstmt.setString(10, bean.getUsing_Reason()); pstmt.setString(11, bean.getApplication_Time()); pstmt.setString(12, bean.getApprover_ID()); pstmt.setString(13, bean.getApprover_Name()); pstmt.setString(14, bean.getApprover_Time()); pstmt.setInt(15, bean.getApprover_Status()); if (pstmt.executeUpdate() > 0) { return true; } } catch (SQLException e) { e.printStackTrace(); } return false; } public boolean VehicleApplicantForm_Update(VehicleApplicantForm bean, Connection conn) { boolean flag = false; String sql = \

Applicant_Number=?,Applicant_Name=?,Telephone_Number=?,Division_Name=?,Company_Name=?,Department_Name=?,Applicant_Leaving_Date=?,Planed_Return_Time=?,Destination=?,Using_Reason=?,Application_Time=?,Approver_ID=?,Approver_Name=?,Approver_Time=?,Approver_Status=?,Comment_Info=?,status=? where id=?\ try { pstmt = conn.prepareStatement(sql); pstmt.setString(1, bean.getApplicant_Number()); pstmt.setString(2, bean.getApplicant_Name()); pstmt.setString(3, bean.getTelephone_Number()); pstmt.setString(4, bean.getDivision_Name()); pstmt.setString(5, bean.getCompany_Name()); pstmt.setString(6, bean.getDepartment_Name()); pstmt.setString(7, bean.getApplicant_Leaving_Date()); pstmt.setString(8, bean.getPlaned_Return_Time()); pstmt.setString(9, bean.getDestination()); pstmt.setString(10, bean.getUsing_Reason()); pstmt.setString(11, bean.getApplication_Time()); pstmt.setString(12, bean.getApprover_ID()); pstmt.setString(13, bean.getApprover_Name());

34