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; } }
public void pasEvenementAan(Evenement e) throws ParseException { String naam = e.getNaam(); String subTitel = e.getSubtitel(); int locatieID = e.getLocatieID(); String contactPersoon = e.getContactPersoon(); String organisator = e.getOrganisator(); String query = "UPDATE event SET naam='" + naam + "', subtitel='" + subTitel + "',datum='" + e.getDatum() + "', locatieid=" + locatieID + " , contactpersoon='" + contactPersoon + "', organisator='" + organisator + "' where eventID='" + e.getEventID() + "'"; System.out.println("Query is ***********************" + query); try { super.addUpdateRecord(query); super.closeConnectRst(); } catch (Exception ex) { System.out.println(ex + "het aanpassen van een evenement is mislukt"); } }
public ArrayList<Evenement> listUpcomingEvents() throws ParseException { ArrayList<Evenement> eList = new ArrayList<Evenement>(); DateHandler dh = new DateHandler(); try { super.makeConnection(); ResultSet rs = super.makeResultSet( "SELECT * FROM `event` WHERE `datum` >= '" + dh.getDate() + "' ORDER BY `datum` DESC"); while (rs.next()) { String EventID = rs.getString("eventID"); String naam = rs.getString("naam"); String subtitel = rs.getString("subtitel"); Date datum = rs.getDate("datum"); int locatieID = rs.getInt("locatieID"); int programmaID = rs.getInt("programmaID"); String contactPersoon = rs.getString("contactpersoon"); String organisator = rs.getString("organisator"); String type = rs.getString("type"); boolean removed = rs.getBoolean("removed"); Evenement e = new Evenement( EventID, naam, subtitel, datum, locatieID, programmaID, contactPersoon, organisator, type, removed, null); eList.add(e); } } catch (SQLException ex) { System.out.println(ex + "Lijst evenementen ophalen mislukt."); } super.closeConnectRst(); return eList; }