--- title: "SQLServerPreparedStatement Members | Microsoft Docs" ms.custom: "" ms.date: "01/19/2017" ms.prod: sql ms.prod_service: connectivity ms.reviewer: "" ms.technology: connectivity ms.topic: conceptual ms.assetid: 2363902f-d4c6-4cd4-a5fc-86079eb9e418 author: David-Engel ms.author: v-daenge --- # SQLServerPreparedStatement Members [!INCLUDE[Driver_JDBC_Download](../../../includes/driver_jdbc_download.md)] The following tables list the members that are exposed by the [SQLServerPreparedStatement](../../../connect/jdbc/reference/sqlserverpreparedstatement-class.md) class. ## Constructors None. ## Fields None. ## Inherited Fields |Class inherited from:|Methods| |---------------------------|-------------| |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](../../../connect/jdbc/reference/addbatch-method-sqlserverpreparedstatement.md)|Adds a set of parameters to the batch of commands for this Statement object.| |[cancel](../../../connect/jdbc/reference/cancel-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Cancels the SQL statement that is currently being run by this Statement object.| |[clearBatch](../../../connect/jdbc/reference/clearbatch-method-sqlserverpreparedstatement.md)|Empties the current list of SQL commands for this [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md) object.| |[clearParameters](../../../connect/jdbc/reference/clearparameters-method-sqlserverpreparedstatement.md)|Clears the current parameter values immediately.| |[clearWarnings](../../../connect/jdbc/reference/clearwarnings-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Clears all the warnings that are reported on this Statement object.| |[close](../../../connect/jdbc/reference/close-method-sqlserverpreparedstatement.md)|Releases the database and JDBC resources of this Statement object immediately instead of waiting for them to be automatically released.| |[execute](../../../connect/jdbc/reference/execute-method-sqlserverpreparedstatement.md)|Runs the SQL statement in this Statement object, which can be any kind of SQL statement.| |[executeBatch](../../../connect/jdbc/reference/executebatch-method-sqlserverpreparedstatement.md)|Submits a batch of commands to the database to be run. If all commands run successfully, returns an array of update counts.| |[executeQuery](../../../connect/jdbc/reference/executequery-method-sqlserverpreparedstatement.md)|Runs the SQL query in this Statement object and returns the [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object that is generated by the query.| |[executeUpdate](../../../connect/jdbc/reference/executeupdate-method-sqlserverpreparedstatement.md)|Runs the SQL statement in this Statement object, which must be an SQL INSERT, UPDATE, MERGE, or DELETE statement; or an SQL statement that returns nothing, such as a DDL statement.| |[getConnection](../../../connect/jdbc/reference/getconnection-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the [SQLServerConnection](../../../connect/jdbc/reference/sqlserverconnection-class.md) object that produced this Statement object.| |[getFetchDirection](../../../connect/jdbc/reference/getfetchdirection-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.| |[getFetchSize](../../../connect/jdbc/reference/getfetchsize-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the number of result set rows that is the default fetch size for result set objects generated from this Statement object.| |[getGeneratedKeys](../../../connect/jdbc/reference/getgeneratedkeys-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves any auto-generated keys that are created as a result of running this Statement object.| |[getMaxFieldSize](../../../connect/jdbc/reference/getmaxfieldsize-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the maximum number of bytes that can be returned for character and binary column values in a [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object produced by this Statement object.| |[getMaxRows](../../../connect/jdbc/reference/getmaxrows-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the maximum number of rows that a [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object produced by this Statement object can contain.| |[getMetaData](../../../connect/jdbc/reference/getmetadata-method-sqlserverpreparedstatement.md)|Retrieves a [SQLServerResultSetMetaData Class](../../../connect/jdbc/reference/sqlserverresultsetmetadata-class.md) object that contains information about the columns of the [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object that will be returned when this Statement object is executed.| |[getMoreResults](../../../connect/jdbc/reference/getmoreresults-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Moves to the next result of this Statement object.| |[getParameterMetaData](../../../connect/jdbc/reference/getparametermetadata-method-sqlserverpreparedstatement.md)|Retrieves the number, types, and properties of the parameters for this Statement object.| |[getResponseBuffering](../../../connect/jdbc/reference/getresponsebuffering-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the response buffering mode for this [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md) object.| |[getQueryTimeout](../../../connect/jdbc/reference/getquerytimeout-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the number of seconds the [!INCLUDE[jdbcNoVersion](../../../includes/jdbcnoversion_md.md)] will wait for this Statement object to run.| |[getResultSet](../../../connect/jdbc/reference/getresultset-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the current result as a [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object.| |[getResultSetConcurrency](../../../connect/jdbc/reference/getresultsetconcurrency-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the result set concurrency for [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) objects that are generated by this Statement object.| |[getResultSetHoldability](../../../connect/jdbc/reference/getresultsetholdability-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the result set holdability for [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) objects that are generated by this Statement object.| |[getResultSetType](../../../connect/jdbc/reference/getresultsettype-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the result set type for [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) objects that are generated by this Statement object.| |[getUpdateCount](../../../connect/jdbc/reference/getupdatecount-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md),) Retrieves the current result as an update count.| |[getWarnings](../../../connect/jdbc/reference/getwarnings-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Retrieves the first warning that is reported by calls on this Statement object.| |[isClosed](../../../connect/jdbc/reference/isclosed-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Indicates whether this Statement object has been closed.| |[isPoolable](../../../connect/jdbc/reference/ispoolable-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Returns a value indicating if a statement can be added to the user-provided statement pool.| |[isWrapperFor](../../../connect/jdbc/reference/iswrapperfor-method-sqlserverpreparedstatement.md)|Indicates whether this statement object is a wrapper for the specified interface.| |[setArray](../../../connect/jdbc/reference/setarray-method-sqlserverpreparedstatement.md)|Sets the designated parameter number to the given Array object.| |[setAsciiStream](../../../connect/jdbc/reference/setasciistream-method-sqlserverpreparedstatement.md)|Sets the designated parameter number to the given InputStream object.| |[setBigDecimal](../../../connect/jdbc/reference/setbigdecimal-method-sqlserverpreparedstatement.md)|Sets the designated parameter number to the given BigDecimal object.| |[setBinaryStream](../../../connect/jdbc/reference/setbinarystream-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified input stream.| |[setBlob](../../../connect/jdbc/reference/setblob-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified Blob object.| |[setboolean](../../../connect/jdbc/reference/setboolean-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **Boolean** value.| |[setByte](../../../connect/jdbc/reference/setbyte-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **byte** value.| |[setBytes](../../../connect/jdbc/reference/setbytes-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified array of bytes.| |[setCharacterStream](../../../connect/jdbc/reference/setcharacterstream-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified Reader object.| |[setClob](../../../connect/jdbc/reference/setclob-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the given Clob object.| |[setCursorName](../../../connect/jdbc/reference/setcursorname-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the SQL cursor name to the specified String, which will be used by subsequent execute methods.| |[setDate](../../../connect/jdbc/reference/setdate-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified date value.| |[setDateTimeOffset](../../../connect/jdbc/reference/setdatetimeoffset-method-sqlserverpreparedstatement.md)|Sets the value of the column specified to the [DateTimeOffset Class](../../../connect/jdbc/reference/datetimeoffset-class.md) value.| |[setDouble](../../../connect/jdbc/reference/setdouble-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **double** value.| |[setEscapeProcessing](../../../connect/jdbc/reference/setescapeprocessing-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the escape processing mode.| |[setFetchDirection](../../../connect/jdbc/reference/setfetchdirection-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Gives the JDBC driver a hint as to the direction in which result set rows should be processed.| |[setFetchSize](../../../connect/jdbc/reference/setfetchsize-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.| |[setFloat](../../../connect/jdbc/reference/setfloat-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **float** value.| |[setInt](../../../connect/jdbc/reference/setint-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **int** value.| |[setLong](../../../connect/jdbc/reference/setlong-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **long** value.| |[setMaxFieldSize](../../../connect/jdbc/reference/setmaxfieldsize-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the limit for the maximum number of bytes in a [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) column storing character or binary values to the given number of bytes.| |[setMaxRows](../../../connect/jdbc/reference/setmaxrows-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the limit for the maximum number of rows that any [SQLServerResultSet](../../../connect/jdbc/reference/sqlserverresultset-class.md) object can contain to the given number.| |[setNCharacterStream](../../../connect/jdbc/reference/setncharacterstream-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified Reader object.| |[setNClob](../../../connect/jdbc/reference/setnclob-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified object.| |[setNull](../../../connect/jdbc/reference/setnull-method-sqlserverpreparedstatement.md)|Sets the designated parameter to a null value, given the type of parameter to set.| |[setNString](../../../connect/jdbc/reference/setnstring-method-int-java-lang-string.md)|Sets the designated parameter to the specified **String** object.| |[setObject](../../../connect/jdbc/reference/setobject-method-sqlserverpreparedstatement.md)|Sets the value of the designated parameter using the given object.| |[setPoolable](../../../connect/jdbc/reference/setpoolable-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Requests that a statement be pooled or not pooled. By default, a SQLServerPreparedStatement object is poolable when created.| |[setQueryTimeout](../../../connect/jdbc/reference/setquerytimeout-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the number of seconds the driver will wait for a Statement object to run to the specified number of seconds.| |[setRef](../../../connect/jdbc/reference/setref-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified Ref object.| |[setResponseBuffering](../../../connect/jdbc/reference/setresponsebuffering-method-sqlserverstatement.md)|(Inherited from [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md).) Sets the response buffering mode for this [SQLServerStatement](../../../connect/jdbc/reference/sqlserverstatement-class.md) object to case-insensitive **String full** or **adaptive**.| |[setShort](../../../connect/jdbc/reference/setshort-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **short** value.| |[setString](../../../connect/jdbc/reference/setstring-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **String** value.| |[setSQLXML](../../../connect/jdbc/reference/setsqlxml-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified **SQLXML** object.| |[setTime](../../../connect/jdbc/reference/settime-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified time value.| |[setTimestamp](../../../connect/jdbc/reference/settimestamp-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified timestamp value.| |[setUnicodeStream](../../../connect/jdbc/reference/setunicodestream-method-sqlserverpreparedstatement.md)|Sets the designated parameter number to the specified input stream, which will have the specified number of bytes.| |[setURL](../../../connect/jdbc/reference/seturl-method-sqlserverpreparedstatement.md)|Sets the designated parameter to the specified URL value.| |[unwrap](../../../connect/jdbc/reference/unwrap-method-sqlserverpreparedstatement.md)|Returns an object that implements the specified interface to allow access to the [!INCLUDE[jdbcNoVersion](../../../includes/jdbcnoversion_md.md)]-specific methods.| ## Inherited Methods |Class inherited from:|Methods| |---------------------------|-------------| |com.microsoft.sqlserver.jdbc.SQLServerStatement|cancel, clearWarnings, execute, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isPoolable, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout| |java.lang.Object|clone, equals, getClass, hashCode, notify, notifyAll, toString, wait| |java.sql.Statement|cancel, clearWarnings, execute, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout| |java.sql.Wrapper|isWrapperFor, unwrap| ## See Also [SQLServerPreparedStatement Class](../../../connect/jdbc/reference/sqlserverpreparedstatement-class.md)