The difference between excute,excuteupdate,excutequery in Java

executeQuery (String sql) executes the SELECT statement, which returns a Recordset (resultset) after the query.

executeupdate (String sql) executes the Update,insert,delete statement, which returns the number of record bars (int) that are affected by the statement execution. For DDL statements that do not manipulate rows such as CREATE table or DROP table, the return value of executeupdate is always zero.

Execute (String sql) executes any SQL statement, which is one of the first two. The return value is a representation of the first result. Returns True when the first execution result is a query statement, which can be obtained by the Getresultset method, or False when the first execution result is an UPDATE statement or DDL statement, and the number of records updated can be obtained through the Getupdatecount method.

The difference between excute,excuteupdate,excutequery in Java