What is PreparedStatement?

Answer Posted / suresh

PreparedStatements are precompiled. When you create a
PreparedStatement you supply a SQL statement. This statement
is passed right along to your database where it is compiled
and cached. The advantage of this is that if you are running
a query multiple times the database will not have to compile
it each time before it is run. This can result in a hefty
performance boost.


Read more: How to use a Java Prepared Statement | eHow.com
http://www.ehow.com/how_5386522_use-java-prepared-statement.html#ixzz12INtbKn4

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

618


Is jdbctemplate thread safe?

485


What is a jdbctemplate?

525


What is the meaning of batch updates?

565


What does the jdbc resultset interface?

535






How many ways can you update a result set?

565


Does JDBC support stored procedures?

561


How to insert an image or raw data into database?

556


What are four types of JDBC driver?

570


Explain the steps in writing a java program using jdbc?

452


What is a rollback in jdbc?

528


What is database deadlock ?

541


How will you perform truncation using JDBC?

580


Where is jdbc used?

490


What are the benefits of PreparedStatement over Statement?

530