Answer Posted / mathivanan
Statement:
Where we r going to a loop the SQL query has to be
compiled every iteration.
PreparedStatement:
Unlike Statement the SQL query is compiled one time and
use that pre_compiled query in all iteration. So it reduces
the execution time
While declaring the PreparedStatement itself v can give
the query which has to performed.
| Is This Answer Correct ? | 23 Yes | 2 No |
Post New Answer View All Answers
How do you determine the sensitivity of the ResultSet object?
What is the difference between ojdbc6 and ojdbc7?
How can you load the drivers?
Why “no suitable driver” error occurs?
What is a jdbc connection string?
What is jdbc databasemetadata interface?
Is jdbc part of j2ee?
What is executequery in java?
Which constraint cannot be specified as an explicit constraint and should be specified with the column only ?
What class.forname will do while loading drivers of jdbc?
What are the different types of JDBC drivers?
How do I stop nullpointerexception?
What is a jdbc connection?
Name the types of jdbc drivers.
How can you know about drivers and database information ?