public Student getStudent(int id) {
StudentDataHandler dataHandler = new StudentDataHandler();
ResultSet resultSet = dataHandler.getStudent(id);
StudentDirector director = new StudentDirector();
try {
return director.createBVStudent(resultSet);
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public int createStudent(MultivaluedMap<String, String> formParams) {
StudentDirector director = new StudentDirector();
Student student = director.createStudent(formParams);
StudentDataHandler dataHandler = new StudentDataHandler();
if (student instanceof BVStudent) {
return dataHandler.createBVStudent((BVStudent) student);
} else {
// TODO create private student (out of scope)
return 0;
}
}
public ArrayList<CourseInstance> getCourseInstances(int id) {
ArrayList<CourseInstance> instances = new ArrayList<CourseInstance>();
StudentDataHandler dataHandler = new StudentDataHandler();
ResultSet resultSet = dataHandler.getCourseInstances(id);
try {
while (resultSet.next()) {
Course course = new Course(resultSet.getString("CODE"), resultSet.getString("TITLE"));
CourseInstance instance =
new CourseInstance(
resultSet.getInt("COURSE_INSTANCEID"),
course,
resultSet.getDate("START_DATE"),
resultSet.getInt("DURATION"),
resultSet.getInt("PRICE"));
instances.add(instance);
}
return instances;
} catch (SQLException e) {
e.printStackTrace();
return null;
}
}
public boolean studentExists(Student student) {
StudentDataHandler dataHandler = new StudentDataHandler();
return dataHandler.studentExists(student);
}