/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

3 votes281 views1 answer
Stpop start psql server
SQL
12 votes262 views1 answer
Env var for setting password for root user mysql docker hub
SQL
-1 vote267 views1 answer
Sql syntax create timestamp column
SQL
8 votes304 views2 answers
Between operator
SQL
0 vote297 views1 answer
Find the names of sailors who have reserved at least one boat
SQL
0 vote264 views1 answer
Time mysql w3
SQL
0 vote270 views1 answer
Get last updated row sql server
SQL
0 vote254 views1 answer
Mysql percentage of total
SQL
0 vote292 views1 answer
Sql sum if
SQL
0 vote274 views1 answer
Empty table sqlite
SQL