/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 vote69 views1 answer
Mariadb list tables
SQL
31 votes111 views4 answers
How to get duplicate records with multiple field in sql
SQL
2 votes101 views1 answer
Plsql left() function
SQL
0 vote98 views1 answer
Select from 3 tables one is empty
SQL
0 vote74 views1 answer
Java spring boot connect to sql server
SQL
5 votes162 views1 answer
Oracle source query
SQL
0 vote69 views1 answer
Requete sql mise a jour content dans un colone mysql
SQL
0 vote105 views1 answer
Access mysql database docker container shell
SQL
0 vote116 views1 answer
Mssql dockere
SQL
0 vote130 views1 answer
Create table with timestamp mysql youtube
SQL