java - 从Java将变量插入SQL查询

Question

如何将变量插入 SQL 查询？

这就是我目前所拥有的...

public String getBugList(int amount) {
    Connection con  = DatabaseConnection.getConnection();
    try (PreparedStatement ps = con.prepareStatement("SELECT submitter, report FROM bugs_log ORDER BY id DESC limit ))
}

我正在尝试列出“数量”错误。因此，如果我输入 2，则只会列出前 2 个。

Answer 1

试试这个代码:

public String getBugList(int amount) {
    Connection con  = DatabaseConnection.getConnection();
    String query = "SELECT submitter, report FROM bugs_log ORDER BY id DESC limit ?";
    try(PreparedStatement ps = con.prepareStatement(query)) {
        ps.setInt(1, amount);
    }
}