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 is DML?
How can we execute stored procedures?
Is java a database?
What is statement and preparedstatement in java?
Which is better jpa or jdbc?
What is jdbc template?
What is preparedstatement in jdbc?
Does jdbctemplate use prepared statements?
Can I get a null resultset?
Is it possible to connect to multiple databases simultaneously?
Explain the locking system in jdbc?
What are the 4 types of jdbc drivers?
Is oracle client required for jdbc connection?
What is ODBC and JDBC? How do you connect the Database?
How can you retrieve data from the resultset using jdbc?
