/SQL/How to pass list as parameter in SQL query

How to pass list as parameter in SQL query

private static String sqlFormatedList(List<String> list){
     StringBuilder sb = new StringBuilder();
     sb.append("('");
     for (String i : list){
       sb.append(i+"','");
     }
     sb.deleteCharAt(sb.length() -1);
     sb.deleteCharAt(sb.lastIndexOf(","));
     sb.append(")");
     return sb.toString();
    }

Source: stackoverflow.com

Similar codes

1 vote145 views1 answer
Timestamp in sqlite
SQL
4 votes176 views6 answers
Select sql
SQL
62 votes218 views8 answers
Mysql add column
SQL
1 vote134 views1 answer
What is intersect
SQL
0 vote160 views1 answer
Group by max date
SQL
22 votes153 views3 answers
Year format in date mysql
SQL
0 vote139 views1 answer
How to order result of subquery in select
SQL
0 vote151 views1 answer
How to join result table in mysql
SQL
1 vote141 views1 answer
Mysql get domain from url
SQL
0 vote149 views1 answer
MySql shutdown unexpectedly InnoDB: Mutexes and rw_locks use Windows interlocked functions InnoDB: Uses event mutexes
SQL