# LotConsumesMaterialHistoryRowMapper.java

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

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

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

    public class LotConsumesMaterialHistoryRowMapper implements RowMapper<LotConsumesMaterialHistory> {

        private LotConsumesMaterialHistory lotConsumesMaterialHistory;

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

            lotConsumesMaterialHistory.setTransRrn(rs.getLong("TRANS_RRN"));
            lotConsumesMaterialHistory.setTransSequence(rs.getLong("TRANS_SEQUENCE"));

            lotConsumesMaterialHistory.setBorRrn(rs.getLong("BOR_RRN"));
            lotConsumesMaterialHistory.setBorVersion(rs.getInt("BOR_VERSION"));
            lotConsumesMaterialHistory.setBorResourceSeq(rs.getInt("BOR_RESOURCE_SEQ"));
            lotConsumesMaterialHistory.setBorLossType(rs.getString("BOR_LOSS_TYPE"));
            lotConsumesMaterialHistory.setBorBasisCode(rs.getString("BOR_BASIS_CODE"));

            lotConsumesMaterialHistory.setLotNumber(rs.getString("LOT_NUMBER"));
            lotConsumesMaterialHistory.setItemRrn(rs.getLong("ITEM_RRN"));
            lotConsumesMaterialHistory.setWarehouseRrn(rs.getLong("WAREHOUSE_RRN"));
            lotConsumesMaterialHistory.setMaterialType(rs.getString("MATERIAL_TYPE"));

            lotConsumesMaterialHistory.setRunRrn(rs.getLong("RUN_RRN"));
            lotConsumesMaterialHistory.setLotRrns(rs.getString("LOT_RRNS"));
            lotConsumesMaterialHistory.setLotIds(rs.getString("LOT_IDS"));

            lotConsumesMaterialHistory.setConsumptionQty(rs.getDouble("CONSUMPTION_QTY"));
            lotConsumesMaterialHistory.setConsumptionDate(rs.getTimestamp("CONSUMPTION_DATE"));
            lotConsumesMaterialHistory.setConsumptionUserId(rs.getString("CONSUMPRION_USER_ID"));

            return lotConsumesMaterialHistory;
        }

    }