0

I was making this little app to practice SpringMVC, but I am keep getting this error. I wanted to see if anybody can point out where I am doing wrong. I see this error is coming from EmployeeDao.jsp, but I coudn't figure out what I am doing wrong, or what causes this error. I appreciate any suggestion. <code>enter image description here</code>

home.jsp

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ page session="false" %>
<html>
<head>
    <title>Home of XYZ Inc.</title>
</head>
<body>
<h1>
    Welcome to my XYZ Inc company. 
</h1>

<P> <a href="viewEmployee">View All Employee</a> </P>


</body>
</html>

EmployeeDao.java

public List<Employee> getAllEmployee(){
    List<Employee> employees;
    employees = new ArrayList<Employee>(); 
    try {
        Statement statement;
        statement = connection.createStatement();

        ResultSet rset = statement.executeQuery("select * from Employees");
        while(rset.next()) {
            Employee employee = new Employee();
            employee.setEmployeeId(rset.getInt("employeeId"));
            employee.setName(rset.getString("name"));
            employee.setTittle(rset.getString("tittle"));
            employee.setHourlyWage(rset.getString("hourlyWage"));
            employee.setTotalHour(rset.getString("totalHour"));
            employees.add(employee);
        }

    }catch(SQLException e) {
        e.printStackTrace();

    }
    return employees;
}

HomeController.java

@RequestMapping("/viewEmployee")
public ModelAndView viewEmployee() {
    List<Employee> list = dao.getAllEmployee();
    return new ModelAndView("viewEmployee", "list", list);
}
Rookie_Guy
  • 82
  • 1
  • 2
  • 10

0 Answers0