java.sql.SQLException : [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement

Question

谁能告诉我为什么我收到以下语法错误？谢谢。

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

stmt = conn.prepareStatement("UPDATE STAFFDIR " +
                       "SET Last_Name = ?, " +
                       "SET First_Name = ?, " +
                       "SET Phone = ?, " +
                       "SET Dept_Code = ?, " +
                       "SET Email = ?, " +
                       "SET Title = ?, " +
                       "SET Loc_Code = ? " + 
                       "WHERE ID = ?;");

               stmt.setString(1, ID);
               stmt.setString(2, Last_Name);
               stmt.setString(3, First_Name);                   
               stmt.setString(4, Phone);
               stmt.setString(5, Dept_Code);
               stmt.setString(6, Email);
               stmt.setString(7, Title);
               stmt.setString(8, Loc_Code);
               stmt.executeUpdate(); 

Answer 1

Sql中的update语句无论设置多少个字段，都只需要一次SET，即

UPDATE STAFFDIR SET Last_Name = ?,
                    First_Name = ?, -- No extra set
                    Phone = ?, ...

顺便说一句，您是否使用了正确的驱动程序(MS Access 与 Sql Server)？