How to execute IN() SQL queries with Spring’s JDBCTemplate effectively?

by

You want a parameter source:

Set<Integer> ids = ...;

MapSqlParameterSource parameters = new MapSqlParameterSource();
parameters.addValue("ids", ids);

List<Foo> foo = getJdbcTemplate().query("SELECT * FROM foo WHERE a IN (:ids)",
     parameters, getRowMapper());

This only works if getJdbcTemplate() returns an instance of type NamedParameterJdbcTemplate

More Related Contents:

  1. NamedParameterJdbcTemplate vs JdbcTemplate
  2. How to use SELECT IN clause in JDBCTemplates?
  3. Hours and seconds are lost when storing a date in the database [closed]
  4. Simulate Result set closing failed [closed]
  5. Multiple queries executed in java in single statement
  6. Efficient way to do batch INSERTS with JDBC
  7. How do I get the size of a java.sql.ResultSet?
  8. How can I get the SQL of a PreparedStatement?
  9. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  10. How does a PreparedStatement avoid or prevent SQL injection?
  11. Variable column names using prepared statements
  12. MySQL and JDBC with rewriteBatchedStatements=true
  13. Spring JDBC Template for calling Stored Procedures
  14. JDBC Pagination
  15. How to enable logging for SQL statements when using JDBC
  16. org.postgresql.util.PSQLException: FATAL: sorry, too many clients already
  17. java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/dbname [duplicate]
  18. Spring-Boot: How do I set JDBC pool properties like maximum number of connections?
  19. Queries returning multiple result sets
  20. Spring JPA @Query with LIKE
  21. dll missing in JDBC
  22. Jdbctemplate query for string: EmptyResultDataAccessException: Incorrect result size: expected 1, actual 0
  23. how to copy data from file to PostgreSQL using JDBC?
  24. Inserting null to an Integer column using JDBC
  25. Iterating through a List Object in JSP
  26. How to use prepared statement for select query in Java?
  27. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  28. Java JDBC connection status
  29. MyBatis executing multiple sql statements in one go, is that possible?
  30. Searching between dates in SQL with JDBC?

Leave a Comment