Redigera

Dela via


executeUpdate Method (java.lang.String, java.lang.String)

Download JDBC driver

Runs the given SQL statement and signals Microsoft JDBC Driver for SQL Server that the auto-generated keys indicated in the given array should be made available for retrieval.

Syntax

  
public final int executeUpdate(java.lang.String sql,  
                               java.lang.String[] columnNames)  

Parameters

sql

A String that contains a SQL statement.

columnNames

An array of type String that indicates which column names of the auto-generated keys should be made available.

Return Value

An int that indicates the number of rows affected, 0 if using a DDL statement.

Exceptions

SQLServerException

Remarks

This executeUpdate method is specified by the executeUpdate method in the java.sql.Statement interface.

If executing a stored procedure results in an update count that is greater than one, or that generates more than one result set, use the execute method to execute the stored procedure.

See Also

executeUpdate Method (SQLServerStatement)
SQLServerStatement Members
SQLServerStatement Class