Guest User

Untitled

a guest
May 20th, 2018
119
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.77 KB | None | 0 0
  1. public class EmployeeDAO{
  2.  
  3. public List<Map<String,Object>> viewEmployees() {
  4.  
  5. JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
  6.  
  7. //This is where i make the sql-statement
  8. List<Map<String, Object>> rows = jdbcTemplate.queryForList("SELECT * FROM employee");
  9.  
  10. //here I want to return an List<Map<String,Object>> of rows
  11. return rows;
  12. }
  13. }
  14.  
  15. public List viewEmployees(){List<Employee> employees = new ArrayList<>();
  16. EmployeeDAO employeeDAO = new EmployeeDAO();
  17. List<Map<String, Object>> rows = employeeDAO.viewEmployees();
  18. //For loop of rows (Employees)
  19. for (Map row : rows) {
  20. Employee employee = new Employee();
  21. employee.setId((int) (row.get("id")));
  22. employee.setName((String) (row.get("name")));
  23. employee.setPosition((String) (row.get("position")));
  24. employee.setProvision_goal((int) (row.get("provision_goal")));
  25. employee.setProvision_accumulated((int) (row.get("provision_accumulated")));
  26. employees.add(employee);
  27. }
  28. return employees;
  29. }
  30.  
  31. java.lang.IllegalArgumentException: Property 'dataSource' is required
  32.  
  33. at org.springframework.jdbc.support.JdbcAccessor.afterPropertiesSet(JdbcAccessor.java:160) ~[spring-jdbc-5.0.5.RELEASE.jar:5.0.5.RELEASE]
  34. at org.springframework.jdbc.core.JdbcTemplate.<init>(JdbcTemplate.java:166) ~[spring-jdbc-5.0.5.RELEASE.jar:5.0.5.RELEASE]
  35. at com.example.demo.dao.EmployeeDAO.viewEmployees(EmployeeDAO.java:37) ~[classes/:na]
  36. at com.example.demo.services.EmployeeServiceImpl.viewEmployees(EmployeeServiceImpl.java:61) ~[classes/:na]
  37. at com.example.demo.controller.HomeController.home(HomeController.java:37) ~[classes/:na]
Add Comment
Please, Sign In to add comment