package com.ld.igds.drug.service;
|
|
import java.sql.ResultSet;
|
import java.sql.SQLException;
|
|
import org.springframework.jdbc.core.RowMapper;
|
|
import com.ld.igds.models.DrugLog;
|
|
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_"));
|
|
data.setUser(rs.getString("USER_"));
|
return data;
|
}
|
|
}
|
