W
Wuschel87
Gast
Ich hab ein kleines Programm entwickelt mit dem ich Daten aus einer Access Datenbank lesen kann,nun möchte ich auch Daten hinzufügen, das ist mein bisheriger code, bekomme aber immer eine fehlermeldung
Fehlermeldung:
für hilfe wär ich sehr dankbar
lg Wuschel
Code:
public static void setData(String vorname, String gebdat,
String beginn, String ende, String name, Connection con)
throws SQLException{
String sql = "INSERT INTO Azubi ( name, vorname, gebdat, beginn, ende )VALUES ('?', '?', '?', '?', '?');";
PreparedStatement execStmt = con.prepareStatement(sql);
SimpleDateFormat date1=new SimpleDateFormat("dd.mm.yyyy");
SimpleDateFormat date2=new SimpleDateFormat("dd.mm.yyyy");
SimpleDateFormat date3=new SimpleDateFormat("dd.mm.yyyy");
Date datetest1=null;
Date datetest2=null;
Date datetest3=null;
try {
datetest1 = (Date) date1.parse(gebdat);
datetest2 =(Date) date2.parse(beginn);
datetest3 =(Date) date3.parse(ende);
} catch (ParseException e) {
Toolkit.getDefaultToolkit().beep();
JOptionPane.showMessageDialog(null, e.toString() , "Fehlermeldung", JOptionPane.ERROR_MESSAGE);
}
execStmt.setString(1, name);
execStmt.setString(2, vorname);
execStmt.setDate(3, datetest1);
execStmt.setDate(4, datetest2);
execStmt.setDate(5, datetest3);
execStmt.executeUpdate();
// stmt.executeUpdate(execStmt);
}
Fehlermeldung:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.clearParameter(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setChar(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcPreparedStatement.setString(Unknown Source)
at form_azubi.setData(form_azubi.java:158)
at form_azubi.dbzu(form_azubi.java:105)
at form_azubi.access$0(form_azubi.java:98)
at form_azubi$1.actionPerformed(form_azubi.java:86)
at javax.swing.AbstractButton.fireActionPerformed(Unknown Source)
at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)
at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)
at java.awt.Component.processMouseEvent(Unknown Source)
at javax.swing.JComponent.processMouseEvent(Unknown Source)
at java.awt.Component.processEvent(Unknown Source)
at java.awt.Container.processEvent(Unknown Source)
at java.awt.Component.dispatchEventImpl(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)
at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)
at java.awt.Container.dispatchEventImpl(Unknown Source)
at java.awt.Window.dispatchEventImpl(Unknown Source)
at java.awt.Component.dispatchEvent(Unknown Source)
at java.awt.EventQueue.dispatchEvent(Unknown Source)
at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
at java.awt.EventDispatchThread.run(Unknown Source)
für hilfe wär ich sehr dankbar
lg Wuschel