|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.message.TraceObject
org.h2.jdbc.JdbcStatement
org.h2.jdbc.JdbcPreparedStatement
public class JdbcPreparedStatement
Represents a prepared statement.
| Field Summary | |
|---|---|
protected CommandInterface |
command
|
| Fields inherited from class org.h2.jdbc.JdbcStatement |
|---|
closedByResultSet, conn, fetchSize, maxRows, resultSet, resultSetConcurrency, resultSetType, session, updateCount |
| Fields inherited from class org.h2.message.TraceObject |
|---|
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID |
| Fields inherited from interface java.sql.Statement |
|---|
CLOSE_ALL_RESULTS, CLOSE_CURRENT_RESULT, EXECUTE_FAILED, KEEP_CURRENT_RESULT, NO_GENERATED_KEYS, RETURN_GENERATED_KEYS, SUCCESS_NO_INFO |
| Method Summary | |
|---|---|
void |
addBatch()
Adds the current settings to the batch. |
void |
addBatch(java.lang.String sql)
Calling this method is not legal on a PreparedStatement. |
protected boolean |
checkClosed(boolean write)
INTERNAL. |
void |
clearBatch()
Clears the batch. |
void |
clearParameters()
Clears all parameters. |
void |
close()
Closes this statement. |
boolean |
execute()
Executes an arbitrary statement. |
boolean |
execute(java.lang.String sql)
Calling this method is not legal on a PreparedStatement. |
boolean |
execute(java.lang.String sql,
int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement. |
boolean |
execute(java.lang.String sql,
int[] columnIndexes)
Calling this method is not legal on a PreparedStatement. |
boolean |
execute(java.lang.String sql,
java.lang.String[] columnNames)
Calling this method is not legal on a PreparedStatement. |
int[] |
executeBatch()
Executes the batch. |
java.sql.ResultSet |
executeQuery()
Executes a query (select statement) and returns the result set. |
java.sql.ResultSet |
executeQuery(java.lang.String sql)
Calling this method is not legal on a PreparedStatement. |
int |
executeUpdate()
Executes a statement (insert, update, delete, create, drop) and returns the update count. |
int |
executeUpdate(java.lang.String sql)
Calling this method is not legal on a PreparedStatement. |
int |
executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
Calling this method is not legal on a PreparedStatement. |
int |
executeUpdate(java.lang.String sql,
int[] columnIndexes)
Calling this method is not legal on a PreparedStatement. |
int |
executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
Calling this method is not legal on a PreparedStatement. |
java.sql.ResultSetMetaData |
getMetaData()
Gets the result set metadata of the query returned when the statement is executed. |
java.sql.ParameterMetaData |
getParameterMetaData()
Get the parameter meta data of this prepared statement. |
void |
setArray(int parameterIndex,
java.sql.Array x)
[Not supported] Sets the value of a parameter as a Array. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as an ASCII stream. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets the value of a parameter as an ASCII stream. |
void |
setAsciiStream(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as an ASCII stream. |
void |
setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
Sets the value of a parameter. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as an input stream. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
Sets the value of a parameter as an input stream. |
void |
setBinaryStream(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as an input stream. |
void |
setBlob(int parameterIndex,
java.sql.Blob x)
Sets the value of a parameter as a Blob. |
void |
setBlob(int parameterIndex,
java.io.InputStream x)
Sets the value of a parameter as a Blob. |
void |
setBlob(int parameterIndex,
java.io.InputStream x,
long length)
Sets the value of a parameter as a Blob. |
void |
setBoolean(int parameterIndex,
boolean x)
Sets the value of a parameter. |
void |
setByte(int parameterIndex,
byte x)
Sets the value of a parameter. |
void |
setBytes(int parameterIndex,
byte[] x)
Sets the value of a parameter as a byte array. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a character stream. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader x,
int length)
Sets the value of a parameter as a character stream. |
void |
setCharacterStream(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a character stream. |
void |
setClob(int parameterIndex,
java.sql.Clob x)
Sets the value of a parameter as a Clob. |
void |
setClob(int parameterIndex,
java.io.Reader x)
Sets the value of a parameter as a Clob. |
void |
setClob(int parameterIndex,
java.io.Reader x,
long length)
Sets the value of a parameter as a Clob. |
void |
setDate(int parameterIndex,
java.sql.Date x)
Sets the value of a parameter. |
void |
setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar calendar)
Sets the date using a specified time zone. |
void |
setDouble(int parameterIndex,
double x)
Sets the value of a parameter. |
void |
setFloat(int parameterIndex,
float x)
Sets the value of a parameter. |
void |
setInt(int parameterIndex,
int x)
Sets the value of a parameter. |
void |
setLong(int parameterIndex,
long x)
Sets the value of a parameter. |
void |
setNull(int parameterIndex,
int sqlType)
Sets a parameter to null. |
void |
setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
Sets a parameter to null. |
void |
setObject(int parameterIndex,
java.lang.Object x)
Sets the value of a parameter. |
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
Sets the value of a parameter. |
void |
setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
Sets the value of a parameter. |
void |
setRef(int parameterIndex,
java.sql.Ref x)
[Not supported] Sets the value of a column as a reference. |
void |
setShort(int parameterIndex,
short x)
Sets the value of a parameter. |
void |
setString(int parameterIndex,
java.lang.String x)
Sets the value of a parameter. |
void |
setTime(int parameterIndex,
java.sql.Time x)
Sets the value of a parameter. |
void |
setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar calendar)
Sets the time using a specified time zone. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x)
Sets the value of a parameter. |
void |
setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar calendar)
Sets the timestamp using a specified time zone. |
void |
setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
Deprecated. |
void |
setURL(int parameterIndex,
java.net.URL x)
[Not supported] |
java.lang.String |
toString()
INTERNAL |
| Methods inherited from class org.h2.message.TraceObject |
|---|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Methods inherited from interface java.sql.Statement |
|---|
cancel, clearWarnings, getConnection, getFetchDirection, getFetchSize, getGeneratedKeys, getMaxFieldSize, getMaxRows, getMoreResults, getMoreResults, getQueryTimeout, getResultSet, getResultSetConcurrency, getResultSetHoldability, getResultSetType, getUpdateCount, getWarnings, setCursorName, setEscapeProcessing, setFetchDirection, setFetchSize, setMaxFieldSize, setMaxRows, setQueryTimeout |
| Field Detail |
|---|
protected CommandInterface command
| Method Detail |
|---|
public java.sql.ResultSet executeQuery()
throws java.sql.SQLException
executeQuery in interface java.sql.PreparedStatementjava.sql.SQLException - if this object is closed or invalid
public int executeUpdate()
throws java.sql.SQLException
executeUpdate in interface java.sql.PreparedStatementjava.sql.SQLException - if this object is closed or invalid
public boolean execute()
throws java.sql.SQLException
execute in interface java.sql.PreparedStatementjava.sql.SQLException - if this object is closed or invalid
public void clearParameters()
throws java.sql.SQLException
clearParameters in interface java.sql.PreparedStatementjava.sql.SQLException - if this object is closed or invalid
public java.sql.ResultSet executeQuery(java.lang.String sql)
throws java.sql.SQLException
executeQuery in interface java.sql.StatementexecuteQuery in class JdbcStatementsql - ignored
java.sql.SQLException - Unsupported Feature
public void addBatch(java.lang.String sql)
throws java.sql.SQLException
addBatch in interface java.sql.StatementaddBatch in class JdbcStatementsql - ignored
java.sql.SQLException - Unsupported Feature
public int executeUpdate(java.lang.String sql)
throws java.sql.SQLException
executeUpdate in interface java.sql.StatementexecuteUpdate in class JdbcStatementsql - ignored
java.sql.SQLException - Unsupported Feature
public boolean execute(java.lang.String sql)
throws java.sql.SQLException
execute in interface java.sql.Statementexecute in class JdbcStatementsql - ignored
java.sql.SQLException - Unsupported Feature
public void setNull(int parameterIndex,
int sqlType)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)sqlType - the data type (Types.x)
java.sql.SQLException - if this object is closed
public void setInt(int parameterIndex,
int x)
throws java.sql.SQLException
setInt in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setString(int parameterIndex,
java.lang.String x)
throws java.sql.SQLException
setString in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setBigDecimal(int parameterIndex,
java.math.BigDecimal x)
throws java.sql.SQLException
setBigDecimal in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setDate(int parameterIndex,
java.sql.Date x)
throws java.sql.SQLException
setDate in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setTime(int parameterIndex,
java.sql.Time x)
throws java.sql.SQLException
setTime in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x)
throws java.sql.SQLException
setTimestamp in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setObject(int parameterIndex,
java.lang.Object x)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value, null is allowedtargetSqlType - the type as defined in java.sql.Types
java.sql.SQLException - if this object is closed
public void setObject(int parameterIndex,
java.lang.Object x,
int targetSqlType,
int scale)
throws java.sql.SQLException
setObject in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value, null is allowedtargetSqlType - the type as defined in java.sql.Typesscale - is ignored
java.sql.SQLException - if this object is closed
public void setBoolean(int parameterIndex,
boolean x)
throws java.sql.SQLException
setBoolean in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setByte(int parameterIndex,
byte x)
throws java.sql.SQLException
setByte in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setShort(int parameterIndex,
short x)
throws java.sql.SQLException
setShort in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setLong(int parameterIndex,
long x)
throws java.sql.SQLException
setLong in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setFloat(int parameterIndex,
float x)
throws java.sql.SQLException
setFloat in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setDouble(int parameterIndex,
double x)
throws java.sql.SQLException
setDouble in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setRef(int parameterIndex,
java.sql.Ref x)
throws java.sql.SQLException
setRef in interface java.sql.PreparedStatementjava.sql.SQLException
public void setDate(int parameterIndex,
java.sql.Date x,
java.util.Calendar calendar)
throws java.sql.SQLException
setDate in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuecalendar - the calendar
java.sql.SQLException - if this object is closed
public void setTime(int parameterIndex,
java.sql.Time x,
java.util.Calendar calendar)
throws java.sql.SQLException
setTime in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuecalendar - the calendar
java.sql.SQLException - if this object is closed
public void setTimestamp(int parameterIndex,
java.sql.Timestamp x,
java.util.Calendar calendar)
throws java.sql.SQLException
setTimestamp in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuecalendar - the calendar
java.sql.SQLException - if this object is closed
public void setUnicodeStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setUnicodeStream in interface java.sql.PreparedStatementjava.sql.SQLException
public void setNull(int parameterIndex,
int sqlType,
java.lang.String typeName)
throws java.sql.SQLException
setNull in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)sqlType - the data type (Types.x)typeName - this parameter is ignored
java.sql.SQLException - if this object is closed
public void setBlob(int parameterIndex,
java.sql.Blob x)
throws java.sql.SQLException
setBlob in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setBlob(int parameterIndex,
java.io.InputStream x)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setClob(int parameterIndex,
java.sql.Clob x)
throws java.sql.SQLException
setClob in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setClob(int parameterIndex,
java.io.Reader x)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setArray(int parameterIndex,
java.sql.Array x)
throws java.sql.SQLException
setArray in interface java.sql.PreparedStatementjava.sql.SQLException
public void setBytes(int parameterIndex,
byte[] x)
throws java.sql.SQLException
setBytes in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setBinaryStream(int parameterIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setBinaryStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setBinaryStream in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setBinaryStream(int parameterIndex,
java.io.InputStream x)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setAsciiStream(int parameterIndex,
java.io.InputStream x,
int length)
throws java.sql.SQLException
setAsciiStream in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setAsciiStream(int parameterIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closed
public void setAsciiStream(int parameterIndex,
java.io.InputStream x)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setCharacterStream(int parameterIndex,
java.io.Reader x,
int length)
throws java.sql.SQLException
setCharacterStream in interface java.sql.PreparedStatementparameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of characters
java.sql.SQLException - if this object is closed
public void setCharacterStream(int parameterIndex,
java.io.Reader x)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the value
java.sql.SQLException - if this object is closed
public void setCharacterStream(int parameterIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of characters
java.sql.SQLException - if this object is closed
public void setURL(int parameterIndex,
java.net.URL x)
throws java.sql.SQLException
setURL in interface java.sql.PreparedStatementjava.sql.SQLException
public java.sql.ResultSetMetaData getMetaData()
throws java.sql.SQLException
getMetaData in interface java.sql.PreparedStatementjava.sql.SQLException - if this object is closed
public void clearBatch()
throws java.sql.SQLException
clearBatch in interface java.sql.StatementclearBatch in class JdbcStatementjava.sql.SQLException
public void close()
throws java.sql.SQLException
close in interface java.sql.Statementclose in class JdbcStatementjava.sql.SQLException
public int[] executeBatch()
throws java.sql.SQLException
executeBatch in interface java.sql.StatementexecuteBatch in class JdbcStatementjava.sql.SQLException
public void addBatch()
throws java.sql.SQLException
addBatch in interface java.sql.PreparedStatementjava.sql.SQLException
public int executeUpdate(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
executeUpdate in interface java.sql.StatementexecuteUpdate in class JdbcStatementsql - ignoredautoGeneratedKeys - ignored
java.sql.SQLException - Unsupported Feature
public int executeUpdate(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
executeUpdate in interface java.sql.StatementexecuteUpdate in class JdbcStatementsql - ignoredcolumnIndexes - ignored
java.sql.SQLException - Unsupported Feature
public int executeUpdate(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
executeUpdate in interface java.sql.StatementexecuteUpdate in class JdbcStatementsql - ignoredcolumnNames - ignored
java.sql.SQLException - Unsupported Feature
public boolean execute(java.lang.String sql,
int autoGeneratedKeys)
throws java.sql.SQLException
execute in interface java.sql.Statementexecute in class JdbcStatementsql - ignoredautoGeneratedKeys - ignored
java.sql.SQLException - Unsupported Feature
public boolean execute(java.lang.String sql,
int[] columnIndexes)
throws java.sql.SQLException
execute in interface java.sql.Statementexecute in class JdbcStatementsql - ignoredcolumnIndexes - ignored
java.sql.SQLException - Unsupported Feature
public boolean execute(java.lang.String sql,
java.lang.String[] columnNames)
throws java.sql.SQLException
execute in interface java.sql.Statementexecute in class JdbcStatementsql - ignoredcolumnNames - ignored
java.sql.SQLException - Unsupported Feature
public java.sql.ParameterMetaData getParameterMetaData()
throws java.sql.SQLException
getParameterMetaData in interface java.sql.PreparedStatementjava.sql.SQLException
public void setClob(int parameterIndex,
java.io.Reader x,
long length)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of characters
java.sql.SQLException - if this object is closed
public void setBlob(int parameterIndex,
java.io.InputStream x,
long length)
throws java.sql.SQLException
parameterIndex - the parameter index (1, 2, ...)x - the valuelength - the maximum number of bytes
java.sql.SQLException - if this object is closedpublic java.lang.String toString()
toString in class JdbcStatementprotected boolean checkClosed(boolean write)
JdbcStatement
checkClosed in class JdbcStatementwrite - if the next operation is possibly writing
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||