# LotMonitorJobStoreMapper.java

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

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.automonitor.entity.LotMonitorJobStore;

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

    public class LotMonitorJobStoreMapper implements RowMapper<LotMonitorJobStore> {

        LotMonitorJobStore store;

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

            store.setLotId(rs.getString("LOT_ID"));
            store.setLotRrn(rs.getLong("LOT_RRN"));
            store.setBaseLotRrn(rs.getLong("BASE_LOT_RRN"));
            store.setBaseLotId(rs.getString("BASE_LOT_ID"));
            store.setEqptId(rs.getString("EQUIPMENT_ID"));
            store.setEqptRrn(rs.getLong("EQUIPMENT_RRN"));
            store.setItemType(rs.getString("ITEM_TYPE"));
            store.setProcessId(rs.getString("PROCESS_ID"));
            store.setProcessRrn(rs.getLong("PROCESS_RRN"));
            store.setProcessVersion(rs.getLong("PROCESS_VERSION"));
            store.setJobStatus(rs.getString("JOB_STATUS"));
            store.setWorkflowRrn(rs.getLong("WORKFLOW_RRN"));
            store.setWorkflowVersion(rs.getInt("WORKFLOW_VERSION"));
            store.setWflStep(rs.getString("WFL_STEP"));
            store.setCarrierRrn(rs.getLong("CARRIER_RRN"));
            store.setCarrierId(rs.getString("CARRIER_ID"));
            store.setMonitorCarrierRrn(rs.getLong("MONITOR_CARRIER_RRN"));
            store.setMonitorCarrierId(rs.getString("MONITOR_CARRIER_ID"));
            store.setQty(rs.getLong("QTY1"));
            store.setProductRrn(rs.getLong("PRODUCT_RRN"));
            store.setProductId(rs.getString("PRODUCT_ID"));
            store.setMergeWflStep(rs.getString("MERGE_WFL_STEP"));
            return store;
        }

    }