Answer Posted / kalyan

As harish, said prepared statement is pre-complied so it
will be very fast when compared to normal statement.when we
execute same query again and again for different set of
input data.

code snippet for this is :--


for normal statement :

Statement st = conn.createStatement();

for prepared statement :

PreparedStatement prSt = conn.prepareStatement
("query") ;

// set values for input paramenters and execute as usual.

What is JDBC Statement?

1037

---

What are the different classes through which JDBC represents statements?

968

---

Explain about the drive manager class working?

1172

---

What is addbatch jdbc?

1115

---

Can we return resultset in java?

963

---

How can you load the drivers?

1004

---

Why would you use setautocommit(false) in jdbc?

1261

---

What is CLOB and BLOB datatypes in JDBC?

1393

---

Is odbc an api?

1096

---

What are the methods which can verify the cursor particular position?

1073

---

Which of the attributes in the monitoring tab for a jdbc connection pool in the administrative console tell us how many clients are currently waiting for a connection?

969

---

Is jdbc secure?

1020

---

Can resultset be null in java?

977

---

What does jdbc stand for?

982

---

What is the use of JDBC DriverManager class?

1118

---