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 is odbc and jdbc in dbms?

1010

---

What is jdbc and jpa?

1066

---

What are the new features added to JDBC 4.0?

1009

---

What is device controller?

1144

---

Explain the various types of locking system in jdbc?

951

---

What is the use of statement in jdbc?

986

---

How can we disable a constraint ?

1076

---

What causes no suitable driver error?

1015

---

How do I receive a ResultSet from a stored procedure?

1018

---

Is jdbc connection secure?

1011

---

What is savepoint in jdbc?

970

---

What is the fastest type of JDBC driver?

1101

---

What is the meaning of batch updates?

1143

---

What protocol does jdbc use?

1022

---

What is jdbc in java?

993

---