What are the differences between execute, executeQuery, and executeUpdate in JDBC?

In JDBC, the methods execute, executeQuery, and executeUpdate are used to execute SQL statements, and the differences between them are as follows:

1. The execute method executes any type of SQL statement and returns a boolean value indicating whether a result set was returned. If the SQL statement is a DDL statement or a statement that returns multiple result sets, the return value is true. If the SQL statement is an INSERT, UPDATE, or DELETE statement, the return value is false.
2. The executeQuery method executes a SELECT statement and returns a ResultSet object that contains the query results.
3. The executeUpdate method is used to execute INSERT, UPDATE, or DELETE statements, and it returns an integer value indicating the number of affected rows.

In summary, the execute method can run any type of SQL statement, the executeQuery method is used for executing SELECT statements and returning a result set, and the executeUpdate method is used for executing INSERT, UPDATE, or DELETE statements and returning the number of affected rows.