/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 vote261 views1 answer
Sqlite3 read only
SQL
0 vote263 views1 answer
Difference between db.query and db.execute
SQL
0 vote293 views2 answers
Mysql missin expression near on
SQL
0 vote266 views1 answer
Allow external access to mysql
SQL
0 vote245 views1 answer
Strat with in sql
SQL
3 votes259 views1 answer
Ms sql skip take
SQL
2 votes275 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
0 vote267 views1 answer
Monthly Birthday SQL Query
SQL
1 vote263 views1 answer
Mysql check table exists
SQL
1 vote280 views1 answer
How to copy data of a table from another database to table of anaother database
SQL