如何在SQL子查询中使用动态参数

SET @param = 'dynamic_value';

SELECT column1, column2
FROM table1
WHERE column3 IN (SELECT column4 FROM table2 WHERE column5 = @param);

WITH subquery AS (
  SELECT column4
  FROM table2
  WHERE column5 = :param
)
SELECT column1, column2
FROM table1
WHERE column3 IN (SELECT column4 FROM subquery);

String param = "dynamic_value";
String sql = "SELECT column1, column2 FROM table1 WHERE column3 IN (SELECT column4 FROM table2 WHERE column5 = ?)";

PreparedStatement statement = connection.prepareStatement(sql);
statement.setString(1, param);

ResultSet resultSet = statement.executeQuery();
while (resultSet.next()) {
  // 处理查询结果
}