What is Statement and PreparedStatement? whatz the
difference?
Answers were Sorted based on User's Feedback
Answer / harish
When you execute a SQL query with Statement. It parses and
executes in the database each time. Where as in
PreparedStatement, first time it parses and executes and
subsequent times, it directly substitute the values in the
query and executes. It is faster than Statement
Is This Answer Correct ? | 11 Yes | 2 No |
As harish, said prepared statement is pre-complied so it
will be very fast when compared to normal statement.when we
execute same query again and again for different set of
input data.
code snippet for this is :--
for normal statement :
Statement st = conn.createStatement();
for prepared statement :
PreparedStatement prSt = conn.prepareStatement
("query") ;
// set values for input paramenters and execute as usual.
Is This Answer Correct ? | 2 Yes | 2 No |
What are the common jdbc exceptions?
What is phantom read and which isolation level prevents it?
HI ALL, How to Overcome "OutOfMemoryException"? when I am compiling source having more than 1000 LOC throwing this exception. Can any one give correct answer to my question? thx
What is batch processing and how to perform batch processing in jdbc?
What are the differences between stored procedure and functions?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
How a driver can be loaded?
If you are truncated using JDBC, how can you that how much data is truncated?
What is jdbc and explain jdbc architecture?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
What does the jdbc connection interface?
What is resultset?