Answer / umamaheswari

PreparedStatement used to send SQL Statement to the Database
It not only contains the SQL Statement ,but also the
precompiled SQL Statement.It means that when the
PreparedStatement is executed ,the DBMS just run the SQL
Statement without compiling it

Answer / ganesan

If you want to execute a Statement object many times, it
normally reduces execution time to use a PreparedStatement
object instead.

Answer / kalyan

If same query is executed multiple times over DB for
different values, we go for preparedStatement

PreparedStatement ps = con.prepareStatement(
"UPDATE TABLE_NAME SET COLUMN = ? WHERE COF_VALUE
LIKE ?");

Where is ojdbc14 jar located?

0 Answers  

---

What is static Synchronized method in JDBC API? Give an example?

3 Answers   3 Edge Solutions, R Systems, Sirvisetti Global Services,

---

What is odbc. how is it related to sql cli?

0 Answers  

---

PreparedStatement is a pre compiled statement but where it's pre compiled ?

4 Answers  

---

Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?

0 Answers  

---

Explain the JDBC Architecture?

0 Answers  

---

How are jdbc statements used?

0 Answers  

---

What are static and dynamic queries?

1 Answers  

---

How to find that, a row is updated or not?

2 Answers  

---

Is odbc an api?

0 Answers  

---

What are collection pools?

0 Answers  

---

What are the 4 types of jdbc drivers?

0 Answers  

---