| java.lang.Object
 org.apache.derby.impl.jdbc.ConnectionChild
org.apache.derby.impl.jdbc.EmbedStatement
org.apache.derby.impl.jdbc.EmbedPreparedStatement
All known Subclasses: org.apache.derby.impl.jdbc.EmbedPreparedStatement20, org.apache.derby.impl.jdbc.EmbedCallableStatement, org.apache.derby.impl.jdbc.EmbedPreparedStatement169,
| Method Summary | |
| final public void | addBatch(String sql)
| | public void | addBatch()
JDBC 2.0
Add a set of parameters to the batch. | | public void | clearParameters()
In general, parameter values remain in force for repeated use of a
Statement. | | void | closeActions()
Additional close to close our activation.
In the case that a XAConnection is involved in the creation of this
PreparedStatement for e.g in the following case
XAConnection xaconn = xadatasource.getXAConnection();//where xadatasource is an object of XADataSource
Connection conn = xaconnection.getConnection();
PreparedStatement ps = conn.preparedStatement("values 1");
In the above case the PreparedStatement will actually be a
BrokeredPreparedStatement40 object. | | final SQLException | dataTypeConversion(int column, String sourceType)
| | final public boolean | execute(String sql)
| | final public boolean | execute(String sql, int autoGenKeys)
| | final public boolean | execute(String sql, int[] columnIndexes)
| | final public boolean | execute(String sql, String[] columnNames)
| | final public boolean | execute()
| | boolean | executeBatchElement(Object batchElement)
| | final public java.sql.ResultSet | executeQuery(String sql)
| | final public java.sql.ResultSet | executeQuery()
A prepared SQL query is executed and its ResultSet is returned. | | boolean | executeStatement(Activation a, boolean executeQuery, boolean executeUpdate)
| | final public int | executeUpdate(String sql)
| | final public int | executeUpdate(String sql, int autoGenKeys)
| | final public int | executeUpdate(String sql, int[] columnIndexes)
| | final public int | executeUpdate(String sql, String[] columnNames)
| | final public int | executeUpdate()
Execute a SQL INSERT, UPDATE or DELETE statement. | | protected void | finalize()
JDBC states that a Statement is closed when garbage collected. | | public EngineParameterMetaData | getEmbedParameterSetMetaData()
Immitate the function in JDBC 3.0
Retrieves the number, types and properties of this PreparedStatement
object's parameters. | | public java.sql.ResultSetMetaData | getMetaData()
JDBC 2.0
The number, types and properties of a ResultSet's columns
are provided by the getMetaData method. | | protected int | getParameterJDBCType(int parameterIndex)
Get the target JDBC type for a parameter. | | final protected String | getParameterSQLType(int parameterIndex)
Return the SQL type name for the parameter. | | final public ParameterValueSet | getParms()
| | final protected DataTypeDescriptor[] | getTypes(int parameterIndex)
Check the parameterINdex is in range and return the
array of type descriptors. | | protected EmbedResultSetMetaData | newEmbedResultSetMetaData(ResultDescription resultDesc)
| | final public void | setAsciiStream(int parameterIndex, InputStream x, long length)
We do this inefficiently and read it all in here. | | final public void | setAsciiStream(int parameterIndex, InputStream x, int length)
We do this inefficiently and read it all in here. | | public void | setAsciiStream(int parameterIndex, InputStream x)
Sets the designated parameter to the given input stream.
When a very large ASCII value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. | | public void | setBinaryStream(int parameterIndex, InputStream x)
Sets the designated parameter to the given input stream.
When a very large binary value is input to a LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream object. | | final public void | setBinaryStream(int parameterIndex, InputStream x, long length)
| | final public void | setBinaryStream(int parameterIndex, InputStream x, int length)
| | public void | setBlob(int i, Blob x)
JDBC 2.0
Set a BLOB parameter. | | public void | setBlob(int parameterIndex, InputStream inputStream)
Sets the designated parameter to a InputStream object.
This method differs from the setBinaryStream(int, InputStream)
method because it informs the driver that the parameter value
should be sent to the server as a BLOB. | | public void | setBlob(int parameterIndex, InputStream inputStream, long length)
Sets the designated parameter to a InputStream object. | | public void | setBoolean(int parameterIndex, boolean x)
Set a parameter to a Java boolean value. | | public void | setBrokeredConnectionControl(BrokeredConnectionControl control)
| | public void | setByte(int parameterIndex, byte x)
Set a parameter to a Java byte value. | | public void | setBytes(int parameterIndex, byte x)
Set a parameter to a Java array of bytes. | | final public void | setCharacterStream(int parameterIndex, java.io.Reader reader, long length)
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. | | final public void | setCharacterStream(int parameterIndex, java.io.Reader reader, int length)
When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. | | public void | setCharacterStream(int parameterIndex, Reader reader)
Sets the designated parameter to the given Reader object.
When a very large UNICODE value is input to a LONGVARCHAR parameter, it
may be more practical to send it via a java.io.Reader
object. | | public void | setClob(int i, Clob x)
JDBC 2.0
Set a CLOB parameter. | | public void | setClob(int parameterIndex, Reader reader)
Sets the designated parameter to a Reader object.
This method differs from the setCharacterStream(int,Reader)
method because it informs the driver that the parameter value should be
sent to the server as a CLOB. | | public void | setClob(int parameterIndex, Reader reader, long length)
Sets the designated parameter to a Reader object. | | public void | setDate(int parameterIndex, Date x)
Set a parameter to a java.sql.Date value. | | final public void | setDate(int parameterIndex, java.sql.Date x, Calendar cal)
Set a parameter to a java.sql.Date value. | | public void | setDouble(int parameterIndex, double x)
Set a parameter to a Java double value. | | public void | setFloat(int parameterIndex, float x)
Set a parameter to a Java float value. | | public void | setInt(int parameterIndex, int x)
Set a parameter to a Java int value. | | public void | setLong(int parameterIndex, long x)
Set a parameter to a Java long value. | | public void | setNull(int parameterIndex, int sqlType)
Set a parameter to SQL NULL. | | public void | setNull(int paramIndex, int sqlType, String typeName)
JDBC 2.0
Sets the designated parameter to SQL NULL.
This version of the method setNull should
be used for user-defined types and REF type parameters. | | final public void | setObject(int parameterIndex, Object x, int targetSqlType, int scale)
The interface says that the type of the Object parameter must
be compatible with the type of the targetSqlType. | | final public void | setObject(int parameterIndex, Object x, int targetSqlType)
This method is like setObject above, but assumes a scale of zero. | | final public void | setObject(int parameterIndex, Object x)
Set the value of a parameter using an object; use the
java.lang equivalent objects for integral values.
The JDBC specification specifies a standard mapping from
Java Object types to SQL types. | | boolean | setObjectConvert(int parameterIndex, Object x)
Allow explict setObject conversions by sub-classes for classes
not supported by this variant. | | public void | setShort(int parameterIndex, short x)
Set a parameter to a Java short value. | | public void | setString(int parameterIndex, String x)
Set a parameter to a Java String value. | | public void | setTime(int parameterIndex, Time x)
Set a parameter to a java.sql.Time value. | | final public void | setTime(int parameterIndex, java.sql.Time x, Calendar cal)
Set a parameter to a java.sql.Time value. | | public void | setTimestamp(int parameterIndex, Timestamp x)
Set a parameter to a java.sql.Timestamp value. | | final public void | setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar cal)
Set a parameter to a java.sql.Timestamp value. | | final public void | setURL(int parameterIndex, java.net.URL x)
JDBC 3.0
Sets the designated parameter to the given java.net.URL value. | | public void | setUnicodeStream(int parameterIndex, InputStream x, int length)
| | public String | toString()
| | public void | transferParameters(EmbedPreparedStatement newStatement)
|
| EmbedPreparedStatement | | public EmbedPreparedStatement(EmbedConnection conn, String sql, boolean forMetaData, int resultSetType, int resultSetConcurrency, int resultSetHoldability, int autoGeneratedKeys, int[] columnIndexes, String[] columnNames) throws SQLException(Code) | | |
| addBatch | | public void addBatch() throws SQLException(Code) | | JDBC 2.0
Add a set of parameters to the batch.
exception:
SQLException - if a database-access error occurs. |
| clearParameters | | public void clearParameters() throws SQLException(Code) | | In general, parameter values remain in force for repeated use of a
Statement. Setting a parameter value automatically clears its
previous value. However, in some cases it is useful to immediately
release the resources used by the current parameter values; this can
be done by calling clearParameters.
exception:
SQLException - thrown on failure. |
| closeActions | | void closeActions() throws SQLException(Code) | | Additional close to close our activation.
In the case that a XAConnection is involved in the creation of this
PreparedStatement for e.g in the following case
XAConnection xaconn = xadatasource.getXAConnection();//where xadatasource is an object of XADataSource
Connection conn = xaconnection.getConnection();
PreparedStatement ps = conn.preparedStatement("values 1");
In the above case the PreparedStatement will actually be a
BrokeredPreparedStatement40 object. Hence when we call
bcc.onStatementClose and pass the PreparedStatement that caused it
applicationStatement will be the appropriate choice since it will
contain the appropriate instance of PreparedStatement in each case
throws:
SQLException - upon failure |
| executeQuery | | final public java.sql.ResultSet executeQuery() throws SQLException(Code) | | A prepared SQL query is executed and its ResultSet is returned.
a ResultSet that contains the data produced by thequery; never null
exception:
SQLException - thrown on failure. |
| executeUpdate | | final public int executeUpdate() throws SQLException(Code) | | Execute a SQL INSERT, UPDATE or DELETE statement. In addition,
SQL statements that return nothing such as SQL DDL statements
can be executed.
either the row count for INSERT, UPDATE or DELETE; or 0for SQL statements that return nothing
exception:
SQLException - thrown on failure. |
| finalize | | protected void finalize() throws Throwable(Code) | | JDBC states that a Statement is closed when garbage collected.
exception:
Throwable - Allows any exception to be thrown during finalize |
| getEmbedParameterSetMetaData | | public EngineParameterMetaData getEmbedParameterSetMetaData() throws SQLException(Code) | | Immitate the function in JDBC 3.0
Retrieves the number, types and properties of this PreparedStatement
object's parameters.
a EngineParameterMetaData object that contains information about thenumber, types and properties of this PreparedStatement object's parameters.
exception:
SQLException - if a database access error occurs |
| getMetaData | | public java.sql.ResultSetMetaData getMetaData() throws SQLException(Code) | | JDBC 2.0
The number, types and properties of a ResultSet's columns
are provided by the getMetaData method.
the description of a ResultSet's columns
exception:
SQLException - Feature not implemented for now. |
| getParameterJDBCType | | protected int getParameterJDBCType(int parameterIndex) throws SQLException(Code) | | Get the target JDBC type for a parameter. Will throw exceptions
if the parameter index is out of range
exception:
SQLException - parameter is out of range |
| getParameterSQLType | | final protected String getParameterSQLType(int parameterIndex) throws SQLException(Code) | | Return the SQL type name for the parameter.
Parameters:
parameterIndex - the 1-based index of the parameter SQL name of the parameter
throws:
SQLException - if parameter is out of range |
| getParms | | final public ParameterValueSet getParms()(Code) | | Get the ParameterValueSet from the activation
The ParameterValueSet for the activation |
| setAsciiStream | | final public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException(Code) | | We do this inefficiently and read it all in here. The target type
is assumed to be a String.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains the ASCII parameter value
Parameters:
length - the number of bytes in the stream
exception:
SQLException - thrown on failure. |
| setAsciiStream | | final public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | We do this inefficiently and read it all in here. The target type
is assumed to be a String.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains the ASCII parameter value
Parameters:
length - the number of bytes in the stream
exception:
SQLException - thrown on failure. |
| setAsciiStream | | public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException(Code) | | Sets the designated parameter to the given input stream.
When a very large ASCII value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.InputStream. Data will be read from the stream as
needed until end-of-file is reached. The JDBC driver will do any
necessary conversion from ASCII to the database char format.
Note: This stream object can either be a standard Java stream
object or your own subclass that implements the standard interface.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the Java input stream that contains the ASCII parameter value
throws:
SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement |
| setBinaryStream | | public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException(Code) | | Sets the designated parameter to the given input stream.
When a very large binary value is input to a LONGVARBINARY
parameter, it may be more practical to send it via a
java.io.InputStream object. The data will be read from the
stream as needed until end-of-file is reached.
Note: This stream object can either be a standard Java stream
object or your own subclass that implements the standard interface.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains the binary parameter value
throws:
SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement |
| setBinaryStream | | final public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException(Code) | | sets the parameter to the Binary stream
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains the binary parameter value
Parameters:
length - the number of bytes in the stream
exception:
SQLException - thrown on failure. |
| setBinaryStream | | final public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | sets the parameter to the binary stream
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains the binary parameter value
Parameters:
length - the number of bytes in the stream
exception:
SQLException - thrown on failure. |
| setBlob | | public void setBlob(int i, Blob x) throws SQLException(Code) | | JDBC 2.0
Set a BLOB parameter.
Parameters:
i - the first parameter is 1, the second is 2, ...
Parameters:
x - an object representing a BLOB |
| setBlob | | public void setBlob(int parameterIndex, InputStream inputStream) throws SQLException(Code) | | Sets the designated parameter to a InputStream object.
This method differs from the setBinaryStream(int, InputStream)
method because it informs the driver that the parameter value
should be sent to the server as a BLOB. When the
setBinaryStream method is used, the driver may have to do
extra work to determine whether the parameter data should be sent to the
server as a LONGVARBINARY or a BLOB
Parameters:
parameterIndex - index of the first parameter is 1, the second is2, ...
Parameters:
inputStream - an object that contains the data to set the parametervalue to.
throws:
SQLException - if a database access error occurs, this method iscalled on a closed PreparedStatement or ifparameterIndex does not correspond to a parametermarker in the SQL statement |
| setBlob | | public void setBlob(int parameterIndex, InputStream inputStream, long length) throws SQLException(Code) | | Sets the designated parameter to a InputStream object.
Parameters:
parameterIndex - index of the first parameter is 1,the second is 2, ...
Parameters:
inputStream - An object that contains the data to set the parametervalue to.
Parameters:
length - the number of bytes in the parameter data.
throws:
SQLException - if parameterIndex does not correspondto a parameter marker in the SQL statement, if the length specifiedis less than zero or if the number of bytes in the inputstream does not matchthe specfied length. |
| setBoolean | | public void setBoolean(int parameterIndex, boolean x) throws SQLException(Code) | | Set a parameter to a Java boolean value. According to the JDBC API spec,
the driver converts this to a SQL BIT value when it sends it to the
database. But we don't have to do this, since the database engine
supports a boolean type.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setByte | | public void setByte(int parameterIndex, byte x) throws SQLException(Code) | | Set a parameter to a Java byte value. The driver converts this
to a SQL TINYINT value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setBytes | | public void setBytes(int parameterIndex, byte x) throws SQLException(Code) | | Set a parameter to a Java array of bytes. The driver converts
this to a SQL VARBINARY or LONGVARBINARY (depending on the
argument's size relative to the driver's limits on VARBINARYs)
when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setCharacterStream | | final public void setCharacterStream(int parameterIndex, java.io.Reader reader, long length) throws SQLException(Code) | | When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. JDBC will read the data from the stream
as needed, until it reaches end-of-file. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard
Java stream object or your own subclass that implements the
standard interface.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
reader - the java reader which contains the UNICODE data
Parameters:
length - the number of characters in the stream
exception:
SQLException - if a database-access error occurs. |
| setCharacterStream | | final public void setCharacterStream(int parameterIndex, java.io.Reader reader, int length) throws SQLException(Code) | | When a very large UNICODE value is input to a LONGVARCHAR
parameter, it may be more practical to send it via a
java.io.Reader. JDBC will read the data from the stream
as needed, until it reaches end-of-file. The JDBC driver will
do any necessary conversion from UNICODE to the database char format.
Note: This stream object can either be a standard
Java stream object or your own subclass that implements the
standard interface.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
reader - the java reader which contains the UNICODE data
Parameters:
length - the number of characters in the stream
exception:
SQLException - if a database-access error occurs. |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader reader) throws SQLException(Code) | | Sets the designated parameter to the given Reader object.
When a very large UNICODE value is input to a LONGVARCHAR parameter, it
may be more practical to send it via a java.io.Reader
object. The data will be read from the stream as needed until
end-of-file is reached. The JDBC driver will do any necessary conversion
from UNICODE to the database char format.
Note: This stream object can either be a standard Java stream
object or your own subclass that implements the standard interface.
Using this lengthless overload is not less effective than using one
where the stream length is specified, but since there is no length
specified, the exact length check will not be performed.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
reader - the java.io.Reader object that contains theUnicode data
throws:
SQLException - if a database access error occurs or this method iscalled on a closed PreparedStatement |
| setClob | | public void setClob(int i, Clob x) throws SQLException(Code) | | JDBC 2.0
Set a CLOB parameter.
Parameters:
i - the first parameter is 1, the second is 2, ...
Parameters:
x - an object representing a CLOB |
| setClob | | public void setClob(int parameterIndex, Reader reader) throws SQLException(Code) | | Sets the designated parameter to a Reader object.
This method differs from the setCharacterStream(int,Reader)
method because it informs the driver that the parameter value should be
sent to the server as a CLOB. When the
setCharacterStream method is used, the driver may have to
do extra work to determine whether the parameter data should be sent to
the server as a LONGVARCHAR or a CLOB.
Parameters:
parameterIndex - index of the first parameter is 1, the second is2, ...
Parameters:
reader - an object that contains the data to set the parametervalue to.
throws:
SQLException - if a database access error occurs, this method iscalled on a closed PreparedStatementor if parameterIndex does notcorrespond to a parameter marker in the SQL statement |
| setClob | | public void setClob(int parameterIndex, Reader reader, long length) throws SQLException(Code) | | Sets the designated parameter to a Reader object.
Parameters:
parameterIndex - index of the first parameter is 1, the second is 2, ...
Parameters:
reader - An object that contains the data to set the parameter value to.
Parameters:
length - the number of characters in the parameter data.
throws:
SQLException - if parameterIndex does not correspond to a parametermarker in the SQL statement, or if the length specified is less than zero. |
| setDate | | public void setDate(int parameterIndex, Date x) throws SQLException(Code) | | Set a parameter to a java.sql.Date value. The driver converts this
to a SQL DATE value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setDate | | final public void setDate(int parameterIndex, java.sql.Date x, Calendar cal) throws SQLException(Code) | | Set a parameter to a java.sql.Date value. The driver converts this
to a SQL DATE value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - Feature not implemented for now. |
| setDouble | | public void setDouble(int parameterIndex, double x) throws SQLException(Code) | | Set a parameter to a Java double value. The driver converts this
to a SQL DOUBLE value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setFloat | | public void setFloat(int parameterIndex, float x) throws SQLException(Code) | | Set a parameter to a Java float value. The driver converts this
to a SQL FLOAT value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setInt | | public void setInt(int parameterIndex, int x) throws SQLException(Code) | | Set a parameter to a Java int value. The driver converts this
to a SQL INTEGER value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setLong | | public void setLong(int parameterIndex, long x) throws SQLException(Code) | | Set a parameter to a Java long value. The driver converts this
to a SQL BIGINT value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setNull | | public void setNull(int parameterIndex, int sqlType) throws SQLException(Code) | | Set a parameter to SQL NULL.
Note: You must specify the parameter's SQL type.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
sqlType - SQL type code defined by java.sql.Types
exception:
SQLException - thrown on failure. |
| setNull | | public void setNull(int paramIndex, int sqlType, String typeName) throws SQLException(Code) | | JDBC 2.0
Sets the designated parameter to SQL NULL.
This version of the method setNull should
be used for user-defined types and REF type parameters. Examples
of user-defined types include: STRUCT, DISTINCT, JAVA_OBJECT, and
named array types.
Parameters:
paramIndex - the first parameter is 1, the second is 2, ...
Parameters:
sqlType - a value from java.sql.Types
Parameters:
typeName - the fully-qualified name of an SQL user-defined type;ignored if the parameter is not a user-defined type or REF
exception:
SQLException - if a database access error occurs orthis method is called on a closed PreparedStatement
exception:
SQLFeatureNotSupportedException - if sqlType isa ARRAY, BLOB, CLOB,DATALINK, JAVA_OBJECT, NCHAR,NCLOB, NVARCHAR, LONGNVARCHAR,REF, ROWID, SQLXMLor STRUCT data type and the JDBC driver does not supportthis data type or if the JDBC driver does not support this method |
| setObject | | final public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException(Code) | | The interface says that the type of the Object parameter must
be compatible with the type of the targetSqlType. We check that,
and if it flies, we expect the underlying engine to do the
required conversion once we pass in the value using its type.
So, an Integer converting to a CHAR is done via setInteger()
support on the underlying CHAR type.
If x is null, it won't tell us its type, so we pass it on to setNull
Parameters:
parameterIndex - The first parameter is 1, the second is 2, ...
Parameters:
x - The object containing the input parameter value
Parameters:
targetSqlType - The SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type.
Parameters:
scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored,
exception:
SQLException - thrown on failure. |
| setObject | | final public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException(Code) | | This method is like setObject above, but assumes a scale of zero.
exception:
SQLException - thrown on failure. |
| setObject | | final public void setObject(int parameterIndex, Object x) throws SQLException(Code) | | Set the value of a parameter using an object; use the
java.lang equivalent objects for integral values.
The JDBC specification specifies a standard mapping from
Java Object types to SQL types. The given argument java object
will be converted to the corresponding SQL type before being
sent to the database.
Note that this method may be used to pass datatabase
specific abstract data types, by using a Driver specific Java
type.
Parameters:
parameterIndex - The first parameter is 1, the second is 2, ...
Parameters:
x - The object containing the input parameter value
exception:
SQLException - thrown on failure. |
| setObjectConvert | | boolean setObjectConvert(int parameterIndex, Object x) throws SQLException(Code) | | Allow explict setObject conversions by sub-classes for classes
not supported by this variant. E.g. BigDecimal
This top-level implementation always returns false.
true if the object was set successfully, false if no validconversion exists.
exception:
SQLException - value could not be set. |
| setShort | | public void setShort(int parameterIndex, short x) throws SQLException(Code) | | Set a parameter to a Java short value. The driver converts this
to a SQL SMALLINT value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setString | | public void setString(int parameterIndex, String x) throws SQLException(Code) | | Set a parameter to a Java String value. The driver converts this
to a SQL VARCHAR or LONGVARCHAR value (depending on the arguments
size relative to the driver's limits on VARCHARs) when it sends
it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setTime | | public void setTime(int parameterIndex, Time x) throws SQLException(Code) | | Set a parameter to a java.sql.Time value. The driver converts this
to a SQL TIME value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setTime | | final public void setTime(int parameterIndex, java.sql.Time x, Calendar cal) throws SQLException(Code) | | Set a parameter to a java.sql.Time value. The driver converts this
to a SQL TIME value when it sends it to the database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - Feature not implemented for now. |
| setTimestamp | | public void setTimestamp(int parameterIndex, Timestamp x) throws SQLException(Code) | | Set a parameter to a java.sql.Timestamp value. The driver
converts this to a SQL TIMESTAMP value when it sends it to the
database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - thrown on failure. |
| setTimestamp | | final public void setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar cal) throws SQLException(Code) | | Set a parameter to a java.sql.Timestamp value. The driver
converts this to a SQL TIMESTAMP value when it sends it to the
database.
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the parameter value
exception:
SQLException - Feature not implemented for now. |
| setURL | | final public void setURL(int parameterIndex, java.net.URL x) throws SQLException(Code) | | JDBC 3.0
Sets the designated parameter to the given java.net.URL value. The driver
converts this to an SQL DATALINK value when it sends it to the database.
Parameters:
parameterIndex - - the first parameter is 1, the second is 2, ...
Parameters:
x - - the java.net.URL object to be set
exception:
SQLException - Feature not implemented for now. |
| setUnicodeStream | | public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | Deprecated in JDBC 3.0
Parameters:
parameterIndex - the first parameter is 1, the second is 2, ...
Parameters:
x - the java input stream which contains theUNICODE parameter value
Parameters:
length - the number of bytes in the stream
exception:
SQLException - thrown on failure. |
|
|