SQLServerStatement Members
The following tables list the members that are exposed by the SQLServerStatement class.
Constructors
None.
Fields
None.
Inherited Fields
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 |
Methods
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 a SQL statement that returns nothing, such as a 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. |
Inherited Methods
Class inherited from: | Methods |
---|---|
java.lang.Object | clone, equals, getClass, hashCode, notify, notifyAll, toString, wait |
java.sql.Wrapper | isWrapperFor, unwrap |