Prepared Statements with unknown number of inputs

hothouse

If I have this query = "select * from cars where make = ?"

I can do this in a prepared statement

PreparedStatement p = con.preparedS..(Query)
p.setString(1,make);

Any idea how to do it if I have multiple makes ?

"select * from cars where make = ? or make = ? or make =? or ..unknown number"

I was thinking of counting the number of inputs and having an array of query strings

String[] queries = {
"",
"select * from cars where make = ?",
"select * from cars where make = ? or make = ?",
"select * from cars where make = ? or make = ? or make = ?",
"select * from cars where make = ? or make = ? or make = ? or make = ?",
etc};

then using

String[] inputs = inputs in array;
int input = inputs.length;
PreparedStatement p = con.preparedS..(queries[input]);
for(int i=1;i<=inputs;i++)
	p.setString(i,inputs[i]);

OMcGovern

You might be able to use this instead...

select * from cars where make in ( ? )

And the ? is a comma-separated list of values.
Eg. 'ford', 'nissan', 'mazda'

regards,
Owen

hothouse

OMcGovern wrote:

You might be able to use this instead...

select * from cars where make in ( ? )

And the ? is a comma-separated list of values.
Eg. 'ford', 'nissan', 'mazda'

regards,
Owen

Works great, much more simple

thanks
Owen