Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class EmployeeDAO{
- public List<Map<String,Object>> viewEmployees() {
- JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
- //This is where i make the sql-statement
- List<Map<String, Object>> rows = jdbcTemplate.queryForList("SELECT * FROM employee");
- //here I want to return an List<Map<String,Object>> of rows
- return rows;
- }
- }
- public List viewEmployees(){List<Employee> employees = new ArrayList<>();
- EmployeeDAO employeeDAO = new EmployeeDAO();
- List<Map<String, Object>> rows = employeeDAO.viewEmployees();
- //For loop of rows (Employees)
- for (Map row : rows) {
- Employee employee = new Employee();
- employee.setId((int) (row.get("id")));
- employee.setName((String) (row.get("name")));
- employee.setPosition((String) (row.get("position")));
- employee.setProvision_goal((int) (row.get("provision_goal")));
- employee.setProvision_accumulated((int) (row.get("provision_accumulated")));
- employees.add(employee);
- }
- return employees;
- }
- java.lang.IllegalArgumentException: Property 'dataSource' is required
- at org.springframework.jdbc.support.JdbcAccessor.afterPropertiesSet(JdbcAccessor.java:160) ~[spring-jdbc-5.0.5.RELEASE.jar:5.0.5.RELEASE]
- at org.springframework.jdbc.core.JdbcTemplate.<init>(JdbcTemplate.java:166) ~[spring-jdbc-5.0.5.RELEASE.jar:5.0.5.RELEASE]
- at com.example.demo.dao.EmployeeDAO.viewEmployees(EmployeeDAO.java:37) ~[classes/:na]
- at com.example.demo.services.EmployeeServiceImpl.viewEmployees(EmployeeServiceImpl.java:61) ~[classes/:na]
- at com.example.demo.controller.HomeController.home(HomeController.java:37) ~[classes/:na]
Add Comment
Please, Sign In to add comment