public Abonne rechercher(String idAbonne) throws SQLException {
pSelectAbonne.clearParameters();
pSelectAbonne.setString(1, idAbonne);
ResultSet rsAbonne = pSelectAbonne.executeQuery();
Abonne a = null;
FabTheatre ft = FabTheatre.getInstance();
ft.setConnection(c);
while(rsAbonne.next()){
String nom = rsAbonne.getString(2);
String prenom = rsAbonne.getString(3);
String adresse = rsAbonne.getString(4);
int nbPlaces = rsAbonne.getInt(5);
Date debutVal = rsAbonne.getDate(6);
Date finVal = rsAbonne.getDate(7);
String idZone = rsAbonne.getString(8);
Zone z = ft.parametrerZone(idZone);
a = new Abonne(idAbonne,nom,prenom,adresse,debutVal,finVal,nbPlaces,z);
}
return a;
}