mysql - 为什么我收到此错误 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException？

Question

我确实遇到了这个错误，错误行如下:

com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'employee WHERE dep_id=29' at line 1

1.UserDao.java:

public void deleteUser(int dep_Id)
{
    try
    {
        PreparedStatement ps=connection.prepareStatement("delete from employee where dep_id=?");
        ps.setInt(1, dep_Id);
        ps.executeUpdate();
    }
    catch(SQLException e)
    {
    System.out.println(e);
    }
}

Answer 1

看来问题是因为我没有提到数据库中的DEPT_ID。已修复。