File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes how to deal with the special character in java and oracle!!! Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "how to deal with the special character in java and oracle!!!" Watch "how to deal with the special character in java and oracle!!!" New topic
Author

how to deal with the special character in java and oracle!!!

Geoffrey Ren
Greenhorn

Joined: Nov 25, 2002
Posts: 18
when I got the user inputting. For example, user input the value "test's"/"test&s"/"test\s". How to insert the value into oracle DB by jdbc.
Thanks for you reply!
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

PreparedStatement will do the escaping for you:

either that or do a loop and escape every "bad" character in the string. The choice is usually PreparedStatement.
Jamie
Peter den Haan
author
Ranch Hand

Joined: Apr 20, 2000
Posts: 3252
Anything other than a PreparedStatement is madness. This becomes even clearer when you start to consider things like date formats. Ok, so you could use ANSI SQL escape syntax -- hands up everyone who can write down a date literal using escape syntax without consulting some kind of reference! And now hands up those who'd never heard of this syntax before... Thought so.
- Peter
Surendran Velath
Greenhorn

Joined: Apr 23, 2003
Posts: 19
You can use a Statement also
stmt.executeUpdate("test''s"/"test&s"/"test\s");
only remember that a single quote needs an additional single quote
test''s
all other characters are accepted directly
 
Don't get me started about those stupid light bulbs.
 
subject: how to deal with the special character in java and oracle!!!
 
Similar Threads
how to deal with the special character in java and oracle!!!
how to deal with the special character in java and oracle!!!
accept command in .sql file not working from ant
doubt in JSTL c:out
String and StringBuffer