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.

Explain the process of creating tables using NetBeans IDE?

1016

---

What happens if connection is not closed in jdbc?

1026

---

What are the advantages of collection pools?

1104

---

Describe odbc?

1021

---

How do I load a database driver with JDBC 4.0 / Java 6?

1029

---

Differentiate between a statement and a preparedstatement.

1108

---

Which jdbc driver type s is are the jdbc odbc bridge?

929

---

What are the different types of statements in jdbc?

968

---

How can we retrieve the file in the oracle database?

1017

---

What are the advantages of database connection pooling?

965

---

What does the jdbc resultsetmetadata interface?

997

---

Why we use jdbc instead of odbc?

1036

---

What are the steps to connect to the database in java?

1035

---

What is transaction processing in jdbc?

1050

---

Which jdbc driver is the fastest driver?

1062

---