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 |
What is CardLayout?
What are the drawbacks of singleton class?
what is the difference b/w static and final methods?
who can i handle multiple client in RMI
Is java util regex pattern thread safe?
Name component subclasses that support painting in java programming?
What is methods and methodology?
What is the difference between multitasking and multithreading in Java
0 Answers Sans Pareil IT Services,
When finalize method is called?
How to reverse string in java?
What is a final class in java?
Why unicode is important?