/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

0 vote347 views1 answer
Cartesian product sql
SQL
1 vote316 views2 answers
Mssql show database size
SQL
0 vote343 views1 answer
Mysql last friday of current month
SQL
0 vote327 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
1 vote331 views1 answer
Mysql alter decimal precision
SQL
0 vote289 views1 answer
Linux upload database to mysql
SQL
0 vote316 views1 answer
Report in database
SQL
0 vote328 views2 answers
Uninstall postgresql mac
SQL
1 vote313 views4 answers
Mysqldump 1 table only
SQL
2 votes282 views1 answer
Foreign key example in dbms
SQL