ISQLServerCallableStatement
, ISQLServerCallableStatement42
, ISQLServerPreparedStatement
, ISQLServerPreparedStatement42
, ISQLServerStatement
, AutoCloseable
, CallableStatement
, PreparedStatement
, Statement
, Wrapper
public class SQLServerCallableStatement42 extends SQLServerCallableStatement implements ISQLServerCallableStatement42
stmtColumnEncriptionSetting
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method | Description |
---|---|---|
void |
registerOutParameter(int index,
SQLType sqlType) |
|
void |
registerOutParameter(int index,
SQLType sqlType,
int scale) |
|
void |
registerOutParameter(int index,
SQLType sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(int index,
SQLType sqlType,
String typeName) |
|
void |
registerOutParameter(String parameterName,
SQLType sqlType) |
|
void |
registerOutParameter(String parameterName,
SQLType sqlType,
int scale) |
|
void |
registerOutParameter(String parameterName,
SQLType sqlType,
int precision,
int scale) |
Registers the parameter in ordinal position index to be of JDBC type sqlType.
|
void |
registerOutParameter(String parameterName,
SQLType sqlType,
String typeName) |
|
void |
setObject(int index,
Object obj,
SQLType jdbcType) |
|
void |
setObject(int parameterIndex,
Object x,
SQLType targetSqlType,
int scaleOrLength) |
|
void |
setObject(int parameterIndex,
Object x,
SQLType targetSqlType,
Integer precision,
Integer scale) |
Sets the value of the designated parameter with the given object.
|
void |
setObject(int parameterIndex,
Object x,
SQLType targetSqlType,
Integer precision,
Integer scale,
boolean forceEncrypt) |
Sets the value of the designated parameter with the given object.
|
void |
setObject(String sCol,
Object obj,
SQLType jdbcType) |
|
void |
setObject(String sCol,
Object obj,
SQLType jdbcType,
int scale) |
|
void |
setObject(String sCol,
Object obj,
SQLType jdbcType,
int scale,
boolean forceEncrypt) |
Sets the value of the designated parameter with the given object.
|
getArray, getArray, getBigDecimal, getBigDecimal, getBigDecimal, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setURL, wasNull
getDateTimeOffset, getDateTimeOffset, setDateTimeOffset
setDateTimeOffset
getResponseBuffering, setResponseBuffering
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
addBatch, clearParameters, execute, executeLargeUpdate, executeQuery, executeUpdate, getMetaData, getParameterMetaData, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDouble, setFloat, setInt, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL
getArray, getArray, getAsciiStream, getAsciiStream, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, getBinaryStream, getBinaryStream, getBlob, getBlob, getBoolean, getBoolean, getByte, getByte, getBytes, getBytes, getCharacterStream, getCharacterStream, getClob, getClob, getDate, getDate, getDate, getDate, getDateTime, getDateTime, getDateTime, getDateTime, getDateTimeOffset, getDateTimeOffset, getDouble, getDouble, getFloat, getFloat, getInt, getInt, getLong, getLong, getMoney, getMoney, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, getRowId, getRowId, getShort, getShort, getSmallDateTime, getSmallDateTime, getSmallDateTime, getSmallDateTime, getSmallMoney, getSmallMoney, getSQLXML, getSQLXML, getString, getString, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDate, setDateTime, setDateTime, setDateTimeOffset, setDateTimeOffset, setDateTimeOffset, setDouble, setDouble, setFloat, setFloat, setInt, setInt, setLong, setLong, setMoney, setMoney, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRowId, setShort, setShort, setSmallDateTime, setSmallDateTime, setSmallMoney, setSmallMoney, setSQLXML, setString, setString, setStructured, setStructured, setStructured, setTime, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setUniqueIdentifier, setUniqueIdentifier, setURL, wasNull
addBatch, addBatch, clearBatch, clearParameters, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeQuery, executeQuery, executeUpdate, executeUpdate, getMetaData, getParameterMetaData, getParameterMetaData, getPreparedStatementHandle, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBigDecimal, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setBoolean, setByte, setByte, setBytes, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDate, setDateTime, setDateTime, setDateTimeOffset, setDateTimeOffset, setDateTimeOffset, setDouble, setDouble, setFloat, setFloat, setGeography, setGeometry, setInt, setInt, setLong, setLong, setMoney, setMoney, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNString, setNull, setNull, setObject, setObject, setObject, setObject, setObject, setRef, setRowId, setShort, setShort, setSmallDateTime, setSmallDateTime, setSmallMoney, setSmallMoney, setSQLXML, setString, setString, setStructured, setStructured, setStructured, setTime, setTime, setTime, setTime, setTime, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setTimestamp, setUnicodeStream, setUniqueIdentifier, setUniqueIdentifier, setURL
cancel, clearWarnings, close, closeOnCompletion, execute, execute, execute, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResponseBuffering, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isWrapperFor, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout, setResponseBuffering, toString, unwrap
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor, unwrap
public void registerOutParameter(int index, SQLType sqlType) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public void registerOutParameter(int index, SQLType sqlType, String typeName) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public void registerOutParameter(int index, SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public void registerOutParameter(int index, SQLType sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement42
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement42
index
- the first parameter is 1, the second is 2,...sqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public void setObject(String sCol, Object obj, SQLType jdbcType) throws SQLServerException
setObject
in interface CallableStatement
setObject
in interface ISQLServerCallableStatement42
SQLServerException
public void setObject(String sCol, Object obj, SQLType jdbcType, int scale) throws SQLServerException
setObject
in interface CallableStatement
setObject
in interface ISQLServerCallableStatement42
SQLServerException
public void setObject(String sCol, Object obj, SQLType jdbcType, int scale, boolean forceEncrypt) throws SQLServerException
ISQLServerCallableStatement42
setObject
in interface ISQLServerCallableStatement42
sCol
- the name of the parameterobj
- the object containing the input parameter valuejdbcType
- the SQL type to be sent to the databasescale
- scale the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.forceEncrypt
- true if force encryption is on, false if force encryption is offSQLServerException
- If any errors occur.public void registerOutParameter(String parameterName, SQLType sqlType, String typeName) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public void registerOutParameter(String parameterName, SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public void registerOutParameter(String parameterName, SQLType sqlType, int precision, int scale) throws SQLServerException
ISQLServerCallableStatement42
The JDBC type specified by sqlType for an OUT parameter determines the Java type that must be used in the get method to read the value of that parameter.
registerOutParameter
in interface ISQLServerCallableStatement42
parameterName
- the name of the parametersqlType
- the JDBC type code defined by SQLType to use to register the OUT Parameter.precision
- the sum of the desired number of digits to the left and right of the decimal point. It must be greater than or equal to zero.scale
- the desired number of digits to the right of the decimal point. It must be greater than or equal to zero.SQLServerException
- If any errors occur.public void registerOutParameter(String parameterName, SQLType sqlType) throws SQLServerException
registerOutParameter
in interface CallableStatement
registerOutParameter
in interface ISQLServerCallableStatement42
SQLServerException
public final void setObject(int index, Object obj, SQLType jdbcType) throws SQLServerException
setObject
in interface ISQLServerPreparedStatement42
setObject
in interface PreparedStatement
SQLServerException
public final void setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength) throws SQLServerException
setObject
in interface ISQLServerPreparedStatement42
setObject
in interface PreparedStatement
SQLServerException
public final void setObject(int parameterIndex, Object x, SQLType targetSqlType, Integer precision, Integer scale) throws SQLServerException
ISQLServerPreparedStatement42
ISQLServerPreparedStatement42.setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)
, except that it assumes a
scale of zero.
The default implementation will throw SQLFeatureNotSupportedException
setObject
in interface ISQLServerPreparedStatement42
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type to be sent to the databaseprecision
- the precision of the columnscale
- the scale of the columnSQLServerException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method
is called on a closed PreparedStatement
public final void setObject(int parameterIndex, Object x, SQLType targetSqlType, Integer precision, Integer scale, boolean forceEncrypt) throws SQLServerException
ISQLServerPreparedStatement42
ISQLServerPreparedStatement42.setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)
, except that it assumes a
scale of zero.
The default implementation will throw SQLFeatureNotSupportedException
setObject
in interface ISQLServerPreparedStatement42
parameterIndex
- the first parameter is 1, the second is 2, ...x
- the object containing the input parameter valuetargetSqlType
- the SQL type to be sent to the databaseprecision
- the precision of the columnscale
- the scale of the columnforceEncrypt
- If the boolean forceEncrypt is set to true, the query parameter will only be set if the designation column is encrypted and Always
Encrypted is enabled on the connection or on the statement. If the boolean forceEncrypt is set to false, the driver will not force
encryption on parameters.SQLServerException
- if parameterIndex does not correspond to a parameter marker in the SQL statement; if a database access error occurs or this method
is called on a closed PreparedStatement
Copyright © 2018 Microsoft Corporation. All rights reserved.