/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

4 votes345 views3 answers
Count with where
SQL
5 votes379 views1 answer
AND OR NOT operators sql
SQL
2 votes346 views1 answer
Mysql time ago difference
SQL
-1 vote402 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote340 views1 answer
Mysql events not work
SQL
0 vote408 views3 answers
Mysql CAST(amount as float)
SQL
0 vote397 views1 answer
Pl/pgsql declare variable
SQL
17 votes430 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote434 views1 answer
Python get backup of sql
SQL
1 vote338 views1 answer
How to see all table partition in oracle
SQL