• Prepared statements define methods and properties that are used to send SQL commands to retrieve data from the database
  • They can be used with or without parameters
  • Increased performance of the code in case of repeated SQL statements
  • They are also know as pre-compiled statements
  • Prepared statements are supported by various DBMS like Oracle, MySQL, DB2, SQL server and PostgreSQL

Example: Creating a Prepared Statement

  • The ‘?‘ is the parameter marker that represents the parameters (in JDBC)