Answer Posted / mathivanan

Statement:
Where we r going to a loop the SQL query has to be
compiled every iteration.

PreparedStatement:
Unlike Statement the SQL query is compiled one time and
use that pre_compiled query in all iteration. So it reduces
the execution time
While declaring the PreparedStatement itself v can give
the query which has to performed.

Where is jdbc used?

483

---

How to check jdbc driver version in sql server?

475

---

Define preparedstatement.

534

---

What is batch processing and how to perform batch processing in jdbc?

508

---

Is jdbc secure?

510

---

---

How do I find whether a parameter exists in the request object?

493

---

Is it possible to connect to multiple databases? Using single statement can we update or extract data from two or three or many databases?

584

---

Is odbc an api?

514

---

What is jdbc thin client?

500

---

What is 2 phase commit?

557

---

What is metadata in programming?

524

---

What is jdbc driver for sql server?

532

---

Explain the JDBC Architecture?

563

---

Why we use jdbc instead of odbc?

494

---

What does executeupdate return in java?

495

---