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

Introduction

Here is the source code for edu.pitt.sis.infsci2730.finalProject.utils.EmployeeRowMapper.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.EmployeeDBModel;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.springframework.jdbc.core.RowMapper;

/**
 *
 * @author yanyanzhou
 */
public class EmployeeRowMapper implements RowMapper<EmployeeDBModel> {

    public EmployeeDBModel mapRow(ResultSet rs, int index) throws SQLException {
        EmployeeDBModel employee = new EmployeeDBModel();

        employee.setEmployee_id(rs.getInt("employee_id"));
        employee.setEmployee_name(rs.getString("employee_name"));
        employee.setAddress_id(rs.getInt("address_id"));
        employee.setStore_id(rs.getInt("store_id"));
        employee.setSalary(rs.getString("salary"));
        employee.setJobtitle(rs.getString("JOBTITLE"));

        return employee;
    }
}