Competition getDataFromDatabase(String arg, Properties properties) {
Competition competition = new Competition();
String getAthleteDataQuery =
"SELECT athletes.name, athletes.dob, athletes.country_code, "
+ "results.race_100m, results.long_jump, results.shot_put, results.high_jump, results.race_400m, "
+ "results.hurdles_110m, results.discus_throw, results.pole_vault, results.javelin_throw, results.race_1500m "
+ "FROM athletes, results, competitions "
+ "WHERE athletes.id = results.athlete_id "
+ "AND results.competition_id = competitions.id "
+ "AND (competitions.id = ? OR competitions.name = ?)";
Connection conn = null;
try {
String url = properties.getProperty("db.url");
String username = properties.getProperty("db.username");
String password = properties.getProperty("db.password");
conn = DriverManager.getConnection(url, username, password);
PreparedStatement athleteDataQuery = conn.prepareStatement(getAthleteDataQuery);
athleteDataQuery.setString(1, arg);
athleteDataQuery.setString(2, arg);
ResultSet resultSet = athleteDataQuery.executeQuery();
while (resultSet.next()) {
Athlete athlete = parseAthlete(resultSet);
if (athlete == null) {
System.out.println(Error.ERROR_DB_ATHLETE_PARSING_FAILED.getErrorText());
continue;
}
DecathlonEvents decathlonEvents = parseDecathlonEvents(resultSet);
if (decathlonEvents == null) {
System.out.println(Error.ERROR_DB_ATHLETE_RESULTS_PARSING_FAILED.getErrorText());
continue;
}
athlete.setDecathlonEvent(decathlonEvents);
competition.addAthlete(athlete);
}
} catch (SQLException e) {
System.out.println(Error.ERROR_DB_CONNECTION.getErrorText());
} finally {
if (conn != null)
try {
conn.close();
} catch (SQLException e) {
System.out.println(Error.ERROR_DB_CLOSE.getErrorText());
}
}
return competition;
}
private Athlete parseAthlete(ResultSet athleteSet) throws SQLException {
SimpleDateFormat dateFormat = (SimpleDateFormat) DateFormat.getDateInstance(DateFormat.MEDIUM);
Athlete athlete = new Athlete();
athlete.setName(athleteSet.getString("name"));
try {
Date date = new SimpleDateFormat("yyyy-MM-dd").parse(athleteSet.getString("dob"));
athlete.setBirthday(dateFormat.format(date));
} catch (ParseException e) {
return null;
}
athlete.setCountry(athleteSet.getString("country_code"));
return athlete;
}
/**
* Get the place of an athlete in the competition according to total score
*
* @param athlete athlete
* @return the place of the athlete in the competition according to total score. If the athlete
* shares a place with one or more athletes (their total score is equal), the place is output
* as 2-4
*/
public String getAthletePlace(Athlete athlete) {
int minPlace = findMinimumPlace(athlete.getAthleteEvents().getTotalPoints());
int maxPlace = findMaximumPlace(athlete.getAthleteEvents().getTotalPoints());
if (minPlace == maxPlace) return String.valueOf(minPlace);
else return String.valueOf(minPlace) + "-" + String.valueOf(maxPlace);
}