Types of Statements

In JDBC, there are three types of statements:

Statement: A Statement is an interface used to execute simple SQL queries with no parameters. The statement is used to create a basic SQL statement that is sent to the database and executed.

PreparedStatement: A PreparedStatement is an interface used to execute parameterized SQL queries. In this type of statement, the SQL statement is precompiled and cached in the database. Parameters can be set and reused without recompiling the SQL statement. This type of statement is used when you need to execute the same SQL statement multiple times with different values.

CallableStatement: A CallableStatement is an interface used to execute stored procedures. Stored procedures are precompiled SQL statements that can be executed multiple times with different parameters. A CallableStatement is used to call a stored procedure and pass parameters to it.