quoting strings in JDBC

[carpeliam]

I know most languages have a quote() function somewhere in their DB classes that replaces the ' or " characters with the appropriate quoted characters, so that these characters do not throw off the quotes in the SQL string. I have yet to figure out whether java supports the same thing. How do you quote characters in Java? Liam Morley
lmorley@wpi.edu
"light the deep, and bring silence to the world.
light the world, and bring depth to the silence."

 

[DJSmith]

what you have to do is use the \ character
example:

String sql = "select * from table where id = \"thisid\""

this will set the string to equal

select * from table where id = "thisid"

 

[carpeliam]

that's not exactly what I had in mind... for example, in Perl, the DBI package has the quote() function which will replace any quote inside of a string with the appropriate quoted string. <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;

 

[kook04]

There is no such method in Java.

Sorry ------
KJR