Statement.java の 30 行で定義されています。
Public メソッド | |
ResultSet | executeQuery (String sql) throws SQLException |
関数 | |
int | executeUpdate (String sql) throws SQLException |
void | close () throws SQLException |
int | getMaxFieldSize () throws SQLException |
void | setMaxFieldSize (int max) throws SQLException |
int | getMaxRows () throws SQLException |
void | setMaxRows (int max) throws SQLException |
void | setEscapeProcessing (boolean enable) throws SQLException |
int | getQueryTimeout () throws SQLException |
void | setQueryTimeout (int seconds) throws SQLException |
void | cancel () throws SQLException |
SQLWarning | getWarnings () throws SQLException |
void | clearWarnings () throws SQLException |
void | setCursorName (String name) throws SQLException |
boolean | execute (String sql) throws SQLException |
ResultSet | getResultSet () throws SQLException |
int | getUpdateCount () throws SQLException |
boolean | getMoreResults () throws SQLException |
void | setFetchDirection (int direction) throws SQLException |
int | getFetchDirection () throws SQLException |
void | setFetchSize (int rows) throws SQLException |
int | getFetchSize () throws SQLException |
int | getResultSetConcurrency () throws SQLException |
int | getResultSetType () throws SQLException |
void | addBatch (String sql) throws SQLException |
void | clearBatch () throws SQLException |
int[] | executeBatch () throws SQLException |
Connection | getConnection () throws SQLException |
boolean | getMoreResults (int current) throws SQLException |
ResultSet | getGeneratedKeys () throws SQLException |
int | executeUpdate (String sql, int autoGeneratedKeys) throws SQLException |
int | executeUpdate (String sql, int columnIndexes[]) throws SQLException |
int | executeUpdate (String sql, String columnNames[]) throws SQLException |
boolean | execute (String sql, int autoGeneratedKeys) throws SQLException |
boolean | execute (String sql, int columnIndexes[]) throws SQLException |
boolean | execute (String sql, String columnNames[]) throws SQLException |
int | getResultSetHoldability () throws SQLException |
変数 | |
int | CLOSE_CURRENT_RESULT = 1 |
int | KEEP_CURRENT_RESULT = 2 |
int | CLOSE_ALL_RESULTS = 3 |
int | SUCCESS_NO_INFO = -2 |
int | EXECUTE_FAILED = -3 |
int | RETURN_GENERATED_KEYS = 1 |
int | NO_GENERATED_KEYS = 2 |
|
Adds the given SQL command to the current list of commmands for this NOTE: This method is optional.
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Cancels this
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Empties this NOTE: This method is optional.
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Clears all the warnings reported on this
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Releases this
Calling the method
Note: A
org.objectweb.cjdbc.driver.PreparedStatement, と org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the names of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which may return multiple results, and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. This array contains the indexes of the columns in the target table that contain the auto-generated keys that should be made available. The driver will ignore the array if the given SQL statement is not an Under some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which may return multiple results, and signals the driver that any auto-generated keys should be made available for retrieval. The driver will ignore this signal if the SQL statement is not an In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which may return multiple results. In some (uncommon) situations, a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this unless you are (1) executing a stored procedure that you know may return multiple results or (2) you are dynamically executing an unknown SQL string.
The
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), と org.objectweb.cjdbc.common.util.ControllerTask.stopHsqldb(). |
|
Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts. The
A driver is not required to implement this method. The possible implementations and return values have been modified in the Java 2 SDK, Standard Edition, version 1.3 to accommodate the option of continuing to proccess commands in a batch update after a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which returns a single
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeSelectRequestOnBackend(), org.objectweb.cjdbc.controller.recoverylog.JDBCRecoveryLog.getLastTransactionId(), と org.objectweb.cjdbc.controller.backend.DatabaseBackend.isValidConnection(). |
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. The driver will ignore the array if the SQL statement is not an
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement and signals the driver that the auto-generated keys indicated in the given array should be made available for retrieval. The driver will ignore the array if the SQL statement is not an
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Executes the given SQL statement, which may be an
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeUpdateRequestOnBackend(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeUpdateRequestOnBackendWithKeys(). |
|
Retrieves the
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the number of result set rows that is the default fetch size for
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves any auto-generated keys created as a result of executing this
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeUpdateRequestOnBackendWithKeys(). |
|
Retrieves the maximum number of bytes that can be returned for character and binary column values in a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the maximum number of rows that a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Moves to this There are no more results when the following is true:
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Moves to this There are no more results when the following is true:
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the number of seconds the driver will wait for a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the current result as a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the result set concurrency for
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the result set holdability for
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the result set type for
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the current result as an update count; if the result is a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Retrieves the first warning reported by calls on this
The warning chain is automatically cleared each time a statement is (re)executed. This method may not be called on a closed
Note: If you are processing a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Sets the SQL cursor name to the given
Note: By definition, the execution of positioned updates and deletes must be done by a different
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeSelectRequestOnBackend(). |
|
Sets escape processing on or off. If escape scanning is on (the default), the driver will do escape substitution before sending the SQL statement to the database. Note: Since prepared statements have usually been parsed prior to making this call, disabling escape processing for
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Gives the driver a hint as to the direction in which rows will be processed in
Note that this method sets the default fetch direction for result sets generated by this
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed. The number of rows specified affects only result sets created using this statement. If the value specified is zero, then the hint is ignored. The default value is zero.
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeSelectRequestOnBackend(). |
|
Sets the limit for the maximum number of bytes in a
org.objectweb.cjdbc.driver.Statementで実装されています.
|
|
Sets the limit for the maximum number of rows that any
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeSelectRequestOnBackend(). |
|
Sets the number of seconds the driver will wait for a
org.objectweb.cjdbc.driver.Statementで実装されています.
参照元 org.objectweb.cjdbc.controller.backend.DriverCompliance.complianceTest(), org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeSelectRequestOnBackend(), org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeUpdateRequestOnBackend(), と org.objectweb.cjdbc.controller.loadbalancer.AbstractLoadBalancer.executeUpdateRequestOnBackendWithKeys(). |
|
The constant indicating that all
|
|
The constant indicating that the current
|
|
The constant indicating that an error occured while executing a batch statement.
|
|
The constant indicating that the current
|
|
The constant indicating that generated keys should not be made available for retrieval.
|
|
The constant indicating that generated keys should be made available for retrieval.
|
|
The constant indicating that a batch statement executed successfully but that no count of the number of rows it affected is available.
|