• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Tim Cooke
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Knute Snortum
  • paul wheaton
  • Devaka Cooray
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Ron McLeod
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Tim Holloway
  • Carey Brown
  • salvin francis

prepared statement....

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi guys i have the following doubts ???
what is the main difference between satemant and prepared statement??
and where does the prepared statement reside ???is it in the application
side or database side???
and please give me an overveiw of how the things work???as to how the query is executed in prepared statement and how different is it frm the statement??
thanks
DAWN
 
author & internet detective
Posts: 39433
768
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dawn,
Welcome to Javaranch!
This has been discussed many times. You can find past discussions by using the search feature at the top of the page. For example, this poster had the same question.
 
dawn varghese
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello ,
i was able to get the difference between th e two but the answer to the question that wheere does the prepared statement reside ?? application side or the database side???remains unanswered...please help
thanks
 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A SQL statement is precompiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
 
dawn varghese
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
krishna ..thanks for the reply...
so now the question in where does the prepared statement object reside???
in the database side or the applicatin side???
as objects are references to the objects....does the application have referrence to the prp statement object in the database side???
thanx....
 
Get off me! Here, read this tiny ad:
Enterprise-grade Excel API for Java
https://products.aspose.com/cells/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!