/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

2 votes107 views1 answer
Mysql query unique column
SQL
4 votes106 views2 answers
Oracle default date format
SQL
19 votes113 views6 answers
Sql server drop table if exists
SQL
2 votes70 views1 answer
Oracle current date without time
SQL
7 votes108 views6 answers
Group_concat mysql
SQL
0 vote113 views1 answer
Sql if else in select
SQL
0 vote103 views2 answers
How to delete the rows with null values in mysql
SQL
0 vote119 views2 answers
Insert data mysql with cmd
SQL
0 vote103 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote107 views1 answer
Sql replace id with name from another table
SQL