java - 当我在java中执行更新查询时遇到一些问题

Question

已关闭。此问题需要 debugging details 。目前不接受答案。

---

编辑问题以包含 desired behavior, a specific problem or error, and the shortest code necessary to reproduce the problem 。这将有助于其他人回答问题。

已关闭 4 年前。

Improve this question

执行更新查询时遇到一些问题，索引 1 超出范围。

public void updateAnswer(String Answer, String correct, String Id_Question, int id) throws SQLException, Exception {
    try {
            //UPDATE Answer SET Answer = ':: A. 10 ::B.15 ::C.20 ::D.5' ,Correct_Answer= 'B' WHERE Id = 151;

        conn = DataConnection.getConnectionToSQLSever();
        sqlStr = "UPDATE Answer SET Answer = '?', Correct_Answer = '?' WHERE Id =?;";

        pst = conn.prepareStatement(sqlStr);
        pst.setString(1, Answer);
        pst.setString(2, correct);
        pst.setInt(3, id);
        System.out.println(pst.toString());
        pst.executeUpdate();
        findAnswerId(Id_Question).setAnswer(Answer);
        findAnswerId(Id_Question).setCorrect(correct);

    } catch (SQLException e) {
        throw e;
    } catch (Exception e) {
        throw e;
    }
}

Answer 1

您的前两个问号被视为文字，实际上，您只有一个参数，这就是您收到索引超出范围的原因。删除单引号，？仅需要一个字符串参数就足够了