how to create comma separated string in single quotes from arraylist of string in JAVA

Question

I have requirement in Java to fire a query on MS SQL like

select * from customer 
where customer.name in ('abc', 'xyz', ...,'pqr');

But I have this IN clause values in the form of ArrayList of String. For ex: the list look like {"abc","xyz",...,"pqr"}

I created a Prepared Statement :

 PreparedStatement pStmt = conn.prepareStatement(select * from customer 
    where customer.name in (?));
String list= StringUtils.join(namesList, ",");
pStmt.setString(1,list);
rs = pStmt.executeQuery();

But the list is like "abc,xyz,..,pqr", but I want it as "'abc','xyz',..,'pqr'" so that I can pass it to Prepares Statement.

How to do it in JAva with out GUAVA helper libraries.

Thanks in Advance!!

Answer 1

List<String> nameList = ...    
String result = nameList.stream().collect(Collectors.joining("','", "'", "'"));

Answer 2

For converting the string you can try this:

String list= StringUtils.join(namesList, "','");
list = "'" + list + "'";

But i dont thing it's a good idea to pass one string for multiple params.