/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

8 votes159 views1 answer
My sql version
SQL
0 vote132 views1 answer
With_for_update sqlalchemy
SQL
0 vote126 views1 answer
C# mysql data reader from two tables
SQL
0 vote139 views1 answer
How to delete python anywhere mysql database
SQL
0 vote143 views2 answers
Sql trigger difference between for and after
SQL
0 vote132 views1 answer
Mysql where in keep order
SQL
0 vote141 views1 answer
Mysql workbench not showing schemas
SQL
2 votes119 views1 answer
Can you use a where clause for a child query
SQL
10 votes131 views5 answers
Create table mysql query
SQL
0 vote119 views1 answer
QCompleter con sql
SQL