| Access | Constructor and Description |
|---|---|
| public |
| Modifier and Type | Method and Description |
|---|---|
| public final void | close()
Overrides org. Implements java. Releases this |
| public CallableStatement | Returns: a new CallableStatementThe current connection conn, CallableStatement The old statement oldStatement)Create a duplicate CalableStatement to this, including state, from the passed in Connection. |
| public final Array | getArray(int
the first parameter is 1, the second is 2, and
so on i)Implements java. Retrieves the value of the designated JDBC |
| public final Array | getArray(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the number of digits to the right of the decimal point scale)Implements java.
Deprecated
Retrieves the value of the designated JDBC |
| public final BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final BigDecimal | getBigDecimal(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Blob | getBlob(int
the first parameter is 1, the second is 2, and so on i)Implements java. Retrieves the value of the designated JDBC |
| public final Blob | getBlob(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final boolean | getBoolean(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final boolean | getBoolean(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final byte | getByte(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final byte | getByte(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final byte[] | getBytes(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final byte[] | getBytes(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| pack-priv final CallableStatement | |
| public final Reader | getCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated parameter as a
|
| public final Reader | getCharacterStream(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated parameter as a
|
| public final Clob | getClob(int
the first parameter is 1, the second is 2, and
so on i)Implements java. Retrieves the value of the designated JDBC |
| public final Clob | getClob(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Date | getDate(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final Date | getDate(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. Retrieves the value of the designated JDBC |
| public final Date | getDate(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Date | getDate(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. Retrieves the value of a JDBC |
| public final double | getDouble(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final double | getDouble(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final float | getFloat(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final float | getFloat(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final int | getInt(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final int | getInt(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final long | getLong(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final long | getLong(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated parameter as a
|
| public final Reader | getNCharacterStream(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated parameter as a
|
| public NClob | getNClob(int
the first parameter is 1, the second is 2, and
so on i)Implements java. Retrieves the value of the designated JDBC |
| public NClob | getNClob(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final String | getNString(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated |
| public final String | getNString(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated |
| public final Object | getObject(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated parameter as an |
| public final Object | getObject(int
the first parameter is 1, the second is 2, and so on i, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Implements java. Returns an object representing the value of OUT parameter
|
| public final Object | getObject(String
the name of the parameter parameterName)Implements java. Retrieves the value of a parameter as an |
| public final Object | getObject(String
the name of the parameter parameterName, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Implements java. Returns an object representing the value of OUT parameter
|
| public final <T> T | getObject(int
the first parameter is 1, the second is 2, and so on parameterIndex, Class<T> Class representing the Java data type to convert the
designated parameter to. type)Implements java. Returns an object representing the value of OUT parameter
|
| public final <T> T | getObject(String
the name of the parameter parameterName, Class<T> Class representing the Java data type to convert
the designated parameter to. type)Implements java. Returns an object representing the value of OUT parameter
|
| pack-priv final PreparedStatement | getPreparedStatement()
Overrides org. Access the underlying PreparedStatement. |
| public final Ref | getRef(int
the first parameter is 1, the second is 2,
and so on i)Implements java. Retrieves the value of the designated JDBC |
| public final Ref | getRef(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final RowId | getRowId(int
the first parameter is 1, the second is 2,... parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final RowId | getRowId(String
the name of the parameter parameterName)Implements java. Retrieves the value of the designated JDBC |
| public final short | getShort(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final short | getShort(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. Retrieves the value of the designated |
| public SQLXML | getSQLXML(String
the name of the parameter parametername)Implements java. Retrieves the value of the designated |
| public final String | getString(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final String | getString(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. Retrieves the value of the designated JDBC |
| public final Time | getTime(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Time | getTime(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. Retrieves the value of a JDBC |
| public final Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Retrieves the value of the designated JDBC |
| public final Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. Retrieves the value of the designated JDBC |
| public final Timestamp | getTimestamp(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final Timestamp | getTimestamp(String
the name of the parameter parameterName, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. Retrieves the value of a JDBC |
| public final URL | getURL(String
the name of the parameter parameterName)Implements java. Retrieves the value of a JDBC |
| public final URL | getURL(int
the first parameter is 1, the second is 2,... i)Implements java. Retrieves the value of the designated JDBC |
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the JDBC type code defined by sqlType)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.Implements java. Registers the OUT parameter in ordinal position
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, int the SQL type code defined by sqlType, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Implements java. Registers the parameter in ordinal position
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,... paramIndex, int a value from sqlType, String java.the fully-qualified name of an SQL structured type typeName)Implements java. Registers the designated output parameter. |
| public final void | registerOutParameter(String
the name of the parameter a, int the JDBC type code defined by b)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.Implements java. Registers the OUT parameter named
|
| public final void | registerOutParameter(String
the name of the parameter a, int SQL type code defined by b, int java.sql.Types.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. c)Implements java. Registers the parameter named
|
| public final void | registerOutParameter(String
the name of the parameter a, int a value from b, String java.the fully-qualified name of an SQL structured type c)Implements java. Registers the designated output parameter. |
| public final void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value value, int the number of bytes in the stream length)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x)Implements java. Sets the designated parameter to the given input stream. |
| public final void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setBigDecimal(String
the name of the parameter parameterName, BigDecimal the parameter value value)Implements java. Sets the designated parameter to the given
|
| public final void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value value, int the number of bytes in the stream length)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x)Implements java. Sets the designated parameter to the given input stream. |
| public final void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length)Implements java. Sets the designated parameter to the given input stream, which will have the specified number of bytes. |
| public final void | setBlob(String
the name of the parameter parameterName, Blob a x)Blob object that maps an SQL BLOB valueImplements java. Sets the designated parameter to the given |
| public final void | setBlob(String
the name of the parameter parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream)Implements java. Sets the designated parameter to an |
| public final void | setBlob(String
the name of the parameter to be set
the second is 2, ... parameterName, InputStream An object that contains the data to set the parameter
value to. inputStream, long the number of bytes in the parameter data. length)Implements java. Sets the designated parameter to an |
| public final void | setBoolean(String
the name of the parameter parameterName, boolean the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setByte(String
the name of the parameter parameterName, byte the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setBytes(String
the name of the parameter parameterName, byte[] the parameter value value)Implements java. Sets the designated parameter to the given Java array of bytes. |
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the value, int java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Implements java. Sets the designated parameter to the given |
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the x)java.io.Reader object that contains the
Unicode dataImplements java. Sets the designated parameter to the given |
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the x, long java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Implements java. Sets the designated parameter to the given |
| public final void | setClob(String
the name of the parameter parameterName, Clob a x)Clob object that maps an SQL CLOB valueImplements java. Sets the designated parameter to the given |
| public final void | setClob(String
the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader)Implements java. Sets the designated parameter to a |
| public final void | setClob(String
the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length)Implements java. Sets the designated parameter to a |
| public final void | setDate(String
the name of the parameter parameterName, Date the parameter value value)Implements java. Sets the designated parameter to the given |
| public final void | setDate(String
the name of the parameter parameterName, Date the parameter value value, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. Sets the designated parameter to the given |
| public final void | setDouble(String
the name of the parameter parameterName, double the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setFloat(String
the name of the parameter parameterName, float the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setInt(String
the name of the parameter parameterName, int the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setLong(String
the name of the parameter parameterName, long the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setNCharacterStream(String
the name of the parameter parameterName, Reader the parameter value value)Implements java. Sets the designated parameter to a |
| public final void | setNCharacterStream(String
the name of the parameter to be set parameterName, Reader the parameter value value, long the number of characters in the parameter data. length)Implements java. Sets the designated parameter to a |
| public final void | setNClob(String
the name of the parameter to be set parameterName, NClob the parameter value value)Implements java. Sets the designated parameter to a |
| public final void | setNClob(String
the name of the parameter parameterName, Reader An object that contains the data to set the parameter value to. reader)Implements java. Sets the designated parameter to a |
| public final void | setNClob(String
the name of the parameter to be set parameterName, Reader An object that contains the data to set the parameter value to. reader, long the number of characters in the parameter data. length)Implements java. Sets the designated parameter to a |
| public final void | setNString(String
the name of the parameter to be set parameterName, String the parameter value value)Implements java. Sets the designated parameter to the given |
| public final void | setNull(String
the name of the parameter parameterName, int the SQL type code defined in type)java.sql.TypesImplements java. Sets the designated parameter to SQL |
| public final void | setNull(String
the name of the parameter parameterName, int a value from a, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or
SQL b)REF valueImplements java. Sets the designated parameter to SQL |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value value, int the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type. a, int 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. b)Implements java. Sets the value of the designated parameter with the given object. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value value, int the SQL type (as defined in java.sql.Types) to be
sent to the database a)Implements java. Sets the value of the designated parameter with the given object. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value value)Implements java. Sets the value of the designated parameter with the given object. |
| public final void | setRowId(String
the name of the parameter parameterName, RowId the parameter value x)Implements java. Sets the designated parameter to the given |
| public final void | setShort(String
the name of the parameter parameterName, short the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setSQLXML(String
the name of the parameter parameterName, SQLXML a xmlObject)SQLXML object that maps an SQL XML valueImplements java. Sets the designated parameter to the given |
| public final void | setString(String
the name of the parameter parameterName, String the parameter value value)Implements java. Sets the designated parameter to the given Java |
| public final void | setTime(String
the name of the parameter parameterName, Time the parameter value value)Implements java. Sets the designated parameter to the given |
| public final void | setTime(String
the name of the parameter parameterName, Time the parameter value value, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. Sets the designated parameter to the given |
| public final void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value value)Implements java. Sets the designated parameter to the given |
| public final void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value value, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. Sets the designated parameter to the given |
| public final void | setURL(String
the name of the parameter parameterName, URL the parameter value value)Implements java. Sets the designated parameter to the given |
| public final boolean | wasNull()
Implements java. Retrieves whether the last OUT parameter read had the value of
SQL |