Additional Notes
When might you choose plain Statements over PreparedStatements?
Track: Java
Topic: SQL for Java Devs
Focus: PreparedStatements
Java: PreparedStatements
Answer
When executing simple, non-repetitive SQL commands.
Plain Statements can be preferable for simple, one-off queries where the cost of preparing a query plan isn't justified. For example, creating a one-time, dynamically-generated SQL command in an admin tool might not benefit from the overhead of a PreparedStatement.
Plain Statements can be preferable for simple, one-off queries where the cost of preparing a query plan isn't justified. For example, creating a one-time, dynamically-generated SQL command in an admin tool might not benefit from the overhead of a PreparedStatement.
Topics: Java PreparedStatements SQL for Java Devs