There’s indeed no straightforward way to do this in JDBC. Some JDBC drivers seem to support PreparedStatement#setArray() on the IN clause. I am only not sure which ones that are. You could just use a helper method with String#join() and Collections#nCopies() to generate the placeholders for IN clause and another helper method to set all … Read more
Put the values in a temporary table and then do a select where id in (select id from temptable)
What I do is to add a “?” for each possible value. var stmt = String.format(“select * from test where field in (%s)”, values.stream() .map(v -> “?”) .collect(Collectors.joining(“, “))); Alternative using StringBuilder (which was the original answer 10+ years ago) List values = … StringBuilder builder = new StringBuilder(); for( int i = 0 ; … Read more
PDO is not good with such things. You need to create a string with placeholders dynamically and insert it into the query, while binding array values the usual way. With positional placeholders it would be like this: $in = str_repeat(‘?,’, count($in_array) – 1) . ‘?’; $sql = “SELECT * FROM my_table WHERE my_value IN ($in)”; … Read more
PreparedStatement IN clause alternatives?