public class CallableStatement extends PreparedStatement implements CallableStatement
{?= call <procedure-name>[<arg1>,<arg2>, ...]}
{call <procedure-name>[<arg1>,<arg2>, ...]}
IN parameter values are set using the set methods inherited from
PreparedStatement. The type of all OUT parameters must be
registered prior to executing the stored procedure; their values
are retrieved after execution via the get methods provided here.
A CallableStatement can return one ResultSet object or
multiple ResultSet objects. Multiple
ResultSet objects are handled using operations
inherited from Statement.
For maximum portability, a call's ResultSet objects and
update counts should be processed prior to getting the values of output
parameters.
paramTypes, shouldPreparedbatchCount, batchMajorVersion, batchMinorVersion, blobColParam, colMap, connection, conObjName, curId, cursorFirstCount, cursorFirstOver, fetchSize, generateKey, isBatchSql, isBuildingMap, isCallable, isCallProc, isClosed, isExeBatch, isFetchSql, isFunction, isOutP, isPoolable, isPrepared, isQuery, isReturnCount, maxSize, paramAllStrs, paramBytes, paramConstMap, paramCount, paramList, paramLobs, paramNameFunc, paramNameIndex, paramNameToIndex, queryTime, resultDirection, schemaName, serverBatchCount, sqlQuery, stId, stmIsOver, stmWarning, tableName, updateCount| 构造器和说明 |
|---|
CallableStatement(Connection connection,
String database,
String originalSql)
由于服务器的调整,服务器端不再用"call"语句来调用存储过程,只能在接口处理语句,并转换为"execute"语句发给服务器端
|
| 限定符和类型 | 方法和说明 |
|---|---|
Array |
getArray(int i)
Retrieves the value of the designated JDBC
ARRAY parameter as an
Array object in the Java programming language. |
Array |
getArray(String parameterName)
Retrieves the value of a JDBC
ARRAY parameter as an
Array object in the Java programming language. |
BigDecimal |
getBigDecimal(int parameterIndex)
Retrieves the value of the designated JDBC
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
BigDecimal |
getBigDecimal(int parameterIndex,
int scale)
已过时。
use
getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName) |
BigDecimal |
getBigDecimal(String parameterName)
Retrieves the value of a JDBC
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains. |
Blob |
getBlob(int parameterIndex)
Retrieves the value of the designated JDBC
BLOB parameter as a
Blob object in the Java programming language. |
Blob |
getBlob(String parameterName)
Retrieves the value of a JDBC
BLOB parameter as a
Blob object in the Java programming language. |
boolean |
getBoolean(int parameterIndex)
Retrieves the value of the designated JDBC
BIT parameter as a
boolean in the Java programming language. |
boolean |
getBoolean(String parameterName)
Retrieves the value of a JDBC
BIT parameter as a
boolean in the Java programming language. |
byte |
getByte(int parameterIndex)
Retrieves the value of the designated JDBC
TINYINT parameter
as a byte in the Java programming language. |
byte |
getByte(String parameterName)
Retrieves the value of a JDBC
TINYINT parameter as a byte
in the Java programming language. |
byte[] |
getBytes(int parameterIndex)
Retrieves the value of the designated JDBC
BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language. |
byte[] |
getBytes(String parameterName)
Retrieves the value of a JDBC
BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language. |
Reader |
getCharacterStream(int parameterIndex) |
Reader |
getCharacterStream(String parameterName) |
Clob |
getClob(int parameterIndex)
Retrieves the value of the designated JDBC
CLOB parameter as a
Clob object in the Java programming language. |
Clob |
getClob(String parameterName)
Retrieves the value of a JDBC
CLOB parameter as a
Clob object in the Java programming language. |
Date |
getDate(int parameterIndex)
Retrieves the value of the designated JDBC
DATE parameter as a
java.sql.Date object. |
Date |
getDate(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
Date |
getDate(String parameterName)
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object. |
Date |
getDate(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date. |
double |
getDouble(int parameterIndex)
Retrieves the value of the designated JDBC
DOUBLE parameter as a double
in the Java programming language. |
double |
getDouble(String parameterName)
Retrieves the value of a JDBC
DOUBLE parameter as a double
in the Java programming language. |
float |
getFloat(int parameterIndex)
Retrieves the value of the designated JDBC
FLOAT parameter
as a float in the Java programming language. |
float |
getFloat(String parameterName)
Retrieves the value of a JDBC
FLOAT parameter as a float
in the Java programming language. |
int |
getInt(int parameterIndex)
Retrieves the value of the designated JDBC
INTEGER parameter
as an int in the Java programming language. |
int |
getInt(String parameterName)
Retrieves the value of a JDBC
INTEGER parameter as an int
in the Java programming language. |
String |
getInterval(int parameterIndex)
以时间间隔类型 INTERVAL 获取当前行的指定列中
返回两个时间
|
long |
getLong(int parameterIndex)
Retrieves the value of the designated JDBC
BIGINT parameter
as a long in the Java programming language. |
long |
getLong(String parameterName)
Retrieves the value of a JDBC
BIGINT parameter as a long
in the Java programming language. |
Reader |
getNCharacterStream(int parameterIndex) |
Reader |
getNCharacterStream(String parameterName) |
NClob |
getNClob(int parameterIndex) |
NClob |
getNClob(String parameterName) |
String |
getNString(int parameterIndex) |
String |
getNString(String parameterName) |
Object |
getObject(int parameterIndex)
Retrieves the value of the designated parameter as an
Object
in the Java programming language. |
<T> T |
getObject(int parameterIndex,
Class<T> type) |
Object |
getObject(int paramIndex,
Map map)
Returns an object representing the value of OUT parameter
i and uses map for the custom
mapping of the parameter value. |
Object |
getObject(String parameterName)
Retrieves the value of a parameter as an
Object in the Java
programming language. |
<T> T |
getObject(String parameterName,
Class<T> type) |
Object |
getObject(String parameterName,
Map<String,Class<?>> map) |
Ref |
getRef(int i)
Retrieves the value of the designated JDBC
REF(<structured-type>)
parameter as a Ref object in the Java programming language. |
Ref |
getRef(String parameterName)
Retrieves the value of a JDBC
REF(<structured-type>)
parameter as a Ref object in the Java programming language. |
RowId |
getRowId(int parameterIndex) |
RowId |
getRowId(String parameterName) |
short |
getShort(int parameterIndex)
Retrieves the value of the designated JDBC
SMALLINT parameter
as a short in the Java programming language. |
short |
getShort(String parameterName)
Retrieves the value of a JDBC
SMALLINT parameter as a short
in the Java programming language. |
SQLXML |
getSQLXML(int parameterIndex) |
SQLXML |
getSQLXML(String parameterName) |
String |
getString(int parameterIndex)
Retrieves the value of the designated JDBC
CHAR,
VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language. |
String |
getString(String parameterName)
Retrieves the value of a JDBC
CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language. |
Time |
getTime(int parameterIndex)
Retrieves the value of the designated JDBC
TIME parameter as a
java.sql.Time object. |
Time |
getTime(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
Time |
getTime(String parameterName)
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object. |
Time |
getTime(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time. |
Timestamp |
getTimestamp(int parameterIndex)
Retrieves the value of the designated JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object. |
Timestamp |
getTimestamp(int parameterIndex,
Calendar cal)
Retrieves the value of the designated JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
Timestamp |
getTimestamp(String parameterName)
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object. |
Timestamp |
getTimestamp(String parameterName,
Calendar cal)
Retrieves the value of a JDBC
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object. |
URL |
getURL(int parameterIndex)
Retrieves the value of the designated JDBC
DATALINK parameter as a
java.net.URL object. |
URL |
getURL(String parameterName)
Retrieves the value of a JDBC
DATALINK parameter as a
java.net.URL object. |
boolean |
isPoolable() |
void |
registerOutParameter(int parameterIndex,
int sqlType)
Registers the OUT parameter in ordinal position
parameterIndex to the JDBC type
sqlType. |
void |
registerOutParameter(int parameterIndex,
int sqlType,
int scale)
Registers the parameter in ordinal position
parameterIndex to be of JDBC type
sqlType. |
void |
registerOutParameter(int paramIndex,
int sqlType,
String typeName)
Registers the designated output parameter.
|
void |
registerOutParameter(String parameterName,
int sqlType)
Registers the OUT parameter named
parameterName to the JDBC type
sqlType. |
void |
registerOutParameter(String parameterName,
int sqlType,
int scale)
Registers the parameter named
parameterName to be of JDBC type
sqlType. |
void |
registerOutParameter(String parameterName,
int sqlType,
String typeName)
Registers the designated output parameter.
|
void |
setAsciiStream(String parameterName,
InputStream x) |
void |
setAsciiStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setAsciiStream(String parameterName,
InputStream x,
long length) |
void |
setBigDecimal(String parameterName,
BigDecimal x)
Sets the designated parameter to the given
java.math.BigDecimal value. |
void |
setBinaryStream(String parameterName,
InputStream x) |
void |
setBinaryStream(String parameterName,
InputStream x,
int length)
Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
|
void |
setBinaryStream(String parameterName,
InputStream x,
long length) |
void |
setBlob(String parameterName,
Blob x) |
void |
setBlob(String parameterName,
InputStream inputStream) |
void |
setBlob(String parameterName,
InputStream inputStream,
long length) |
void |
setBoolean(String parameterName,
boolean x)
Sets the designated parameter to the given Java
boolean value. |
void |
setByte(String parameterName,
byte x)
Sets the designated parameter to the given Java
byte value. |
void |
setBytes(String parameterName,
byte[] x)
Sets the designated parameter to the given Java array of bytes.
|
void |
setCharacterStream(String parameterName,
Reader reader) |
void |
setCharacterStream(String parameterName,
Reader reader,
int length)
Sets the designated parameter to the given
Reader
object, which is the given number of characters long. |
void |
setCharacterStream(String parameterName,
Reader reader,
long length) |
void |
setClob(String parameterName,
Clob x) |
void |
setClob(String parameterName,
Reader reader) |
void |
setClob(String parameterName,
Reader reader,
long length) |
void |
setDate(String parameterName,
Date x)
Sets the designated parameter to the given
java.sql.Date value. |
void |
setDate(String parameterName,
Date x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Date value,
using the given Calendar object. |
void |
setDouble(String parameterName,
double x)
Sets the designated parameter to the given Java
double value. |
void |
setFloat(String parameterName,
float x)
Sets the designated parameter to the given Java
float value. |
void |
setInt(String parameterName,
int x)
Sets the designated parameter to the given Java
int value. |
void |
setLong(String parameterName,
long x)
Sets the designated parameter to the given Java
long value. |
void |
setNCharacterStream(String parameterName,
Reader reader) |
void |
setNCharacterStream(String parameterName,
Reader reader,
long length) |
void |
setNClob(String parameterName,
NClob value)
jre 1.4.2
|
void |
setNClob(String parameterName,
Reader reader) |
void |
setNClob(String parameterName,
Reader reader,
long length) |
void |
setNString(String parameterName,
String value) |
void |
setNull(String parameterName,
int sqlType)
Sets the designated parameter to SQL
NULL. |
void |
setNull(String parameterName,
int sqlType,
String typeName)
Sets the designated parameter to SQL
NULL. |
void |
setObject(String parameterName,
Object x)
Sets the value of the designated parameter with the given object.
|
void |
setObject(String parameterName,
Object x,
int targetSqlType)
Sets the value of the designated parameter with the given object.
|
void |
setObject(String parameterName,
Object x,
int targetSqlType,
int scale)
Sets the value of the designated parameter with the given object.
|
void |
setRowId(String parameterName,
RowId x)
jre 1.4.2
|
void |
setShort(String parameterName,
short x)
Sets the designated parameter to the given Java
short value. |
void |
setSQLXML(String parameterName,
SQLXML xmlObject) |
void |
setString(String parameterName,
String x)
Sets the designated parameter to the given Java
String value. |
void |
setTime(String parameterName,
Time x)
Sets the designated parameter to the given
java.sql.Time value. |
void |
setTime(String parameterName,
Time x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Time value,
using the given Calendar object. |
void |
setTimestamp(String parameterName,
Timestamp x)
Sets the designated parameter to the given
java.sql.Timestamp value. |
void |
setTimestamp(String parameterName,
Timestamp x,
Calendar cal)
Sets the designated parameter to the given
java.sql.Timestamp value,
using the given Calendar object. |
void |
setURL(String parameterName,
URL val)
Sets the designated parameter to the given
java.net.URL object. |
boolean |
wasNull()
Retrieves whether the last OUT parameter read had the value of
SQL
NULL. |
addBatch, addBatch1, clearBatch, clearParameters, execute, executeBatch, executeQuery, executeUpdate, get0x0Bytes, getInsertRowids, getMetaData, getParameterMetaData, getParamType, getSetRedHorseTypeFromJavaType, isClosed, isWrapperFor, setArray, setAsciiStream, setAsciiStream, setAsciiStream, setBigDecimal, setBinaryStream, setBinaryStream, setBinaryStream, setBlob, setBlob, setBlob, setBoolean, setByte, setBytes, setCharacterStream, setCharacterStream, setCharacterStream, setClob, setClob, setClob, setDate, setDate, setDateTime_TZ, setDatetime, setDouble, setFloat, setInt, setInterval_D, setInterval_D2H, setInterval_D2M, setInterval_D2S, setInterval_H, setInterval_H2M, setInterval_H2S, setInterval_M, setInterval_M2S, setInterval_MI, setInterval_S, setInterval_Y, setInterval_Y2M, setInterval, setLong, setNCharacterStream, setNCharacterStream, setNClob, setNClob, setNClob, setNString, setNull, setNull, setObject, setObject, setObject, setPoolable, setRef, setRowId, setShort, setSQLXML, setString, setTime_TZ, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURL, unwrapaddBatch, byteToDouble, byteToFloat, byteToInt, byteToLong, byteToNumeric, byteToShort, cancel, checkBCountAndPCount, checkCallInParam, checkCallOutParam, checkCallOutParam, checkGeneratedKey, checkSqlLen, checkSQLNull, clearWarnings, close, closeOnCompletion, distillTbName, execute, execute, execute, execute, execute, executeLob, executeQuery, executeQueryFetch, executeStream, executeStream, executeStreamLoad, executeUpdate, executeUpdate, executeUpdate, executeUpdate, executeWithNoCallCheck, firstResultSet, flush, getColumnName, getConnection, getCursorFirstCount, getErr_Code, getExecuteStr, getFetchDirection, getFetchSize, getGeneratedKeys, getLobResultSet, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getProcName, getProcParamsName, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getRowid, getServerCursor, getServerMajorVersion, getServerMinorVersion, getSqlsEffectCountVector, getUpdateCount, getWarnings, initExecuteEnviorment, intToByte, isCloseOnCompletion, isFetchSql, isLimitParamSql, isReturnValues, isStmIsOver, longToByte, manificateRs, reSizeBuffer, resumeRowid, resumeSendType, rsRowData, sendTaskNum, serverSupportBatch, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setFetchSql, setIndexMaping, setMaxFieldSize, setMaxRows, setQueryTimeout, setRecv_mode, setResultsetFirstSize, setServerCursor, setSQLExecuteMG, setStmIsOver, setStmWarning, toStringclone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, waitregisterOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, registerOutParameter, setObject, setObjectaddBatch, 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, setObject, setObject, setRef, setRowId, setShort, setSQLXML, setString, setTime, setTime, setTimestamp, setTimestamp, setUnicodeStream, setURLaddBatch, 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, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeoutisWrapperFor, unwrappublic CallableStatement(Connection connection, String database, String originalSql) throws SQLException
connection - database - originalSql - SQLExceptionpublic void registerOutParameter(int parameterIndex,
int sqlType)
throws SQLException
parameterIndex to the JDBC type
sqlType. All OUT parameters must be registered
before a stored procedure is executed.
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.
If the JDBC type expected to be returned to this output parameter
is specific to this particular database, sqlType
should be java.sql.Types.OTHER. The method
getObject(int) retrieves the value.
registerOutParameter 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onsqlType - the JDBC type code defined by java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.SQLException - if a database access error occursTypespublic void registerOutParameter(int parameterIndex,
int sqlType,
int scale)
throws SQLException
parameterIndex to be of JDBC type
sqlType. This method must be called
before a stored procedure is executed.
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.
This version of registerOutParameter should be
used when the parameter is of JDBC type NUMERIC
or DECIMAL.
registerOutParameter 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onsqlType - the SQL type code defined by java.sql.Types.scale - the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero.SQLException - if a database access error occursTypespublic boolean wasNull()
throws SQLException
NULL. Note that this method should be called only after
calling a getter method; otherwise, there is no value to use in
determining whether it is null or not.wasNull 在接口中 CallableStatementtrue if the last parameter read was SQL
NULL; false otherwiseSQLException - if a database access error occurspublic String getString(int parameterIndex) throws SQLException
CHAR,
VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language.
For the fixed-length type JDBC CHAR,
the String object
returned has exactly the same value the JDBC
CHAR value had in the
database, including any padding added by the database.
getString 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL,
the result
is null.SQLException - if a database access error occurssetString(java.lang.String, java.lang.String)public boolean getBoolean(int parameterIndex)
throws SQLException
BIT parameter as a
boolean in the Java programming language.getBoolean 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL,
the result is false.SQLException - if a database access error occurssetBoolean(java.lang.String, boolean)public byte getByte(int parameterIndex)
throws SQLException
TINYINT parameter
as a byte in the Java programming language.getByte 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetByte(java.lang.String, byte)public short getShort(int parameterIndex)
throws SQLException
SMALLINT parameter
as a short in the Java programming language.getShort 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetShort(java.lang.String, short)public int getInt(int parameterIndex)
throws SQLException
INTEGER parameter
as an int in the Java programming language.getInt 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetInt(java.lang.String, int)public long getLong(int parameterIndex)
throws SQLException
BIGINT parameter
as a long in the Java programming language.getLong 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetLong(java.lang.String, long)public float getFloat(int parameterIndex)
throws SQLException
FLOAT parameter
as a float in the Java programming language.getFloat 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetFloat(java.lang.String, float)public double getDouble(int parameterIndex)
throws SQLException
DOUBLE parameter as a double
in the Java programming language.getDouble 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is 0.SQLException - if a database access error occurssetDouble(java.lang.String, double)public BigDecimal getBigDecimal(int parameterIndex, int scale) throws SQLException
getBigDecimal(int parameterIndex)
or getBigDecimal(String parameterName)NUMERIC parameter as a
java.math.BigDecimal object with scale digits to
the right of the decimal point.getBigDecimal 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onscale - the number of digits to the right of the decimal pointNULL, the result
is null.SQLException - if a database access error occurssetBigDecimal(java.lang.String, java.math.BigDecimal)public byte[] getBytes(int parameterIndex)
throws SQLException
BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language.getBytes 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is null.SQLException - if a database access error occurssetBytes(java.lang.String, byte[])public Date getDate(int parameterIndex) throws SQLException
DATE parameter as a
java.sql.Date object.getDate 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is null.SQLException - if a database access error occurssetDate(java.lang.String, java.sql.Date)public Time getTime(int parameterIndex) throws SQLException
TIME parameter as a
java.sql.Time object.getTime 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is null.SQLException - if a database access error occurssetTime(java.lang.String, java.sql.Time)public Timestamp getTimestamp(int parameterIndex) throws SQLException
TIMESTAMP parameter as a
java.sql.Timestamp object.getTimestamp 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result
is null.SQLException - if a database access error occurssetTimestamp(java.lang.String, java.sql.Timestamp)public Object getObject(int parameterIndex) throws SQLException
Object
in the Java programming language. If the value is an SQL NULL,
the driver returns a Java null.
This method returns a Java object whose type corresponds to the JDBC
type that was registered for this parameter using the method
registerOutParameter. By registering the target JDBC
type as java.sql.Types.OTHER, this method can be used
to read database-specific abstract data types.
getObject 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onjava.lang.Object holding the OUT parameter valueSQLException - if a database access error occursTypes,
setObject(java.lang.String, java.lang.Object, int, int)public BigDecimal getBigDecimal(int parameterIndex) throws SQLException
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.getBigDecimal 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so onNULL, the result is null.SQLException - if a database access error occurssetBigDecimal(java.lang.String, java.math.BigDecimal)public Ref getRef(int i) throws SQLException
REF(<structured-type>)
parameter as a Ref object in the Java programming language.getRef 在接口中 CallableStatementi - the first parameter is 1, the second is 2,
and so onRef object in the
Java programming language. If the value was SQL NULL, the value
null is returned.SQLException - if a database access error occurspublic Blob getBlob(int parameterIndex) throws SQLException
BLOB parameter as a
Blob object in the Java programming language.getBlob 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2, and so onBlob object in the
Java programming language. If the value was SQL NULL, the value
null is returned.SQLException - if a database access error occurspublic Clob getClob(int parameterIndex) throws SQLException
CLOB parameter as a
Clob object in the Java programming language.getClob 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2, and
so onClob object in the
Java programming language. If the value was SQL NULL, the
value null is returned.SQLException - if a database access error occurspublic Array getArray(int i) throws SQLException
ARRAY parameter as an
Array object in the Java programming language.getArray 在接口中 CallableStatementi - the first parameter is 1, the second is 2, and
so onArray object in
the Java programming language. If the value was SQL NULL, the
value null is returned.SQLException - if a database access error occurspublic Date getDate(int parameterIndex, Calendar cal) throws SQLException
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
With a Calendar object, the driver
can calculate the date taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getDate 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the dateNULL, the result
is null.SQLException - if a database access error occurssetDate(java.lang.String, java.sql.Date)public Time getTime(int parameterIndex, Calendar cal) throws SQLException
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
With a Calendar object, the driver
can calculate the time taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getTime 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the timeNULL, the result
is null.SQLException - if a database access error occurssetTime(java.lang.String, java.sql.Time)public Timestamp getTimestamp(int parameterIndex, Calendar cal) throws SQLException
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
With a Calendar object, the driver
can calculate the timestamp taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getTimestamp 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,
and so oncal - the Calendar object the driver will use
to construct the timestampNULL, the result
is null.SQLException - if a database access error occurssetTimestamp(java.lang.String, java.sql.Timestamp)public String getInterval(int parameterIndex) throws SQLException
返回两个时间
SQLExceptionpublic void registerOutParameter(int paramIndex,
int sqlType,
String typeName)
throws SQLException
registerOutParameter
should be used for a user-defined or REF output parameter. Examples
of user-defined types include: STRUCT, DISTINCT,
JAVA_OBJECT, and named array types.
Before executing a stored procedure call, you must explicitly
call registerOutParameter to register the type from
java.sql.Types for each
OUT parameter. For a user-defined parameter, the fully-qualified SQL
type name of the parameter should also be given, while a REF
parameter requires that the fully-qualified type name of the
referenced type be given. A JDBC driver that does not need the
type code and type name information may ignore it. To be portable,
however, applications should always provide these values for
user-defined and REF parameters.
Although it is intended for user-defined and REF parameters,
this method may be used to register a parameter of any JDBC type.
If the parameter does not have a user-defined or REF type, the
typeName parameter is ignored.
Note: When reading the value of an out parameter, you must use the getter method whose Java type corresponds to the parameter's registered SQL type.
registerOutParameter 在接口中 CallableStatementparamIndex - the first parameter is 1, the second is 2,...sqlType - a value from TypestypeName - the fully-qualified name of an SQL structured typeSQLException - if a database access error occursTypespublic void registerOutParameter(String parameterName, int sqlType) throws SQLException
parameterName to the JDBC type
sqlType. All OUT parameters must be registered
before a stored procedure is executed.
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.
If the JDBC type expected to be returned to this output parameter
is specific to this particular database, sqlType
should be java.sql.Types.OTHER. The method
getObject(int) retrieves the value.
registerOutParameter 在接口中 CallableStatementparameterName - the name of the parametersqlType - the JDBC type code defined by java.sql.Types.
If the parameter is of JDBC type NUMERIC
or DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.SQLException - if a database access error occursTypespublic void registerOutParameter(String parameterName, int sqlType, int scale) throws SQLException
parameterName to be of JDBC type
sqlType. This method must be called
before a stored procedure is executed.
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.
This version of registerOutParameter should be
used when the parameter is of JDBC type NUMERIC
or DECIMAL.
registerOutParameter 在接口中 CallableStatementparameterName - the name of the parametersqlType - SQL type code defined by java.sql.Types.scale - the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero.SQLException - if a database access error occursTypespublic void registerOutParameter(String parameterName, int sqlType, String typeName) throws SQLException
registerOutParameter
should be used for a user-named or REF output parameter. Examples
of user-named types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Before executing a stored procedure call, you must explicitly
call registerOutParameter to register the type from
java.sql.Types for each
OUT parameter. For a user-named parameter the fully-qualified SQL
type name of the parameter should also be given, while a REF
parameter requires that the fully-qualified type name of the
referenced type be given. A JDBC driver that does not need the
type code and type name information may ignore it. To be portable,
however, applications should always provide these values for
user-named and REF parameters.
Although it is intended for user-named and REF parameters, this method may be used to register a parameter of any JDBC type. If the parameter does not have a user-named or REF type, the typeName parameter is ignored.
Note: When reading the value of an out parameter, you
must use the getXXX method whose Java type XXX corresponds to the
parameter's registered SQL type.
registerOutParameter 在接口中 CallableStatementparameterName - the name of the parametersqlType - a value from TypestypeName - the fully-qualified name of an SQL structured typeSQLException - if a database access error occursTypespublic URL getURL(int parameterIndex) throws SQLException
DATALINK parameter as a
java.net.URL object.getURL 在接口中 CallableStatementparameterIndex - the first parameter is 1, the second is 2,...java.net.URL object that represents the
JDBC DATALINK value used as the designated
parameterSQLException - if a database access error occurs,
or if the URL being returned is
not a valid URL on the Java platformsetURL(java.lang.String, java.net.URL)public void setURL(String parameterName, URL val) throws SQLException
java.net.URL object.
The driver converts this to an SQL DATALINK value when
it sends it to the database.setURL 在接口中 CallableStatementparameterName - the name of the parameterval - the parameter valueSQLException - if a database access error occurs,
or if a URL is malformedgetURL(int)public void setNull(String parameterName, int sqlType) throws SQLException
NULL.
Note: You must specify the parameter's SQL type.
setNull 在接口中 CallableStatementparameterName - the name of the parametersqlType - the SQL type code defined in java.sql.TypesSQLException - if a database access error occurspublic void setBoolean(String parameterName, boolean x) throws SQLException
boolean value.
The driver converts this
to an SQL BIT value when it sends it to the database.setBoolean 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetBoolean(int)public void setByte(String parameterName, byte x) throws SQLException
byte value.
The driver converts this
to an SQL TINYINT value when it sends it to the database.setByte 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetByte(int)public void setShort(String parameterName, short x) throws SQLException
short value.
The driver converts this
to an SQL SMALLINT value when it sends it to the database.setShort 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetShort(int)public void setInt(String parameterName, int x) throws SQLException
int value.
The driver converts this
to an SQL INTEGER value when it sends it to the database.setInt 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetInt(int)public void setLong(String parameterName, long x) throws SQLException
long value.
The driver converts this
to an SQL BIGINT value when it sends it to the database.setLong 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetLong(int)public void setFloat(String parameterName, float x) throws SQLException
float value.
The driver converts this
to an SQL FLOAT value when it sends it to the database.setFloat 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetFloat(int)public void setDouble(String parameterName, double x) throws SQLException
double value.
The driver converts this
to an SQL DOUBLE value when it sends it to the database.setDouble 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetDouble(int)public void setBigDecimal(String parameterName, BigDecimal x) throws SQLException
java.math.BigDecimal value.
The driver converts this to an SQL NUMERIC value when
it sends it to the database.setBigDecimal 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetBigDecimal(int, int)public void setString(String parameterName, String x) throws SQLException
String value.
The driver converts this
to an SQL VARCHAR or LONGVARCHAR value
(depending on the argument's
size relative to the driver's limits on VARCHAR values)
when it sends it to the database.setString 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetString(int)public void setBytes(String parameterName, byte[] x) throws SQLException
VARBINARY or
LONGVARBINARY (depending on the argument's size relative
to the driver's limits on VARBINARY values) when it sends
it to the database.setBytes 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occurspublic void setDate(String parameterName, Date x) throws SQLException
java.sql.Date value.
The driver converts this
to an SQL DATE value when it sends it to the database.setDate 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetDate(int)public void setTime(String parameterName, Time x) throws SQLException
java.sql.Time value.
The driver converts this
to an SQL TIME value when it sends it to the database.setTime 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetTime(int)public void setTimestamp(String parameterName, Timestamp x) throws SQLException
java.sql.Timestamp value.
The driver
converts this to an SQL TIMESTAMP value when it sends it to the
database.setTimestamp 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valueSQLException - if a database access error occursgetTimestamp(int)public void setAsciiStream(String parameterName, InputStream x, int length) throws SQLException
LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. Data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setAsciiStream 在接口中 CallableStatementparameterName - the name of the parameterx - the Java input stream that contains the ASCII parameter valuelength - the number of bytes in the streamSQLException - if a database access error occurspublic void setBinaryStream(String parameterName, InputStream x, int length) throws SQLException
LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream object. The data will be read from the stream
as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setBinaryStream 在接口中 CallableStatementparameterName - the name of the parameterx - the java input stream which contains the binary parameter valuelength - the number of bytes in the streamSQLException - if a database access error occurspublic void setObject(String parameterName, Object x, int targetSqlType, int scale) throws SQLException
java.lang equivalent objects should be used.
The given Java object will be converted to the given targetSqlType before being sent to the database.
If the object has a custom mapping (is of a class implementing the
interface SQLData),
the JDBC driver should call the method SQLData.writeSQL to write it
to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref, Blob, Clob, Struct,
or Array, the driver should pass it to the database as a
value of the corresponding SQL type.
Note that this method may be used to pass datatabase- specific abstract data types.
setObject 在接口中 CallableStatementparameterName - the name of the parameterx - the object containing the input parameter valuetargetSqlType - the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type.scale - for java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal point. For all other
types, this value will be ignored.SQLException - if a database access error occursTypes,
getObject(int)public void setObject(String parameterName, Object x, int targetSqlType) throws SQLException
setObject
above, except that it assumes a scale of zero.setObject 在接口中 CallableStatementparameterName - the name of the parameterx - the object containing the input parameter valuetargetSqlType - the SQL type (as defined in java.sql.Types) to be
sent to the databaseSQLException - if a database access error occursgetObject(int)public void setObject(String parameterName, Object x) throws SQLException
Object; therefore, the
java.lang equivalent objects should be used for built-in types.
The JDBC specification specifies a standard mapping from
Java Object types to SQL types. The given argument
will be converted to the corresponding SQL type before being
sent to the database.
Note that this method may be used to pass datatabase- specific abstract data types, by using a driver-specific Java type.
If the object is of a class implementing the interface SQLData,
the JDBC driver should call the method SQLData.writeSQL
to write it to the SQL data stream.
If, on the other hand, the object is of a class implementing
Ref, Blob, Clob, Struct,
or Array, the driver should pass it to the database as a
value of the corresponding SQL type.
This method throws an exception if there is an ambiguity, for example, if the object is of a class implementing more than one of the interfaces named above.
setObject 在接口中 CallableStatementparameterName - the name of the parameterx - the object containing the input parameter valueSQLException - if a database access error occurs or if the given
Object parameter is ambiguousgetObject(int)public void setCharacterStream(String parameterName, Reader reader, int length) throws SQLException
Reader
object, which is the given number of characters long.
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader object. The data will be read from the stream
as needed until end-of-file is reached. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream object or your own subclass that implements the standard interface.
setCharacterStream 在接口中 CallableStatementparameterName - the name of the parameterreader - the java.io.Reader object that
contains the UNICODE data used as the designated parameterlength - the number of characters in the streamSQLException - if a database access error occurspublic void setDate(String parameterName, Date x, Calendar cal) throws SQLException
java.sql.Date value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL DATE value,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the date
taking into account a custom timezone. If no
Calendar object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.setDate 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valuecal - the Calendar object the driver will use
to construct the dateSQLException - if a database access error occursgetDate(int)public void setTime(String parameterName, Time x, Calendar cal) throws SQLException
java.sql.Time value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL TIME value,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the time
taking into account a custom timezone. If no
Calendar object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.setTime 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valuecal - the Calendar object the driver will use
to construct the timeSQLException - if a database access error occursgetTime(int)public void setTimestamp(String parameterName, Timestamp x, Calendar cal) throws SQLException
java.sql.Timestamp value,
using the given Calendar object. The driver uses
the Calendar object to construct an SQL TIMESTAMP value,
which the driver then sends to the database. With a
a Calendar object, the driver can calculate the timestamp
taking into account a custom timezone. If no
Calendar object is specified, the driver uses the default
timezone, which is that of the virtual machine running the application.setTimestamp 在接口中 CallableStatementparameterName - the name of the parameterx - the parameter valuecal - the Calendar object the driver will use
to construct the timestampSQLException - if a database access error occursgetTimestamp(int)public void setNull(String parameterName, int sqlType, String typeName) throws SQLException
NULL.
This version of the method setNull should
be used for user-defined types and REF type parameters. Examples
of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Note: To be portable, applications must give the SQL type code and the fully-qualified SQL type name when specifying a NULL user-defined or REF parameter. In the case of a user-defined type the name is the type name of the parameter itself. For a REF parameter, the name is the type name of the referenced type. If a JDBC driver does not need the type code or type name information, it may ignore it.
Although it is intended for user-defined and Ref parameters, this method may be used to set a null parameter of any JDBC type. If the parameter does not have a user-defined or REF type, the given typeName is ignored.
setNull 在接口中 CallableStatementparameterName - the name of the parametersqlType - a value from java.sql.TypestypeName - the fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL REF valueSQLException - if a database access error occurspublic String getString(String parameterName) throws SQLException
CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language.
For the fixed-length type JDBC CHAR,
the String object
returned has exactly the same value the JDBC
CHAR value had in the
database, including any padding added by the database.
getString 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is null.SQLException - if a database access error occurssetString(java.lang.String, java.lang.String)public boolean getBoolean(String parameterName) throws SQLException
BIT parameter as a
boolean in the Java programming language.getBoolean 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is false.SQLException - if a database access error occurssetBoolean(java.lang.String, boolean)public byte getByte(String parameterName) throws SQLException
TINYINT parameter as a byte
in the Java programming language.getByte 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is 0.SQLException - if a database access error occurssetByte(java.lang.String, byte)public short getShort(String parameterName) throws SQLException
SMALLINT parameter as a short
in the Java programming language.getShort 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is 0.SQLException - if a database access error occurssetShort(java.lang.String, short)public int getInt(String parameterName) throws SQLException
INTEGER parameter as an int
in the Java programming language.getInt 在接口中 CallableStatementparameterName - the name of the parameterNULL,
the result is 0.SQLException - if a database access error occurssetInt(java.lang.String, int)public long getLong(String parameterName) throws SQLException
BIGINT parameter as a long
in the Java programming language.getLong 在接口中 CallableStatementparameterName - the name of the parameterNULL,
the result is 0.SQLException - if a database access error occurssetLong(java.lang.String, long)public float getFloat(String parameterName) throws SQLException
FLOAT parameter as a float
in the Java programming language.getFloat 在接口中 CallableStatementparameterName - the name of the parameterNULL,
the result is 0.SQLException - if a database access error occurssetFloat(java.lang.String, float)public double getDouble(String parameterName) throws SQLException
DOUBLE parameter as a double
in the Java programming language.getDouble 在接口中 CallableStatementparameterName - the name of the parameterNULL,
the result is 0.SQLException - if a database access error occurssetDouble(java.lang.String, double)public byte[] getBytes(String parameterName) throws SQLException
BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language.getBytes 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result is
null.SQLException - if a database access error occurssetBytes(java.lang.String, byte[])public Date getDate(String parameterName) throws SQLException
DATE parameter as a
java.sql.Date object.getDate 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is null.SQLException - if a database access error occurssetDate(java.lang.String, java.sql.Date)public Time getTime(String parameterName) throws SQLException
TIME parameter as a
java.sql.Time object.getTime 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is null.SQLException - if a database access error occurssetTime(java.lang.String, java.sql.Time)public Timestamp getTimestamp(String parameterName) throws SQLException
TIMESTAMP parameter as a
java.sql.Timestamp object.getTimestamp 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result
is null.SQLException - if a database access error occurssetTimestamp(java.lang.String, java.sql.Timestamp)public Object getObject(String parameterName) throws SQLException
Object in the Java
programming language. If the value is an SQL NULL, the
driver returns a Java null.
This method returns a Java object whose type corresponds to the JDBC
type that was registered for this parameter using the method
registerOutParameter. By registering the target JDBC
type as java.sql.Types.OTHER, this method can be used
to read database-specific abstract data types.
getObject 在接口中 CallableStatementparameterName - the name of the parameterjava.lang.Object holding the OUT parameter value.SQLException - if a database access error occursTypes,
setObject(java.lang.String, java.lang.Object, int, int)public BigDecimal getBigDecimal(String parameterName) throws SQLException
NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.getBigDecimal 在接口中 CallableStatementparameterName - the name of the parameterNULL, the result is null.SQLException - if a database access error occurssetBigDecimal(java.lang.String, java.math.BigDecimal)public Object getObject(int paramIndex, Map map) throws SQLException
i and uses map for the custom
mapping of the parameter value.
This method returns a Java object whose type corresponds to the
JDBC type that was registered for this parameter using the method
registerOutParameter. By registering the target
JDBC type as java.sql.Types.OTHER, this method can
be used to read database-specific abstract data types.
getObject 在接口中 CallableStatementmap - the mapping from SQL type names to Java classesjava.lang.Object holding the OUT parameter valueSQLException - if a database access error occurssetObject(java.lang.String, java.lang.Object, int, int)public Ref getRef(String parameterName) throws SQLException
REF(<structured-type>)
parameter as a Ref object in the Java programming language.getRef 在接口中 CallableStatementparameterName - the name of the parameterRef object in the
Java programming language. If the value was SQL NULL,
the value null is returned.SQLException - if a database access error occurspublic Blob getBlob(String parameterName) throws SQLException
BLOB parameter as a
Blob object in the Java programming language.getBlob 在接口中 CallableStatementparameterName - the name of the parameterBlob object in the
Java programming language. If the value was SQL NULL,
the value null is returned.SQLException - if a database access error occurspublic Clob getClob(String parameterName) throws SQLException
CLOB parameter as a
Clob object in the Java programming language.getClob 在接口中 CallableStatementparameterName - the name of the parameterClob object in the
Java programming language. If the value was SQL NULL,
the value null is returned.SQLException - if a database access error occurspublic Array getArray(String parameterName) throws SQLException
ARRAY parameter as an
Array object in the Java programming language.getArray 在接口中 CallableStatementparameterName - the name of the parameterArray object in
Java programming language. If the value was SQL NULL,
the value null is returned.SQLException - if a database access error occurspublic Date getDate(String parameterName, Calendar cal) throws SQLException
DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
With a Calendar object, the driver
can calculate the date taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getDate 在接口中 CallableStatementparameterName - the name of the parametercal - the Calendar object the driver will use
to construct the dateNULL,
the result is null.SQLException - if a database access error occurssetDate(java.lang.String, java.sql.Date)public Time getTime(String parameterName, Calendar cal) throws SQLException
TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
With a Calendar object, the driver
can calculate the time taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getTime 在接口中 CallableStatementparameterName - the name of the parametercal - the Calendar object the driver will use
to construct the timeNULL, the result is
null.SQLException - if a database access error occurssetTime(java.lang.String, java.sql.Time)public Timestamp getTimestamp(String parameterName, Calendar cal) throws SQLException
TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
With a Calendar object, the driver
can calculate the timestamp taking into account a custom timezone and locale.
If no Calendar object is specified, the driver uses the
default timezone and locale.getTimestamp 在接口中 CallableStatementparameterName - the name of the parametercal - the Calendar object the driver will use
to construct the timestampNULL, the result is
null.SQLException - if a database access error occurssetTimestamp(java.lang.String, java.sql.Timestamp)public URL getURL(String parameterName) throws SQLException
DATALINK parameter as a
java.net.URL object.getURL 在接口中 CallableStatementparameterName - the name of the parameterjava.net.URL object in the
Java programming language. If the value was SQL NULL, the
value null is returned.SQLException - if a database access error occurs,
or if there is a problem with the URLsetURL(java.lang.String, java.net.URL)public Reader getCharacterStream(int parameterIndex) throws SQLException
getCharacterStream 在接口中 CallableStatementSQLExceptionpublic Reader getCharacterStream(String parameterName) throws SQLException
getCharacterStream 在接口中 CallableStatementSQLExceptionpublic Reader getNCharacterStream(int parameterIndex) throws SQLException
getNCharacterStream 在接口中 CallableStatementSQLExceptionpublic Reader getNCharacterStream(String parameterName) throws SQLException
getNCharacterStream 在接口中 CallableStatementSQLExceptionpublic NClob getNClob(int parameterIndex) throws SQLException
getNClob 在接口中 CallableStatementSQLExceptionpublic NClob getNClob(String parameterName) throws SQLException
getNClob 在接口中 CallableStatementSQLExceptionpublic String getNString(int parameterIndex) throws SQLException
getNString 在接口中 CallableStatementSQLExceptionpublic String getNString(String parameterName) throws SQLException
getNString 在接口中 CallableStatementSQLExceptionpublic RowId getRowId(int parameterIndex) throws SQLException
getRowId 在接口中 CallableStatementSQLExceptionpublic RowId getRowId(String parameterName) throws SQLException
getRowId 在接口中 CallableStatementSQLExceptionpublic SQLXML getSQLXML(int parameterIndex) throws SQLException
getSQLXML 在接口中 CallableStatementSQLExceptionpublic SQLXML getSQLXML(String parameterName) throws SQLException
getSQLXML 在接口中 CallableStatementSQLExceptionpublic void setAsciiStream(String parameterName, InputStream x, long length) throws SQLException
setAsciiStream 在接口中 CallableStatementSQLExceptionpublic void setAsciiStream(String parameterName, InputStream x) throws SQLException
setAsciiStream 在接口中 CallableStatementSQLExceptionpublic void setBinaryStream(String parameterName, InputStream x, long length) throws SQLException
setBinaryStream 在接口中 CallableStatementSQLExceptionpublic void setBinaryStream(String parameterName, InputStream x) throws SQLException
setBinaryStream 在接口中 CallableStatementSQLExceptionpublic void setBlob(String parameterName, Blob x) throws SQLException
setBlob 在接口中 CallableStatementSQLExceptionpublic void setBlob(String parameterName, InputStream inputStream, long length) throws SQLException
setBlob 在接口中 CallableStatementSQLExceptionpublic void setBlob(String parameterName, InputStream inputStream) throws SQLException
setBlob 在接口中 CallableStatementSQLExceptionpublic void setCharacterStream(String parameterName, Reader reader, long length) throws SQLException
setCharacterStream 在接口中 CallableStatementSQLExceptionpublic void setCharacterStream(String parameterName, Reader reader) throws SQLException
setCharacterStream 在接口中 CallableStatementSQLExceptionpublic void setClob(String parameterName, Clob x) throws SQLException
setClob 在接口中 CallableStatementSQLExceptionpublic void setClob(String parameterName, Reader reader, long length) throws SQLException
setClob 在接口中 CallableStatementSQLExceptionpublic void setClob(String parameterName, Reader reader) throws SQLException
setClob 在接口中 CallableStatementSQLExceptionpublic void setNCharacterStream(String parameterName, Reader reader, long length) throws SQLException
setNCharacterStream 在接口中 CallableStatementSQLExceptionpublic void setNCharacterStream(String parameterName, Reader reader) throws SQLException
setNCharacterStream 在接口中 CallableStatementSQLExceptionpublic void setNClob(String parameterName, NClob value) throws SQLException
setNClob 在接口中 CallableStatementSQLExceptionpublic void setNClob(String parameterName, Reader reader, long length) throws SQLException
setNClob 在接口中 CallableStatementSQLExceptionpublic void setNClob(String parameterName, Reader reader) throws SQLException
setNClob 在接口中 CallableStatementSQLExceptionpublic <T> T getObject(int parameterIndex,
Class<T> type)
throws SQLException
getObject 在接口中 CallableStatementSQLExceptionpublic <T> T getObject(String parameterName, Class<T> type) throws SQLException
getObject 在接口中 CallableStatementSQLExceptionpublic void setNString(String parameterName, String value) throws SQLException
setNString 在接口中 CallableStatementSQLExceptionpublic void setRowId(String parameterName, RowId x) throws SQLException
setRowId 在接口中 CallableStatementSQLExceptionpublic void setSQLXML(String parameterName, SQLXML xmlObject) throws SQLException
setSQLXML 在接口中 CallableStatementSQLExceptionpublic boolean isPoolable()
throws SQLException
isPoolable 在接口中 StatementisPoolable 在类中 PreparedStatementSQLExceptionpublic Object getObject(String parameterName, Map<String,Class<?>> map) throws SQLException
getObject 在接口中 CallableStatementSQLExceptionCopyright © 2025. All rights reserved.