First Commit

Change-Id: I12c22813e8807ad664983d0232bedb5f7651c82e
Signed-off-by: I327101 <aparna.i@sap.com>
diff --git a/src/main/java/com/example/utils/EmployeeRowMapper.java b/src/main/java/com/example/utils/EmployeeRowMapper.java
new file mode 100644
index 0000000..1d413e3
--- /dev/null
+++ b/src/main/java/com/example/utils/EmployeeRowMapper.java
@@ -0,0 +1,27 @@
+package com.example.utils;

+

+import java.sql.ResultSet;

+import java.sql.SQLException;

+

+import org.springframework.jdbc.core.RowMapper;

+import org.springframework.stereotype.Component;

+

+import com.example.model.Employee;

+

+/**

+ * This defines a RowMapper for Employee class RowMapper maps a row of the table

+ * Employee to an object Employee and returns the object

+ */                                                                

+

+@Component

+public class EmployeeRowMapper implements RowMapper<Employee> {

+

+	@Override

+	public Employee mapRow(ResultSet rs, int rowNum) throws SQLException {

+		Employee employee = new Employee();

+		employee.setName(rs.getString("name"));

+		employee.setId(rs.getString("id"));

+		employee.setPosition(rs.getString("position"));

+		return employee;

+	}

+}