Today, there are always errors in the operation of data:
Java.sql.SQLException: [Microsoft][odbc Microsoft Access Driver] INSERT into statement syntax error.
At Sun.jdbc.odbc.JdbcOdbc.createSQLException (jdbcodbc.java:6958)
At Sun.jdbc.odbc.JdbcOdbc.standardError (jdbcodbc.java:7115)
At Sun.jdbc.odbc.JdbcOdbc.SQLExecDirect (jdbcodbc.java:3111)
At Sun.jdbc.odbc.JdbcOdbcStatement.execute (jdbcodbcstatement.java:338)
At Sun.jdbc.odbc.JdbcOdbcStatement.executeUpdate (jdbcodbcstatement.java:288)
At Dboperation. Database.execupdate (database.java:69)
At service. Servicethread.repair (servicethread.java:116)
At service. Servicethread.run (SERVICETHREAD.JAVA:80)
Dizzy dead, find code in line 116 valid, 116 behavior
String sql= "INSERT into repair (deviceid,people,reason,time) VALUES (' +deviceid+" ', ' "+ people+" ', ' "+reason+" ', ' "+ Logdate+ "')";
Boolean success = Db.execupdate (SQL);
Debugging for a while, the old found that they are right, grammar is no problem, but is not debugging reasons. Finally no way, with Baidu search a bit, the original access keyword problem. Here I change the above red character time to LogTime, all OK.