Explaining the Difference Between execute(), executeQuery(), and executeUpdate() Methods in JDBC

In JDBC, the execute() method is used to execute any SQL statement, while executeQuery() method is specifically used for executing SELECT queries and returning a ResultSet, and executeUpdate() method is used for executing INSERT, UPDATE, DELETE statements and returning the number of rows affected.

Scenarios for Using Each Method:

• execute(): This method should be used when dealing with dynamic SQL queries where the type of operation is not known beforehand.
• executeQuery(): Use this method when executing SELECT queries that are expected to return a result set that needs to be processed.
• executeUpdate(): When executing INSERT, UPDATE, DELETE statements that modify data in the database and you need to know the number of rows affected, use this method.