/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 vote111 views1 answer
Select statement to print longest name
SQL
0 vote133 views1 answer
Sql server insert inner join
SQL
0 vote115 views1 answer
Convert sql server guid to varbinary
SQL
1 vote129 views1 answer
Sql select whole row max column
SQL
1 vote131 views2 answers
Mysql error 1215
SQL
0 vote131 views1 answer
Create query in where clasue
SQL
2 votes119 views3 answers
How to check current user in mySQL
SQL
0 vote125 views1 answer
Start stop mysql linux
SQL
0 vote70 views2 answers
Delete query sql server
SQL
4 votes132 views1 answer
Postgresql create table with index
SQL