/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 vote203 views1 answer
Mssql check if date is greater than today
SQL
4 votes211 views1 answer
Is there any command to change postgres password
SQL
1 vote185 views2 answers
Mysql spring boot application.properties
SQL
0 vote224 views1 answer
Data types mysql vs postgresql
SQL
1 vote207 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
3 votes219 views5 answers
Foreign keys
SQL
0 vote205 views1 answer
Sql datediff month
SQL
0 vote219 views1 answer
Mysql show create db
SQL
0 vote231 views1 answer
Pl/pgsql declare variable
SQL
0 vote219 views1 answer
Supprimer les valeur d'une table mysql
SQL