/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 vote216 views1 answer
Sum sqlserver
SQL
0 vote222 views1 answer
Sql inserted
SQL
0 vote219 views1 answer
Call function in query sql server
SQL
3 votes233 views4 answers
Stop MySQL
SQL
0 vote228 views1 answer
Fast sql column count
SQL
0 vote215 views1 answer
How much table store postgres
SQL
0 vote235 views1 answer
Set a value by excuting stored procedure
SQL
1 vote192 views1 answer
Database run
SQL
0 vote225 views1 answer
Setval postgres example table id
SQL
3 votes226 views3 answers
Concatenation in sql
SQL