java - MySQL语法异常，手动工作

Question

我正在手动使用此查询，它工作正常，我缺少什么？如果我不使用 WHERE，它会完美执行。

for (ArrayList<String> match : matches) {
    System.out.println(match.get(0));

    // String
    // 7412095225787794836

    String query1 = "SELECT COUNT(*) FROM `matches_players` WHERE `match_id` = ?";
    PreparedStatement preparedStmt1 = (PreparedStatement) conn.prepareStatement(query1);
    preparedStmt1.setString(1, match.get(0));
    ResultSet rs1 = preparedStmt1.executeQuery(query1);
    // 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 '?' at line 1

    while (rs1.next()) {
        System.out.println("players=" + rs1.getInt("COUNT(*)"));
    }
}

Answer 1

我认为 executeQuery 方法不需要参数。 SQL 文本已在准备中提供。尝试从 executeQuery 方法中删除参数。

替换这个:

 ResultSet rs1 = preparedStmt1.executeQuery(query1);
                                            ^^^^^^

这样:

 ResultSet rs1 = preparedStmt1.executeQuery();

看看会产生多大的烟球。