All Superinterfaces:
AutoCloseable, PreparedStatement, Statement, Wrapper

  • Field Summary

  • Method Summary

    getArray(int parameterIndex)

    Retrieves the value of the designated JDBC ARRAY parameter as an Array object in the Java programming language.

    Retrieves the value of a JDBC ARRAY parameter as an Array object in the Java programming language.

    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.

    getBigDecimal(int parameterIndex, int scale)

    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.

    getBlob(int parameterIndex)

    Retrieves the value of the designated JDBC BLOB parameter as a Blob object in the Java programming language.

    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 or BOOLEAN parameter as a boolean in the Java programming language.

    boolean

    Retrieves the value of a JDBC BIT or BOOLEAN 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

    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[]

    Retrieves the value of a JDBC BINARY or VARBINARY parameter as an array of byte values in the Java programming language.

    getCharacterStream(int parameterIndex)

    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

    getClob(int parameterIndex)

    Retrieves the value of the designated JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

    Retrieves the value of a JDBC CLOB parameter as a java.sql.Clob object in the Java programming language.

    getDate(int parameterIndex)

    Retrieves the value of the designated JDBC DATE parameter as a java.sql.Date object.

    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.

    Retrieves the value of a JDBC DATE parameter as a java.sql.Date object.

    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

    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

    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

    Retrieves the value of a JDBC INTEGER parameter as an int in the Java programming language.

    long

    getLong(int parameterIndex)

    Retrieves the value of the designated JDBC BIGINT parameter as a long in the Java programming language.

    long

    Retrieves the value of a JDBC BIGINT parameter as a long in the Java programming language.

    getNCharacterStream(int parameterIndex)

    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

    Retrieves the value of the designated parameter as a java.io.Reader object in the Java programming language.

    getNClob(int parameterIndex)

    Retrieves the value of the designated JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

    Retrieves the value of a JDBC NCLOB parameter as a java.sql.NClob object in the Java programming language.

    getNString(int parameterIndex)

    Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

    Retrieves the value of the designated NCHAR, NVARCHAR or LONGNVARCHAR parameter as a String in the Java programming language.

    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)

    Returns an object representing the value of OUT parameter parameterIndex and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

    Returns an object representing the value of OUT parameter parameterIndex and uses map for the custom mapping of the parameter value.

    Retrieves the value of a parameter as an Object in the Java programming language.

    <T> T

    Returns an object representing the value of OUT parameter parameterName and will convert from the SQL type of the parameter to the requested Java data type, if the conversion is supported.

    Returns an object representing the value of OUT parameter parameterName and uses map for the custom mapping of the parameter value.

    getRef(int parameterIndex)

    Retrieves the value of the designated JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

    Retrieves the value of a JDBC REF(<structured-type>) parameter as a Ref object in the Java programming language.

    getRowId(int parameterIndex)

    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

    Retrieves the value of the designated JDBC ROWID parameter as a java.sql.RowId object.

    short

    getShort(int parameterIndex)

    Retrieves the value of the designated JDBC SMALLINT parameter as a short in the Java programming language.

    short

    Retrieves the value of a JDBC SMALLINT parameter as a short in the Java programming language.

    getSQLXML(int parameterIndex)

    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

    Retrieves the value of the designated SQL XML parameter as a java.sql.SQLXML object in the Java programming language.

    getString(int parameterIndex)

    Retrieves the value of the designated JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

    Retrieves the value of a JDBC CHAR, VARCHAR, or LONGVARCHAR parameter as a String in the Java programming language.

    getTime(int parameterIndex)

    Retrieves the value of the designated JDBC TIME parameter as a java.sql.Time object.

    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.

    Retrieves the value of a JDBC TIME parameter as a java.sql.Time object.

    Retrieves the value of a JDBC TIME parameter as a java.sql.Time object, using the given Calendar object to construct the time.

    getTimestamp(int parameterIndex)

    Retrieves the value of the designated JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

    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.

    Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object.

    Retrieves the value of a JDBC TIMESTAMP parameter as a java.sql.Timestamp object, using the given Calendar object to construct the Timestamp object.

    getURL(int parameterIndex)

    Retrieves the value of the designated JDBC DATALINK parameter as a java.net.URL object.

    Retrieves the value of a JDBC DATALINK parameter as a java.net.URL object.

    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 parameterIndex, int sqlType, String typeName)

    Registers the designated output parameter.

    default void

    registerOutParameter(int parameterIndex, SQLType sqlType)

    Registers the OUT parameter in ordinal position parameterIndex to the JDBC type sqlType.

    default void

    registerOutParameter(int parameterIndex, SQLType sqlType, int scale)

    Registers the parameter in ordinal position parameterIndex to be of JDBC type sqlType.

    default void

    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

    Registers the designated output parameter.

    default void

    Registers the OUT parameter named parameterName to the JDBC type sqlType.

    default void

    Registers the parameter named parameterName to be of JDBC type sqlType.

    default void

    Registers the designated output parameter.

    void

    Sets the designated parameter to the given input stream.

    void

    Sets the designated parameter to the given input stream, which will have the specified number of bytes.

    void

    Sets the designated parameter to the given input stream, which will have the specified number of bytes.

    void

    Sets the designated parameter to the given java.math.BigDecimal value.

    void

    Sets the designated parameter to the given input stream.

    void

    Sets the designated parameter to the given input stream, which will have the specified number of bytes.

    void

    Sets the designated parameter to the given input stream, which will have the specified number of bytes.

    void

    Sets the designated parameter to an InputStream object.

    void

    Sets the designated parameter to an InputStream object.

    void

    Sets the designated parameter to the given java.sql.Blob object.

    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

    Sets the designated parameter to the given Reader object.

    void

    Sets the designated parameter to the given Reader object, which is the given number of characters long.

    void

    Sets the designated parameter to the given Reader object, which is the given number of characters long.

    void

    Sets the designated parameter to a Reader object.

    void

    setClob(String parameterName, Reader reader, long length)

    Sets the designated parameter to a Reader object.

    void

    Sets the designated parameter to the given java.sql.Clob object.

    void

    Sets the designated parameter to the given java.sql.Date value using the default time zone of the virtual machine that is running the application.

    void

    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

    Sets the designated parameter to a Reader object.

    void

    Sets the designated parameter to a Reader object.

    void

    Sets the designated parameter to a Reader object.

    void

    setNClob(String parameterName, Reader reader, long length)

    Sets the designated parameter to a Reader object.

    void

    Sets the designated parameter to a java.sql.NClob object.

    void

    Sets the designated parameter to the given String object.

    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

    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.

    default void

    Sets the value of the designated parameter with the given object.

    default void

    Sets the value of the designated parameter with the given object.

    void

    Sets the designated parameter to the given java.sql.RowId object.

    void

    setShort(String parameterName, short x)

    Sets the designated parameter to the given Java short value.

    void

    Sets the designated parameter to the given java.sql.SQLXML object.

    void

    Sets the designated parameter to the given Java String value.

    void

    Sets the designated parameter to the given java.sql.Time value.

    void

    Sets the designated parameter to the given java.sql.Time value, using the given Calendar object.

    void

    Sets the designated parameter to the given java.sql.Timestamp value.

    void

    Sets the designated parameter to the given java.sql.Timestamp value, using the given Calendar object.

    void

    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.

    Methods declared in interface Statement

    addBatch, cancel, clearBatch, clearWarnings, close, closeOnCompletion, enquoteIdentifier, enquoteLiteral, enquoteNCharLiteral, execute, execute, execute, execute, executeBatch, executeLargeBatch, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeLargeUpdate, executeQuery, executeUpdate, executeUpdate, executeUpdate, executeUpdate, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getLargeMaxRows, getLargeUpdateCount, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, isClosed, isCloseOnCompletion, isPoolable, isSimpleIdentifier, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setLargeMaxRows, setMaxFieldSize, setMaxRows, setPoolable, setQueryTimeout

  • Method Details

    • registerOutParameter

    • registerOutParameter

    • wasNull

    • getString

    • getBoolean

    • getByte

    • getShort

    • getInt

    • getLong

    • getFloat

    • getDouble

    • getBigDecimal

    • getBytes

    • getDate

    • getTime

    • getTimestamp

    • getObject

    • getBigDecimal

    • getObject

    • getRef

    • getBlob

    • getClob

    • getArray

    • getDate

    • getTime

    • getTimestamp

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter

    • getURL

    • setURL

    • setNull

    • setBoolean

    • setByte

    • setShort

    • setInt

    • setLong

    • setFloat

    • setDouble

    • setBigDecimal

    • setString

    • setBytes

    • setDate

    • setTime

    • setTimestamp

    • setAsciiStream

    • setBinaryStream

    • setObject

    • setObject

    • setObject

    • setCharacterStream

    • setDate

    • setTime

    • setTimestamp

    • setNull

    • getString

    • getBoolean

    • getByte

    • getShort

    • getInt

    • getLong

    • getFloat

    • getDouble

    • getBytes

    • getDate

    • getTime

    • getTimestamp

    • getObject

    • getBigDecimal

    • getObject

    • getRef

    • getBlob

    • getClob

    • getArray

    • getDate

    • getTime

    • getTimestamp

    • getURL

    • getRowId

    • getRowId

    • setRowId

    • setNString

    • setNCharacterStream

    • setNClob

    • setClob

    • setBlob

    • setNClob

    • getNClob

    • getNClob

    • setSQLXML

    • getSQLXML

    • getSQLXML

    • getNString

    • getNString

    • getNCharacterStream

    • getNCharacterStream

    • getCharacterStream

    • getCharacterStream

    • setBlob

    • setClob

    • setAsciiStream

    • setBinaryStream

    • setCharacterStream

    • setAsciiStream

    • setBinaryStream

    • setCharacterStream

    • setNCharacterStream

    • setClob

    • setBlob

    • setNClob

    • getObject

    • getObject

    • setObject

    • setObject

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter

    • registerOutParameter