SQLServerStatement Members

 

DownloadDownload JDBC Driver

The following tables list the members that are exposed by the SQLServerStatement class.

None.

None.

NameDescription
java.sql.StatementCLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
NameDescription
addBatchAdds the given SQL command to the current list of commands for this SQLServerStatement object.
cancelCancels the SQL statement that is currently being run by this SQLServerStatement object.
clearBatchEmpties the current list of SQL commands for this SQLServerStatement object.
clearWarningsClears all the warnings that are reported on this SQLServerStatement object.
closeReleases this SQLServerStatement object's database and JDBC resources immediately instead of waiting for them to be automatically released.
executeRuns the given SQL statement, which can return multiple results.
executeBatchSubmits a batch of commands to the database to be run. If all commands run successfully, returns an array of update counts.
executeQueryRuns the given SQL statement and returns a single SQLServerResultSet object.
executeUpdateRuns the given SQL statement, which can be an INSERT, UPDATE, MERGE, or DELETE statement; or an SQL statement that returns nothing, such as an SQL DDL statement.
getConnectionRetrieves the SQLServerConnection object that produced this SQLServerStatement object.
getFetchDirectionRetrieves the direction for fetching rows from database tables that is the default for result sets generated from this SQLServerStatement object.
getFetchSizeRetrieves the number of result set rows that is the default fetch size for result set objects generated from this SQLServerStatement object.
getGeneratedKeysRetrieves any auto-generated keys that are created as a result of running this SQLServerStatement object.
getMaxFieldSizeRetrieves the maximum number of bytes that can be returned for character and binary column values in a SQLServerResultSet object that is produced by this SQLServerStatement object.
getMaxRowsRetrieves the maximum number of rows that a SQLServerResultSet object that is produced by this SQLServerStatement object can contain.
getMoreResultsMoves to the next result of this SQLServerStatement object.
getQueryTimeoutRetrieves the number of seconds the Microsoft JDBC Driver for SQL Server will wait for this SQLServerStatement object to run.
getResponseBufferingRetrieves the response buffering mode for this SQLServerStatement object.
getResultSetRetrieves the current result as a SQLServerResultSet object.
getResultSetConcurrencyRetrieves the result set concurrency for SQLServerResultSet objects that are generated by this SQLServerStatement object.
getResultSetHoldabilityRetrieves the result set holdability for SQLServerResultSet objects that are generated by this SQLServerStatement object.
getResultSetTypeRetrieves the result set type for SQLServerResultSet objects that are generated by this SQLServerStatement object.
getUpdateCountRetrieves the current result as an update count.
getWarningsRetrieves the first warning that is reported by calls on this SQLServerStatement object.
isClosedIndicates whether this SQLServerStatement object has been closed.
isPoolableReturns a value indicating if a statement can be added to the user-provided statement pool.
isWrapperForIndicates whether this statement object is a wrapper for the specified interface.
setCursorNameSets the SQL cursor name to the given String, which will be used by subsequent execute methods.
setEscapeProcessingSets the escape processing mode.
setFetchDirectionGives the JDBC driver a hint as to the direction in which result set rows should be processed.
setFetchSizeGives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
setMaxFieldSizeSets the limit for the maximum number of bytes in a SQLServerResultSet column storing character or binary values to the given number of bytes.
setMaxRowsSets the limit for the maximum number of rows that any SQLServerResultSet object can contain to the given number.
setPoolableRequests that a statement be pooled or not pooled.
setQueryTimeoutSets the number of seconds the driver will wait for a SQLServerStatement object to run to the given number of seconds.
setResponseBufferingSets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive.
unwrapReturns an object that implements the specified interface to allow access to the Microsoft JDBC Driver for SQL Server-specific methods.
Class inherited from:Methods
java.lang.Objectclone, equals, getClass, hashCode, notify, notifyAll, toString, wait
java.sql.WrapperisWrapperFor, unwrap

SQLServerStatement Class

Community Additions

ADD
Show: