public Evenement getEvent(String id) {
Evenement e = new Evenement("", "", "", null, 0, 0, "", "", "", false, null);
try {
super.makeConnection();
ResultSet rs = super.makeResultSet("SELECT * FROM event WHERE eventID= '" + id + "'");
while (rs.next()) {
e.setEventID(id);
e.setNaam(rs.getString("naam"));
e.setSubtitel(rs.getString("subtitel"));
e.setDatum(rs.getDate("datum"));
e.setLocatieID(rs.getInt("locatieID"));
e.setProgrammaID(rs.getInt("programmaID"));
e.setContactPersoon(rs.getString("contactpersoon"));
e.setOrganisator(rs.getString("organisator"));
e.setType(rs.getString("type"));
e.setRemoved(rs.getBoolean("removed"));
}
super.closeConnectRst();
return e;
} catch (SQLException ex) {
super.closeConnectRst();
System.out.println(e + "het ophalen van alle evenementen is mislukt");
return e;
}
}
