# AutoMonitorItemMapper.java

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

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

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

    public class AutoMonitorItemMapper implements RowMapper<AutoMonitorItem> {

        AutoMonitorItem item;

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

            item.setWorkflowRrn(rs.getLong("workflow_rrn"));
            item.setWorkflowVersion(rs.getInt("workflow_version"));
            item.setWorkflowId(rs.getString("WORKFLOW_ID"));
            item.setEqptId(rs.getString("equipment_id"));
            item.setEqptRrn(rs.getLong("equipment_rrn"));
            item.setItemType(rs.getString("item_type"));
            item.setQty(rs.getLong("qty"));
            item.setProductId(rs.getString("product_id"));
            item.setProductRrn(rs.getLong("product_rrn"));
            item.setProcessId(rs.getString("process_id"));
            item.setProcessRrn(rs.getLong("process_rrn"));
            item.setMonitorCarrierFlag(rs.getBoolean("monitor_carrier_flag"));
            item.setMonitorCarrierType(rs.getString("monitor_carrier_type"));
            item.setCurrentVersion(rs.getInt("OBJ_CURRENT_VERSION"));
            item.setActiveVersion(rs.getInt("OBJ_ACTIVE_VERSION"));
            item.setSysInActiveFlag(rs.getBoolean("sys_inactive_flag"));
            item.setMainEqptType(rs.getString("MAIN_EQUIPMENT_TYPE"));
            item.setStartSplitFlag(rs.getBoolean("START_SPLIT_FLAG"));
            return item;
        }

    }