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
What does jdbc setmaxrows method do?
What is jdbc and explain jdbc architecture?
Explain Basic Steps in Writing a Java Program Using Jdbc?
What are the components of jdbc?
What do you mean by metadata and why we are using it?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
What is the meaning of connection?
How do I stop nullpointerexception?
What is jdbc driver?
What is jdbc odbc bridge in java?
How can you retrieve data from the resultset using jdbc?
What are the main steps in java to make JDBC connectivity?
What is a jdbc driver and how many jdbc drivers are available?
How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?
What is the role of class.forname while loading drivers?