/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 vote182 views1 answer
Java mysql swing example
SQL
65 votes543 views6 answers
Sql add column to table
SQL
0 vote246 views2 answers
Getting customers with no orders sql
SQL
1 vote177 views1 answer
Oracle explain plan
SQL
3 votes206 views3 answers
1396(hy00) mysql error
SQL
0 vote169 views1 answer
Alter table fulltext
SQL
0 vote256 views1 answer
Dockerfile example for Django
SQL
1 vote257 views1 answer
Connect to mysql database ubuntu
SQL
2 votes207 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote178 views1 answer
Sql server remove enter from string
SQL