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.

What are the utilities of the callablestatement?

957

---

Is jdbc connection secure?

907

---

How can we move the cursor in a scrollable result set?

916

---

What class.forname will do while loading drivers of jdbc?

902

---

What are the advantages of collection pools?

994

---

Why do I have to reaccess the database for Array, Blob, and Clob data?

1022

---

List the common jdbc exceptions ?

960

---

Which is faster jdbc or odbc?

864

---

What is odbc jdbc?

971

---

Explain the various types of locking system in jdbc?

847

---

What are the differences between execute, executequery, and executeupdate?

921

---

What is jdbc thin client in oracle?

869

---

Which database is used for java?

919

---

What are the new features added to JDBC 4.0?

930

---

Does sql allow null values ?

928

---