# LotFutureReassignMapper.java

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

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.wip.LotFutureReassign;

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

    public class LotFutureReassignMapper implements RowMapper<LotFutureReassign> {

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

            lotFutureReassign.setTransRrn(rs.getLong("TRANS_RRN"));
            lotFutureReassign.setTransSequence(rs.getInt("TRANS_SEQUENCE"));
            lotFutureReassign.setTransTimestamp(rs.getTimestamp("TRANS_TIMESTAMP"));

            lotFutureReassign.setLotRrn(rs.getLong("LOT_RRN"));
            lotFutureReassign.setStepSequence(rs.getLong("STEP_SEQUENCE"));
            lotFutureReassign.setFacilityRrn(rs.getLong("FACILITY_RRN"));
            lotFutureReassign.setProductRrn(rs.getLong("PRODUCT_RRN"));
            lotFutureReassign.setProcessRrn(rs.getLong("PROCESS_RRN"));
            lotFutureReassign.setProcessVersion(rs.getInt("PROCESS_VERSION"));
            lotFutureReassign.setWflStepPath(rs.getString("WFL_STEP_PATH"));

            lotFutureReassign.setReasonCategory(rs.getString("REASON_CATEGORY"));
            lotFutureReassign.setReasonCode(rs.getString("REASON_CODE"));
            lotFutureReassign.setReason(rs.getString("REASON"));
            lotFutureReassign.setResponsibility(rs.getString("RESPONSIBILITY"));
            lotFutureReassign.setDeleteFutureActionFlag(rs.getString("DELETE_FUTURE_ACTION_FLAG"));
            lotFutureReassign.setReassignType(rs.getString("REASSIGN_TYPE"));
            lotFutureReassign.setCurWflStepPath(rs.getString("CURRENT_WFL_STEP_PATH"));
            lotFutureReassign.setProductVersion(rs.getInt("PRODUCT_VERSION"));

            return lotFutureReassign;
        }

    }