# ProcessSpecItemRowMapper.java

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

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

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

    public class ProcessSpecItemRowMapper implements RowMapper<ProcessSpecItem> {

        private ProcessSpecItem processSpecItem;

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

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

            processSpecItem.setRouteRrn(rs.getLong("ROUTE_RRN"));
            processSpecItem.setRouteId(rs.getString("ROUTE_ID"));
            processSpecItem.setRouteVersion(rs.getInt("ROUTE_VERSION"));
            processSpecItem.setRouteSeq(rs.getString("ROUTE_SEQ"));

            processSpecItem.setOperationRrn(rs.getLong("OPERATION_RRN"));
            processSpecItem.setOperationId(rs.getString("OPERATION_ID"));
            processSpecItem.setOperationDesc(rs.getString("OPERATION_DESC"));
            processSpecItem.setOperationType(rs.getString("OPERATION_TYPE"));
            processSpecItem.setOperationSeq(rs.getString("OPERATION_SEQ"));

            processSpecItem.setFlowSeq(rs.getString("FLOW_SEQ"));

            processSpecItem.setWorkArea(rs.getString("WORK_AREA"));
            processSpecItem.setStageId(rs.getString("STAGE_ID"));

            processSpecItem.setRecipeRrn(rs.getLong("RECIPE_RRN"));
            processSpecItem.setRecipeId(rs.getString("RECIPE_ID"));

            processSpecItem.setReticleFamilyRrn(rs.getLong("RETICLE_FAMILY_RRN"));
            processSpecItem.setReticleFamilyId(rs.getString("RETICLE_FAMILY_ID"));

            processSpecItem.setParameterSetRrn(rs.getLong("PARAMETER_SET_RRN"));
            processSpecItem.setParameterSetId(rs.getString("PARAMETER_SET_ID"));

            processSpecItem.setEquipmentGroupRrn(rs.getLong("EQUIPMENT_GROUP_RRN"));
            processSpecItem.setEquipmentGroupId(rs.getString("EQUIPMENT_GROUP_ID"));

            processSpecItem.setPollutionLevel(rs.getString("POLLUTION_LEVEL"));
            processSpecItem.setProcessLocation(rs.getString("PROCESS_LOCATION"));
            processSpecItem.setBankFlag(rs.getString("BANK_FLAG"));
            processSpecItem.setFlipType(rs.getString("FLIP_TYPE"));
            processSpecItem.setCpDefine(rs.getString("CP_DEFINE"));

            processSpecItem.setEcnRrn(rs.getLong("ECN_RRN"));
            processSpecItem.setStatus(rs.getString("STATUS"));
            processSpecItem.setEffectiveTime(rs.getTimestamp("EFFECTIVE_TIME"));
            processSpecItem.setTerminatedTime(rs.getTimestamp("TERMINATED_TIME"));
            processSpecItem.setCreatedUser(rs.getString("CREATED_USER"));
            processSpecItem.setCreatedTime(rs.getTimestamp("CREATED_TIME"));
            processSpecItem.setUpdatedUser(rs.getString("UPDATED_USER"));
            processSpecItem.setUpdatedTime(rs.getTimestamp("UPDATED_TIME"));
            processSpecItem.setVariableFlag(rs.getBoolean("VARIABLE_FLAG"));

            processSpecItem.setEquipmentGroupRrns(rs.getString("EQUIPMENT_GROUP_RRNS"));

            return processSpecItem;
        }

    }