java - MySQL 不执行 (Java)

Question

出于某种原因，我无法使用此代码更新我的数据库。有人可以帮我吗？我得到的是，当玩家完成某项任务时，当且仅当他们的时间低于最佳记录时间时，它才会记录他们花费的时间。

    public void setScores(MapleCharacter chr, int mapid, float time) {
    Connection con1 = DatabaseConnection.getConnection();
    try {
        PreparedStatement ps;
        ps = con1.prepareStatement("SELECT time from jumpquests WHERE characterid = ? AND mapid = ?");
        ps.setInt(1, chr.getId());
        ps.setInt(2, chr.getMapId());
        ResultSet rs = ps.executeQuery();
        if (rs.next()) {
            if (time < rs.getFloat("time")) {
                executeScores(chr, mapid, time);
            }
        } else {
            executeScores(chr, mapid, time);
        }
        rs.close();
        ps.close();
    } catch (Exception Ex) {
        System.out.println("Ran into exception.");
    }
}

public void executeScores(MapleCharacter chr, int mapid, float time) {
    System.out.println("Setting scores for " + chr.getName() + " for map " + mapid + " at time " + time);
    Connection con1 = DatabaseConnection.getConnection();
    try {
        PreparedStatement ps = con1.prepareStatement("REPLACE INTO jumpquests (characterid, mapid, time) values (?,?,?)");
        ps.setInt(1, chr.getId());
        ps.setInt(2, chr.getMapId());
        ps.setFloat(3, time);
        ps.close();
    } catch (Exception e) {
        System.out.println("Executing scores ran into exception.");
    }
}

Answer 1

我不确定与 JAVA 相关的任何内容，但您的 REPLACE INTO SQL 语句包含保留字 time，需要使用 backtique 进行转义，例如以下。参见 MySQL Documentation获取更多信息。

REPLACE INTO jumpquests (characterid, mapid, time) values (?,?,?)
                                               ^........Here

应该是

REPLACE INTO jumpquests (characterid, mapid, `time`) values (?,?,?)