/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 votes195 views1 answer
How to calculate number of days between two dates excluding weekends in oracle
SQL
0 vote202 views2 answers
Sqlite unique
SQL
0 vote257 views1 answer
Mysql enter ubuntu
SQL
1 vote152 views1 answer
File /etc/init.d/mysql not exists
SQL
2 votes204 views1 answer
Check isolation level in mysql
SQL
34 votes247 views6 answers
Install mysql client ubuntu
SQL
0 vote203 views4 answers
Mysql select bottom 10 rows
SQL
2 votes240 views1 answer
Sqlite insert if not exists
SQL
0 vote200 views1 answer
Convert rows to columns in sql server
SQL
16 votes203 views4 answers
Ascending order mysql
SQL