从java更新mySQL数据库上的int

Question

我在更新sql server时遇到问题。级别是普通键，idScore是主键。这些级别是服务器上的整数。我已经设法达到了这些水平，但有一段时间我一直坚持更新新的价值观。“uCon”正在工作，它已登录到服务器。可以执行其他命令。必须是sql语句。允许登录的acc进行更新和选择。可以换成ofc

        int highScore1 = 23;
    int highScore2 = 6;
    int highScore3 = 7;
    String userName = "nisse";
    try {
        Statement st = Login.uCon.createStatement();
        String sql = "UPDATE phantom.BoulderDash SET level1 = "+highScore1+", "
                                                  + "level2 = "+highScore2+", "
                                                  + "level3 = "+highScore3+","
                                                  + "WHERE idScore = '" + userName + "';";
        st.execute(sql);
    } catch (Exception ex) {
        System.out.println("fail");
    }

Answer 1

在where子句之前有一个多余的逗号（,），应该删除它：

String sql = "UPDATE phantom.BoulderDash SET level1 = "+highScore1+", "
                                                  + "level2 = "+highScore2+", "
                                                  + "level3 = "+highScore3+" " // No comma here
                                                  + "WHERE idScore = '" + userName + "';";