/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 vote244 views1 answer
Mysql select all where count more than"
SQL
1 vote290 views1 answer
Find size of all DB's postgres
SQL
49 votes308 views6 answers
Mysql add column to table
SQL
0 vote249 views1 answer
Inser into example
SQL
22 votes249 views3 answers
Join three tables sql
SQL
0 vote255 views1 answer
Mysql Digital Ocean connection problems
SQL
7 votes253 views1 answer
Minecraft forge server host
SQL
0 vote251 views1 answer
Sql select by content lenght
SQL
0 vote241 views1 answer
Oracle query to see what scema i am working in
SQL
0 vote283 views1 answer
Mysql workbench Error Code: 2013. Lost connection to MySQL server during query
SQL