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 Difference Between PreparedStatement and Statement and CollableStatement? Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply 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
internet detective
Marshal

Joined: May 26, 2003
Posts: 26155
    
  66

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.


[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://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Difference Between PreparedStatement and Statement and CollableStatement?
 
Similar Threads
Diff b/w Statement and PreparedStatement
Statement and PreparedStatement question?
Difference between Statement/Prepared statement?
Statement vs preparedStatement
JDBC