public Player nextPlayerResult() throws SQLException {
Player player = new Player();
player.setIdentifier(Integer.parseInt(resultSet.getString(Fields.IDENTIFIER.name())));
player.setFirstName(resultSet.getString(Fields.FIRSTNAME.name()));
player.setLastName(resultSet.getString(Fields.LASTNAME.name()));
player.setEmailAddress(resultSet.getString(Fields.EMAILADDRESS.name()));
player.setBirthdate(LocalDate.parse(resultSet.getString(Fields.BIRTHDATE.name())));
player.setGamerTag(resultSet.getString(Fields.GAMERTAG.name()));
return player;
}
public List<String> getGamertags() throws SQLException {
Connection connection;
Statement statement = null;
List<String> results = new ArrayList<String>();
try {
connection = database.getConnection();
statement = connection.createStatement();
// Execute a statement
String sqlString = String.format("SELECT %s FROM %s", Fields.GAMERTAG, tableName);
resultSet = statement.executeQuery(sqlString);
while (resultSet.next()) {
results.add(resultSet.getString(Fields.GAMERTAG.name()));
}
} finally {
close(statement);
}
return results;
}
