/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 vote193 views1 answer
If exist column in table drop sql query mysql
SQL
2 votes195 views1 answer
How to make multiple keys as primary in bdms
SQL
0 vote184 views1 answer
Find how many table doesn't contain column in mysql
SQL
0 vote198 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
0 vote211 views1 answer
Fetching data from mysqldb
SQL
6 votes190 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote155 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote278 views2 answers
Sqlalchemy default value for column
SQL
4 votes203 views1 answer
Create db table
SQL
0 vote227 views1 answer
Mysql faster delete
SQL