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

What is jdbc connection string?

503


Explain the role of driver in jdbc.

561


What are jdbc and its components?

574


What are the new features added to JDBC 4.0?

533


How to set the attribute concurrency in resultset?

499






Explain the locking system in jdbc & its types?

502


What are the functions of the jdbc connection interface?

500


Why isn't the java.sql.DriverManager class being found?

564


What does the jdbc databasemetadata interface?

520


How many types of statements are there in jdbc?

488


explain about special characters?

535


Why do you use a data source object for a connection?

537


Can we have foreign key reference to a non primary key column ?

528


Differentiate between stored procedure and functions?

616


What is the advantage of namedparameterjdbctemplate?

506