| Methods Summary |
|---|
| public java.sql.ResultSet | executeQuery()Executes the SQL query in this PreparedStatement object
and returns the ResultSet object generated by the query.
ResultSet rs = preparedStatement.executeQuery();
if (rs == null)
return null;
return new ResultSetWrapper40(this, rs);
|
| public java.sql.ResultSet | executeQuery(java.lang.String sql)Executes the given SQL statement, which returns a single
ResultSet object.
ResultSet rs = preparedStatement.executeQuery(sql);
if (rs == null)
return null;
return new ResultSetWrapper40(this, rs);
|
| public java.sql.ResultSet | getGeneratedKeys()Retrieves any auto-generated keys created as a result of executing this
Statement object. If this Statement object did
not generate any keys, an empty ResultSet
object is returned.
Note:If the columns which represent the auto-generated keys were not specified,
the JDBC driver implementation will determine the columns which best represent the auto-generated keys.
ResultSet rs = preparedStatement.getGeneratedKeys();
if (rs == null)
return null;
return new ResultSetWrapper40(this, rs);
|
| public java.sql.ResultSet | getResultSet()Retrieves the current result as a ResultSet object.
This method should be called only once per result.
ResultSet rs = preparedStatement.getResultSet();
if (rs == null)
return null;
return new ResultSetWrapper40(this, rs);
|
| public boolean | isClosed()Retrieves whether this Statement object has been closed. A Statement is closed if the
method close has been called on it, or if it is automatically closed.
return preparedStatement.isClosed();
|
| public boolean | isPoolable()Returns a value indicating whether the Statement
is poolable or not.
return preparedStatement.isPoolable();
|
| public boolean | isWrapperFor(java.lang.Class iface)Returns true if this either implements the interface argument or is directly or indirectly a wrapper
for an object that does. Returns false otherwise. If this implements the interface then return true,
else if this is a wrapper then return the result of recursively calling isWrapperFor on the wrapped
object. If this does not implement the interface and is not a wrapper, return false.
This method should be implemented as a low-cost operation compared to unwrap so that
callers can use this method to avoid expensive unwrap calls that may fail. If this method
returns true then calling unwrap with the same argument should succeed.
boolean result ;
if (iface.isInstance(this)) {
result = true;
}else{
result = preparedStatement.isWrapperFor(iface);
}
return result;
|
| public void | setAsciiStream(int parameterIndex, java.io.InputStream x, long length)Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
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.
preparedStatement.setAsciiStream(parameterIndex, x, length);
|
| public void | setAsciiStream(int parameterIndex, java.io.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. 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.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setAsciiStream which takes a length parameter.
preparedStatement.setAsciiStream(parameterIndex, x);
|
| public void | setBinaryStream(int parameterIndex, java.io.InputStream x, long length)Sets the designated parameter to the given input stream, which will have
the specified number of bytes.
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.
preparedStatement.setBinaryStream(parameterIndex, x, length);
|
| public void | setBinaryStream(int parameterIndex, java.io.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. 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.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBinaryStream which takes a length parameter.
preparedStatement.setBinaryStream(parameterIndex, x);
|
| public void | setBlob(int parameterIndex, java.io.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. 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
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setBlob which takes a length parameter.
preparedStatement.setBlob(parameterIndex, inputStream);
|
| public void | setBlob(int parameterIndex, java.io.InputStream inputStream, long length)Sets the designated parameter to a InputStream object. The inputstream must contain the number
of characters specified by length otherwise a SQLException will be
generated when the PreparedStatement is executed.
This method differs from the setBinaryStream (int, InputStream, int)
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
preparedStatement.setBlob(parameterIndex, inputStream, length);
|
| public void | setCharacterStream(int parameterIndex, java.io.Reader reader, long length)Sets the designated parameter to the given Reader
object, which is the given number of characters long.
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.
preparedStatement.setCharacterStream(parameterIndex, reader, length);
|
| public void | setCharacterStream(int parameterIndex, java.io.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. 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.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setCharacterStream which takes a length parameter.
preparedStatement.setCharacterStream(parameterIndex, reader);
|
| public void | setClob(int parameterIndex, java.io.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. 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
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setClob which takes a length parameter.
preparedStatement.setClob(parameterIndex, reader);
|
| public void | setClob(int parameterIndex, java.io.Reader reader, long length)Sets the designated parameter to a Reader object. The reader must contain the number
of characters specified by length otherwise a SQLException will be
generated when the PreparedStatement is executed.
This method differs from the setCharacterStream (int, Reader, int) 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
preparedStatement.setClob(parameterIndex, reader, length);
|
| public void | setNCharacterStream(int parameterIndex, java.io.Reader value)Sets the designated parameter to a Reader object. The
Reader reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
Note: This stream object can either be a standard
Java stream object or your own subclass that implements the
standard interface.
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNCharacterStream which takes a length parameter.
preparedStatement.setNCharacterStream(parameterIndex, value);
|
| public void | setNCharacterStream(int parameterIndex, java.io.Reader value, long length)Sets the designated parameter to a Reader object. The
Reader reads the data till end-of-file is reached. The
driver does the necessary conversion from Java character format to
the national character set in the database.
preparedStatement.setNCharacterStream(parameterIndex, value, length);
|
| public void | setNClob(int parameterIndex, java.io.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 NCLOB. 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 LONGNVARCHAR or a NCLOB
Note: Consult your JDBC driver documentation to determine if
it might be more efficient to use a version of
setNClob which takes a length parameter.
preparedStatement.setNClob(parameterIndex, reader);
|
| public void | setNClob(int parameterIndex, java.sql.NClob value)Sets the designated parameter to a java.sql.NClob object. The driver converts this to a
SQL NCLOB value when it sends it to the database.
preparedStatement.setNClob(parameterIndex, value);
|
| public void | setNClob(int parameterIndex, java.io.Reader reader, long length)Sets the designated parameter to a Reader object. The reader must contain the number
of characters specified by length otherwise a SQLException will be
generated when the PreparedStatement is executed.
This method differs from the setCharacterStream (int, Reader, int) method
because it informs the driver that the parameter value should be sent to
the server as a NCLOB. 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 LONGNVARCHAR or a NCLOB
preparedStatement.setNClob(parameterIndex, reader, length);
|
| public void | setNString(int parameterIndex, java.lang.String value)Sets the designated paramter to the given String object.
The driver converts this to a SQL NCHAR or
NVARCHAR or LONGNVARCHAR value
(depending on the argument's
size relative to the driver's limits on NVARCHAR values)
when it sends it to the database.
preparedStatement.setNString(parameterIndex, value);
|
| public void | setPoolable(boolean poolable)Requests that a Statement be pooled or not pooled. The value
specified is a hint to the statement pool implementation indicating
whether the applicaiton wants the statement to be pooled. It is up to
the statement pool manager as to whether the hint is used.
The poolable value of a statement is applicable to both internal
statement caches implemented by the driver and external statement caches
implemented by application servers and other applications.
By default, a Statement is not poolable when created, and
a PreparedStatement and CallableStatement
are poolable when created.
preparedStatement.setPoolable(poolable);
|
| public void | setRowId(int parameterIndex, java.sql.RowId x)Sets the designated parameter to the given java.sql.RowId object. The
driver converts this to a SQL ROWID value when it sends it
to the database
preparedStatement.setRowId(parameterIndex, x);
|
| public void | setSQLXML(int parameterIndex, java.sql.SQLXML xmlObject)Sets the designated parameter to the given java.sql.SQLXML object.
The driver converts this to an
SQL XML value when it sends it to the database.
preparedStatement.setSQLXML(parameterIndex, xmlObject);
|
| public T | unwrap(java.lang.Class iface)Returns an object that implements the given interface to allow access to
non-standard methods, or standard methods not exposed by the proxy.
If the receiver implements the interface then the result is the receiver
or a proxy for the receiver. If the receiver is a wrapper
and the wrapped object implements the interface then the result is the
wrapped object or a proxy for the wrapped object. Otherwise return the
the result of calling unwrap recursively on the wrapped object
or a proxy for that result. If the receiver is not a
wrapper and does not implement the interface, then an SQLException is thrown.
T result ;
if (iface.isInstance(this)) {
result = iface.cast(this);
} else {
result = preparedStatement.unwrap(iface);
}
return result;
|
