#jdbc preparedstatement

In this article, we will discuss about executing SQL statements using PreparedStatement.    

PreparedStatement

  PreparedStatement class is a subclass of Statement class.   But, in many situations its favored over Statement because:   – In some situations, it is more efficient compared to Statement – It can prevent SQL injection attack – It is helpful while preparing SQL queries involving…

JDBC Prepared Statement

JDBC prepared statement address the following requirements:

Creating parametrised statements such that data for parameters can be substituted dynamically.

Creating statements involving data values that cannot always be represented as character strings.

Pre-compiling SQL statements to avoid repeated compiling of the same SQL statements.

In most cases, you may not have the…