How to set multiple values in PrepareStatement while using "IN" in the query

[Gaurav Goyal]

For the foll prepared stmt

ps=Connection.prepareStatement(select * from EMPLOYEE
where emp_name IN ? );

Suppose i have 3 names to find "black", "brown" and "green"

what shd I pass to setString method

ps.setString(1,_______);

[Jan Cumps]

The JavAranch article Batching Select Statements in JDBC by Jeanne Boyarsky proposes some approaches to handle this.

Regards, Jan