Hallo
<form action="eintragdb.jsp" method="get">
statement.execute("INSERT INTO fluege " + "(FLIGHT NUMBER, CALLSIGN, DATE, DEPARTURE, ARRIVAL, ALTERNATE 1, ALTERNATE 2, DEPARTURE TIME, ARRIVAL TIME, FLIGHT TIME, TOTAL TIME, AIRCRAFT, FUEL, ROUTE, REMARKS) " + "VALUES (\"" + flightnumber + "\",\"" + callsign + "\",\"" + date + "\",\"" + departure + "\",\"" + arrival + "\",\"" + alternate1 + "\",\"" + alternate2 + "\",\"" + departuretime + "\",\"" + arrivaltime + "\",\"" + flighttime + "\",\"" + totaltime + "\",\"" + aircraft + "\",\"" + fuel + "\",\"" + route + "\",\"" + remarks + "\");");
statement.execute("INSERT INTO ´fluege´ "
+ "(´FLIGHT NUMBER´, CALLSIGN, DATE, DEPARTURE, ARRIVAL, ´ALTERNATE 1´,"+
" ´ALTERNATE 2´, ´DEPARTURE TIME´, ´ARRIVAL TIME´, ´FLIGHT TIME´, ´TOTAL TIME´, AIRCRAFT, FUEL, ROUTE, REMARKS) "
// Tabellen-/ Spaltennamen mit Leer- oder Sonderzeichen sind immer etwas Problematisch
// Tipp: Benutze statt eines Leerzeichen das "_"
// und setze bei allen Tabellen- und Spaltennamen das "`"-Zeichen.
+ "VALUES (\"" + flightnumber + "\",\"" + callsign + "\",\"" + date + "\",\"" + departure + "\",\"" + arrival + "\",\"" +
alternate1 + "\",\"" + alternate2 + "\",\"" + departuretime + "\",\"" + arrivaltime + "\",\"" + flighttime + "\",\"" +
totaltime + "\",\"" + aircraft + "\",\"" + fuel + "\",\"" + route + "\",\"" + remarks + "\")");
// Ich kenne die Spaltenwerte nicht, aber bei Nummern sollten die Werte nicht mit " gekennzeichnet werden.
// Dies führt manchmal zu Fehlern.