# ErpShipLotRowMapper.java

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

    import com.mycim.framework.jdbc.mapper.RowMapper;
    import com.mycim.server.erp.dto.ErpShipLotDto;

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

    public class ErpShipLotRowMapper implements RowMapper<ErpShipLotDto> {

        @Override
        public ErpShipLotDto mapRow(ResultSet rs, int rowNum) throws SQLException {
            ErpShipLotDto erpShipLotDto = new ErpShipLotDto();
            erpShipLotDto.setMandt(rs.getString("MANDT"));
            erpShipLotDto.setPlant(rs.getString("PLANT"));
            erpShipLotDto.setOrderId(rs.getString("ORDERID"));
            erpShipLotDto.setMoveType(rs.getString("MOVE_TYPE"));
            erpShipLotDto.setMaterial(rs.getString("MATERIAL"));
            erpShipLotDto.setBatch(rs.getString("BATCH"));
            erpShipLotDto.setEntryQnt(rs.getInt("ENTRY_QNT"));
            erpShipLotDto.setEntryUom(rs.getString("ENTRY_UOM"));
            erpShipLotDto.setYeild(rs.getDouble("YEILD"));
            erpShipLotDto.setLpcUom(rs.getInt("LPC_UOM"));
            erpShipLotDto.setHsdat(rs.getString("HSDAT"));
            erpShipLotDto.setLwedt(rs.getString("LWEDT"));
            erpShipLotDto.setVfdat(rs.getString("VFDAT"));
            erpShipLotDto.setStatus(rs.getString("STATUS"));
            erpShipLotDto.setErdat(rs.getString("ERDAT"));
            erpShipLotDto.setErzet(rs.getString("ERZET"));

            return erpShipLotDto;
        }

    }