Export (0) Print
Expand All

SQLServerStatement Members

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

Name

Description

java.sql.Statement

CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO

Name

Description

addBatch

Adds the given SQL command to the current list of commands for this SQLServerStatement object.

cancel

Cancels the SQL statement that is currently being run by this SQLServerStatement object.

clearBatch

Empties the current list of SQL commands for this SQLServerStatement object.

clearWarnings

Clears all the warnings that are reported on this SQLServerStatement object.

close

Releases this SQLServerStatement object's database and JDBC resources immediately instead of waiting for them to be automatically released.

execute

Runs the given SQL statement, which can return multiple results.

executeBatch

Submits a batch of commands to the database to be run. If all commands run successfully, returns an array of update counts.

executeQuery

Runs the given SQL statement and returns a single SQLServerResultSet object.

executeUpdate

Runs 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.

getConnection

Retrieves the SQLServerConnection object that produced this SQLServerStatement object.

getFetchDirection

Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this SQLServerStatement object.

getFetchSize

Retrieves the number of result set rows that is the default fetch size for result set objects generated from this SQLServerStatement object.

getGeneratedKeys

Retrieves any auto-generated keys that are created as a result of running this SQLServerStatement object.

getMaxFieldSize

Retrieves 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.

getMaxRows

Retrieves the maximum number of rows that a SQLServerResultSet object that is produced by this SQLServerStatement object can contain.

getMoreResults

Moves to the next result of this SQLServerStatement object.

getQueryTimeout

Retrieves the number of seconds the Microsoft JDBC Driver for SQL Server will wait for this SQLServerStatement object to run.

getResponseBuffering

Retrieves the response buffering mode for this SQLServerStatement object.

getResultSet

Retrieves the current result as a SQLServerResultSet object.

getResultSetConcurrency

Retrieves the result set concurrency for SQLServerResultSet objects that are generated by this SQLServerStatement object.

getResultSetHoldability

Retrieves the result set holdability for SQLServerResultSet objects that are generated by this SQLServerStatement object.

getResultSetType

Retrieves the result set type for SQLServerResultSet objects that are generated by this SQLServerStatement object.

getUpdateCount

Retrieves the current result as an update count.

getWarnings

Retrieves the first warning that is reported by calls on this SQLServerStatement object.

isClosed

Indicates whether this SQLServerStatement object has been closed.

isPoolable

Returns a value indicating if a statement can be added to the user-provided statement pool.

isWrapperFor

Indicates whether this statement object is a wrapper for the specified interface.

setCursorName

Sets the SQL cursor name to the given String, which will be used by subsequent execute methods.

setEscapeProcessing

Sets the escape processing mode.

setFetchDirection

Gives the JDBC driver a hint as to the direction in which result set rows should be processed.

setFetchSize

Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.

setMaxFieldSize

Sets the limit for the maximum number of bytes in a SQLServerResultSet column storing character or binary values to the given number of bytes.

setMaxRows

Sets the limit for the maximum number of rows that any SQLServerResultSet object can contain to the given number.

setPoolable

Requests that a statement be pooled or not pooled.

setQueryTimeout

Sets the number of seconds the driver will wait for a SQLServerStatement object to run to the given number of seconds.

setResponseBuffering

Sets the response buffering mode for this SQLServerStatement object to case-insensitive String full or adaptive.

unwrap

Returns 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.Object

clone, equals, getClass, hashCode, notify, notifyAll, toString, wait

java.sql.Wrapper

isWrapperFor, unwrap

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft