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! You may also be interested in:
|
<<: How to use Dockerfile to create a mirror of the Java runtime environment
>>: How to reference external CSS files and iconfont in WeChat applet wxss
animation-name animation name, can have multiple ...
Table of contents JS Three Mountains Synchronous ...
When creating a tomcat server on a local eclipse,...
MySQL Installer provides an easy-to-use, wizard-b...
This article shares the specific code for impleme...
<> Operator Function: Indicates not equal t...
1. Always close HTML tags In the source code of p...
Select the category selection. After testing, IE ...
I believe everyone is very sensitive to colors. C...
According to Chinese custom, we are still celebra...
MySQL Advanced SQL Statements use kgc; create tab...
Description: Limit the number of lines of text di...
Table of contents Achieve results Available plugi...
Table of contents Preliminary preparation Deploym...
In Linux system, newly install docker and enter t...