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 ?");

What is jdbc resultsetmetadata interface?

0 Answers  

---

Are all the required JDBC drivers to establish connectivity to my database part of the JDK?

0 Answers  

---

What are cursor attributes?

3 Answers  

---

Write an sql to find all records having all upper case alphanumeric characters in a field ?

0 Answers  

---

What is a rollback in jdbc?

0 Answers  

---

How does a custom RowSetReader get called from a CachedRowSet?

0 Answers  

---

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

0 Answers  

---

What is connection pooling? What Method and class used for Connection pooling in Java?

2 Answers  

---

What is data source in java?

0 Answers  

---

how can we get the metaData (columnNames) from a table which has no Records..

2 Answers  

---

write down exceptions those appear in java programs when u write JDBC Programs?

2 Answers  

---

What are the basic exceptions in jdbc?

0 Answers  

---