Answer to Question #63006 in Java | JSP | JSF for jonney

Question

why preparedstatement is faster in execution than standard SQL statement ?

Answer 1

When you use Prepared Statement SQL will validate the query only once, whereas if you just use a statement it will validate the query each time. The other benefit of using Prepared Statements is to avoid causing a SQL injection vulnerability - though in your case your query is so simple you haven't encountered that.
So,
Advantages of a PreparedStatement:
1) Precompilation and DB-side caching of the SQL statement leads to overall faster execution and the ability to reuse the same SQL statement in batches.
2) Automatic prevention of SQL injection attacks by builtin escaping of quotes and other special characters. Note that this requires that you use any of the PreparedStatement setXxx() methods to set the values.