Lesson - 04 : JDBC - Statement Interface in JDBC

The following table provides a summary of each interface's purpose to decide on the interface to use.

Statement : Use the for general-purpose access to your database. Useful when you are using static SQL statements at runtime. The Statement interface cannot accept parameters.

PreparedStatement : Use the when you plan to use the SQL statements many times. The PreparedStatement interface accepts input parameters at runtime.

CallableStatement : Use the when you want to access the database stored procedures. The CallableStatement interface can also accept runtime input parameters.