/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

5 votes218 views1 answer
AND OR NOT operators sql
SQL
3 votes205 views4 answers
Show sql server database
SQL
7 votes242 views2 answers
Mysql check db size
SQL
0 vote220 views1 answer
Sql server user permissions and roles
SQL
0 vote211 views1 answer
Casterar postgres
SQL
1 vote162 views1 answer
Convert money to varchar sql server
SQL
0 vote191 views1 answer
Mysql workbench search all tables
SQL
0 vote256 views1 answer
Get total and distict row diff in sql
SQL
1 vote243 views2 answers
Truncate table sqlite
SQL
7 votes212 views2 answers
Get database size mysql
SQL