/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 vote183 views1 answer
Subquery aggregation
SQL
0 vote183 views1 answer
Mysql workbench indent formatting
SQL
0 vote228 views1 answer
Reset a table's identity column and remove test records
SQL
4 votes191 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
14 votes226 views5 answers
Set password for postgres user ubuntu
SQL
0 vote171 views1 answer
Sum sqlserver
SQL
13 votes185 views2 answers
Get tables in database sql
SQL
0 vote216 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
2 votes203 views2 answers
Sqlalchemy return id after insert
SQL
2 votes183 views2 answers
Mysql user access to database
SQL