What is the main functionality of Prepared Statement?
Answers were Sorted based on User's Feedback
Answer / madhu
it is wrong assumption that preparedStatement is precompiled statement,because when we send any query with prepared statement it is going to store in SGA memory and it select any algorithm to find the solution.when we send the same query second time it won't compile once again.in this it going to improve performance.for the first time it is not precompiled for the second it is precompiled.
i hope is correct, if any thing wrong suggest me.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / arjun
when client send any query first time it can go to database
after second time no need to connect directly connect
database that is the functionality
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / md sirajuddin
Prepared Statement is an interface , which is used to execute queries . In case of prepared Statement we can insert the data dynamically to the query , prepared statement is used to execution query multiple times.
| Is This Answer Correct ? | 0 Yes | 0 No |
why are wait(), notify() and notifyall() methods defined in the object class? : Java thread
What is the difference between a vector & an array list?
How does system arraycopy work in java?
How to decrease number of hashings in has
How to call static method?
System.out & System.in are final static data member of System class but we can change there reference through setOut() & setIn() method how...
What is default constructors?
What is the final access modifier in java?
what is meant by Garbage collection?
Why do we need hashmap in java?
What is meant by polymorphism?
Why does java does not support multiple inheritance? Explain