public HashSet<Answer> readPerfectAnswersForDiagnosis(int diagnosisId) {
HashSet<Answer> answers = new HashSet<Answer>();
try {
establishConnection();
Statement stmt = connection.createStatement();
String SQL =
"SELECT answers.* FROM answers, perfect_diagnosis_diagnoses_to_answers WHERE perfect_diagnosis_diagnoses_to_answers.answer = answers.id AND perfect_diagnosis_diagnoses_to_answers.diagnosis = "
+ diagnosisId
+ ";";
ResultSet set = stmt.executeQuery(SQL);
Answer answer;
while (set.next()) {
answer = new Answer();
answer.setId(set.getInt("id"));
answers.add(answer);
}
} catch (SQLException ex) {
System.out.println("SQL Error read perfect answers of diagnosis");
}
return answers;
}
