What is the difference between a CallableStatement and PreparedStatement?

callable statements:

Callable Statement is used to call stored procedures.CallableStatement is used to execute stored procedures(a set of sql statements).

prepare statement:

prepared statement is compiled only once and executed many times with different parameters avoiding delay of compilation for every retrival (execution).In prepared statements the date formats and number formats are taken care of. Also it takes care if we have a string with apostrophe which otherwise needs to be escaped everytime.




Sandeep Joshi
Mathematics, Technology and Programming are my passion. I am a part of Java Ecosystem and through this blog, I contribute to it. I am here to blog about my interests, views and experiences.
I am on Google+ and Facebook.
I feel proud to be listed as a "National Memory Record Holder" in the Limca Book of Records, 2009 and have attempted for an International Memory record in the Guiness Book of Records. I can remember the value of PI upto 10,000 digits after the decimal (3.1415.....). You can contact me on javagenious.com(At)gmal.com ; I would like to hear from you :)