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 Relational Databases and the fly likes Difference Between PreparedStatement and Statement and CollableStatement? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Difference Between PreparedStatement and Statement and CollableStatement?" Watch "Difference Between PreparedStatement and Statement and CollableStatement?" New topic
Author

Difference Between PreparedStatement and Statement and CollableStatement?

Perumal Kasi
Greenhorn

Joined: Jul 10, 2004
Posts: 12
Hi,

I want to know the Difference Between PreparedStatement and Statement and CollableStatement?
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Then you should read the JavaDocs for these classes. Anything you don't understand after that feel free to post and I'm sure someone will try to explain.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Ajith Kallambella
Sheriff

Joined: Mar 17, 2000
Posts: 5782
Moving this discussion to "JDBC" forum...


Open Group Certified Distinguished IT Architect. Open Group Certified Master IT Architect. Sun Certified Architect (SCEA).
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 31814
    
195

Peru,
CallableStatements are for stored procedures. PreparedStatements are for regular queries (where you substitute in parameters.) For more info, look at the JavaDocs that Paul referenced.


[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Difference Between PreparedStatement and Statement and CollableStatement?