@Override public Department findDepartment(String departmentCode) throws SQLException { List<Department> list = DatabaseHelper.getResultList( FIND_ONE__DEPARTMENT_QUERY, new DepartmentMapper(), departmentCode); if (list != null && list.size() > 0) { return list.get(0); } return null; }
@Override public List<Department> findDepartments() throws SQLException { return DatabaseHelper.getResultList(FIND_ALL_DEPARTMENT_QUERY, new DepartmentMapper()); }