The difference between MySQL execute, executeUpdate and executeQuery

The differences among execute, executeUpdate, and executeQuery (and their return values)

1. boolean execute(String sql)

Allows execution of query statements, update statements, and DDL statements.

When the return value is true, it means that a query statement is executed, and the result can be obtained through the getResultSet method; when the return value is false, an update statement or DDL statement is executed, and the getUpdateCount method obtains the number of updated records.

example:

public static void main(String[] args) { 
 
 Connection conn = null; 
 Statement stm = null; 
 ResultSet rs = null; 
 try { 
  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); 
  conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Test;user=sa;password=sasa"); 
  stm = conn.createStatement(); 
  boolean ret = stm.execute("select * from stuinfo"); 
  if(ret){ 
  rs = stm.getResultSet(); 
  while(rs.next()){ 
   System.out.println("Name: "+rs.getString("stuName")+"\tAge: "+rs.getString("stuScore")); 
  } 
  } 
  ret = stm.execute("update stuinfo set stuScore=62 where stuname='张三'"); 
  int count = stm.getUpdateCount(); 
  if(!ret){ 
  System.out.println(count+"The data was modified successfully!"); 
  } 
 } catch (ClassNotFoundException e) { 
  e.printStackTrace(); 
 } catch (SQLException e) { 
  e.printStackTrace(); 
 }  
 } 

2. int executeUpdate(String sql)

Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement, or an SQL statement that returns nothing (such as an SQL DDL statement).

The return value is the number of records updated.

3. ResultSet executeQuery(String sql)

Executes the given SQL statement, which returns a single ResultSet object.

execute is a combination of executeUpdate and executeQuery

Thank you for reading, I hope it can help you, thank you for your support of this site!