/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 vote166 views1 answer
Create dump file mysql workbench
SQL
0 vote185 views1 answer
Sql last time database was accessed
SQL
6 votes173 views1 answer
To count number of rows in SQL table
SQL
0 vote170 views1 answer
Find and replace database table phpmyadmin
SQL
0 vote176 views1 answer
List all indexes postgres
SQL
3 votes206 views1 answer
Sql double index
SQL
0 vote184 views1 answer
Get relation data in mysql using query to excel
SQL
0 vote164 views1 answer
Mysql remove tabs from string
SQL
2 votes190 views1 answer
Revokeprivileges mysql
SQL
0 vote176 views1 answer
Query archive mode
SQL