public interface ISQLServerCallableStatement42 extends ISQLServerCallableStatement, ISQLServerPreparedStatement42
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO
Modifier and Type | Method and 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(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.
|
getDateTimeOffset, getDateTimeOffset, setDateTimeOffset
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
setObject, setObject, setObject, setObject
setDateTimeOffset
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
getResponseBuffering, setResponseBuffering
addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout
isWrapperFor, unwrap
void registerOutParameter(int index, SQLType sqlType) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
void registerOutParameter(int index, SQLType sqlType, String typeName) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
void registerOutParameter(int index, SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
void registerOutParameter(int index, SQLType sqlType, int precision, int scale) throws SQLServerException
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.
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.void setObject(String sCol, Object obj, SQLType jdbcType) throws SQLServerException
setObject
in interface CallableStatement
SQLServerException
void setObject(String sCol, Object obj, SQLType jdbcType, int scale) throws SQLServerException
setObject
in interface CallableStatement
SQLServerException
void setObject(String sCol, Object obj, SQLType jdbcType, int scale, boolean forceEncrypt) throws SQLServerException
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.void registerOutParameter(String parameterName, SQLType sqlType, String typeName) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
void registerOutParameter(String parameterName, SQLType sqlType, int scale) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
void registerOutParameter(String parameterName, SQLType sqlType, int precision, int scale) throws SQLServerException
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.
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.void registerOutParameter(String parameterName, SQLType sqlType) throws SQLServerException
registerOutParameter
in interface CallableStatement
SQLServerException
Copyright © 2017 Microsoft Corporation. All rights reserved.