# PodMapper.java

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

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.ems.POD;

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

    public class PodMapper implements RowMapper<POD> {

        @Override
        public POD mapRow(ResultSet rs, int rowNum) throws SQLException {
            POD pod = new POD();
            // construct the value object
            pod.setInstanceRrn(rs.getLong("instance_rrn"));
            pod.setInstanceId(rs.getString("instance_id"));
            pod.setInstanceDesc(rs.getString("instance_desc"));
            pod.setPodStatus(rs.getString("current_status"));
            pod.setPodPollutionLevel(rs.getString("pollution_level"));
            pod.setCarrierCode(rs.getString("pod_code"));
            pod.setAllowableEventsId(rs.getString("allowable_events_id"));
            pod.setObjectSubtype(rs.getString("pod_type"));
            pod.setMaintenanceEngineerId(rs.getString("engineer_group_id"));
            pod.setNamedSpace(rs.getString("named_space"));
            pod.setObject(rs.getString("object"));
            pod.setObjectType(rs.getString("object_type"));
            pod.setMcsMoveStatus(rs.getString("mcs_move_status"));
            pod.setMcsLastMoveTime(rs.getTimestamp("mcs_last_move_time"));
            pod.setMcsLastOperatorRrn(new Long(rs.getLong("mcs_last_operator_rrn")));
            pod.setEqptRrn(new Long(rs.getLong("eqpt_rrn")));
            pod.setJobRrn(new Long(rs.getLong("job_rrn")));
            pod.setRunRrn(new Long(rs.getLong("run_rrn")));
            pod.setCarrierMapRrn(new Long(rs.getLong("pod_map_rrn")));
            pod.setLoadPosition(new Short(rs.getShort("load_position")));
            pod.setFlagType(rs.getString("flag_type"));
            return pod;
        }

    }