Home > DeveloperSection > Interviews > What is the difference between PreparedStatement and Statement in java?

Posted on    November-03-2015 5:10 AM

 Java Java  J2EE 
 1 Answer(s)
  520  View(s)
Rate this:

Anupam Mishra

Total Post:23

Posted on    November-03-2015 6:10 AM

1.A statement is parsed and executed each time its call sent to database.
2. A prepared statement may be parsed once and executed repeatedly with different parameters.

There are four steps for the execution of query:

1. Query is parsed

2.Query is compiled.

3. Query is optimized.

4. Query is executed.

In case of statement, the above four steps are performed every time. And in case of prepared statement the above three steps are performed once.

Modified On Mar-17-2016 01:26:47 AM

Don't want to miss updates? Please click the below button!

Follow MindStick