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
Describe the steps needed to execute a sql query using jdbc.
How can I determine where a given table is referenced via foreign keys?
Explain how to make updates to the updatable resultsets.
What is execute in java?
How can we set null value in jdbc preparedstatement?
Where is mysql jdbc driver located?
If I use the JDBC API, do I have to use ODBC underneath?
What is jdbc and its types?
What is a jdbc connection pool?
What is jdbc connection?
Explain in detail about JDBC and its general features?
What is the different between ResultSet and RowSet?
What is jdbc class forname?
What do you mean by odbc?
Is jdbc connection secure?