Answer Posted / rashmi
there are 3 types of statements used in jdbc
------
1.createStatement()
2.preparedStatement()
3.callableStatement()
createStatement returns the object of statement.through this we can call methods belongs
to the statement interface.preparedStatement returns the object of preparedstatement.through this we can call methods belongs
to the preparedstatement interface.
The difference b/w statement and preparedstatement is :
if we use statement the sql querry parses by the database server each and every time.when
we send the request. but by using preparedstatement the sql querry parses only once and that
parsed querry is used every time.
for example if there are 100 sql statements by using statement 100 parsings are necessary.
but by using preparedStatement the parsing is happened only once.so we can save the 99 parsings.
The callablestatement is used to call the storedprocedures.
| Is This Answer Correct ? | 15 Yes | 4 No |
Post New Answer View All Answers
What are temp tables ?
How many types of statements are there in jdbc?
What is jdbc and its types?
What is type 4 jdbc driver?
What is jdbc driver manager?
Where can I find ojdbc14 jar file?
Does jdbctemplate use prepared statements?
Why is odbc needed?
Why did my jdbc code throw a rollback sqlexception?
What are the higher level apis under development on top of jdbc currently?
Is not bound in this context unable to find jdbc spring boot?
Explain in detail about JDBC and its general features?
Jdbc-odbc bridge is multi-threaded or not?
How to get the Database server details in java program?
How to check jdbc driver version in sql server?
