Interested to Buy Any Domain ? << Click Here >> for more details...
What is Statement and PreparedStatement? whatz the
difference?
- 2 Answers
- 7597 Views
- I also Faced
- E-Mail Answers
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 is a jdbctemplate?
Why do we use jdbc in java?
What do you mean by batch processing in jdbc?
what are design patterns?
What are the different types of JDBC drivers?
What is jdbc and odbc?
How can you make the connection using jdbc?
wa is connection pooling? how do u create connection pooling?wat is use connection pooling?
How many types of statements are there in jdbc?
Explain the different ways to register a driver?
What is represented by the connection object?
What is the meaning of “dirty read” in the database?
Core Java 
