# ErpWorkOrderRowMapper.java

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

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

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

    public class ErpWorkOrderRowMapper implements RowMapper<ErpWorkOrderDto> {

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

            erpWorkOrderDto.setMandt(rs.getString("MANDT"));
            erpWorkOrderDto.setWerks(rs.getString("WERKS"));
            erpWorkOrderDto.setAufnr(rs.getString("AUFNR"));
            erpWorkOrderDto.setPlnbez(rs.getString("PLNBEZ"));
            erpWorkOrderDto.setAuart(rs.getString("AUART"));
            erpWorkOrderDto.setMtart(rs.getString("MTART"));
            erpWorkOrderDto.setGamng(rs.getInt("GAMNG"));
            erpWorkOrderDto.setGmein(rs.getString("GMEIN"));
            erpWorkOrderDto.setGstrp(rs.getString("GSTRP"));
            erpWorkOrderDto.setGltrp(rs.getString("GLTRP"));
            erpWorkOrderDto.setEtdat(rs.getString("ETDAT"));
            erpWorkOrderDto.setZdieit(rs.getString("ZDIEIT"));
            erpWorkOrderDto.setLoekz(rs.getString("LOEKZ"));
            erpWorkOrderDto.setKdauf(rs.getString("KDAUF"));
            erpWorkOrderDto.setKdpos(rs.getString("KDPOS"));
            erpWorkOrderDto.setStatus(rs.getString("STATUS"));
            erpWorkOrderDto.setErdat(rs.getString("ERDAT"));
            erpWorkOrderDto.setErzet(rs.getString("ERZET"));

            return erpWorkOrderDto;
        }

    }