What is a PreparedStatement?

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

More JDBC Interview Questions

Why do we need jdbc?

0 Answers  


why we don't use the type 2 driver for connect to the database in jdbc?

1 Answers   TCS,


Is possible to open a connection to a database with exclusive mode with JDBC?

0 Answers  


How can you load the drivers in jdbc?

1 Answers  


What is a Connection?

1 Answers  






What are the differences between statement and preparedstatement interface?

0 Answers  


What driver should I use for scalable Oracle JDBC applications?

0 Answers  


Is java a database?

0 Answers  


How to know howmuch data is truncated?

0 Answers   Mastek,


What is meant by a ResultSet?

3 Answers  


What is savepoint in jdbc?

0 Answers  


What are the steps to connect to the database in java?

0 Answers  


Categories