Overview  Package   Class  Tree  Deprecated  Index  Help  Codase Click search sample or example code, search definition, search google 
 PREV CLASS   NEXT CLASS FRAMES    NO FRAMES    
SUMMARY: NESTED | FIELD | CONSTR | METHOD DETAIL: FIELD | CONSTR | METHOD

java.sql
Interface Statement

All Known Subinterfaces:
CallableStatement sample code for java.sql.CallableStatement definition code for java.sql.CallableStatement , PreparedStatement sample code for java.sql.PreparedStatement definition code for java.sql.PreparedStatement 
public interface Statement

The object used for executing a static SQL statement and returning the results it produces.

By default, only one ResultSet object per Statement object can be open at the same time. Therefore, if the reading of one ResultSet object is interleaved with the reading of another, each must have been generated by different Statement objects. All execution methods in the Statement interface implicitly close a statment's current ResultSet object if an open one exists.

See Also:
Connection.createStatement() sample code for java.sql.Connection.createStatement() definition code for java.sql.Connection.createStatement() , ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet

Field Summary
static int CLOSE_ALL_RESULTS sample code for java.sql.Statement.CLOSE_ALL_RESULTS definition code for java.sql.Statement.CLOSE_ALL_RESULTS
          The constant indicating that all ResultSet objects that have previously been kept open should be closed when calling getMoreResults.
static int CLOSE_CURRENT_RESULT sample code for java.sql.Statement.CLOSE_CURRENT_RESULT definition code for java.sql.Statement.CLOSE_CURRENT_RESULT
          The constant indicating that the current ResultSet object should be closed when calling getMoreResults.
static int EXECUTE_FAILED sample code for java.sql.Statement.EXECUTE_FAILED definition code for java.sql.Statement.EXECUTE_FAILED
          The constant indicating that an error occured while executing a batch statement.
static int KEEP_CURRENT_RESULT sample code for java.sql.Statement.KEEP_CURRENT_RESULT definition code for java.sql.Statement.KEEP_CURRENT_RESULT
          The constant indicating that the current ResultSet object should not be closed when calling getMoreResults.
static int NO_GENERATED_KEYS sample code for java.sql.Statement.NO_GENERATED_KEYS definition code for java.sql.Statement.NO_GENERATED_KEYS
          The constant indicating that generated keys should not be made available for retrieval.
static int RETURN_GENERATED_KEYS sample code for java.sql.Statement.RETURN_GENERATED_KEYS definition code for java.sql.Statement.RETURN_GENERATED_KEYS
          The constant indicating that generated keys should be made available for retrieval.
static int SUCCESS_NO_INFO sample code for java.sql.Statement.SUCCESS_NO_INFO definition code for java.sql.Statement.SUCCESS_NO_INFO
          The constant indicating that a batch statement executed successfully but that no count of the number of rows it affected is available.
 
Method Summary
 void addBatch sample code for java.sql.Statement.addBatch(java.lang.String) definition code for java.sql.Statement.addBatch(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  sql)
          Adds the given SQL command to the current list of commmands for this Statement object.
 void cancel sample code for java.sql.Statement.cancel() definition code for java.sql.Statement.cancel() ()
          Cancels this Statement object if both the DBMS and driver support aborting an SQL statement.
 void clearBatch sample code for java.sql.Statement.clearBatch() definition code for java.sql.Statement.clearBatch() ()
          Empties this Statement object's current list of SQL commands.
 void clearWarnings sample code for java.sql.Statement.clearWarnings() definition code for java.sql.Statement.clearWarnings() ()
          Clears all the warnings reported on this Statement object.
 void close sample code for java.sql.Statement.close() definition code for java.sql.Statement.close() ()
          Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
 boolean execute sample code for java.sql.Statement.execute(java.lang.String) definition code for java.sql.Statement.execute(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  sql)
          Executes the given SQL statement, which may return multiple results.
 boolean execute sample code for java.sql.Statement.execute(java.lang.String, int) definition code for java.sql.Statement.execute(java.lang.String, int) (String sample code for java.lang.String definition code for java.lang.String  sql, int autoGeneratedKeys)
          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.
 boolean execute sample code for java.sql.Statement.execute(java.lang.String, int[]) definition code for java.sql.Statement.execute(java.lang.String, int[]) (String sample code for java.lang.String definition code for java.lang.String  sql, int[] columnIndexes)
          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.
 boolean execute sample code for java.sql.Statement.execute(java.lang.String, java.lang.String[]) definition code for java.sql.Statement.execute(java.lang.String, java.lang.String[]) (String sample code for java.lang.String definition code for java.lang.String  sql, String sample code for java.lang.String definition code for java.lang.String [] columnNames)
          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.
 int[] executeBatch sample code for java.sql.Statement.executeBatch() definition code for java.sql.Statement.executeBatch() ()
          Submits a batch of commands to the database for execution and if all commands execute successfully, returns an array of update counts.
 ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet executeQuery sample code for java.sql.Statement.executeQuery(java.lang.String) definition code for java.sql.Statement.executeQuery(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  sql)
          Executes the given SQL statement, which returns a single ResultSet object.
 int executeUpdate sample code for java.sql.Statement.executeUpdate(java.lang.String) definition code for java.sql.Statement.executeUpdate(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  sql)
          Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.
 int executeUpdate sample code for java.sql.Statement.executeUpdate(java.lang.String, int) definition code for java.sql.Statement.executeUpdate(java.lang.String, int) (String sample code for java.lang.String definition code for java.lang.String  sql, int autoGeneratedKeys)
          Executes the given SQL statement and signals the driver with the given flag about whether the auto-generated keys produced by this Statement object should be made available for retrieval.
 int executeUpdate sample code for java.sql.Statement.executeUpdate(java.lang.String, int[]) definition code for java.sql.Statement.executeUpdate(java.lang.String, int[]) (String sample code for java.lang.String definition code for java.lang.String  sql, int[] columnIndexes)
          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.
 int executeUpdate sample code for java.sql.Statement.executeUpdate(java.lang.String, java.lang.String[]) definition code for java.sql.Statement.executeUpdate(java.lang.String, java.lang.String[]) (String sample code for java.lang.String definition code for java.lang.String  sql, String sample code for java.lang.String definition code for java.lang.String [] columnNames)
          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.
 Connection sample code for java.sql.Connection definition code for java.sql.Connection getConnection sample code for java.sql.Statement.getConnection() definition code for java.sql.Statement.getConnection() ()
          Retrieves the Connection object that produced this Statement object.
 int getFetchDirection sample code for java.sql.Statement.getFetchDirection() definition code for java.sql.Statement.getFetchDirection() ()
          Retrieves the direction for fetching rows from database tables that is the default for result sets generated from this Statement object.
 int getFetchSize sample code for java.sql.Statement.getFetchSize() definition code for java.sql.Statement.getFetchSize() ()
          Retrieves the number of result set rows that is the default fetch size for ResultSet objects generated from this Statement object.
 ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet getGeneratedKeys sample code for java.sql.Statement.getGeneratedKeys() definition code for java.sql.Statement.getGeneratedKeys() ()
          Retrieves any auto-generated keys created as a result of executing this Statement object.
 int getMaxFieldSize sample code for java.sql.Statement.getMaxFieldSize() definition code for java.sql.Statement.getMaxFieldSize() ()
          Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object.
 int getMaxRows sample code for java.sql.Statement.getMaxRows() definition code for java.sql.Statement.getMaxRows() ()
          Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain.
 boolean getMoreResults sample code for java.sql.Statement.getMoreResults() definition code for java.sql.Statement.getMoreResults() ()
          Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.
 boolean getMoreResults sample code for java.sql.Statement.getMoreResults(int) definition code for java.sql.Statement.getMoreResults(int) (int current)
          Moves to this Statement object's next result, deals with any current ResultSet object(s) according to the instructions specified by the given flag, and returns true if the next result is a ResultSet object.
 int getQueryTimeout sample code for java.sql.Statement.getQueryTimeout() definition code for java.sql.Statement.getQueryTimeout() ()
          Retrieves the number of seconds the driver will wait for a Statement object to execute.
 ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet getResultSet sample code for java.sql.Statement.getResultSet() definition code for java.sql.Statement.getResultSet() ()
          Retrieves the current result as a ResultSet object.
 int getResultSetConcurrency sample code for java.sql.Statement.getResultSetConcurrency() definition code for java.sql.Statement.getResultSetConcurrency() ()
          Retrieves the result set concurrency for ResultSet objects generated by this Statement object.
 int getResultSetHoldability sample code for java.sql.Statement.getResultSetHoldability() definition code for java.sql.Statement.getResultSetHoldability() ()
          Retrieves the result set holdability for ResultSet objects generated by this Statement object.
 int getResultSetType sample code for java.sql.Statement.getResultSetType() definition code for java.sql.Statement.getResultSetType() ()
          Retrieves the result set type for ResultSet objects generated by this Statement object.
 int getUpdateCount sample code for java.sql.Statement.getUpdateCount() definition code for java.sql.Statement.getUpdateCount() ()
          Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned.
 SQLWarning sample code for java.sql.SQLWarning definition code for java.sql.SQLWarning getWarnings sample code for java.sql.Statement.getWarnings() definition code for java.sql.Statement.getWarnings() ()
          Retrieves the first warning reported by calls on this Statement object.
 void setCursorName sample code for java.sql.Statement.setCursorName(java.lang.String) definition code for java.sql.Statement.setCursorName(java.lang.String) (String sample code for java.lang.String definition code for java.lang.String  name)
          Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods.
 void setEscapeProcessing sample code for java.sql.Statement.setEscapeProcessing(boolean) definition code for java.sql.Statement.setEscapeProcessing(boolean) (boolean enable)
          Sets escape processing on or off.
 void setFetchDirection sample code for java.sql.Statement.setFetchDirection(int) definition code for java.sql.Statement.setFetchDirection(int) (int direction)
          Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object.
 void setFetchSize sample code for java.sql.Statement.setFetchSize(int) definition code for java.sql.Statement.setFetchSize(int) (int rows)
          Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed.
 void setMaxFieldSize sample code for java.sql.Statement.setMaxFieldSize(int) definition code for java.sql.Statement.setMaxFieldSize(int) (int max)
          Sets the limit for the maximum number of bytes in a ResultSet column storing character or binary values to the given number of bytes.
 void setMaxRows sample code for java.sql.Statement.setMaxRows(int) definition code for java.sql.Statement.setMaxRows(int) (int max)
          Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number.
 void setQueryTimeout sample code for java.sql.Statement.setQueryTimeout(int) definition code for java.sql.Statement.setQueryTimeout(int) (int seconds)
          Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds.
 

Field Detail

CLOSE_CURRENT_RESULT sample code for java.sql.Statement.CLOSE_CURRENT_RESULT 

static final int CLOSE_CURRENT_RESULT
The constant indicating that the current ResultSet object should be closed when calling getMoreResults.

Since:
1.4
See Also:
Constant Field Values

KEEP_CURRENT_RESULT sample code for java.sql.Statement.KEEP_CURRENT_RESULT 

static final int KEEP_CURRENT_RESULT
The constant indicating that the current ResultSet object should not be closed when calling getMoreResults.

Since:
1.4
See Also:
Constant Field Values

CLOSE_ALL_RESULTS sample code for java.sql.Statement.CLOSE_ALL_RESULTS 

static final int CLOSE_ALL_RESULTS
The constant indicating that all ResultSet objects that have previously been kept open should be closed when calling getMoreResults.

Since:
1.4
See Also:
Constant Field Values

SUCCESS_NO_INFO sample code for java.sql.Statement.SUCCESS_NO_INFO 

static final int SUCCESS_NO_INFO
The constant indicating that a batch statement executed successfully but that no count of the number of rows it affected is available.

Since:
1.4
See Also:
Constant Field Values

EXECUTE_FAILED sample code for java.sql.Statement.EXECUTE_FAILED 

static final int EXECUTE_FAILED
The constant indicating that an error occured while executing a batch statement.

Since:
1.4
See Also:
Constant Field Values

RETURN_GENERATED_KEYS sample code for java.sql.Statement.RETURN_GENERATED_KEYS 

static final int RETURN_GENERATED_KEYS
The constant indicating that generated keys should be made available for retrieval.

Since:
1.4
See Also:
Constant Field Values

NO_GENERATED_KEYS sample code for java.sql.Statement.NO_GENERATED_KEYS 

static final int NO_GENERATED_KEYS
The constant indicating that generated keys should not be made available for retrieval.

Since:
1.4
See Also:
Constant Field Values
Method Detail

executeQuery sample code for java.sql.Statement.executeQuery(java.lang.String) definition code for java.sql.Statement.executeQuery(java.lang.String) 

ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet  executeQuery(String sample code for java.lang.String definition code for java.lang.String  sql)
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Executes the given SQL statement, which returns a single ResultSet object.

Parameters:
sql - an SQL statement to be sent to the database, typically a static SQL SELECT statement
Returns:
a ResultSet object that contains the data produced by the given query; never null
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the given SQL statement produces anything other than a single ResultSet object

executeUpdate sample code for java.sql.Statement.executeUpdate(java.lang.String) definition code for java.sql.Statement.executeUpdate(java.lang.String) 

int executeUpdate(String sample code for java.lang.String definition code for java.lang.String  sql)
                  throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Executes the given SQL statement, which may be an INSERT, UPDATE, or DELETE statement or an SQL statement that returns nothing, such as an SQL DDL statement.

Parameters:
sql - an SQL INSERT, UPDATE or DELETE statement or an SQL statement that returns nothing
Returns:
either the row count for INSERT, UPDATE or DELETE statements, or 0 for SQL statements that return nothing
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the given SQL statement produces a ResultSet object

close sample code for java.sql.Statement.close() definition code for java.sql.Statement.close() 

void close()
           throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Releases this Statement object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed. It is generally good practice to release resources as soon as you are finished with them to avoid tying up database resources.

Calling the method close on a Statement object that is already closed has no effect.

Note: A Statement object is automatically closed when it is garbage collected. When a Statement object is closed, its current ResultSet object, if one exists, is also closed.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs

getMaxFieldSize sample code for java.sql.Statement.getMaxFieldSize() definition code for java.sql.Statement.getMaxFieldSize() 

int getMaxFieldSize()
                    throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the maximum number of bytes that can be returned for character and binary column values in a ResultSet object produced by this Statement object. This limit applies only to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR columns. If the limit is exceeded, the excess data is silently discarded.

Returns:
the current column size limit for columns storing character and binary values; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
setMaxFieldSize(int) sample code for java.sql.Statement.setMaxFieldSize(int) definition code for java.sql.Statement.setMaxFieldSize(int)

setMaxFieldSize sample code for java.sql.Statement.setMaxFieldSize(int) definition code for java.sql.Statement.setMaxFieldSize(int) 

void setMaxFieldSize(int max)
                     throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Sets the limit for the maximum number of bytes in a ResultSet column storing character or binary values to the given number of bytes. This limit applies only to BINARY, VARBINARY, LONGVARBINARY, CHAR, VARCHAR, and LONGVARCHAR fields. If the limit is exceeded, the excess data is silently discarded. For maximum portability, use values greater than 256.

Parameters:
max - the new column size limit in bytes; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the condition max >= 0 is not satisfied
See Also:
getMaxFieldSize() sample code for java.sql.Statement.getMaxFieldSize() definition code for java.sql.Statement.getMaxFieldSize()

getMaxRows sample code for java.sql.Statement.getMaxRows() definition code for java.sql.Statement.getMaxRows() 

int getMaxRows()
               throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the maximum number of rows that a ResultSet object produced by this Statement object can contain. If this limit is exceeded, the excess rows are silently dropped.

Returns:
the current maximum number of rows for a ResultSet object produced by this Statement object; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
setMaxRows(int) sample code for java.sql.Statement.setMaxRows(int) definition code for java.sql.Statement.setMaxRows(int)

setMaxRows sample code for java.sql.Statement.setMaxRows(int) definition code for java.sql.Statement.setMaxRows(int) 

void setMaxRows(int max)
                throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Sets the limit for the maximum number of rows that any ResultSet object can contain to the given number. If the limit is exceeded, the excess rows are silently dropped.

Parameters:
max - the new max rows limit; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the condition max >= 0 is not satisfied
See Also:
getMaxRows() sample code for java.sql.Statement.getMaxRows() definition code for java.sql.Statement.getMaxRows()

setEscapeProcessing sample code for java.sql.Statement.setEscapeProcessing(boolean) definition code for java.sql.Statement.setEscapeProcessing(boolean) 

void setEscapeProcessing(boolean enable)
                         throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
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 PreparedStatements objects will have no effect.

Parameters:
enable - true to enable escape processing; false to disable it
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs

getQueryTimeout sample code for java.sql.Statement.getQueryTimeout() definition code for java.sql.Statement.getQueryTimeout() 

int getQueryTimeout()
                    throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the number of seconds the driver will wait for a Statement object to execute. If the limit is exceeded, a SQLException is thrown.

Returns:
the current query timeout limit in seconds; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
setQueryTimeout(int) sample code for java.sql.Statement.setQueryTimeout(int) definition code for java.sql.Statement.setQueryTimeout(int)

setQueryTimeout sample code for java.sql.Statement.setQueryTimeout(int) definition code for java.sql.Statement.setQueryTimeout(int) 

void setQueryTimeout(int seconds)
                     throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Sets the number of seconds the driver will wait for a Statement object to execute to the given number of seconds. If the limit is exceeded, an SQLException is thrown.

Parameters:
seconds - the new query timeout limit in seconds; zero means there is no limit
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the condition seconds >= 0 is not satisfied
See Also:
getQueryTimeout() sample code for java.sql.Statement.getQueryTimeout() definition code for java.sql.Statement.getQueryTimeout()

cancel sample code for java.sql.Statement.cancel() definition code for java.sql.Statement.cancel() 

void cancel()
            throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Cancels this Statement object if both the DBMS and driver support aborting an SQL statement. This method can be used by one thread to cancel a statement that is being executed by another thread.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs

getWarnings sample code for java.sql.Statement.getWarnings() definition code for java.sql.Statement.getWarnings() 

SQLWarning sample code for java.sql.SQLWarning definition code for java.sql.SQLWarning  getWarnings()
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the first warning reported by calls on this Statement object. Subsequent Statement object warnings will be chained to this SQLWarning object.

The warning chain is automatically cleared each time a statement is (re)executed. This method may not be called on a closed Statement object; doing so will cause an SQLException to be thrown.

Note: If you are processing a ResultSet object, any warnings associated with reads on that ResultSet object will be chained on it rather than on the Statement object that produced it.

Returns:
the first SQLWarning object or null if there are no warnings
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or this method is called on a closed statement

clearWarnings sample code for java.sql.Statement.clearWarnings() definition code for java.sql.Statement.clearWarnings() 

void clearWarnings()
                   throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Clears all the warnings reported on this Statement object. After a call to this method, the method getWarnings will return null until a new warning is reported for this Statement object.

Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs

setCursorName sample code for java.sql.Statement.setCursorName(java.lang.String) definition code for java.sql.Statement.setCursorName(java.lang.String) 

void setCursorName(String sample code for java.lang.String definition code for java.lang.String  name)
                   throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Sets the SQL cursor name to the given String, which will be used by subsequent Statement object execute methods. This name can then be used in SQL positioned update or delete statements to identify the current row in the ResultSet object generated by this statement. If the database does not support positioned update/delete, this method is a noop. To insure that a cursor has the proper isolation level to support updates, the cursor's SELECT statement should have the form SELECT FOR UPDATE. If FOR UPDATE is not present, positioned updates may fail.

Note: By definition, the execution of positioned updates and deletes must be done by a different Statement object than the one that generated the ResultSet object being used for positioning. Also, cursor names must be unique within a connection.

Parameters:
name - the new cursor name, which must be unique within a connection
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs

execute sample code for java.sql.Statement.execute(java.lang.String) definition code for java.sql.Statement.execute(java.lang.String) 

boolean execute(String sample code for java.lang.String definition code for java.lang.String  sql)
                throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
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 execute method executes an SQL statement and indicates the form of the first result. You must then use the methods getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).

Parameters:
sql - any SQL statement
Returns:
true if the first result is a ResultSet object; false if it is an update count or there are no results
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
getResultSet() sample code for java.sql.Statement.getResultSet() definition code for java.sql.Statement.getResultSet() , getUpdateCount() sample code for java.sql.Statement.getUpdateCount() definition code for java.sql.Statement.getUpdateCount() , getMoreResults() sample code for java.sql.Statement.getMoreResults() definition code for java.sql.Statement.getMoreResults()

getResultSet sample code for java.sql.Statement.getResultSet() definition code for java.sql.Statement.getResultSet() 

ResultSet sample code for java.sql.ResultSet definition code for java.sql.ResultSet  getResultSet()
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the current result as a ResultSet object. This method should be called only once per result.

Returns:
the current result as a ResultSet object or null if the result is an update count or there are no more results
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
execute(java.lang.String) sample code for java.sql.Statement.execute(java.lang.String) definition code for java.sql.Statement.execute(java.lang.String)

getUpdateCount sample code for java.sql.Statement.getUpdateCount() definition code for java.sql.Statement.getUpdateCount() 

int getUpdateCount()
                   throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Retrieves the current result as an update count; if the result is a ResultSet object or there are no more results, -1 is returned. This method should be called only once per result.

Returns:
the current result as an update count; -1 if the current result is a ResultSet object or there are no more results
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
execute(java.lang.String) sample code for java.sql.Statement.execute(java.lang.String) definition code for java.sql.Statement.execute(java.lang.String)

getMoreResults sample code for java.sql.Statement.getMoreResults() definition code for java.sql.Statement.getMoreResults() 

boolean getMoreResults()
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Moves to this Statement object's next result, returns true if it is a ResultSet object, and implicitly closes any current ResultSet object(s) obtained with the method getResultSet.

There are no more results when the following is true: 

     // stmt is a Statement object
     ((stmt.getMoreResults() == false) && (stmt.getUpdateCount() == -1))

Returns:
true if the next result is a ResultSet object; false if it is an update count or there are no more results
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs
See Also:
execute(java.lang.String) sample code for java.sql.Statement.execute(java.lang.String) definition code for java.sql.Statement.execute(java.lang.String)

setFetchDirection sample code for java.sql.Statement.setFetchDirection(int) definition code for java.sql.Statement.setFetchDirection(int) 

void setFetchDirection(int direction)
                       throws SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException
Gives the driver a hint as to the direction in which rows will be processed in ResultSet objects created using this Statement object. The default value is ResultSet.FETCH_FORWARD.

Note that this method sets the default fetch direction for result sets generated by this Statement object. Each result set has its own methods for getting and setting its own fetch direction.

Parameters:
direction - the initial direction for processing rows
Throws:
SQLException sample code for java.sql.SQLException definition code for java.sql.SQLException - if a database access error occurs or the given direction is not one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
Since:
1.2
See Also:
getFetchDirection() sample code for java.sql.Statement.getFetchDirection() definition code for java.sql.Statement.getFetchDirection()

getFetchDirection