CODEWITHSUNDEEP
javajdbcprepared-statement
Geek
Geek

Reputation: 23409

Prepared Statements and JDBC Drivers

I have the below questions on Prepared Statements in Java.

  1. Is it beneficial to use Prepared Statements when the SQL Query does not have any Where clause ? Assume a simple query Select * from tablename;

  2. It is said that the Prepared Statement is compiled once and only the values are substituted the second time. Hence it is faster as the Query validation and compilation step can be skipped. Where is the compiled form stored ? What is the life time of this compiled form ?

Upvotes: 6

Views: 981

Answers (2)

Amree
Amree

Reputation: 2890

  1. Use PreparedStatement everytime there's an input or more from the user. It will help you escape the needed characters to prevent SQL Injection and errors in queries.

Upvotes: 2

Sid
Sid

Reputation: 4987

  1. A PreparedStatement is beneficial when there are parameters to be passed and when the query is to be executed repeatedly. If there is a simple query to be fired once, a Statement will prove faster.

  2. The caching takes place on DB server. The DB server has APIs that help caching compiled queries. Hence for repeated execution of queries, the same compiled query will run again and boost performance.

Upvotes: 2

Related Questions