/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

7 votes318 views4 answers
What is my mysql version
SQL
0 vote291 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote329 views1 answer
T-sql update table variale
SQL
1 vote323 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote315 views1 answer
Mysql subdate
SQL
1 vote302 views2 answers
Setval max id postgresql sequence
SQL
0 vote329 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote317 views3 answers
Database restoring error
SQL
0 vote311 views4 answers
Stored procedure sql
SQL
0 vote290 views1 answer
Oracle select invalid views
SQL