Pass multiple values to query dynamically in java

Viewed 6300

I am trying to pass multiple values in a SELECT QUERY consisting of two IN clauses. I would like to execute the following query:

String sql = "select ADDRESS from CDR where APARTY in(?,?,?) intersect select ADDRESS from CDR where BPARTY in (?,?) and USAGETYPE='SMSMT'";

How can I pass value using preparedStatement.setString() ?.Thanks in advance.

2 Answers
Related