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

I was wondering if there is a more elegant way to do IN() queries with Spring’s JDBCTemplate. Currently I do something like that:

StringBuilder jobTypeInClauseBuilder = new StringBuilder();
for(int i = 0; i < jobTypes.length; i++) {
    Type jobType = jobTypes[i];

    if(i != 0) {


Which is quite painful since if I have nine lines just for building the clause for the IN() query. I would like to have something like the parameter substitution of prepared statements

5 Answers

Leave a Comment