/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 vote324 views1 answer
Disableforiegn key check
SQL
0 vote326 views1 answer
Original Query
SQL
1 vote356 views1 answer
Store select query result in variable sql server
SQL
0 vote362 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote343 views1 answer
Sql server convert to guid
SQL
0 vote393 views1 answer
Mssql find deadlocks
SQL
0 vote325 views1 answer
Convert sql server guid to varbinary
SQL
14 votes343 views6 answers
Auto_increment mysql
SQL
0 vote370 views2 answers
Select a row include list of array with join two table SQL
SQL
19 votes343 views6 answers
Sql create table
SQL