Answer / aravind

Hi Manikandansit

There is a small correction in my answer prepared statement
will be parsed for the first time when it executes any query
and there onwards parsed query will be maintained in some
sort of pool....hence next time when it tries to execute
mutilple queries with different values parsing will not
happen again...that's how we say it as precompiled...so this
will reduce the processing time when u have multiple rows of
data to insert..

I hope this will help you...if u r not satisfied with the
answer please do let me know.

Answer / manikandansit

thanks aravind.

Answer / amitabha

What is meant by parsing here?

Answer / 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();

java based application for hospital management

0 Answers  

---

Which is best database for java?

0 Answers  

---

What is connection data?

0 Answers  

---

What type of driver called is pure Java driver?

3 Answers   Vertex,

---

what does the method Class.forName returns?

4 Answers   Siemens, TCS,

---

What is serialization and deserialization in java programming?

0 Answers  

---

Which interface is responsible for transaction management in jdbc?

0 Answers  

---

commit() and rollback() methods are defined in which interface?

5 Answers  

---

What are JDBC statements?

2 Answers  

---

How do I write Greek ( or other non-ASCII/8859-1 ) characters to a database?

0 Answers  

---

What is meant by jdbc and odbc?

0 Answers  

---

How to get the data from a table into a buffer?

2 Answers  

---