Interested to Buy Any Domain ? << Click Here >> for more details...
What is Statement and PreparedStatement? whatz the
difference?
- 2 Answers
- 7758 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / harish
When you execute a SQL query with Statement. It parses and
executes in the database each time. Where as in
PreparedStatement, first time it parses and executes and
subsequent times, it directly substitute the values in the
query and executes. It is faster than Statement
| Is This Answer Correct ? | 11 Yes | 2 No |
As harish, said prepared statement is pre-complied so it
will be very fast when compared to normal statement.when we
execute same query again and again for different set of
input data.
code snippet for this is :--
for normal statement :
Statement st = conn.createStatement();
for prepared statement :
PreparedStatement prSt = conn.prepareStatement
("query") ;
// set values for input paramenters and execute as usual.
| Is This Answer Correct ? | 2 Yes | 2 No |
What is ODBC and JDBC? How do you connect the Database?
How vendor Naming registry supports JNDI?
What are the advantages of using preparedstatement over statement?
What is the exception thrown by JDBC ?
What is the syntax of URL to get connection?
How do I insert/update records with some of the columns having NULL value?
What is jdbc and odbc in java?
How can we retrieve the file in the oracle database?
What is odbc and jdbc?
what is CallableStatement and what is its usage?
How warnings are retrieved in JDBC?
code to insert values/rows into oracle database from a java swing textfield when a button is pressed(using preparedstatements)
Core Java 
