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 |