java - [Microsoft][ODBC Microsoft Access 驱动程序] 查询表达式中存在语法错误(缺少运算符)

Question

需要有关 JAVA 更新查询的帮助，刚刚开始学习但遇到问题

执行时出现以下错误

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'B.AWHERE ID =4'.

MS Access 数据库文件中的数据未更新

public void update(Student s)
    {
        int w = Integer.parseInt(s.getID());

        String query = "UPDATE Student SET ID =" + w + "," + "FirstName =" + s.getFirstName() + "," + "LastName =" + s.getLastName() + "," + "Address =" + s.getAddress() + "," + "Gender =" + s.getGender() + "," + "DOB =" + s.getDOB() + "," + "Degree =" + s.getDegree() + "WHERE ID =" + w;

        try
        {
            stmt.executeUpdate(query);
        }
        catch(SQLException e)
        {
            System.out.println("Problem in Query");
            e.printStackTrace();
        }
    }

Answer 1

将您的 UPDATE 语句更改为如下所示

String query = "UPDATE Student SET "FirstName = '" + s.getFirstName() + 
"'," + "LastName = '" + s.getLastName() + 
"'," + "Address = '" + s.getAddress() + 
"'," + "Gender = '" + s.getGender() + 
"'," + "DOB = '" + s.getDOB() + 
"'," + "Degree = '" + s.getDegree() + 
"' WHERE ID = " + w;

但是您的查询没有多大意义，因为您正在设置 ID = w 并检查 WHERE ID = w