# EquipmentChartInfoRowMapper.java

    package com.mycim.server.edcchart.dao.mapper;

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.edcspc.EquipmentChartInfo;

    import java.sql.ResultSet;
    import java.sql.SQLException;

    /**
     * @author yanbing.chen
     * @version 6.0.0
     * @date 2019/12/13
     **/
    public class EquipmentChartInfoRowMapper implements RowMapper<EquipmentChartInfo> {

        private EquipmentChartInfo equipmentChartInfo;

        @Override
        public EquipmentChartInfo mapRow(ResultSet rs, int rowNum) throws SQLException {
            equipmentChartInfo = new EquipmentChartInfo();

            equipmentChartInfo.setEquipmentRrn(rs.getLong("EQUIPMENT_RRN"));
            equipmentChartInfo.setChartId(rs.getString("CHART_ID"));

            equipmentChartInfo.setFacilityRrn(rs.getLong("FACILITY_RRN"));
            equipmentChartInfo.setEquipmentId(rs.getString("EQUIPMENT_ID"));
            equipmentChartInfo.setChartName(rs.getString("CHART_NAME"));
            equipmentChartInfo.setAreaId(rs.getString("AREA_ID"));

            equipmentChartInfo.setDeriveChartName(rs.getString("DERIVE_CHART_NAME"));
            equipmentChartInfo.setUserName(rs.getString("USER_NAME"));
            equipmentChartInfo.setRecipeList(rs.getString("RECIPE_LIST"));
            equipmentChartInfo.setProdList(rs.getString("PROD_LIST"));
            equipmentChartInfo.setTimeInterval(rs.getFloat("TIME_INTERVAL"));
            equipmentChartInfo.setWarningTime(rs.getFloat("WARNING_TIME"));
            equipmentChartInfo.setFormula(rs.getString("FORMULA"));

            equipmentChartInfo.setLastUploadTimestamp(rs.getTimestamp("LAST_UPLOAD_TIMESTAMP"));
            equipmentChartInfo.setExpiredTimestamp(rs.getTimestamp("EXPIRED_TIMESTAMP"));
            equipmentChartInfo.setMailSendTimestamp(rs.getTimestamp("MAIL_SEND_TIMESTAMP"));

            return equipmentChartInfo;
        }

    }