# LotRunCardReviewQueueRowMapper.java

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

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

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

    /**
     * @author pinyan.song
     * @version 6.0.0
     * @date 2019-12-25 14:19
     **/
    public class LotRunCardReviewQueueRowMapper implements RowMapper<LotRunCardReviewQueue> {

        LotRunCardReviewQueue lotRunCardReviewQueue;

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

            lotRunCardReviewQueue.setRunCardRrn(rs.getLong("RUN_CARD_RRN"));
            lotRunCardReviewQueue.setQueueSequence(rs.getInt("QUEUE_SEQUENCE"));

            lotRunCardReviewQueue.setUserRrn(rs.getLong("USER_RRN"));
            lotRunCardReviewQueue.setUserGroupRrn(rs.getLong("USER_GROUP_RRN"));

            lotRunCardReviewQueue.setReviewUserRrn(rs.getLong("REVIEW_USER_RRN"));
            lotRunCardReviewQueue.setReviewTimestamp(rs.getTimestamp("REVIEW_TIMESTAMP"));
            lotRunCardReviewQueue.setReviewResult(rs.getString("REVIEW_RESULT"));

            lotRunCardReviewQueue.setReviewRole(rs.getString("REVIEW_ROLE"));
            lotRunCardReviewQueue.setReviewComments(rs.getString("REVIEW_COMMENTS"));

            return lotRunCardReviewQueue;
        }

    }