# ErpMaterialRowMapper.java

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

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

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

    public class ErpMaterialRowMapper implements RowMapper<ErpMaterialDto> {

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

            erpMaterialDto.setMandt(rs.getString("MANDT"));
            erpMaterialDto.setPlant(rs.getString("PLANT"));
            erpMaterialDto.setMatnr(rs.getString("MATNR"));
            erpMaterialDto.setMeins(rs.getString("MEINS"));
            erpMaterialDto.setMtart(rs.getString("MTART"));
            erpMaterialDto.setMesMatnr(rs.getString("MES_MATNR"));
            erpMaterialDto.setLvorm(rs.getString("LVORM"));
            erpMaterialDto.setStatus(rs.getString("STATUS"));
            erpMaterialDto.setErsda(rs.getString("ERSDA"));
            erpMaterialDto.setLaeda(rs.getString("LAEDA"));
            erpMaterialDto.setErdat(rs.getString("ERDAT"));
            erpMaterialDto.setErzet(rs.getString("ERZET"));
            erpMaterialDto.setSemiFinish(rs.getString("ZSEMI"));

            return erpMaterialDto;
        }

    }