public static void updateAppointments(Appointment PlaceholderAppointment) {
        // look up key to keys and "insert" to make everything work; //To change body of generated methods, choose Tools | Templates.
        String sql = "UPDATE appointments SET Title =?,  Description=?,   Location=?,  Type=?,  start=?, end=?,   Customer_ID=?,  User_ID=?, Contact_ID=? WHERE Appointment_ID = ?";
        try {
            PreparedStatement ps = DBConnection.getConnection().prepareStatement(sql);
            ps.setString(1, PlaceholderAppointment.getTitle());
            ps.setString(2, PlaceholderAppointment.getDescription());
            ps.setString(3, PlaceholderAppointment.getLocation());
            ps.setString(4, PlaceholderAppointment.getType());
            LocalDateTime start = LocalDateTime.of(PlaceholderAppointment.getDate(), PlaceholderAppointment.getStartTime());
            start = WashTimeZone(start, ZoneId.systemDefault(), ZoneId.of("UTC"));
            LocalDateTime end = LocalDateTime.of(PlaceholderAppointment.getDate(), PlaceholderAppointment.getEndTime());
            end = WashTimeZone(end, ZoneId.systemDefault(), ZoneId.of("UTC"));
            Timestamp Tstart = Timestamp.valueOf(start);
            Timestamp Tend = Timestamp.valueOf(end);
            ps.setTimestamp(5, Tstart);
            ps.setTimestamp(6, Tend);
//timezone work needs to happen here
            ps.setInt(7, PlaceholderAppointment.getCustomerid());
            ps.setInt(8, PlaceholderAppointment.getUserid());
            ps.setInt(9, PlaceholderAppointment.getContactid());
            ps.setInt(10, PlaceholderAppointment.getAppointment_ID());
            ps.execute();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
public static void updateAppointments(Appointment PlaceholderAppointment) {
       
        String sql = "UPDATE appointments SET Title =?,  Description=?,   Location=?,  Type=?,  start=?, end=?,   Customer_ID=?,  User_ID=?, Contact_ID=? WHERE Appointment_ID = ?";
        try {
            PreparedStatement ps = DBConnection.getConnection().prepareStatement(sql);
            ps.setString(1, PlaceholderAppointment.getTitle());
            ps.setString(2, PlaceholderAppointment.getDescription());
            ps.setString(3, PlaceholderAppointment.getLocation());
            ps.setString(4, PlaceholderAppointment.getType());
            LocalDateTime start = LocalDateTime.of(PlaceholderAppointment.getDate(), PlaceholderAppointment.getStartTime());
            start = WashTimeZone(start, ZoneId.systemDefault(), ZoneId.of("UTC"));
            LocalDateTime end = LocalDateTime.of(PlaceholderAppointment.getDate(), PlaceholderAppointment.getEndTime());
            end = WashTimeZone(end, ZoneId.systemDefault(), ZoneId.of("UTC"));
            Timestamp Tstart = Timestamp.valueOf(start);
            Timestamp Tend = Timestamp.valueOf(end);
            ps.setTimestamp(5, Tstart);
            ps.setTimestamp(6, Tend);
            ps.setInt(7, PlaceholderAppointment.getCustomerid());
            ps.setInt(8, PlaceholderAppointment.getUserid());
            ps.setInt(9, PlaceholderAppointment.getContactid());
            ps.setInt(10, PlaceholderAppointment.getAppointment_ID());
            ps.execute();
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
public static void updateappointments(appointment placeholderappointment) { string sql = "update appointments set title =?, description=?, location=?, type=?, start=?, end=?, customer_id=?, user_id=?, contact_id=? where appointment_id = ?"; try { preparedstatement ps = dbconnection.getconnection().preparestatement(sql); ps.setstring(1, placeholderappointment.gettitle()); ps.setstring(2, placeholderappointment.getdescription()); ps.setstring(3, placeholderappointment.getlocation()); ps.setstring(4, placeholderappointment.gettype()); localdatetime start = localdatetime.of(placeholderappointment.getdate(), placeholderappointment.getstarttime()); start = washtimezone(start, zoneid.systemdefault(), zoneid.of("utc")); localdatetime end = localdatetime.of(placeholderappointment.getdate(), placeholderappointment.getendtime()); end = washtimezone(end, zoneid.systemdefault(), zoneid.of("utc")); timestamp tstart = timestamp.valueof(start); timestamp tend = timestamp.valueof(end); ps.settimestamp(5, tstart); ps.settimestamp(6, tend); ps.setint(7, placeholderappointment.getcustomerid()); ps.setint(8, placeholderappointment.getuserid()); ps.setint(9, placeholderappointment.getcontactid()); ps.setint(10, placeholderappointment.getappointment_id()); ps.execute(); } catch (sqlexception ex) { ex.printstacktrace(); } }