What is the difference between PreparedStatement and Statement in java?

Question

Anupam Mishra · Answer

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.

interview