Ich benutze eine mdb datenbank fur mein program aber wenn ich etwas eintragen will bekomme ich dies Fehlermeldung: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorre
dies ist das code:
private void writeTable(){
/* First clear the table */
emptyTable();
Statement insertRow;// = con.prepareStatement(
String baseString = "INSERT INTO UserTable " +
"VALUES (?, ?)";
String insertString;
int numRows = tabulka.getRowCount();
javax.swing.table.TableModel model = tabulka.getModel();
Integer sup, nm;
if(DEBUG) System.out.println("\nDoing Write...");
try {
/* connect to the database */
String filename = "c:/java/mdbTEST.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection(database ,"","");
insertRow = con.prepareStatement(baseString);
for (int r=0; r < numRows; r++) {
if (model.getValueAt(r, 0) != null){
insertString = baseString + model.getValueAt(r, 0)+"',";
insertString = insertString + model.getValueAt(r, 1)+",";
if(DEBUG) System.out.println(insertString);
insertRow = con.createStatement();
insertRow.executeUpdate(insertString);
System.out.println("Writing Row " + r);
insertRow.close();
}
}
con.close();
} catch(SQLException ex) {
System.err.println("SQLException4: " + ex.getMessage());
}
clearTable();
}
dies ist das code:
private void writeTable(){
/* First clear the table */
emptyTable();
Statement insertRow;// = con.prepareStatement(
String baseString = "INSERT INTO UserTable " +
"VALUES (?, ?)";
String insertString;
int numRows = tabulka.getRowCount();
javax.swing.table.TableModel model = tabulka.getModel();
Integer sup, nm;
if(DEBUG) System.out.println("\nDoing Write...");
try {
/* connect to the database */
String filename = "c:/java/mdbTEST.mdb";
String database = "jdbcdbcriver={Microsoft Access Driver (*.mdb)};DBQ=";
database+= filename.trim() + ";DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection(database ,"","");
insertRow = con.prepareStatement(baseString);
for (int r=0; r < numRows; r++) {
if (model.getValueAt(r, 0) != null){
insertString = baseString + model.getValueAt(r, 0)+"',";
insertString = insertString + model.getValueAt(r, 1)+",";
if(DEBUG) System.out.println(insertString);
insertRow = con.createStatement();
insertRow.executeUpdate(insertString);
System.out.println("Writing Row " + r);
insertRow.close();
}
}
con.close();
} catch(SQLException ex) {
System.err.println("SQLException4: " + ex.getMessage());
}
clearTable();
}