| | |
| | | //数据同步 |
| | | String s1 = |
| | | "insert into sys_car(id,car_number,number_type,car_type,dept_id," + |
| | | "person_in_charge,brand,date_for_production,umweltsatz,mode,jurisdiction) " + |
| | | "person_in_charge,brand,date_for_production,umweltsatz,mode,jurisdiction,picture,driving_conditions) " + |
| | | "values(" + "'" + car.getId() + "'" + "," + |
| | | "'" + car.getCarNumber() + "'" + "," + |
| | | "'" + car.getNumberType() + "'" + "," + |
| | |
| | | "'" + new SimpleDateFormat("yyyy-MM-dd").format(car.getDateForProduction()) + "'" + "," + |
| | | "'" + car.getUmweltsatz() + "'" + "," + |
| | | "'" + car.getMode() + "'" + "," + |
| | | "'" +car.getJurisdiction() + "'" + ")"; |
| | | "'" + car.getJurisdiction() + "'" + "," + |
| | | "'" + car.getPicture() + "'" + "," + |
| | | "'" +car.getDrivingConditions() + "'" + ")"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | }else { |
| | | //修改 |
| | |
| | | ",umweltsatz = " + "'" + car.getUmweltsatz() + "'" + |
| | | ",mode = " + "'" + car.getMode() + "'" + |
| | | ",jurisdiction = " + "'" + car.getJurisdiction() + "'" + |
| | | ",picture = " + "'" + car.getPicture() + "'" + |
| | | ",driving_conditions = " + "'" + car.getDrivingConditions() + "'" + |
| | | " " +"where id = " + "'" + car.getId() + "'"; |
| | | FtpUtil.sqlFileUpload(s1); |
| | | } |