java - 如何在Prepared语句中组合2个参数

Question

我想将下面的 java Statement 转换为 PreparedStatement ，结合 2 个参数，即 input1 和 input2。如何做到这一点？

   public static void main(String[] args) {

        String input1="Hello";
        String input2="World";

        try {

            String sql = "select * from veracodetable where output = \'"  +input1 + input2+ "\'";
            statement = con.createStatement();
            statement.executeQuery(sql);
            rs = s.getResultSet();
        } 
        catch (Exception e) {

        }
    }

Answer 1

类似这样的吗？

String sql = "select * from veracodetable where output = ?";
PreparedStatement statement = con.prepareStatement(sql);
statement.setString(input1+input2);
statement.executeQuery();
rs = s.getResultSet();

当然，如您所见，PreparedStatement 只有一个参数。