tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <Larry.Mead...@plumcreek.com>
Subject Re: OT: PreparedStatement with dynamic parameter list
Date Tue, 01 Apr 2003 15:52:08 GMT
Here are a couple of options for this:

The open-source ibatis database framework (www.ibatis.com) lets you do
this.

Another home-grown solution would be to create a StringBuffer for your
SQL, and a map for the parameters. Then you can prepare the statement,
and iterate through the map setting the parameters.

Larry

>>> schakravarthy@doas.ga.gov 04/01/03 08:37 AM >>>

Has anyone constructed a PreparedStatement where the number of ?s ( i.e
bind variables ) is unknown at compile time  ?


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message