Answer Posted / aravind

Hi,
in prepared statement when u mention the query that time
only statement will be internaly sent to DB and checks for
the query syntax, so when u execute it directly executes
the statement.

PreparedStatement pstmt = conn.prepareStatement("insert
into table (column2) values ("My Value") where id = 1000");

//pstmt is already compiled

pstmt.execute();

What are the different types of classes in the api component?

971

---

Is jdbc a protocol?

939

---

What is addbatch jdbc?

1044

---

What is jdbc architecture in java?

948

---

What are the differences between setmaxrows(int) and setfetchsize(int)?

1065

---

How can I connect mysql or oracle with java?

966

---

What are jdbc and its components?

987

---

What is a rollback in jdbc?

946

---

How does a file store compare with a jdbc store?

1207

---

What is jdbc type?

890

---

What are the packages are used in jdbc?

1044

---

What are the advantages of collection pools?

1055

---

Prepared statements are faster. Why?

1054

---

How to achieve JDBC Connection Pooling using JDBC DataSource and JNDI in Apache Tomcat Server?

1024

---

How do I know which jdbc driver to use?

1009

---