@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());
}
