Thread: PreparedStatement: setting column names dynamically
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
Chantal, You probably want to do something like a persistence layer, look at castor, not sure of the url, but google castor persistence should give you something. Dave On Fri, 2002-07-26 at 07:25, Chantal Ackermann wrote: > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html > >
hello Dave, thank you for the link. it looks very interesting though I haven't found a straight solution to my problem yet. but I might solve some of my other problems using it. ;-) cheers Chantal Dave Cramer wrote: >Chantal, > >You probably want to do something like a persistence layer, look at >castor, not sure of the url, but google castor persistence should give >you something. > >Dave >On Fri, 2002-07-26 at 07:25, Chantal Ackermann wrote: > > >>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 >> >>