| Author |
prepared statement....
|
dawn varghese
Greenhorn
Joined: May 01, 2004
Posts: 3
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26181
|
|
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.
|
[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
|
|
dawn varghese
Greenhorn
Joined: May 01, 2004
Posts: 3
|
|
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
Joined: May 04, 2004
Posts: 3
|
|
|
A SQL statement is precompiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.
|
Krishnaswamy.V<br />Think Java<br />Eat Java<br />Live Java
|
|
dawn varghese
Greenhorn
Joined: May 01, 2004
Posts: 3
|
|
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....
|
|
 |
|
|
subject: prepared statement....
|
|
|
0
