Answer / harish

When you execute a SQL query with Statement. It parses and
executes in the database each time. Where as in
PreparedStatement, first time it parses and executes and
subsequent times, it directly substitute the values in the
query and executes. It is faster than Statement

Answer / 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 are drivers available?

0 Answers  

---

List the common jdbc exceptions ?

0 Answers  

---

Why do we use jdbc?

0 Answers  

---

How do I connect to jdbc?

0 Answers  

---

How to execute bulk number of queries at once?

3 Answers   Wipro,

---

How to store images in database?

2 Answers  

---

Without using of Class.forName(? ?), how do you connect to db?

3 Answers   IBM,

---

What are dml and ddl?

0 Answers  

---

What is JDBC RowSet? What are different types of RowSet?

0 Answers  

---

What is the difference between Union, Unionall ?

1 Answers  

---

Why do we use jdbc in java?

0 Answers  

---

After creating conntinpool in weblogic how to write the code in programe where i can use that pool object in the programe connecting to the database and how to debug programe withou eclipse

2 Answers   Wipro,

---