| java.lang.Object
 org.h2.message.TraceObject
org.h2.jdbc.JdbcStatement
org.h2.jdbc.JdbcPreparedStatement
All known Subclasses: org.h2.jdbc.JdbcCallableStatement,
| Method Summary | |
| public void | addBatch(String sql)
Calling this method is not legal on a PreparedStatement. | | public void | addBatch()
Adds the current settings to the batch. | | public void | clearBatch()
Clears the batch. | | public void | clearParameters()
Clears all parameters. | | public void | close()
Closes this statement. | | public boolean | execute()
Executes an arbitrary statement. | | public boolean | execute(String sql)
Calling this method is not legal on a PreparedStatement. | | public boolean | execute(String sql, int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement. | | public boolean | execute(String sql, int[] columnIndexes)
Calling this method is not legal on a PreparedStatement. | | public boolean | execute(String sql, String[] columnNames)
Calling this method is not legal on a PreparedStatement. | | public int[] | executeBatch()
Executes the batch. | | public ResultSet | executeQuery()
Executes a query (select statement) and returns the result set. | | public ResultSet | executeQuery(String sql)
Calling this method is not legal on a PreparedStatement. | | public int | executeUpdate()
Executes a statement (insert, update, delete, create, drop, commit,
rollback) and returns the update count. | | public int | executeUpdate(String sql)
Calling this method is not legal on a PreparedStatement. | | public int | executeUpdate(String sql, int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement. | | public int | executeUpdate(String sql, int[] columnIndexes)
Calling this method is not legal on a PreparedStatement. | | public int | executeUpdate(String sql, String[] columnNames)
Calling this method is not legal on a PreparedStatement. | | public ResultSetMetaData | getMetaData()
Gets the result set metadata of the query returned when the statement is
executed. | | public ParameterMetaData | getParameterMetaData()
Get the parameter meta data of this prepared statement. | | public void | setArray(int parameterIndex, Array x)
[Not supported] Sets the value of a parameter as a Array. | | public void | setAsciiStream(int parameterIndex, InputStream x, int length)
Sets the value of a parameter as an ASCII stream. | | public void | setAsciiStream(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as an ASCII stream. | | public void | setAsciiStream(int parameterIndex, InputStream x)
Sets the value of a parameter as an ASCII stream. | | public void | setBigDecimal(int parameterIndex, BigDecimal x)
Sets the value of a parameter. | | public void | setBinaryStream(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as an input stream. | | public void | setBinaryStream(int parameterIndex, InputStream x, int length)
Sets the value of a parameter as an input stream. | | public void | setBinaryStream(int parameterIndex, InputStream x)
Sets the value of a parameter as an input stream. | | public void | setBlob(int parameterIndex, Blob x)
Sets the value of a parameter as a Blob. | | public void | setBlob(int parameterIndex, InputStream x)
Sets the value of a parameter as a Blob. | | public void | setBlob(int parameterIndex, InputStream x, long length)
Sets the value of a parameter as a Blob. | | public void | setBoolean(int parameterIndex, boolean x)
Sets the value of a parameter. | | public void | setByte(int parameterIndex, byte x)
Sets the value of a parameter. | | public void | setBytes(int parameterIndex, byte[] x)
Sets the value of a parameter as a byte array. | | public void | setCharacterStream(int parameterIndex, Reader x, int length)
Sets the value of a parameter as a character stream. | | public void | setCharacterStream(int parameterIndex, Reader x)
Sets the value of a parameter as a character stream. | | public void | setCharacterStream(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a character stream. | | public void | setClob(int parameterIndex, Clob x)
Sets the value of a parameter as a Clob. | | public void | setClob(int parameterIndex, Reader x)
Sets the value of a parameter as a Clob. | | public void | setClob(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a Clob. | | public void | setDate(int parameterIndex, java.sql.Date x)
Sets the value of a parameter. | | public void | setDate(int parameterIndex, java.sql.Date x, Calendar calendar)
Sets the date using a specified timezone. | | public void | setDouble(int parameterIndex, double x)
Sets the value of a parameter. | | public void | setFloat(int parameterIndex, float x)
Sets the value of a parameter. | | public void | setInt(int parameterIndex, int x)
Sets the value of a parameter. | | public void | setLong(int parameterIndex, long x)
Sets the value of a parameter. | | public void | setNCharacterStream(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a character stream. | | public void | setNCharacterStream(int parameterIndex, Reader x)
Sets the value of a parameter as a character stream. | | public void | setNClob(int parameterIndex, Reader x)
Sets the value of a parameter as a Clob. | | public void | setNClob(int parameterIndex, Reader x, long length)
Sets the value of a parameter as a Clob. | | public void | setNString(int parameterIndex, String x)
Sets the value of a parameter. | | public void | setNull(int parameterIndex, int sqlType)
Sets a parameter to null. | | public void | setNull(int parameterIndex, int sqlType, String typeName)
Sets a parameter to null. | | public void | setObject(int parameterIndex, Object x)
Sets the value of a parameter. | | public void | setObject(int parameterIndex, Object x, int targetSqlType)
Sets the value of a parameter. | | public void | setObject(int parameterIndex, Object x, int targetSqlType, int scale)
Sets the value of a parameter. | | public void | setRef(int parameterIndex, Ref x)
[Not supported] Sets the value of a column as a reference. | | public void | setShort(int parameterIndex, short x)
Sets the value of a parameter. | | public void | setString(int parameterIndex, String x)
Sets the value of a parameter. | | public void | setTime(int parameterIndex, java.sql.Time x)
Sets the value of a parameter. | | public void | setTime(int parameterIndex, java.sql.Time x, Calendar calendar)
Sets the time using a specified timezone. | | public void | setTimestamp(int parameterIndex, java.sql.Timestamp x)
Sets the value of a parameter. | | public void | setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar calendar)
Sets the timestamp using a specified timezone. | | public void | setURL(int parameterIndex, URL x)
| | public void | setUnicodeStream(int parameterIndex, InputStream x, int length)
[Not supported] This feature is deprecated and not supported. | | public String | toString()
|
| addBatch | | public void addBatch() throws SQLException(Code) | | Adds the current settings to the batch.
|
| clearParameters | | public void clearParameters() throws SQLException(Code) | | Clears all parameters.
throws:
SQLException - if this object is closed or invalid |
| close | | public void close() throws SQLException(Code) | | Closes this statement.
All result sets that where created by this statement
become invalid after calling this method.
|
| execute | | public boolean execute() throws SQLException(Code) | | 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.
true if a result set is available, false if not
throws:
SQLException - if this object is closed or invalid |
| execute | | public boolean execute(String sql, int autoGeneratedKeys) throws SQLException(Code) | | Calling this method is not legal on a PreparedStatement.
throws:
SQLException - Unsupported Feature |
| execute | | public boolean execute(String sql, int[] columnIndexes) throws SQLException(Code) | | Calling this method is not legal on a PreparedStatement.
throws:
SQLException - Unsupported Feature |
| executeBatch | | public int[] executeBatch() throws SQLException(Code) | | Executes the batch.
the array of update counts |
| executeQuery | | public ResultSet executeQuery() throws SQLException(Code) | | 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).
the result set
throws:
SQLException - if this object is closed or invalid |
| executeUpdate | | public int executeUpdate() throws SQLException(Code) | | Executes a statement (insert, update, delete, create, drop, commit,
rollback) and returns the update count. If another result set exists for
this statement, this will be closed (even if this statement fails).
If the statement is a create or drop and does not throw an exception, the
current transaction (if any) is committed after executing the statement.
If auto commit is on, this statement will be committed.
the update count (number of row affected by an insert, update ordelete, or 0 if no rows or the statement was a create, drop,commit or rollback)
throws:
SQLException - if this object is closed or invalid |
| executeUpdate | | public int executeUpdate(String sql, int autoGeneratedKeys) throws SQLException(Code) | | Calling this method is not legal on a PreparedStatement.
throws:
SQLException - Unsupported Feature |
| executeUpdate | | public int executeUpdate(String sql, int[] columnIndexes) throws SQLException(Code) | | Calling this method is not legal on a PreparedStatement.
throws:
SQLException - Unsupported Feature |
| getMetaData | | public ResultSetMetaData getMetaData() throws SQLException(Code) | | Gets the result set metadata of the query returned when the statement is
executed. If this is not a query, this method returns null.
the meta data or null if this is not a query
throws:
SQLException - if this object is closed |
| setArray | | public void setArray(int parameterIndex, Array x) throws SQLException(Code) | | [Not supported] Sets the value of a parameter as a Array.
|
| setAsciiStream | | public void setAsciiStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | Sets the value of a parameter as an ASCII stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setAsciiStream | | public void setAsciiStream(int parameterIndex, InputStream x, long length) throws SQLException(Code) | | Sets the value of a parameter as an ASCII stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setAsciiStream | | public void setAsciiStream(int parameterIndex, InputStream x) throws SQLException(Code) | | Sets the value of a parameter as an ASCII stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBigDecimal | | public void setBigDecimal(int parameterIndex, BigDecimal x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBinaryStream | | public void setBinaryStream(int parameterIndex, InputStream x, long length) throws SQLException(Code) | | Sets the value of a parameter as an input stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setBinaryStream | | public void setBinaryStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | Sets the value of a parameter as an input stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setBinaryStream | | public void setBinaryStream(int parameterIndex, InputStream x) throws SQLException(Code) | | Sets the value of a parameter as an input stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBlob | | public void setBlob(int parameterIndex, Blob x) throws SQLException(Code) | | Sets the value of a parameter as a Blob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBlob | | public void setBlob(int parameterIndex, InputStream x) throws SQLException(Code) | | Sets the value of a parameter as a Blob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBlob | | public void setBlob(int parameterIndex, InputStream x, long length) throws SQLException(Code) | | Sets the value of a parameter as a Blob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBoolean | | public void setBoolean(int parameterIndex, boolean x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setByte | | public void setByte(int parameterIndex, byte x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setBytes | | public void setBytes(int parameterIndex, byte[] x) throws SQLException(Code) | | Sets the value of a parameter as a byte array.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader x, int length) throws SQLException(Code) | | Sets the value of a parameter as a character stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader x) throws SQLException(Code) | | Sets the value of a parameter as a character stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setCharacterStream | | public void setCharacterStream(int parameterIndex, Reader x, long length) throws SQLException(Code) | | Sets the value of a parameter as a character stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setClob | | public void setClob(int parameterIndex, Clob x) throws SQLException(Code) | | Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setClob | | public void setClob(int parameterIndex, Reader x) throws SQLException(Code) | | Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setClob | | public void setClob(int parameterIndex, Reader x, long length) throws SQLException(Code) | | Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setDate | | public void setDate(int parameterIndex, java.sql.Date x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setDate | | public void setDate(int parameterIndex, java.sql.Date x, Calendar calendar) throws SQLException(Code) | | Sets the date using a specified timezone. The value will be converted to
the local timezone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
calendar - the calendar
throws:
SQLException - if this object is closed |
| setDouble | | public void setDouble(int parameterIndex, double x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setFloat | | public void setFloat(int parameterIndex, float x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setInt | | public void setInt(int parameterIndex, int x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setLong | | public void setLong(int parameterIndex, long x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setNCharacterStream | | public void setNCharacterStream(int parameterIndex, Reader x, long length) throws SQLException(Code) | | Sets the value of a parameter as a character stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
length - the number of bytes
throws:
SQLException - if this object is closed |
| setNCharacterStream | | public void setNCharacterStream(int parameterIndex, Reader x) throws SQLException(Code) | | Sets the value of a parameter as a character stream.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setNClob | | public void setNClob(int parameterIndex, Reader x) throws SQLException(Code) | | Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setNClob | | public void setNClob(int parameterIndex, Reader x, long length) throws SQLException(Code) | | Sets the value of a parameter as a Clob.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setNString | | public void setNString(int parameterIndex, String x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setNull | | public void setNull(int parameterIndex, int sqlType) throws SQLException(Code) | | Sets a parameter to null.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
sqlType - the data type (Types.x)
throws:
SQLException - if this object is closed |
| setNull | | public void setNull(int parameterIndex, int sqlType, String typeName) throws SQLException(Code) | | Sets a parameter to null.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
sqlType - the data type (Types.x)
Parameters:
typeName - this parameter is ignored
throws:
SQLException - if this object is closed |
| setObject | | public void setObject(int parameterIndex, Object x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setObject | | public void setObject(int parameterIndex, Object x, int targetSqlType) throws SQLException(Code) | | Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value, null is allowed
Parameters:
targetSqlType - the type as defined in java.sql.Types
throws:
SQLException - if this object is closed |
| setObject | | public void setObject(int parameterIndex, Object x, int targetSqlType, int scale) throws SQLException(Code) | | Sets the value of a parameter. The object is converted, if required, to
the specified data type before sending to the database.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value, null is allowed
Parameters:
targetSqlType - the type as defined in java.sql.Types
Parameters:
scale - is ignored
throws:
SQLException - if this object is closed |
| setRef | | public void setRef(int parameterIndex, Ref x) throws SQLException(Code) | | [Not supported] Sets the value of a column as a reference.
|
| setShort | | public void setShort(int parameterIndex, short x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setString | | public void setString(int parameterIndex, String x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setTime | | public void setTime(int parameterIndex, java.sql.Time x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setTime | | public void setTime(int parameterIndex, java.sql.Time x, Calendar calendar) throws SQLException(Code) | | Sets the time using a specified timezone. The value will be converted to
the local timezone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
calendar - the calendar
throws:
SQLException - if this object is closed |
| setTimestamp | | public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws SQLException(Code) | | Sets the value of a parameter.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
throws:
SQLException - if this object is closed |
| setTimestamp | | public void setTimestamp(int parameterIndex, java.sql.Timestamp x, Calendar calendar) throws SQLException(Code) | | Sets the timestamp using a specified timezone. The value will be
converted to the local timezone.
Parameters:
parameterIndex - the parameter index (1, 2, ...)
Parameters:
x - the value
Parameters:
calendar - the calendar
throws:
SQLException - if this object is closed |
| setUnicodeStream | | public void setUnicodeStream(int parameterIndex, InputStream x, int length) throws SQLException(Code) | | [Not supported] This feature is deprecated and not supported.
|
| Fields inherited from org.h2.message.TraceObject | final public static int CALLABLE_STATEMENTCONNECTIONDATABASE_META_DATAPREPARED_STATEMENTRESULT_SETRESULT_SET_META_DATASAVEPOINTSQL_EXCEPTIONSTATEMENTBLOBCLOBPARAMETER_META_DATA(Code)(Java Doc)
final public static int DATA_SOURCEXA_DATA_SOURCEXIDARRAY(Code)(Java Doc)
|
|
|