# ProductAttributeInfoMapper.java

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

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

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

    public class ProductAttributeInfoMapper implements RowMapper<ProductAttributeInfo> {

        private ProductAttributeInfo prodAttribute;

        @Override
        public ProductAttributeInfo mapRow(ResultSet rs, int rowNum) throws SQLException {

            prodAttribute = new ProductAttributeInfo();

            prodAttribute.setProductId(rs.getString("product_id"));
            prodAttribute.setProductRrn(rs.getLong("PRODUCT_RRN"));
            prodAttribute.setProductVersion(rs.getInt("PRODUCT_VERSION"));
            prodAttribute.setProcessRrn(rs.getLong("PROCESS_RRN"));
            prodAttribute.setProcessId(rs.getString("PROCESS_ID"));
            prodAttribute.setProcessVersion(rs.getInt("PROCESS_VERSION"));

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

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

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

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

            return prodAttribute;

        }

    }