| | |
| | | |
| | | public class DrugLogRowMapper implements RowMapper<DrugLog> { |
| | | |
| | | @Override |
| | | public DrugLog mapRow(ResultSet rs, int index) throws SQLException { |
| | | DrugLog data = new DrugLog(); |
| | | data.setId(rs.getString("ID_")); |
| | | data.setCompanyId(rs.getString("COMPANY_ID_")); |
| | | data.setDeptId(rs.getString("DEPT_ID_")); |
| | | data.setDepotId(rs.getString("DEPOT_ID_")); |
| | | data.setEnd(rs.getTimestamp("END_")); |
| | | data.setStart(rs.getTimestamp("START_")); |
| | | |
| | | data.setPestBatchId(rs.getString("PEST_BATCH_ID_")); |
| | | data.setNum(rs.getInt("NUM_")); |
| | | data.setMode(rs.getString("MODE_")); |
| | | data.setRecirMode(rs.getString("RECIR_MODE_")); |
| | | data.setDrugName(rs.getString("DRUG_NAME_")); |
| | | data.setConcentration(rs.getDouble("CONCENTRATION_")); |
| | | data.setGrainDose(rs.getDouble("GRAIN_DOSE_")); |
| | | |
| | | data.setSpaceDose(rs.getDouble("SPACE_DOSE_")); |
| | | data.setDose(rs.getDouble("DOSE_")); |
| | | data.setVentilateMethod(rs.getString("VENTILATE_METHOD_")); |
| | | data.setVentilateTime(rs.getDate("VENTILATE_TIME_")); |
| | | data.setAfterPh3(rs.getDouble("AFTER_PH3_")); |
| | | data.setEvaluate(rs.getString("EVALUATE_")); |
| | | data.setCzsjff(rs.getString("CZSJFF_")); |
| | | data.setCzclcs(rs.getString("CZCLCS_")); |
| | | |
| | | data.setRemarks(rs.getString("REMARKS_")); |
| | | data.setUpdateTime(rs.getTimestamp("UPDATE_TIME_")); |
| | | data.setUpdateUser(rs.getString("UPDATE_USER_")); |
| | | @Override |
| | | public DrugLog mapRow(ResultSet rs, int index) throws SQLException { |
| | | DrugLog data = new DrugLog(); |
| | | data.setId(rs.getString("ID_")); |
| | | data.setCompanyId(rs.getString("COMPANY_ID_")); |
| | | data.setDeptId(rs.getString("DEPT_ID_")); |
| | | data.setDepotId(rs.getString("DEPOT_ID_")); |
| | | data.setEnd(rs.getTimestamp("END_")); |
| | | data.setStart(rs.getTimestamp("START_")); |
| | | |
| | | data.setUser(rs.getString("USER_")); |
| | | return data; |
| | | } |
| | | data.setPestBatchId(rs.getString("PEST_BATCH_ID_")); |
| | | data.setNum(rs.getInt("NUM_")); |
| | | data.setMode(rs.getString("MODE_")); |
| | | data.setRecirMode(rs.getString("RECIR_MODE_")); |
| | | data.setDrugName(rs.getString("DRUG_NAME_")); |
| | | data.setConcentration(rs.getDouble("CONCENTRATION_")); |
| | | data.setGrainDose(rs.getDouble("GRAIN_DOSE_")); |
| | | |
| | | data.setSpaceDose(rs.getDouble("SPACE_DOSE_")); |
| | | data.setDose(rs.getDouble("DOSE_")); |
| | | data.setVentilateMethod(rs.getString("VENTILATE_METHOD_")); |
| | | data.setVentilateTime(rs.getDate("VENTILATE_TIME_")); |
| | | data.setAfterPh3(rs.getDouble("AFTER_PH3_")); |
| | | data.setEvaluate(rs.getString("EVALUATE_")); |
| | | data.setCzsjff(rs.getString("CZSJFF_")); |
| | | data.setCzclcs(rs.getString("CZCLCS_")); |
| | | |
| | | data.setRemarks(rs.getString("REMARKS_")); |
| | | data.setUpdateTime(rs.getTimestamp("UPDATE_TIME_")); |
| | | data.setUpdateUser(rs.getString("UPDATE_USER_")); |
| | | |
| | | data.setUser(rs.getString("USER_")); |
| | | return data; |
| | | } |
| | | |
| | | } |