What is a PreparedStatement?

Question Posted / guest

3 Answers
5953 Views
Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a PreparedStatement?..

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

Is This Answer Correct ?

6 Yes

0 No

What is a PreparedStatement?..

Answer / ganesan

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

Is This Answer Correct ?

5 Yes

1 No

What is a PreparedStatement?..

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

Is This Answer Correct ?

3 Yes

0 No

Post New Answer