| Modifier and Type | Field and Description |
|---|---|
| private final List | |
| private final List | |
| private final ParsingConnection | connection
Deprecated
as a consequence of
ParsingConnection being deprecated.
|
| private final List | |
| private PreparedStatement | |
| private PreparedStatement | |
| private final ThrowingFunction | |
| private final Statement |
| Access | Constructor and Description |
|---|---|
| pack-priv | ParsingStatement(ParsingConnection connection, Statement statement)
Deprecated
as a consequence of
ParsingConnection being deprecated.
|
| pack-priv | ParsingStatement(ParsingConnection connection, ThrowingFunction<List<List<Param<?>>>, PreparedStatement, SQLException> prepared)
Deprecated
as a consequence of
ParsingConnection being deprecated.
|
| Modifier and Type | Method and Description |
|---|---|
| public final void | addBatch(String
typically this is a SQL sql)INSERT or
UPDATE statementImplements java. Statement object.
|
| public final void | addBatch()
Implements java. PreparedStatement
object's batch of commands.
|
| private final List | |
| public final void | cancel()
Implements java. Statement object if both the DBMS and
driver support aborting an SQL statement.
|
| public final void | clearBatch()
Implements java. Statement object's current list of
SQL commands.
|
| public final void | clearParameters()
Implements java. |
| public final void | clearWarnings()
Implements java. Statement
object.
|
| public final void | close()
Implements java. Statement object's database
and JDBC resources immediately instead of waiting for
this to happen when it is automatically closed.
|
| private final SQLException | |
| public final void | closeOnCompletion()
Implements java. Statement will be closed when all its
dependent result sets are closed.
|
| public final boolean | execute(String
any SQL statement sql)Implements java. |
| public final boolean | execute(String
any SQL statement sql, int a constant indicating whether auto-generated
keys should be made available for retrieval using the method
autoGeneratedKeys)getGeneratedKeys; one of the following constants:
Statement.RETURN_GENERATED_KEYS or
Statement.NO_GENERATED_KEYSImplements java. |
| public final boolean | execute(String
any SQL statement sql, int[] an array of the indexes of the columns in the
inserted row that should be made available for retrieval by a
call to the method columnIndexes)getGeneratedKeysImplements java. |
| public final boolean | execute(String
any SQL statement sql, String[] an array of the names of the columns in the inserted
row that should be made available for retrieval by a call to the
method columnNames)getGeneratedKeysImplements java. |
| public final boolean | execute()
Implements java. PreparedStatement object,
which may be any kind of SQL statement.
|
| public final int[] | executeBatch()
Implements java. |
| public final long[] | executeLargeBatch()
Overrides default java. |
| public final long | executeLargeUpdate(String
an SQL Data Manipulation Language (DML) statement,
such as sql)INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.Overrides default java. INSERT,
UPDATE, or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement.
|
| public final long | executeLargeUpdate(String
an SQL Data Manipulation Language (DML) statement,
such as sql, int INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.a flag indicating whether auto-generated keys
should be made available for retrieval;
one of the following constants:
autoGeneratedKeys)Statement.RETURN_GENERATED_KEYS
Statement.NO_GENERATED_KEYSOverrides default java. Statement object
should be made available for retrieval.
|
| public final long | executeLargeUpdate(String
an SQL Data Manipulation Language (DML) statement,
such as sql, int[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of column indexes indicating the columns
that should be returned from the inserted row columnIndexes)Overrides default java. |
| public final long | executeLargeUpdate(String
an SQL Data Manipulation Language (DML) statement,
such as sql, String[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of the names of the columns that should be
returned from the inserted row columnNames)Overrides default java. |
| public final long | executeLargeUpdate()
Overrides default java. 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.
|
| public final ResultSet | executeQuery(String
an SQL statement to be sent to the database, typically a
static SQL sql)SELECT statementImplements java. ResultSet object.
|
| public final ResultSet | executeQuery()
Implements java. PreparedStatement object
and returns the ResultSet object generated by the query.
|
| public final int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as sql)INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.Implements java. INSERT,
UPDATE, or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement.
|
| public final int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as sql, int INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.a flag indicating whether auto-generated keys
should be made available for retrieval;
one of the following constants:
autoGeneratedKeys)Statement.RETURN_GENERATED_KEYS
Statement.NO_GENERATED_KEYSImplements java. Statement object
should be made available for retrieval.
|
| public final int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as sql, int[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of column indexes indicating the columns
that should be returned from the inserted row columnIndexes)Implements java. |
| public final int | executeUpdate(String
an SQL Data Manipulation Language (DML) statement, such as sql, String[] INSERT, UPDATE or
DELETE; or an SQL statement that returns nothing,
such as a DDL statement.an array of the names of the columns that should be
returned from the inserted row columnNames)Implements java. |
| public final int | executeUpdate()
Implements java. 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.
|
| public final Array | getArray(int
the first parameter is 1, the second is 2, and
so on parameterIndex)Implements java. ARRAY parameter as an
java.sql.Array object in the Java programming language.
|
| public final Array | getArray(String
the name of the parameter parameterName)Implements java. ARRAY parameter as an
java.sql.Array object in the Java programming language.
|
| 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. NUMERIC parameter as a
java.math.BigDecimal object with scale digits to
the right of the decimal point.
|
| public final BigDecimal | getBigDecimal(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.
|
| public final BigDecimal | getBigDecimal(String
the name of the parameter parameterName)Implements java. NUMERIC parameter as a
java.math.BigDecimal object with as many digits to the
right of the decimal point as the value contains.
|
| public final Blob | getBlob(int
the first parameter is 1, the second is 2, and so on parameterIndex)Implements java. BLOB parameter as a
java.sql.Blob object in the Java programming language.
|
| public final Blob | getBlob(String
the name of the parameter parameterName)Implements java. BLOB parameter as a
java.sql.Blob object in the Java programming language.
|
| public final boolean | getBoolean(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BIT
or BOOLEAN parameter as a
boolean in the Java programming language.
|
| public final boolean | getBoolean(String
the name of the parameter parameterName)Implements java. BIT or BOOLEAN
parameter as a
boolean in the Java programming language.
|
| public final byte | getByte(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TINYINT parameter
as a byte in the Java programming language.
|
| public final byte | getByte(String
the name of the parameter parameterName)Implements java. TINYINT parameter as a byte
in the Java programming language.
|
| public final byte[] | getBytes(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BINARY or
VARBINARY parameter as an array of byte
values in the Java programming language.
|
| public final byte[] | getBytes(String
the name of the parameter parameterName)Implements java. BINARY or VARBINARY
parameter as an array of byte values in the Java
programming language.
|
| public final Reader | getCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. java.io.Reader object in the Java programming language.
|
| public final Reader | getCharacterStream(String
the name of the parameter parameterName)Implements java. java.io.Reader object in the Java programming language.
|
| public final Clob | getClob(int
the first parameter is 1, the second is 2, and
so on parameterIndex)Implements java. CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
| public final Clob | getClob(String
the name of the parameter parameterName)Implements java. CLOB parameter as a
java.sql.Clob object in the Java programming language.
|
| public final Connection | getConnection()
Implements java. Connection object
that produced this Statement object.
|
| public final Date | getDate(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. DATE parameter as a
java.sql.Date object.
|
| 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. DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
|
| public final Date | getDate(String
the name of the parameter parameterName)Implements java. DATE parameter as a
java.sql.Date object.
|
| 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. DATE parameter as a
java.sql.Date object, using
the given Calendar object
to construct the date.
|
| public final double | getDouble(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. DOUBLE parameter as a double
in the Java programming language.
|
| public final double | getDouble(String
the name of the parameter parameterName)Implements java. DOUBLE parameter as a double
in the Java programming language.
|
| public final int | getFetchDirection()
Implements java. Statement object.
|
| public final int | getFetchSize()
Implements java. ResultSet objects
generated from this Statement object.
|
| public final float | getFloat(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. FLOAT parameter
as a float in the Java programming language.
|
| public final float | getFloat(String
the name of the parameter parameterName)Implements java. FLOAT parameter as a float
in the Java programming language.
|
| public final ResultSet | getGeneratedKeys()
Implements java. Statement object.
|
| public final int | getInt(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. INTEGER parameter
as an int in the Java programming language.
|
| public final int | getInt(String
the name of the parameter parameterName)Implements java. INTEGER parameter as an int
in the Java programming language.
|
| public final long | getLargeMaxRows()
Overrides default java. ResultSet object produced by this
Statement object can contain.
|
| public final long | getLargeUpdateCount()
Overrides default java. ResultSet object or there are no more results, -1
is returned.
|
| public final long | getLong(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. BIGINT parameter
as a long in the Java programming language.
|
| public final long | getLong(String
the name of the parameter parameterName)Implements java. BIGINT parameter as a long
in the Java programming language.
|
| public final int | getMaxFieldSize()
Implements java. ResultSet
object produced by this Statement object.
|
| public final int | getMaxRows()
Implements java. ResultSet object produced by this
Statement object can contain.
|
| public final ResultSetMetaData | getMetaData()
Implements java. ResultSetMetaData object that contains
information about the columns of the ResultSet object
that will be returned when this PreparedStatement object
is executed.
|
| public final boolean | getMoreResults()
Implements java. Statement object's next result, returns
true if it is a ResultSet object, and
implicitly closes any current ResultSet
object(s) obtained with the method getResultSet.
|
| public final boolean | getMoreResults(int
one of the following current)Statement
constants indicating what should happen to current
ResultSet objects obtained using the method
getResultSet:
Statement.CLOSE_CURRENT_RESULT,
Statement.KEEP_CURRENT_RESULT, or
Statement.CLOSE_ALL_RESULTSImplements java. Statement object's next result, deals with
any current ResultSet object(s) according to the instructions
specified by the given flag, and returns
true if the next result is a ResultSet object.
|
| public final Reader | getNCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex)Implements java. java.io.Reader object in the Java programming language.
|
| public final Reader | getNCharacterStream(String
the name of the parameter parameterName)Implements java. java.io.Reader object in the Java programming language.
|
| public final NClob | getNClob(int
the first parameter is 1, the second is 2, and
so on parameterIndex)Implements java. NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
| public final NClob | getNClob(String
the name of the parameter parameterName)Implements java. NCLOB parameter as a
java.sql.NClob object in the Java programming language.
|
| public final String | getNString(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
|
| public final String | getNString(String
the name of the parameter parameterName)Implements java. NCHAR,
NVARCHAR
or LONGNVARCHAR parameter as
a String in the Java programming language.
|
| public final Object | getObject(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. Object
in the Java programming language.
|
| public final Object | getObject(int
the first parameter is 1, the second is 2, and so on parameterIndex, Map<String, Class<?>> the mapping from SQL type names to Java classes map)Implements java. parameterIndex and uses map for the custom
mapping of the parameter value.
|
| public final Object | getObject(String
the name of the parameter parameterName)Implements java. Object in the Java
programming language.
|
| 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. parameterName and uses map for the custom
mapping of the parameter value.
|
| 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. parameterIndex and will convert from the
SQL type of the parameter to the requested Java data type, if the
conversion is supported.
|
| 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. parameterName and will convert from the
SQL type of the parameter to the requested Java data type, if the
conversion is supported.
|
| public final ParameterMetaData | getParameterMetaData()
Implements java. PreparedStatement object's parameters.
|
| public final int | getQueryTimeout()
Implements java. Statement object to execute.
|
| public final Ref | getRef(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. REF(<structured-type>)
parameter as a java.sql.Ref object in the Java programming language.
|
| public final Ref | getRef(String
the name of the parameter parameterName)Implements java. REF(<structured-type>)
parameter as a java.sql.Ref object in the Java programming language.
|
| public final ResultSet | getResultSet()
Implements java. ResultSet object.
|
| public final int | getResultSetConcurrency()
Implements java. ResultSet objects
generated by this Statement object.
|
| public final int | getResultSetHoldability()
Implements java. ResultSet objects
generated by this Statement object.
|
| public final int | getResultSetType()
Implements java. ResultSet objects
generated by this Statement object.
|
| public final RowId | getRowId(int
the first parameter is 1, the second is 2,... parameterIndex)Implements java. ROWID parameter as a
java.sql.RowId object.
|
| public final RowId | getRowId(String
the name of the parameter parameterName)Implements java. ROWID parameter as a
java.sql.RowId object.
|
| public final short | getShort(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. SMALLINT parameter
as a short in the Java programming language.
|
| public final short | getShort(String
the name of the parameter parameterName)Implements java. SMALLINT parameter as a short
in the Java programming language.
|
| public final SQLXML | getSQLXML(int
index of the first parameter is 1, the second is 2, ... parameterIndex)Implements java. SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
| public final SQLXML | getSQLXML(String
the name of the parameter parameterName)Implements java. SQL XML parameter as a
java.sql.SQLXML object in the Java programming language.
|
| public final String | getString(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. CHAR,
VARCHAR, or LONGVARCHAR parameter as a
String in the Java programming language.
|
| public final String | getString(String
the name of the parameter parameterName)Implements java. CHAR, VARCHAR,
or LONGVARCHAR parameter as a String in
the Java programming language.
|
| public final Time | getTime(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TIME parameter as a
java.sql.Time object.
|
| 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. TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
|
| public final Time | getTime(String
the name of the parameter parameterName)Implements java. TIME parameter as a
java.sql.Time object.
|
| 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. TIME parameter as a
java.sql.Time object, using
the given Calendar object
to construct the time.
|
| public final Timestamp | getTimestamp(int
the first parameter is 1, the second is 2,
and so on parameterIndex)Implements java. TIMESTAMP parameter as a
java.sql.Timestamp object.
|
| 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. TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
|
| public final Timestamp | getTimestamp(String
the name of the parameter parameterName)Implements java. TIMESTAMP parameter as a
java.sql.Timestamp object.
|
| 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. TIMESTAMP parameter as a
java.sql.Timestamp object, using
the given Calendar object to construct
the Timestamp object.
|
| public final int | getUpdateCount()
Implements java. ResultSet object or there are no more results, -1
is returned.
|
| public final URL | getURL(int
the first parameter is 1, the second is 2,... parameterIndex)Implements java. DATALINK parameter as a
java.net.URL object.
|
| public final URL | getURL(String
the name of the parameter parameterName)Implements java. DATALINK parameter as a
java.net.URL object.
|
| public final SQLWarning | getWarnings()
Implements java. Statement object.
|
| public final boolean | isClosed()
Implements java. Statement object has been closed.
|
| public final boolean | isCloseOnCompletion()
Implements java. Statement will be
closed when all its dependent result sets are closed.
|
| public final boolean | isPoolable()
Implements java. Statement
is poolable or not.
|
| public final boolean | isWrapperFor(Class<?>
a Class defining an interface. iface)Implements java. |
| private final Statement | |
| private final PreparedStatement | lastOrDummy()
[#12481] Some operations require access to the |
| private final PreparedStatement | |
| private final PreparedStatement | |
| private static final byte[] | |
| 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. parameterIndex to the JDBC type
sqlType.
|
| 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. parameterIndex to be of JDBC type
sqlType.
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,... parameterIndex, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL structured type typeName)Implements java. |
| public final void | registerOutParameter(String
the name of the parameter parameterName, 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. parameterName to the JDBC type
sqlType.
|
| public final void | registerOutParameter(String
the name of the parameter parameterName, int 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. parameterName to be of JDBC type
sqlType.
|
| public final void | registerOutParameter(String
the name of the parameter parameterName, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL structured type typeName)Implements java. |
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, SQLType the JDBC type code defined by sqlType)SQLType to use to
register the OUT Parameter.
If the parameter is of JDBC type JDBCType.NUMERIC
or JDBCType.DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Overrides default java. parameterIndex to the JDBC type
sqlType.
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,
and so on parameterIndex, SQLType the JDBC type code defined by sqlType, int SQLType to use to
register the OUT Parameter.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Overrides default java. parameterIndex to be of JDBC type
sqlType.
|
| public final void | registerOutParameter(int
the first parameter is 1, the second is 2,... parameterIndex, SQLType the JDBC type code defined by sqlType, String SQLType to use to
register the OUT Parameter.the fully-qualified name of an SQL structured type typeName)Overrides default java. |
| public final void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType)SQLType to use to
register the OUT Parameter.
If the parameter is of JDBC type JDBCType.NUMERIC
or JDBCType.DECIMAL, the version of
registerOutParameter that accepts a scale value
should be used.Overrides default java. parameterName to the JDBC type
sqlType.
|
| public final void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType, int SQLType to use to
register the OUT Parameter.the desired number of digits to the right of the
decimal point. It must be greater than or equal to zero. scale)Overrides default java. parameterName to be of JDBC type
sqlType.
|
| public final void | registerOutParameter(String
the name of the parameter parameterName, SQLType the JDBC type code defined by sqlType, String SQLType to use to
register the OUT Parameter.the fully-qualified name of an SQL structured type typeName)Overrides default java. |
| private final void | |
| public final void | setArray(int
the first parameter is 1, the second is 2, ... parameterIndex, Array an x)Array object that maps an SQL ARRAY valueImplements java. java.sql.Array object.
|
| public final void | setAsciiStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x)Implements java. |
| public final void | setAsciiStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length)Implements java. |
| public final void | setAsciiStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the Java input stream that contains the ASCII parameter value x, long the number of bytes in the stream length)Implements java. |
| public final void | setAsciiStream(String
the name of the parameter parameterName, InputStream the Java input stream that contains the ASCII parameter value x, int the number of bytes in the stream length)Implements java. |
| 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. |
| 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. |
| public final void | setBigDecimal(int
the first parameter is 1, the second is 2, ... parameterIndex, BigDecimal the parameter value x)Implements java. java.math.BigDecimal value.
|
| public final void | setBigDecimal(String
the name of the parameter parameterName, BigDecimal the parameter value x)Implements java. java.math.BigDecimal value.
|
| public final void | setBinaryStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x)Implements java. |
| public final void | setBinaryStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length)Implements java. |
| public final void | setBinaryStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the binary parameter value x, long the number of bytes in the stream length)Implements java. |
| public final void | setBinaryStream(String
the name of the parameter parameterName, InputStream the java input stream which contains the binary parameter value x, int the number of bytes in the stream length)Implements java. |
| 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. |
| 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. |
| public final void | setBlob(int
index of the first parameter is 1,
the second is 2, ... parameterIndex, InputStream An object that contains the data to set the parameter
value to. inputStream)Implements java. InputStream object.
|
| public final void | setBlob(int
index of the first parameter is 1,
the second is 2, ... parameterIndex, 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. InputStream object.
|
| public final void | setBlob(int
the first parameter is 1, the second is 2, ... parameterIndex, Blob a x)Blob object that maps an SQL BLOB valueImplements java. java.sql.Blob object.
|
| 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. InputStream object.
|
| public final void | setBlob(String
the name of the parameter parameterName, Blob a x)Blob object that maps an SQL BLOB valueImplements java. java.sql.Blob object.
|
| 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. InputStream object.
|
| public final void | setBoolean(int
the first parameter is 1, the second is 2, ... parameterIndex, boolean the parameter value x)Implements java. boolean value.
|
| public final void | setBoolean(String
the name of the parameter parameterName, boolean the parameter value x)Implements java. boolean value.
|
| public final void | setByte(int
the first parameter is 1, the second is 2, ... parameterIndex, byte the parameter value x)Implements java. byte value.
|
| public final void | setByte(String
the name of the parameter parameterName, byte the parameter value x)Implements java. byte value.
|
| public final void | setBytes(int
the first parameter is 1, the second is 2, ... parameterIndex, byte[] the parameter value x)Implements java. |
| public final void | setBytes(String
the name of the parameter parameterName, byte[] the parameter value x)Implements java. |
| public final void | setCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex, Reader the reader)java.io.Reader object that contains the
Unicode dataImplements java. Reader
object.
|
| public final void | setCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex, Reader the reader, int java.io.Reader object that contains the
Unicode datathe number of characters in the stream length)Implements java. Reader
object, which is the given number of characters long.
|
| public final void | setCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex, Reader the reader, long java.io.Reader object that contains the
Unicode datathe number of characters in the stream length)Implements java. Reader
object, which is the given number of characters long.
|
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader, int java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Implements java. Reader
object, which is the given number of characters long.
|
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader, long java.io.Reader object that
contains the UNICODE data used as the designated parameterthe number of characters in the stream length)Implements java. Reader
object, which is the given number of characters long.
|
| public final void | setCharacterStream(String
the name of the parameter parameterName, Reader the reader)java.io.Reader object that contains the
Unicode dataImplements java. Reader
object.
|
| public final void | setClob(int
index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader)Implements java. Reader object.
|
| public final void | setClob(int
index of the first parameter is 1, the second is 2, ... parameterIndex, 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. Reader object.
|
| public final void | setClob(int
the first parameter is 1, the second is 2, ... parameterIndex, Clob a x)Clob object that maps an SQL CLOB valueImplements java. java.sql.Clob object.
|
| 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. Reader object.
|
| public final void | setClob(String
the name of the parameter parameterName, Clob a x)Clob object that maps an SQL CLOB valueImplements java. java.sql.Clob object.
|
| 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. Reader object.
|
| public final void | setCursorName(String
the new cursor name, which must be unique within
a connection name)Implements java. String, which
will be used by subsequent Statement object
execute methods.
|
| public final void | setDate(int
the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x)Implements java. java.sql.Date value
using the default time zone of the virtual machine that is running
the application.
|
| public final void | setDate(int
the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. java.sql.Date value,
using the given Calendar object.
|
| public final void | setDate(String
the name of the parameter parameterName, Date the parameter value x)Implements java. java.sql.Date value
using the default time zone of the virtual machine that is running
the application.
|
| public final void | setDate(String
the name of the parameter parameterName, Date the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the dateImplements java. java.sql.Date value,
using the given Calendar object.
|
| public final void | setDouble(int
the first parameter is 1, the second is 2, ... parameterIndex, double the parameter value x)Implements java. double value.
|
| public final void | setDouble(String
the name of the parameter parameterName, double the parameter value x)Implements java. double value.
|
| public final void | setEscapeProcessing(boolean
true to enable escape processing;
false to disable itImplements java. |
| public final void | setFetchDirection(int
the initial direction for processing rows direction)Implements java. ResultSet
objects created using this Statement object.
|
| public final void | setFetchSize(int
the number of rows to fetch rows)Implements java. ResultSet objects generated by this Statement.
|
| private final void | |
| public final void | setFloat(int
the first parameter is 1, the second is 2, ... parameterIndex, float the parameter value x)Implements java. float value.
|
| public final void | setFloat(String
the name of the parameter parameterName, float the parameter value x)Implements java. float value.
|
| public final void | setInt(int
the first parameter is 1, the second is 2, ... parameterIndex, int the parameter value x)Implements java. int value.
|
| public final void | setInt(String
the name of the parameter parameterName, int the parameter value x)Implements java. int value.
|
| public final void | setLargeMaxRows(long
the new max rows limit; zero means there is no limit max)Overrides default java. ResultSet object generated by this Statement
object can contain to the given number.
|
| public final void | setLong(int
the first parameter is 1, the second is 2, ... parameterIndex, long the parameter value x)Implements java. long value.
|
| public final void | setLong(String
the name of the parameter parameterName, long the parameter value x)Implements java. long value.
|
| public final void | setMaxFieldSize(int
the new column size limit in bytes; zero means there is no limit max)Implements java. ResultSet
object produced by this Statement object.
|
| public final void | setMaxRows(int
the new max rows limit; zero means there is no limit max)Implements java. ResultSet object generated by this Statement
object can contain to the given number.
|
| public final void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value)Implements java. Reader object.
|
| public final void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value, long the number of characters in the parameter data. length)Implements java. Reader object.
|
| 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. Reader object.
|
| public final void | setNCharacterStream(String
the name of the parameter parameterName, Reader the parameter value value)Implements java. Reader object.
|
| public final void | setNClob(int
index of the first parameter is 1, the second is 2, ... parameterIndex, Reader An object that contains the data to set the parameter value to. reader)Implements java. Reader object.
|
| public final void | setNClob(int
index of the first parameter is 1, the second is 2, ... parameterIndex, 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. Reader object.
|
| public final void | setNClob(int
of the first parameter is 1, the second is 2, ... parameterIndex, NClob the parameter value value)Implements java. java.sql.NClob object.
|
| public final void | setNClob(String
the name of the parameter to be set parameterName, NClob the parameter value value)Implements java. java.sql.NClob object.
|
| 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. Reader object.
|
| 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. Reader object.
|
| public final void | setNString(int
of the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value value)Implements java. String object.
|
| public final void | setNString(String
the name of the parameter to be set parameterName, String the parameter value value)Implements java. String object.
|
| public final void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int the SQL type code defined in sqlType)java.sql.TypesImplements java. NULL.
|
| public final void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int a value from sqlType, String java.sql.Typesthe fully-qualified name of an SQL user-defined type;
ignored if the parameter is not a user-defined type or REF typeName)Implements java. NULL.
|
| public final void | setNull(String
the name of the parameter parameterName, int the SQL type code defined in sqlType)java.sql.TypesImplements java. NULL.
|
| public final void | setNull(String
the name of the parameter parameterName, int a value from sqlType, 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 typeName)REF valueImplements java. NULL.
|
| public final void | setObject(int
the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database targetSqlType)Implements java. |
| public final void | setObject(int
the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x)Implements java. Sets the value of the designated parameter using the given object. |
| public final void | setObject(int
the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type. targetSqlType, int for scaleOrLength)java.sql.Types.DECIMAL
or java.sql.Types.NUMERIC types,
this is the number of digits after the decimal point. For
Java Object types InputStream and Reader,
this is the length
of the data in the stream or reader. For all other types,
this value will be ignored.Implements java. Sets the value of the designated parameter with the given object. |
| public final void | setObject(int
the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database. The
scale argument may further qualify this type. targetSqlType, int for scaleOrLength)java.sql.JDBCType.DECIMAL
or java.sql.JDBCType.NUMERIC types,
this is the number of digits after the decimal point. For
Java Object types InputStream and Reader,
this is the length
of the data in the stream or reader. For all other types,
this value will be ignored.Overrides default java. Sets the value of the designated parameter with the given object. |
| public final void | setObject(int
the first parameter is 1, the second is 2, ... parameterIndex, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database targetSqlType)Overrides default java. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database. The scale argument may further qualify this type. targetSqlType, 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. scale)Implements java. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, int the SQL type (as defined in java.sql.Types) to be
sent to the database targetSqlType)Implements java. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x)Implements java. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, SQLType the SQL type to be
sent to the database. The scale argument may further qualify this type. targetSqlType, int for scaleOrLength)java.sql.JDBCType.DECIMAL
or java.sql.JDBCType.NUMERIC types,
this is the number of digits after the decimal point. For
Java Object types InputStream and Reader,
this is the length
of the data in the stream or reader. For all other types,
this value will be ignored.Overrides default java. |
| public final void | setObject(String
the name of the parameter parameterName, Object the object containing the input parameter value x, SQLType the SQL type to be sent to the database targetSqlType)Overrides default java. |
| public final void | setPoolable(boolean
requests that the statement be pooled if true and
that the statement not be pooled if false poolable)Implements java. Statement be pooled or not pooled.
|
| public final void | setQueryTimeout(int
the new query timeout limit in seconds; zero means
there is no limit seconds)Implements java. Statement object to execute to the given number of seconds.
|
| public final void | setRef(int
the first parameter is 1, the second is 2, ... parameterIndex, Ref an SQL x)REF valueImplements java. REF(<structured-type>) value.
|
| public final void | setRowId(int
the first parameter is 1, the second is 2, ... parameterIndex, RowId the parameter value x)Implements java. java.sql.RowId object.
|
| public final void | setRowId(String
the name of the parameter parameterName, RowId the parameter value x)Implements java. java.sql.RowId object.
|
| public final void | setShort(int
the first parameter is 1, the second is 2, ... parameterIndex, short the parameter value x)Implements java. short value.
|
| public final void | setShort(String
the name of the parameter parameterName, short the parameter value x)Implements java. short value.
|
| public final void | setSQLXML(int
index of the first parameter is 1, the second is 2, ... parameterIndex, SQLXML a xmlObject)SQLXML object that maps an SQL XML valueImplements java. java.sql.SQLXML object.
|
| public final void | setSQLXML(String
the name of the parameter parameterName, SQLXML a xmlObject)SQLXML object that maps an SQL XML valueImplements java. java.sql.SQLXML object.
|
| public final void | setString(int
the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value x)Implements java. String value.
|
| public final void | setString(String
the name of the parameter parameterName, String the parameter value x)Implements java. String value.
|
| public final void | setTime(int
the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x)Implements java. java.sql.Time value.
|
| public final void | setTime(int
the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. java.sql.Time value,
using the given Calendar object.
|
| public final void | setTime(String
the name of the parameter parameterName, Time the parameter value x)Implements java. java.sql.Time value.
|
| public final void | setTime(String
the name of the parameter parameterName, Time the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timeImplements java. java.sql.Time value,
using the given Calendar object.
|
| public final void | setTimestamp(int
the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x)Implements java. java.sql.Timestamp value.
|
| public final void | setTimestamp(int
the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. java.sql.Timestamp value,
using the given Calendar object.
|
| public final void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x)Implements java. java.sql.Timestamp value.
|
| public final void | setTimestamp(String
the name of the parameter parameterName, Timestamp the parameter value x, Calendar the cal)Calendar object the driver will use
to construct the timestampImplements java. java.sql.Timestamp value,
using the given Calendar object.
|
| public final void | setUnicodeStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream a x, int java.io.InputStream object that contains the
Unicode parameter valuethe number of bytes in the stream length)Implements java. |
| public final void | setURL(int
the first parameter is 1, the second is 2, ... parameterIndex, URL the x)java.net.URL object to be setImplements java. java.net.URL value.
|
| public final void | setURL(String
the name of the parameter parameterName, URL the parameter value val)Implements java. java.net.URL object.
|
| private final @NotNull Statement | |
| private final @Nullable Statement | |
| public final <T> T | unwrap(Class<T>
A Class defining an interface that the result must implement. iface)Implements java. |
| public final boolean | wasNull()
Implements java. NULL.
|