내용 |
package kr.co.javaspecialist.employees.model;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.stereotype.Repository;
@Repository
public class EmpRepository implements IEmpRepository {
@Autowired
JdbcTemplate jdbcTemplate;
private class EmpRowMapper implements RowMapper<EmpVO> {
public EmpVO mapRow(ResultSet rs, int count) throws SQLException {
EmpVO emp = new EmpVO();
emp.setEmployeeId(rs.getInt("employee_id"));
emp.setFirstName(rs.getString("first_name"));
emp.setLastName(rs.getString("last_name"));
emp.setEmail(rs.getString("email"));
emp.setPhoneNumber(rs.getString("phone_number"));
emp.setHireDate(rs.getDate("hire_date"));
emp.setJobId(rs.getString("job_id"));
emp.setSalary(rs.getDouble("salary"));
emp.setCommissionPct(rs.getDouble("commission_pct"));
emp.setManagerId(rs.getInt("manager_id"));
emp.setDepartmentId(rs.getInt("department_id"));
return emp;
}
}
public List<EmpVO> getEmpList() {
String sql = "select * from employees";
return jdbcTemplate.query(sql, new EmpRowMapper());
}
public EmpVO getEmpDetails(int employeeId){
String sql = "SELECT * FROM EMPLOYEES WHERE EMPLOYEE_ID=?";
return jdbcTemplate.queryForObject(sql, new EmpRowMapper(), employeeId);
}
}
|