# ElogSubSheetMapper.java

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

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

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

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

        @Override
        public ElogSubSheet mapRow(ResultSet rs, int rowNum) throws SQLException {
            ElogSubSheet subSheet = new ElogSubSheet();
            subSheet.setElogSubSheetRrn(rs.getLong("elog_sub_sheet_rrn"));
            subSheet.setElogSheetRrn(rs.getLong("elog_sheet_rrn"));
            subSheet.setEquipmentId(rs.getString("equipment_id"));
            subSheet.setEquipmentRrn(rs.getLong("equipment_rrn"));
            subSheet.setChamberType(rs.getString("chamber_type"));
            subSheet.setChamberFlow(rs.getString("chamber_flow"));
            subSheet.setLotRrn(rs.getLong("lot_rrn"));
            subSheet.setLotId(rs.getString("lot_id"));
            subSheet.setStepSequence(rs.getLong("step_sequence"));
            subSheet.setSlot(rs.getInt("slot"));
            subSheet.setBatchId(rs.getString("batch_id"));
            subSheet.setRecipeId(rs.getString("recipe_id"));
            subSheet.setRecipePhysicalId(rs.getString("RECIPE_PHYSICAL_ID"));
            subSheet.setUnitId(rs.getString("unit_id"));
            subSheet.setUnitQty(rs.getInt("unit_qty"));
            subSheet.setCarrierId(rs.getString("carrier_id"));
            subSheet.setProcessStartUserId(rs.getString("process_start_user_id"));
            subSheet.setProcessStartTime(rs.getTimestamp("process_start_time"));
            subSheet.setProcessEndUserId(rs.getString("process_end_user_id"));
            subSheet.setProcessEndTime(rs.getTimestamp("process_end_time"));

            return subSheet;
        }

    }