/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

24 votes175 views4 answers
Delete db postgres
SQL
23 votes152 views4 answers
Sql server substring
SQL
19 votes157 views3 answers
Grant mysql
SQL
0 vote160 views1 answer
Mysql query to select the highest value
SQL
0 vote160 views1 answer
How to use lower case in mysql
SQL
0 vote146 views1 answer
Sql datediff db2
SQL
0 vote196 views1 answer
Select true if exists on another table or false sqlserver
SQL
0 vote165 views2 answers
Oracle create tablespace autoextend
SQL
0 vote278 views1 answer
Oracle convert int to date
SQL
11 votes152 views2 answers
Insert current date sql
SQL