Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

prepared statement....

 
dawn varghese
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
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 35279
384
Eclipse IDE Java VI Editor
  • 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
 
krishnaswamy venkataraman
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....
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic