Statement.execute

Interface Overview | Interface Members | This Package | All Packages

Syntax

public abstract boolean execute( String sql ) throws SQLException

Parameters

sql: any SQL statement

Returns

true if the next result is a ResultSet; false if it is an update count or there are no more results

Description

Execute a SQL statement that may return multiple results. Under some (uncommon) situations a single SQL statement may return multiple result sets and/or update counts. Normally you can ignore this, unless you're executing a stored procedure that you know may return multiple results, or unless you're dynamically executing an unknown SQL string. The "execute", "getMoreResults", "getResultSet" and "getUpdateCount" methods let you navigate through multiple results. The "execute" method executes a SQL statement and indicates the form of the first result. You can then use getResultSet or getUpdateCount to retrieve the result, and getMoreResults to move to any subsequent result(s).

Exceptions

SQLException if a database-access error occurs.