/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 vote172 views1 answer
Error code 1292 mysql workbench
SQL
0 vote174 views1 answer
Influxdb clone measurement
SQL
0 vote164 views1 answer
Insert or update cassandra
SQL
0 vote171 views1 answer
How to save data in database in mysql node
SQL
0 vote194 views1 answer
Sql server create constraint
SQL
0 vote171 views1 answer
Redudancy in SQL
SQL
3 votes154 views1 answer
Oracle nextval
SQL
1 vote232 views2 answers
Mysql SELECT
SQL
1 vote162 views1 answer
Where date = max(date) in sql
SQL
1 vote181 views3 answers
SELECT * FROM
SQL