/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

2 votes368 views1 answer
Oracle generated column
SQL
0 vote373 views1 answer
Add sqlcmd to path linux
SQL
0 vote360 views1 answer
How to reset table in sql server
SQL
2 votes338 views1 answer
How to add where command in update comand with joins
SQL
2 votes369 views2 answers
Microsoft sql server extract hour and minute from datetime
SQL
1 vote342 views1 answer
What is intersect
SQL
0 vote361 views1 answer
Suse status MySQL
SQL
0 vote345 views1 answer
Cast as decimal postgresql
SQL
6 votes362 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote350 views1 answer
No suitable driver found for sqlite
SQL