/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 vote327 views1 answer
Postgres set default schema
SQL
1 vote339 views2 answers
Identify rows with 2 same column value and delete duplicate mysql
SQL
9 votes343 views1 answer
No sql
SQL
0 vote353 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote333 views1 answer
How to select a row in sql
SQL
0 vote328 views1 answer
How to order result of subquery in select
SQL
0 vote310 views1 answer
Sql server 2012 create or alter procedure
SQL
-2 votes345 views3 answers
How to fetch first 10 rows in sql
SQL
0 vote332 views1 answer
Edit a field mysql terminal
SQL
0 vote344 views1 answer
Mysql 5.7 in centos 7
SQL