# ProcessSpecInfoRowMapper.java

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

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.valueobject.prp.ProcessSpecInfo;

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

    /**
     * @author Qiansheng.Wang
     * @since 2020-09-08
     */
    public class ProcessSpecInfoRowMapper implements RowMapper<ProcessSpecInfo> {

        private ProcessSpecInfo processSpecInfo;

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

            processSpecInfo.setProcessRrn(rs.getLong("PROCESS_RRN"));
            processSpecInfo.setProcessId(rs.getString("PROCESS_ID"));
            processSpecInfo.setProcessVersion(rs.getInt("PROCESS_VERSION"));

            processSpecInfo.setActiveFlag(rs.getBoolean("ACTIVE_FLAG"));
            processSpecInfo.setActiveTime(rs.getTimestamp("ACTIVE_TIME"));
            processSpecInfo.setActiveUser(rs.getString("ACTIVE_USER"));

            processSpecInfo.setCurrentStatus(rs.getString("CURRENT_STATUS"));

            processSpecInfo.setLastUpdatedUser(rs.getString("LAST_UPDATED_USER"));
            processSpecInfo.setLastUpdatedTime(rs.getTimestamp("LAST_UPDATED_TIME"));

            processSpecInfo.setCreateUserId(rs.getString("CREATE_USER_ID"));
            processSpecInfo.setCreateTime(rs.getTimestamp("CREATE_TIME"));

            processSpecInfo.setVersionLastUpdateTime(rs.getTimestamp("VERSION_LAST_UPDATED_TIME"));

            return processSpecInfo;
        }

    }