java - 如何通过DAO更新mysql中实体的ID？

Question

//这是我的 AccountDAO 中的代码

@Override
    public void editAccount(Accounts account) throws ErrorException {

            response = FAILED;
            Connection connection = null;
            PreparedStatement pStatement = null;
            String sql = "UPDATE all_accounts SET 
                         accountID=?,accPassword=?,accStatus=?"
                         + "WHERE accountID "+ account.getAccountID();
            ResultSet resultSet = null;
        try {    
                if(manager == null){
                       manager = (DBManager) 
                                 DBManagerImplementation.getInstance();
            }

            connection = manager.getConnection();
            pStatement = connection.prepareStatement(sql);

            pStatement.setString(1, account.getPassword());
            pStatement.setString(2, account.getStatus());

            pStatement.execute();
        } catch (SQLException ex) {
            System.out.println("Error in editng/adding new 
                                 employee!!"+ex.toString());

        }catch (Exception ex) {
             System.out.println("Erroorr. super error!!"+ex.toString());
        } finally{
            DataDispatcher.dispatch(resultSet, pStatement, connection);
        }
    }

但是编译后这是我的错误:

Error in editng/adding new employee!!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 '111' at line 1

Answer 1

这就是您的查询的样子

"UPDATE all_accounts SET 
accountID=?,accPassword=?,accStatus=?"
+ "WHERE accountID "+ account.getAccountID();

有几个突出的事情

• WHERE 子句之前没有空格
• 没有为 WHERE 子句赋值，即

WHERE accountID ="+ account.getAccountID();