What is the difference between callable statements, prepare statements , createstatements?

  • CallableStatement: This is used to retrieve the stored procedures from the database. ie., these statements are used when two or more SQL statements are retrieved over and over.
  • PreparedStatement: These are pre-compiled statements which are stored in database. We are using these, if the same query is to be executed over and over.
  • CreateStatement: This is used to execute single SQL statement.