[Microsoft][ODBC Microsoft Access 驱动程序] INSERT INTO 语句的语法错误。
public static void Add1(String academy, String classes, String name,
String number, String sex, String grade, String birthday,
String phone) throws SQLException {
String sql ="INSERT INTO student(academy,classes,name,number,sex,grade,birthday,phone) values('academy','classes','name','number','sex','grade','birthday','phone')";
access.execute(sql);
}
public static void Add1(String academy, String classes, String name,
String number, String sex, String grade, String birthday,
String phone) throws SQLException {
String sql ="INSERT INTO student(academy,classes,name,number,sex,grade,birthday,phone) values('academy','classes','name','number','sex','grade','birthday','phone')";
access.execute(sql);
}
注意数据类型的匹配。
注意sql语句中的空格。
是不是sql语句的问题?values内的改为 '"academy"’试试
stmt.executeUpdate(sql);
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate(Unknown Source)
at Client$AccessFactory.write(Client.java:312)
at Client$AccessLog.write(Client.java:141)
at Client.doWork(Client.java:416)
at Client.main(Client.java:431)"insert into logger(time,message) values('1','111')"
这条语句都插入不成功啊....
字段都是字符串,只有两个字段..
其中的字段名是参数,应该这样插入
。。values(+'“academy”'+,。);也就是 +' "参数" '+