java - Pass String array values to sql IN condition -

i have string array

string[] val=request.getparametervalues("names");   for(int i=0;i<val.length;i++){    //printval[i]; } 

i assign values of string array sql statement as

how can pass string values sql condition? if array have following values james,smith, jake etc, pass

sql =  "where dept_name in('james','smith','jake')";  

ideally want string array values passed inside in condition of sql.

you can construct query filter , append query main query.

stringbuilder sb= new stringbuilder(); string filter = "";  string[] val=request.getparametervalues("names");   for(int i=0;i<val.length;i++){    //printval[i];  sb.append( "'"+val[i]+"'," ); }  filter = sb.tostring(); filter = filter.substring(0, filter.length()-1);  sql =  "where dept_name in("+filter+")";