# ElogSheetMapper.java

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

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

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

    /**
     * @author finatice.yang
     * @date 2021/7/20
     **/
    public class ElogSheetMapper implements RowMapper<ElogSheet> {

        @Override
        public ElogSheet mapRow(ResultSet rs, int rowNum) throws SQLException {
            ElogSheet elogSheet = new ElogSheet();
            elogSheet.setElogSheetRrn(rs.getLong("elog_sheet_rrn"));
            elogSheet.setEquipmentId(rs.getString("equipment_id"));
            elogSheet.setEquipmentRrn(rs.getLong("equipment_rrn"));
            elogSheet.setEquipmentGroupId(rs.getString("equipment_group_id"));
            elogSheet.setChamberType(rs.getString("chamber_type"));
            elogSheet.setLotId(rs.getString("lot_id"));
            elogSheet.setLotRrn(rs.getLong("lot_rrn"));
            elogSheet.setStepSequence(rs.getLong("step_sequence"));
            elogSheet.setLotType(rs.getString("lot_type"));
            elogSheet.setQty(rs.getInt("qty"));
            elogSheet.setChamberQty(rs.getInt("chamber_qty"));
            elogSheet.setBatchId(rs.getString("batch_id"));
            elogSheet.setRecipeId(rs.getString("recipe_id"));
            elogSheet.setRecipePhysicalId(rs.getString("RECIPE_PHYSICAL_ID"));
            elogSheet.setHotFlag(rs.getString("hot_flag"));
            elogSheet.setPriority(rs.getInt("priority"));
            elogSheet.setCarrierId(rs.getString("carrier_id"));
            elogSheet.setProductId(rs.getString("product_id"));
            elogSheet.setProductVersion(rs.getInt("product_version"));
            elogSheet.setProcessId(rs.getString("process_id"));
            elogSheet.setProcessVersion(rs.getInt("process_version"));
            elogSheet.setRouteId(rs.getString("route_id"));
            elogSheet.setOperationId(rs.getString("step_id"));
            elogSheet.setFlowSeq(rs.getString("flow_seq"));
            elogSheet.setReticleGroupId(rs.getString("reticle_group_id"));
            elogSheet.setReticleId(rs.getString("reticle_id"));
            elogSheet.setProcessLocation(rs.getString("process_location"));
            elogSheet.setStageId(rs.getString("stage_id"));
            elogSheet.setPollutionLevel(rs.getString("pollution_level"));
            elogSheet.setCustomerId(rs.getString("customer_id"));
            elogSheet.setWorkArea(rs.getString("workarea"));
            elogSheet.setProcessStartUserId(rs.getString("process_start_user_id"));
            elogSheet.setProcessStartTime(rs.getTimestamp("process_start_time"));
            elogSheet.setProcessEndUserId(rs.getString("process_end_user_id"));
            elogSheet.setProcessEndTime(rs.getTimestamp("process_end_time"));
            return elogSheet;
        }

    }