Represents a prepared statement.
Methods |
void |
addBatch(String sql)
Calling this method is not legal on a PreparedStatement.
|
void |
addBatch(String sql) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
Throws:
SQLException - Unsupported Feature
|
void |
addBatch()
Adds the current settings to the batch.
|
void |
addBatch() throws SQLException
Adds the current settings to the batch.
|
boolean |
checkClosed(boolean write)
|
boolean |
checkClosed(boolean write)
|
void |
clearBatch()
Clears the batch.
|
void |
clearBatch() throws SQLException
Clears the batch.
|
void |
clearParameters()
Clears all parameters.
|
void |
clearParameters() throws SQLException
Clears all parameters.
Throws:
SQLException - if this object is closed or invalid
|
void |
close()
Closes this statement.
|
void |
close() throws SQLException
Closes this statement.
All result sets that where created by this statement
become invalid after calling this method.
|
boolean |
execute()
Executes an arbitrary statement.
|
boolean |
execute() throws SQLException
Executes an arbitrary statement. If another result set exists for this
statement, this will be closed (even if this statement fails). If auto
commit is on, and the statement is not a select, this statement will be
committed.
Returns:
true if a result set is available, false if not
Throws:
SQLException - if this object is closed or invalid
|
boolean |
execute(String sql)
Calling this method is not legal on a PreparedStatement.
|
boolean |
execute(String sql) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
Throws:
SQLException - Unsupported Feature
|
boolean |
execute(String sql, int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement.
|
boolean |
execute(String sql, int autoGeneratedKeys) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
autoGeneratedKeys - ignored
Throws:
SQLException - Unsupported Feature
|
boolean |
execute(String sql, int[] columnIndexes)
Calling this method is not legal on a PreparedStatement.
|
boolean |
execute(String sql, int[] columnIndexes) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
columnIndexes - ignored
Throws:
SQLException - Unsupported Feature
|
boolean |
execute(String sql, String[] columnNames)
Calling this method is not legal on a PreparedStatement.
|
boolean |
execute(String sql, String[] columnNames) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
columnNames - ignored
Throws:
SQLException - Unsupported Feature
|
int[] |
executeBatch()
Executes the batch.
|
int[] |
executeBatch() throws SQLException
Executes the batch.
If one of the batched statements fails, this database will continue.
Returns:
the array of update counts
|
ResultSet |
executeQuery()
Executes a query (select statement) and returns the result set.
|
ResultSet |
executeQuery() throws SQLException
Executes a query (select statement) and returns the result set. If
another result set exists for this statement, this will be closed (even
if this statement fails).
Returns:
the result set
Throws:
SQLException - if this object is closed or invalid
|
ResultSet |
executeQuery(String sql)
Calling this method is not legal on a PreparedStatement.
|
ResultSet |
executeQuery(String sql) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
Throws:
SQLException - Unsupported Feature
|
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
|
int |
executeUpdate() throws SQLException
Executes a statement (insert, update, delete, create, drop)
and returns the update count.
If another result set exists for this statement, this will be closed
(even if this statement fails).
If auto commit is on, this statement will be committed.
If the statement is a DDL statement (create, drop, alter) and does not
throw an exception, the current transaction (if any) is committed after
executing the statement.
Returns:
the update count (number of row affected by an insert, update or
delete, or 0 if no rows or the statement was a create, drop,
commit or rollback)
Throws:
SQLException - if this object is closed or invalid
|
int |
executeUpdate(String sql)
Calling this method is not legal on a PreparedStatement.
|
int |
executeUpdate(String sql) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
Throws:
SQLException - Unsupported Feature
|
int |
executeUpdate(String sql, int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement.
|
int |
executeUpdate(String sql, int autoGeneratedKeys) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
autoGeneratedKeys - ignored
Throws:
SQLException - Unsupported Feature
|
int |
executeUpdate(String sql, int[] columnIndexes)
Calling this method is not legal on a PreparedStatement.
|
int |
executeUpdate(String sql, int[] columnIndexes) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
columnIndexes - ignored
Throws:
SQLException - Unsupported Feature
|
int |
executeUpdate(String sql, String[] columnNames)
Calling this method is not legal on a PreparedStatement.
|
int |
executeUpdate(String sql, String[] columnNames) throws SQLException
Calling this method is not legal on a PreparedStatement.
Parameters:
sql - ignored
columnNames - ignored
Throws:
SQLException - Unsupported Feature
|
ResultSetMetaData |
getMetaData()
Gets the result set metadata of the query returned when the statement is
executed.
|
ResultSetMetaData |
getMetaData() throws SQLException
Gets the result set metadata of the query returned when the statement is
executed. If this is not a query, this method returns null.
Returns:
the meta data or null if this is not a query
Throws:
SQLException - if this object is closed
|
ParameterMetaData |
getParameterMetaData()
Get the parameter meta data of this prepared statement.
|
ParameterMetaData |
getParameterMetaData() throws SQLException
Get the parameter meta data of this prepared statement.
Returns:
the meta data
|
void |
setArray(int parameterIndex, Array x)
[Not supported] Sets the value of a parameter as a Array.
|
void |
setArray(int parameterIndex, Array x) throws SQLException
[Not supported] Sets the value of a parameter as a Array.
|
void |
setAsciiStream(int parameterIndex, InputStream x, int length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setAsciiStream(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setAsciiStream(int parameterIndex, InputStream x)
Sets the value of a parameter as an ASCII stream.
|
void |
setAsciiStream(int parameterIndex, InputStream x) throws SQLException
Sets the value of a parameter as an ASCII stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBigDecimal(int parameterIndex, BigDecimal x)
Sets the value of a parameter.
|
void |
setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(int parameterIndex, InputStream x, int length)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBinaryStream(int parameterIndex, InputStream x)
Sets the value of a parameter as an input stream.
|
void |
setBinaryStream(int parameterIndex, InputStream x) throws SQLException
Sets the value of a parameter as an input stream.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBlob(int parameterIndex, Blob x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(int parameterIndex, Blob x) throws SQLException
Sets the value of a parameter as a Blob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBlob(int parameterIndex, InputStream x)
Sets the value of a parameter as a Blob.
|
void |
setBlob(int parameterIndex, InputStream x) throws SQLException
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBlob(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as a Blob.
|
void |
setBlob(int parameterIndex, InputStream x, long length) throws SQLException
Sets the value of a parameter as a Blob.
This method does not close the stream.
The stream may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of bytes
Throws:
SQLException - if this object is closed
|
void |
setBoolean(int parameterIndex, boolean x)
Sets the value of a parameter.
|
void |
setBoolean(int parameterIndex, boolean x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setByte(int parameterIndex, byte x)
Sets the value of a parameter.
|
void |
setByte(int parameterIndex, byte x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setBytes(int parameterIndex, byte[] x)
Sets the value of a parameter as a byte array.
|
void |
setBytes(int parameterIndex, byte[] x) throws SQLException
Sets the value of a parameter as a byte array.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(int parameterIndex, Reader x, int length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(int parameterIndex, Reader x, int length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(int parameterIndex, Reader x)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(int parameterIndex, Reader x) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setCharacterStream(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a character stream.
|
void |
setCharacterStream(int parameterIndex, Reader x, long length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setClob(int parameterIndex, Clob x)
Sets the value of a parameter as a Clob.
|
void |
setClob(int parameterIndex, Clob x) throws SQLException
Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setClob(int parameterIndex, Reader x)
Sets the value of a parameter as a Clob.
|
void |
setClob(int parameterIndex, Reader x) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setClob(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a Clob.
|
void |
setClob(int parameterIndex, Reader x, long length) throws SQLException
Sets the value of a parameter as a Clob. This method does not close the
reader. The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setDate(int parameterIndex, Date x)
Sets the value of a parameter.
|
void |
setDate(int parameterIndex, Date x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setDate(int parameterIndex, Date x, Calendar calendar)
Sets the date using a specified time zone.
|
void |
setDate(int parameterIndex, Date x, Calendar calendar) throws SQLException
Sets the date using a specified time zone. The value will be converted to
the local time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
calendar - the calendar
Throws:
SQLException - if this object is closed
|
void |
setDouble(int parameterIndex, double x)
Sets the value of a parameter.
|
void |
setDouble(int parameterIndex, double x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setFloat(int parameterIndex, float x)
Sets the value of a parameter.
|
void |
setFloat(int parameterIndex, float x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setInt(int parameterIndex, int x)
Sets the value of a parameter.
|
void |
setInt(int parameterIndex, int x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setLong(int parameterIndex, long x)
Sets the value of a parameter.
|
void |
setLong(int parameterIndex, long x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNCharacterStream(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(int parameterIndex, Reader x, long length) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setNCharacterStream(int parameterIndex, Reader x)
Sets the value of a parameter as a character stream.
|
void |
setNCharacterStream(int parameterIndex, Reader x) throws SQLException
Sets the value of a parameter as a character stream.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNClob(int parameterIndex, NClob x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(int parameterIndex, NClob x) throws SQLException
Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNClob(int parameterIndex, Reader x)
Sets the value of a parameter as a Clob.
|
void |
setNClob(int parameterIndex, Reader x) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNClob(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a Clob.
|
void |
setNClob(int parameterIndex, Reader x, long length) throws SQLException
Sets the value of a parameter as a Clob.
This method does not close the reader.
The reader may be closed after executing the statement.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
length - the maximum number of characters
Throws:
SQLException - if this object is closed
|
void |
setNString(int parameterIndex, String x)
Sets the value of a parameter.
|
void |
setNString(int parameterIndex, String x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setNull(int parameterIndex, int sqlType)
Sets a parameter to null.
|
void |
setNull(int parameterIndex, int sqlType) throws SQLException
Sets a parameter to null.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
sqlType - the data type (Types.x)
Throws:
SQLException - if this object is closed
|
void |
setNull(int parameterIndex, int sqlType, String typeName)
Sets a parameter to null.
|
void |
setNull(int parameterIndex, int sqlType, String typeName) throws SQLException
Sets a parameter to null.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
sqlType - the data type (Types.x)
typeName - this parameter is ignored
Throws:
SQLException - if this object is closed
|
void |
setObject(int parameterIndex, Object x)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex, Object x) throws SQLException
Sets the value of a parameter.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setObject(int parameterIndex, Object x, int targetSqlType)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
Throws:
SQLException - if this object is closed
|
void |
setObject(int parameterIndex, Object x, int targetSqlType, int scale)
Sets the value of a parameter.
|
void |
setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException
Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Objects of unknown classes are serialized (on the client side).
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value, null is allowed
targetSqlType - the type as defined in java.sql.Types
scale - is ignored
Throws:
SQLException - if this object is closed
|
void |
setRef(int parameterIndex, Ref x)
[Not supported] Sets the value of a column as a reference.
|
void |
setRef(int parameterIndex, Ref x) throws SQLException
[Not supported] Sets the value of a column as a reference.
|
void |
setRowId(int parameterIndex, RowId x)
[Not supported] Sets the value of a parameter as a row id.
|
void |
setRowId(int parameterIndex, RowId x) throws SQLException
[Not supported] Sets the value of a parameter as a row id.
|
void |
setSQLXML(int parameterIndex, SQLXML x)
[Not supported] Sets the value of a parameter as a SQLXML object.
|
void |
setSQLXML(int parameterIndex, SQLXML x) throws SQLException
[Not supported] Sets the value of a parameter as a SQLXML object.
|
void |
setShort(int parameterIndex, short x)
Sets the value of a parameter.
|
void |
setShort(int parameterIndex, short x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setString(int parameterIndex, String x)
Sets the value of a parameter.
|
void |
setString(int parameterIndex, String x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setTime(int parameterIndex, Time x)
Sets the value of a parameter.
|
void |
setTime(int parameterIndex, Time x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setTime(int parameterIndex, Time x, Calendar calendar)
Sets the time using a specified time zone.
|
void |
setTime(int parameterIndex, Time x, Calendar calendar) throws SQLException
Sets the time using a specified time zone. The value will be converted to
the local time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
calendar - the calendar
Throws:
SQLException - if this object is closed
|
void |
setTimestamp(int parameterIndex, Timestamp x)
Sets the value of a parameter.
|
void |
setTimestamp(int parameterIndex, Timestamp x) throws SQLException
Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
Throws:
SQLException - if this object is closed
|
void |
setTimestamp(int parameterIndex, Timestamp x, Calendar calendar)
Sets the timestamp using a specified time zone.
|
void |
setTimestamp(int parameterIndex, Timestamp x, Calendar calendar) throws SQLException
Sets the timestamp using a specified time zone. The value will be
converted to the local time zone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
x - the value
calendar - the calendar
Throws:
SQLException - if this object is closed
|
void |
setURL(int parameterIndex, URL x)
[Not supported]
|
void |
setURL(int parameterIndex, URL x) throws SQLException
[Not supported]
|
void |
setUnicodeStream(int parameterIndex, InputStream x, int length)
[Not supported] This feature is deprecated and not supported.
|
void |
setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException
[Not supported] This feature is deprecated and not supported.
|