Friday, 3 May 2019

JDBC Difference between execute, executeQuery and executeUpdate in JDBC



execute method can be used with any type of SQL statements and it returns a boolean. A true indicates that the execute method returned a result set object which can be retrieved using getResultSet method. false indicates that the query returned an int value or void. execute method can run both select and insert/update statements.
executeQuery method execute statements that returns a result set by fetching some data from the database. It executes only select statements.
executeUpdate method execute sql statements that insert/update/delete data at the database. This method return int value representing number of records affected; Returns 0 if the query returns nothing. The method accepts only non-select statements.

No comments:

Post a Comment