This week's book giveaway is in the OCAJP 8 forum.
We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line!
See this thread for details.
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


Win a copy of OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
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: 32636
    
215

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]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, 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?
 
jQuery in Action, 3rd edition