SQL Code:
Java Methode:
Fehler Meldung:
Was hab ich falsch gemacht?
Code:
UPDATE Filialen_Ausland
SET id=?, LABEL=?, STRASZE=?, PLZ_ORT=?, ORT,TEL_LAND=?, TEL_ANFANG_INT=?, TEL_ANFANG_TXT=?, TEL_ENDE_DEFAULT=?, FAX_ANFANG_TXT=?, FAX_ENDE_TXT=?
Java Methode:
Java:
private void jButtonUpdateA2ActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql = "UPDATE Filialen_Ausland SET id=?, LABEL=?, STRASZE=?, PLZ_ORT=?, ORT,TEL_LAND=?, TEL_ANFANG_INT=?,"
+ " TEL_ANFANG_TXT=?, TEL_ENDE_DEFAULT=?, FAX_ANFANG_TXT=?, FAX_ENDE_TXT=?";
pst = conn.prepareStatement(sql);
pst.setInt(1,Integer.parseInt(jTextFieldA1.getText()));
pst.setString(2,jTextFieldA2.getText());
pst.setString(3,jTextFieldA3.getText());
pst.setString(4,jTextFieldA4.getText());
pst.setString(5,jTextFieldA5.getText());
pst.setInt(6,Integer.parseInt(jTextFieldA6.getText()));
pst.setInt(7,Integer.parseInt(jTextFieldA7.getText()));
pst.setString(8,jTextFieldA8.getText());
if(jTextFieldA9.getText().equals("")){
pst.setObject(9, null);
}else{
pst.setInt(9,Integer.parseInt(jTextFieldA9.getText()));
}
pst.setString(10,jTextFieldA10.getText());
if(jTextFieldA11.getText().equals("")){
pst.setObject(11, null);
}else{
pst.setString(11,jTextFieldA11.getText());
}
pst.executeUpdate();
Update_Table_Filialen_Ausland();
JOptionPane.showMessageDialog(null, "Filiale aktualisiert");
}catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null, e);
}finally{
try{
if (pst != null) {
pst.close();
}
}catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null, e);
}
}
}
Fehler Meldung:
Code:
org.sqlite.SQLiteException: [SQLITE_ERROR] sql error or missing database (near ",": syntax error)
Was hab ich falsch gemacht?