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

What is the use of JDBC DriverManager class?

0 Answers  


What is odbc jdbc?

0 Answers  


What is device controller?

0 Answers  


What is an escape syntax?

0 Answers  


What is Type-2 Driver and when this driver is used?

2 Answers  






Differentiate between type_scroll_insensitive and type_scroll_sensitive.

0 Answers  


What should be done for auto generating primary key id in a table ?

0 Answers  


Where jdbc drivermanager class is used?

0 Answers  


Give an example of code used for setting up connection with a driver.

0 Answers  


How many categories of jdbc drivers are there?

0 Answers  


Is jdbc and orm?

0 Answers  


Does jdbctemplate use prepared statements?

0 Answers  


Categories