All Superinterfaces:
AutoCloseable, Statement, Wrapper
All Known Subinterfaces:
CallableStatement

  • Field Summary

  • Method Summary

    void

    addBatch()

    Adds a set of parameters to this PreparedStatement object's batch of commands.

    void

    Clears the current parameter values immediately.

    boolean

    execute()

    Executes the SQL statement in this PreparedStatement object, which may be any kind of SQL statement.

    default long

    Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

    Executes the SQL query in this PreparedStatement object and returns the ResultSet object generated by the query.

    int

    Executes the SQL statement in this PreparedStatement object, which must be an SQL Data Manipulation Language (DML) statement, such as INSERT, UPDATE or DELETE; or an SQL statement that returns nothing, such as a DDL statement.

    Retrieves a ResultSetMetaData object that contains information about the columns of the ResultSet object that will be returned when this PreparedStatement object is executed.

    Retrieves the number, types and properties of this PreparedStatement object's parameters.

    void

    setArray(int parameterIndex, Array x)

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

    void

    Sets the designated parameter to the given input stream.

    void

    setAsciiStream(int parameterIndex, InputStream x, int length)

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

    void

    setAsciiStream(int parameterIndex, InputStream x, long length)

    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

    setBinaryStream(int parameterIndex, InputStream x, long length)

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

    void

    Sets the designated parameter to a InputStream object.

    void

    setBlob(int parameterIndex, InputStream inputStream, long length)

    Sets the designated parameter to a InputStream object.

    void

    setBlob(int parameterIndex, Blob x)

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

    void

    setBoolean(int parameterIndex, boolean x)

    Sets the designated parameter to the given Java boolean value.

    void

    setByte(int parameterIndex, byte x)

    Sets the designated parameter to the given Java byte value.

    void

    setBytes(int parameterIndex, byte[] x)

    Sets the designated parameter to the given Java array of bytes.

    void

    setCharacterStream(int parameterIndex, Reader reader)

    Sets the designated parameter to the given Reader object.

    void

    setCharacterStream(int parameterIndex, Reader reader, int length)

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

    void

    setCharacterStream(int parameterIndex, Reader reader, long length)

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

    void

    setClob(int parameterIndex, Reader reader)

    Sets the designated parameter to a Reader object.

    void

    setClob(int parameterIndex, Reader reader, long length)

    Sets the designated parameter to a Reader object.

    void

    setClob(int parameterIndex, Clob x)

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

    void

    setDate(int parameterIndex, Date x)

    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(int parameterIndex, double x)

    Sets the designated parameter to the given Java double value.

    void

    setFloat(int parameterIndex, float x)

    Sets the designated parameter to the given Java float value.

    void

    setInt(int parameterIndex, int x)

    Sets the designated parameter to the given Java int value.

    void

    setLong(int parameterIndex, long x)

    Sets the designated parameter to the given Java long value.

    void

    setNCharacterStream(int parameterIndex, Reader value)

    Sets the designated parameter to a Reader object.

    void

    setNCharacterStream(int parameterIndex, Reader value, long length)

    Sets the designated parameter to a Reader object.

    void

    setNClob(int parameterIndex, Reader reader)

    Sets the designated parameter to a Reader object.

    void

    setNClob(int parameterIndex, Reader reader, long length)

    Sets the designated parameter to a Reader object.

    void

    setNClob(int parameterIndex, NClob value)

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

    void

    setNString(int parameterIndex, String value)

    Sets the designated parameter to the given String object.

    void

    setNull(int parameterIndex, int sqlType)

    Sets the designated parameter to SQL NULL.

    void

    setNull(int parameterIndex, int sqlType, String typeName)

    Sets the designated parameter to SQL NULL.

    void

    setObject(int parameterIndex, Object x)

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

    void

    setObject(int parameterIndex, Object x, int targetSqlType)

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

    void

    setObject(int parameterIndex, Object x, int targetSqlType, int scaleOrLength)

    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

    setObject(int parameterIndex, Object x, SQLType targetSqlType, int scaleOrLength)

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

    void

    setRef(int parameterIndex, Ref x)

    Sets the designated parameter to the given REF(<structured-type>) value.

    void

    setRowId(int parameterIndex, RowId x)

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

    void

    setShort(int parameterIndex, short x)

    Sets the designated parameter to the given Java short value.

    void

    setSQLXML(int parameterIndex, SQLXML xmlObject)

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

    void

    setString(int parameterIndex, String x)

    Sets the designated parameter to the given Java String value.

    void

    setTime(int parameterIndex, Time x)

    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

    void

    setURL(int parameterIndex, URL x)

    Sets the designated parameter to the given java.net.URL value.

    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

    • executeQuery

    • executeUpdate

    • setNull

    • setBoolean

    • setByte

    • setShort

    • setInt

    • setLong

    • setFloat

    • setDouble

    • setBigDecimal

    • setString

    • setBytes

    • setDate

    • setTime

    • setTimestamp

    • setAsciiStream

    • setUnicodeStream

    • setBinaryStream

    • clearParameters

    • setObject

    • setObject

    • execute

    • addBatch

    • setCharacterStream

    • setRef

    • setBlob

    • setClob

    • setArray

    • getMetaData

    • setDate

    • setTime

    • setTimestamp

    • setNull

    • setURL

    • getParameterMetaData

    • setRowId

    • setNString

    • setNCharacterStream

    • setNClob

    • setClob

    • setBlob

    • setNClob

    • setSQLXML

    • setObject

    • setAsciiStream

    • setBinaryStream

    • setCharacterStream

    • setAsciiStream

    • setBinaryStream

    • setCharacterStream

    • setNCharacterStream

    • setClob

    • setBlob

    • setNClob

    • setObject

    • setObject

    • executeLargeUpdate