PreparedStatement with list of parameters in a IN clause [duplicate]

by

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 ; i < values.size(); i++ ) {
    builder.append("?,");
}

String placeHolders =  builder.deleteCharAt( builder.length() -1 ).toString();
String stmt = "select * from test where field in ("+ placeHolders + ")";
PreparedStatement pstmt = ...

And then happily set the params

int index = 1;
for( Object o : values ) {
   pstmt.setObject(  index++, o ); // or whatever it applies 
}

More Related Contents:

  1. PreparedStatement IN clause alternatives?
  2. Using setDate in PreparedStatement
  3. Java: Insert multiple rows into MySQL with PreparedStatement
  4. How can I get the SQL of a PreparedStatement?
  5. Using “like” wildcard in prepared statement
  6. Get query from java.sql.PreparedStatement [duplicate]
  7. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  8. How does a PreparedStatement avoid or prevent SQL injection?
  9. Variable column names using prepared statements
  10. Reusing a PreparedStatement multiple times
  11. Where’s my invalid character (ORA-00911)
  12. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  13. right syntax to use near ‘?’
  14. How does Java’s PreparedStatement work?
  15. Does the preparedStatement avoid SQL injection? [duplicate]
  16. mysql prepared statement error: MySQLSyntaxErrorException
  17. PreparedStatement setNull(..)
  18. Oracle’s RETURNING INTO usage in Java (JDBC, Prepared Statement)
  19. How to use prepared statement for select query in Java?
  20. JDBC Prepared Statement . setDate(….) doesn’t save the time, just the date.. How can I save the time as well?
  21. PreparedStatement and setTimestamp in oracle jdbc
  22. java.sql.SQLException: Access denied for user ‘root’@’localhost’ (using password: YES)
  23. Running a .sql script using MySQL with JDBC
  24. JDBC connection to MSSQL server in windows authentication mode
  25. Oracle JDBC intermittent Connection Issue
  26. How to execute .sql script file using JDBC [duplicate]
  27. Hibernate batch size confusion
  28. Lightweight JDBC helper library alternative to Apache Commons DbUtils [closed]
  29. Do I need to close ‘PreparedStatement’? [closed]
  30. java.sql.SQLException: No database selected – why?

Leave a Comment