How to generate a dynamic “in (…)” sql list through Spring JdbcTemplate?

by

Yes, it’s possible in Spring if you use NamedParameterJdbcTemplate or SimpleJdbcTemplate with named parameters. List parameter can be set as a java.util.List:

List<String> list = new ArrayList<String>();

list.add("A");
list.add("B");
list.add("C");

List<SomeObject> result = simpleJdbcTemplate.query("SELECT * FROM t WHERE c in (:list)",
    new RowMapper<SomeObject>() { ... },
    Collections.singletonMap("list", list));

In this case Spring internally creates the SQL query with the required number of placeholders based on the size of the actual list when replacing named parameters with ?s.

More Related Contents:

  1. Why does self-invocation not work for Spring proxies (e.g. with AOP)?
  2. Spring Resttemplate exception handling
  3. Spring Boot – How to get the running port
  4. create two method for same url pattern with different arguments
  5. Spring Boot CORS filter – CORS preflight channel did not succeed
  6. Where should “@Transactional” be placed Service Layer or DAO
  7. Splitting applicationContext to multiple files
  8. Spring Data – ignore parameter if it has a null value
  9. Spring MVC – Why not able to use @RequestBody and @RequestParam together
  10. How exactly does the Spring BeanPostProcessor work?
  11. @Value not resolved when using @PropertySource annotation. How to configure PropertySourcesPlaceholderConfigurer?
  12. implement dynamically datasource in spring data jpa
  13. A ‘simple’ way to implement Swagger in a Spring MVC application
  14. spring autowiring with unique beans: Spring expected single matching bean but found 2
  15. How to conditionally declare Bean when multiple profiles are not active?
  16. spring integration + cron + quartz in cluster?
  17. Reuse spring application context across junit test classes
  18. Spring Security and @Async (Authenticated Users mixed up)
  19. Spring @Transactional with a transaction across multiple data sources
  20. How to parse gzip encoded response with RestTemplate in Spring-Web
  21. How to use multiple login pages one for admin and the other one for user
  22. Another unnamed CacheManager already exists in the same VM (ehCache 2.5)
  23. Changing default welcome-page for spring-boot application deployed as a war
  24. Create Account, Forgot Password and Change Password
  25. Spring Social Authentication Filter for Stateless REST Endpoints which use Facebook Token for authentication
  26. CSS not loading in Spring Boot
  27. Spring : serving static resources outside context root
  28. Spring Boot SSL Client
  29. LazyInitializationException in JPA and Hibernate
  30. Adding custom RequestCondition’s in Spring mvc 3.1

Leave a Comment