aspose file tools*
The moose likes JDBC and the fly likes Statement & PreparedStatement difference? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Statement & PreparedStatement difference?" Watch "Statement & PreparedStatement difference?" New topic
Author

Statement & PreparedStatement difference?

carl varola
Ranch Hand

Joined: May 16, 2002
Posts: 59
All,
What is the differences between those two objects,please sample codes to clear up any confusion.
Thanks.
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

I don't know that sample code would really clear anything up as to what the difference is between the 2.
Basically, when you use a PreparedStatement, the SQL statement is preprocessed before being sent to the DB.
If you just us a Statement the SQL is sent straight to the DB without ever being processed.
The reason this can be a problem is because of special characters. So if you used a contraction like don't won't can't isn't as data inside your SQL, the ' is a special SQL character that needs to be escaped before it hits the DB. This is what PreparedStatement will do for you.
Personally, I almost always use a PreparedStatement when inserting and updating data in the DB not only because of the reasons mentioned above, but because I like the syntax and how you formulate your query better. It looks neater, and I am a code neat freak.


GenRocket - Experts at Building Test Data
carl varola
Ranch Hand

Joined: May 16, 2002
Posts: 59
when you say "SQL statement is preprocessed " when u use preparedStatement,preprocessed by what?your application?your database engine?plz more info.
Thanks
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15299
    
    6

Your JDBC Driver actually does the preprocessing.
You have to understand that a DB REALLY doesn't understand SQL. When you submit SQL to a database, it actually goes through a preprocessor that converts the SQL into the language that the DB can understand and use. This processing typically happens on the DB itself.
carl varola
Ranch Hand

Joined: May 16, 2002
Posts: 59
Thanks........i will read more about it and probably i will come up with more questions............thanks.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Statement & PreparedStatement difference?