PreparedStatement: setting column names dynamically - Mailing list pgsql-jdbc

From Chantal Ackermann
Subject PreparedStatement: setting column names dynamically
Date
Msg-id 3D4131C3.50809@web.de
Whole thread Raw
Responses Re: PreparedStatement: setting column names dynamically
List pgsql-jdbc
hello all,

sorry, if this has already been asked:

Is it possible to set column or table names in a PreparedStatement
similar to setting values? I happen to do this very often and in a very
structured way. If it would be possible I could reuse the prepared
statement.

what I mean is:

at the moment I have a query like:

"Select " + column + " from " + table + " where " + column + "=?";

and I would like to have something like:

"Select ? from ? where ?=?";

I see that PreparedStatement doesn't provide any setColumn() methods or
whatever. but there might be some other way I am not aware off, I hope!

Any ideas, suggestions, tips?
Thank you
Chantal


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Give me a hand
Next
From: "Ribamar FS"
Date:
Subject: Re: RES: Java access pgsql sample