连接access无法执行插入语句

[subin8]

这是代码看看那错了

我的QQ 154336958


package DB;

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;

public class GetAccessDB {
static String str = "C:\\database\\gw.mdb";

public Connection getconn() {
Connection conn = null;
// String strurl="jdbc:odbc:driver={Microsoft Access Driver
// (*.mdb)};DBQ="+str;
try { // "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=
String strurl = "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="
+ str;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection(strurl);
} catch (Exception ex) {
ex.printStackTrace();
}
return conn;
}

public void selected() {
try {
Statement stat = this.getconn().createStatement();
ResultSet rs = stat.executeQuery("select * from sort");
while (rs.next()) {
System.out.println(rs.getString("name"));
}
} catch (Exception ex) {
ex.printStackTrace();
}
}

public void insert() {
try {
Connection conn = this.getconn();
System.out.print(conn.createStatement().executeUpdate("insert into sort(id,fid,name) values(3,0,'aa')"));
} catch (Exception ex) {
ex.printStackTrace();
}
}

public static void main(String args[]) {
GetAccessDB a = new GetAccessDB();
a.insert();
a.selected();
}

}

[subin8]

gw 库中
sort
有字段 id, fid,name

[piaoyao888]

id应该是自动增加的吧！如果是的话就不行的，把它去掉!
insert into sort(fid,name) values(0,'aa')