JDBC Prepared Statement Example

  • The main feature of a PreparedStatement object is that, unlike a Statement object, it is given a SQL statement when it is created.
  • The advantage to this is that in most cases, this SQL statement is sent to the DBMS right away, where it is compiled.
  • As a result, the PreparedStatement object contains not just a SQL statement, but a SQL statement that has been precompiled.
  • This means that when the PreparedStatement is executed, the DBMS can just run the PreparedStatement SQL statement without having to compile it first.