从 Java 将变量插入 SQL 查询 [英] Inserting variable into SQL query from Java

问题描述

如何在 SQL 查询中插入变量?

How do you insert variables into an SQL Query?

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

This is what I have so far ...

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 个.

I'm trying to get "amount" bugs to list. So if I input 2, then only the top 2 will get listed.

推荐答案

试试这个代码:

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);
    }
}

这篇关于从 Java 将变量插入 SQL 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！