/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 vote182 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
4 votes198 views2 answers
How to insert ip address in mysql using php
SQL
3 votes152 views1 answer
Ubuntu install postgresql 12
SQL
18 votes270 views3 answers
Get the list of all tables in sql server
SQL
0 vote193 views3 answers
Postgres trim string
SQL
0 vote208 views1 answer
Hierarchal database table
SQL
19 votes244 views1 answer
Sqrt(-1)
SQL
0 vote183 views2 answers
Sqlalchemy core in clause
SQL
0 vote232 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
10 votes290 views2 answers
Doublon sql
SQL