1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30
|
public static void findPatient(String name) {
try {
prep = con.prepareStatement("select tab_patient.Nom, tab_patient.Prenom, tab_patient.Sexe, tab_patient.DateNaissance, tab_hospitalisation.DateEntree, tab_hospitalisation.DateSortie, tab_diagnostic.CodeCIM10 FROM (tab_patient INNER JOIN tab_hospitalisation ON tab_patient.NumPatient = tab_hospitalisation.NumPatient) INNER JOIN tab_diagnostic ON tab_hospitalisation.NumHospitalisation = tab_diagnostic.NumHospitalisation"
+ " WHERE (DateEntree BETWEEN '2005-02-01' AND '2005-02-31') AND Nom=?;");
res = prep.executeQuery();
prep.setString(1, name);
if(res.first()) {
monPatient.setNom(res.getString(1));
monPatient.setPnom(res.getString(2));
monPatient.setSexe(res.getInt(3));
monPatient.setDdn(res.getDate(4));
}
while(res.next()) {
Hospitalisation hospit = new Hospitalisation(null, null);
hospit.setDateEntree(res.getDate(5));
hospit.setDateSortie(res.getDate(6));
hospits.add(hospit);
Diagnostic diag = new Diagnostic(null);
diag.setCodeCim(res.getString(7));
diags.add(diag);
}
res.close();
} catch (SQLException e) {
e.printStackTrace();
}
} |
Partager