/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

0 vote288 views1 answer
Linked server delete openquery
SQL
1 vote311 views1 answer
OstgreSQL version
SQL
2 votes291 views3 answers
How to pass password mysql command line
SQL
9 votes313 views1 answer
Alter table column change data type to text mysql
SQL
7 votes306 views3 answers
Foreign key oracle
SQL
0 vote285 views1 answer
How to query all tables mysql at the same time
SQL
0 vote298 views1 answer
Java check if something is in mysql table
SQL
19 votes294 views6 answers
Sql create table
SQL
0 vote266 views1 answer
Sql runnignsum
SQL
0 vote283 views1 answer
Pl/sql loop example
SQL