错误：com.microsoft.sqlserver.jdbc.SQLServerException：索引2超出范围

Question

I have a function to update the user's information as follows:

public void updateAccount(String username, String name, String address, String aboutMe, String 
id) {
    String sql = "update Account set username = '?', \n"
            + "                [Full_Name] = '?',\n"
            + "                [Address] = '?',\n"
            + "                [about_me] = '?'\n"
            + "                where id = ?";
    try {
        PreparedStatement ps = connection.prepareStatement(sql);
        ps.setString(1, username);
        ps.setString(2, name);
        ps.setString(3, address);
        ps.setString(4, aboutMe);
        ps.setString(5, id);
        ps.executeUpdate();

    } catch (Exception ex) {
        Logger.getLogger(AccountDao.class.getName()).log(Level.SEVERE, null, ex);
    }
}

and this code is giving me an error like this: 

Severe: com.microsoft.sqlserver.jdbc.SQLServerException: The index 2 is out of range.

在com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError（SQLServerException.java:191）在com.microsoft.sqlserver.jdbc.SQLServerPrearedStatement.setterGetParam（SQLServerPrearedStatement.java:933）在com.microsoft.sqlserver.jdbc.SQLServerPrearedStatement.set值（SQLServerPrearedStatement.java:948）在com.microsoft.sqlserver.jdbc.SQLServerPrearedStatement.set字符串（SQLServerPrearedStatement.java:1578）在道。帐户Dao.update帐户（帐户Dao.java:117）在控制器。UserProfileController.do帖子（UserProfileController.java:91）

我不明白为什么会出现“索引2超出范围”的错误，有什么方法可以修复它吗？

Answer 1

不要将？参数标记括在引号中。这些由适当的setter键入：

String sql = "update Account set username = ?, \n"
        + "                [Full_Name] = ?,\n"
        + "                [Address] = ?,\n"
        + "                [about_me] = ?\n"
        + "                where id = ?";