edu.pitt.sis.infsci2730.finalProject.utils.RecordRowMapper.java Source code

Introduction

Here is the source code for edu.pitt.sis.infsci2730.finalProject.utils.RecordRowMapper.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package edu.pitt.sis.infsci2730.finalProject.utils;

import edu.pitt.sis.infsci2730.finalProject.model.RecordDBModel;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;

/**
 *
 * @author yanyanzhou
 */
public class RecordRowMapper implements RowMapper<RecordDBModel> {

    public RecordDBModel mapRow(ResultSet rs, int index) throws SQLException {
        RecordDBModel record = new RecordDBModel();

        record.setTransaction_id(rs.getInt("TRANSACTION_ID"));
        record.setProduct_id(rs.getInt("PRODUCT_ID"));
        record.setAmount(rs.getInt("AMOUNT"));
        record.setPrice(rs.getInt("PRICE"));

        return record;
    }
}