/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 vote146 views1 answer
Sql first day quarter
SQL
0 vote135 views1 answer
Sql create table with references not primary key
SQL
4 votes133 views1 answer
SQL order random
SQL
0 vote135 views1 answer
Snap craft
SQL
0 vote135 views3 answers
Java hide mysql login credentials
SQL
1 vote132 views1 answer
Postgresql convert text to float
SQL
0 vote173 views1 answer
Get first monday of month sql
SQL
1 vote133 views1 answer
Mysql random limit 1
SQL
0 vote152 views1 answer
SQL Server date literal
SQL
2 votes139 views2 answers
How to add not null constraint in sql
SQL