/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

1 vote172 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote170 views1 answer
Oracle sql log to console
SQL
0 vote216 views1 answer
How to find unique element in sql
SQL
7 votes187 views1 answer
Query delete duplicates
SQL
3 votes129 views1 answer
If 0 return null else return query mysql
SQL
53 votes540 views6 answers
Sql server alter column
SQL
0 vote169 views1 answer
Sql get date from timestamp
SQL
0 vote177 views1 answer
Flask sqlalchemy remove duplicates
SQL
1 vote177 views1 answer
Mysql backup skip table
SQL
9 votes228 views6 answers
Replace sql
SQL