| Modifier and Type | Class and Description |
|---|---|
| private static class | ClientPreparedStatement.PossibleTypes
PossibleTypes is information which is set of types. |
| Modifier and Type | Field and Description |
|---|---|
| private boolean | |
| public MaterialPreparedStatement | |
| pack-priv boolean | |
| pack-priv ColumnMetaData | |
| pack-priv boolean[] | |
| pack-priv Object[] | |
| private boolean[] | |
| private ArrayList | |
| private final ClientPooledConnection | |
| private String | |
| pack-priv String |
| Access | Constructor and Description |
|---|---|
| public | ClientPreparedStatement(Agent
The instance of NetAgent associated with this
CallableStatement object. agent, ClientConnection The connection object associated with this
PreparedStatement Object. connection, String A String object that is the SQL statement to be sent
to the database. sql, Section Section section, ClientPooledConnection The ClientPooledConnection wraps the underlying physical
connection associated with this prepared statement.
It is used to pass the Statement closed and the Statement
error occurred events that occur back to the
ClientPooledConnection. cpc)The PreparedStatement constructor used for JDBC 2 positioned update statements. |
| public | ClientPreparedStatement(Agent
The instance of NetAgent associated with this
CallableStatement object. agent, ClientConnection The connection object associated with this
PreparedStatement Object. connection, String A String object that is the SQL statement
to be sent to the database. sql, int One of the ResultSet type constants. type, int One of the ResultSet concurrency constants. concurrency, int One of the ResultSet holdability constants. holdability, int a flag indicating whether auto-generated
keys should be returned. autoGeneratedKeys, String[] an array of column names indicating the columns that
should be returned from the inserted row or rows. columnNames, int[] an array of column names indicating the columns that
should be returned from the inserted row. columnIndexes, ClientPooledConnection The ClientPooledConnection wraps the underlying physical
connection associated with this prepared statement
it is used to pass the Statement closed and the Statement
error occurred events that occur back to the
ClientPooledConnection. cpc)The PreparedStatementConstructor used for jdbc 2 prepared statements with scroll attributes. |
| Modifier and Type | Method and Description |
|---|---|
| public void | addBatch(String
typically this is a SQL sql)INSERT or
UPDATE statementOverrides org. Implements java. Statement object.
|
| public void | addBatch()
Implements java. PreparedStatement
object's batch of commands.
|
| pack-priv void | |
| pack-priv void | |
| private void | |
| protected void | |
| private void | checkStreamLength(long
The length of the stream being set length)Check the length passed in for the stream that is to be set. |
| private void | |
| private void | |
| private void | |
| private void | |
| private void | |
| private void | |
| public void | clearParameters()
Implements java. |
| public void | completeDescribeInput(ColumnMetaData parameterMetaData, Sqlca sqlca)
Implements org. |
| public void | completeDescribeOutput(ColumnMetaData resultSetMetaData, Sqlca sqlca)
Implements org. |
| public void | completeLocalCommit(Iterator<E> listenerIterator)
Overrides org. Implements org. |
| public void | completeLocalRollback(Iterator<E> listenerIterator)
Overrides org. Implements org. |
| private void | |
| public boolean | execute(String
any SQL statement sql)Overrides org. Implements java. |
| public boolean | execute()
Implements java. PreparedStatement object,
which may be any kind of SQL statement.
|
| public 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_KEYSOverrides org. Implements java. |
| public 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)getGeneratedKeysOverrides org. Implements java. |
| public 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)getGeneratedKeysOverrides org. Implements java. |
| public int[] | executeBatch()
Overrides org. Implements java. |
| private long[] | |
| private long[] | |
| public 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 ResultSet | executeQuery(String
an SQL statement to be sent to the database, typically a
static SQL sql)SELECT statementOverrides org. Implements java. ResultSet object.
|
| public ResultSet | executeQuery()
Implements java. PreparedStatement object
and returns the ResultSet object generated by the query.
|
| pack-priv ClientResultSet | |
| public 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.Overrides org. Implements java. INSERT,
UPDATE, or DELETE statement or an
SQL statement that returns nothing, such as an SQL DDL statement.
|
| public 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 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_KEYSOverrides org. Implements java. Statement object
should be made available for retrieval.
|
| public 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)Overrides org. Implements java. |
| public 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)Overrides org. Implements java. |
| private long | |
| pack-priv boolean | |
| private boolean[] | |
| private Object[] | |
| private void | |
| pack-priv void | |
| private ColumnMetaData | |
| protected String | Returns: name of java.sql interfaceOverrides org. |
| public 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.
|
| private ColumnMetaData | |
| public ParameterMetaData | getParameterMetaData()
Implements java. PreparedStatement object's parameters.
|
| private ClientParameterMetaData | |
| private void | |
| private void | |
| private void | |
| protected void | |
| public void | |
| protected void | markClosed(boolean
if true the Statement will be removed
from the open statements list and PreparedStatement will also be removed
from commit and rollback listeners list in
removeListener)org.apache.derby.client.am.Connection.Overrides org. |
| pack-priv void | |
| private void | |
| private void | |
| private void | |
| private void | |
| public void | |
| pack-priv void | resetForReuse()
Overrides org. |
| private void | |
| private void | |
| public void | resetPreparedStatement(Agent agent, ClientConnection connection, String sql, int type, int concurrency, int holdability, int autoGeneratedKeys, String[] columnNames, int[] columnIndexes)
|
| public 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 void | setAsciiStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the ASCII parameter value x, long the number of bytes in the stream length)Implements java. |
| public void | setAsciiStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the ASCII parameter value x, int the number of bytes in the stream length)Implements java. |
| public 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 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 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 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 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. |
| private void | |
| public 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 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 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. |
| private void | |
| public void | setBoolean(int
the first parameter is 1, the second is 2, ... parameterIndex, boolean the parameter value x)Implements java. boolean value.
|
| public void | setByte(int
the first parameter is 1, the second is 2, ... parameterIndex, byte the parameter value x)Implements java. byte value.
|
| public void | setBytes(int
the first parameter is 1, the second is 2, ... parameterIndex, byte[] the parameter value x)Implements java. |
| pack-priv void | |
| public void | setCharacterStream(int
the first parameter is 1, the second is 2, ... parameterIndex, Reader the x)java.io.Reader object that contains the
Unicode dataImplements java. Reader object.
|
| public void | setCharacterStream(int
the index of the parameter to which this set
method is applied parameterIndex, Reader the java Reader which contains the UNICODE value x, long the number of bytes in the stream length)Implements java. |
| public void | setCharacterStream(int
the index of the parameter to which this
set method is applied parameterIndex, Reader the java Reader which contains the UNICODE value x, int the number of bytes in the stream length)Implements java. |
| public 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 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 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. |
| private void | |
| public void | setDate(int
the first parameter is 1, the second is 2, ... parameterIndex, Date the parameter value x, Calendar the calendar)Calendar object the driver will use
to construct the dateImplements java. java.sql.Date value,
using the given Calendar object.
|
| public 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 void | setDouble(int
the first parameter is 1, the second is 2, ... parameterIndex, double the parameter value x)Implements java. double value.
|
| public void | setFloat(int
the first parameter is 1, the second is 2, ... parameterIndex, float the parameter value x)Implements java. float value.
|
| pack-priv void | |
| public void | setInt(int
the first parameter is 1, the second is 2, ... parameterIndex, int the parameter value x)Implements java. int value.
|
| pack-priv void | |
| public void | setLong(int
the first parameter is 1, the second is 2, ... parameterIndex, long the parameter value x)Implements java. long value.
|
| pack-priv void | |
| public void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... parameterIndex, Reader the parameter value value)Implements java. Reader object.
|
| public void | setNCharacterStream(int
of the first parameter is 1, the second is 2, ... index, Reader the parameter value value, long the number of characters in the parameter data. length)Implements java. Reader object.
|
| public 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 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 void | setNClob(int
of the first parameter is 1, the second is 2, ... index, NClob the parameter value value)Implements java. java.sql.NClob object.
|
| public void | setNString(int
of the first parameter is 1, the second is 2, ... index, String the parameter value value)Implements java. String object.
|
| public void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int the SQL type code defined in jdbcType)java.sql.TypesImplements java. NULL.
|
| public void | setNull(int
the first parameter is 1, the second is 2, ... parameterIndex, int a value from jdbcType, 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.
|
| pack-priv void | |
| public 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 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 targetJdbcType)Implements java. |
| public 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. targetJdbcType, int for scale)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. |
| private void | |
| public 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 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 void | setShort(int
the first parameter is 1, the second is 2, ... parameterIndex, short the parameter value x)Implements java. short value.
|
| pack-priv void | |
| public 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 void | setString(int
the first parameter is 1, the second is 2, ... parameterIndex, String the parameter value x)Implements java. String value.
|
| pack-priv void | |
| public void | setTime(int
the first parameter is 1, the second is 2, ... parameterIndex, Time the parameter value x, Calendar the calendar)Calendar object the driver will use
to construct the timeImplements java. java.sql.Time value,
using the given Calendar object.
|
| public 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 void | setTimestamp(int
the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x, Calendar the calendar)Calendar object the driver will use
to construct the timestampImplements java. java.sql.Timestamp value,
using the given Calendar object.
|
| public void | setTimestamp(int
the first parameter is 1, the second is 2, ... parameterIndex, Timestamp the parameter value x)Implements java. java.sql.Timestamp value.
|
| private void | |
| public void | setUnicodeStream(int
the first parameter is 1, the second is 2, ... parameterIndex, InputStream the java input stream which contains the UNICODE parameter
value x, int the number of bytes in the stream length)Implements java.
Deprecated
Sets the specified parameter to the given input stream.
|
| public 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.
|
| private void | |
| private void | writeExecute(Section section, ColumnMetaData parameterMetaData, Object[] inputs, int numInputColumns, boolean outputExpected, boolean chainedWritesFollowingSetLob)
|
| private void | writeOpenQuery(Section section, int fetchSize, int resultSetType, int numInputColumns, ColumnMetaData parameterMetaData, Object[] inputs)
|
| private void | |
| private void |