Overview | Module | Use | Devguide | Index

Methods' Summary | Methods' Details | Attributes' Summary | Attributes' Details

:: com :: sun :: star :: sdbc ::
interface XPreparedStatement
  Base Hierarchy
      ::com::sun::star::uno::XInterface
       |
       +-XPreparedStatement
Description provides the possibilty of executing a precompiled SQL statement. A SQL statement is pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Methods' Summary
executeQuery | executes the SQL query in this `PreparedStatement` object and returns the result set generated by the query.
executeUpdate | executes the SQL INSERT, UPDATE or DELETE statement in this PreparedStatement object. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed.
execute | executes any kind of SQL statement.
getConnection | returns the Connection object that produced this Statement object.

Methods' Details
executeQuery
XResultSet executeQuery() | raises( | SQLException );
Description executes the SQL query in this `PreparedStatement` object and returns the result set generated by the query. Returns the ResultSet object Throws SQLException if a database access error occurs.
executeUpdate
long executeUpdate() | raises( | SQLException );
Description executes the SQL INSERT, UPDATE or DELETE statement in this PreparedStatement object. In addition, SQL statements that return nothing, such as SQL DDL statements, can be executed. Returns either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing Throws SQLException if a database access error occurs.
execute
boolean execute() | raises( | SQLException );
Description executes any kind of SQL statement. Some prepared statements return multiple results; the execute method handles these complex statements as well as the simpler form of statements handled by executeQuery and executeUpdate. Returns true if successful Throws SQLException if a database access error occurs.
getConnection
XConnection getConnection() | raises( | SQLException );
Description returns the Connection object that produced this Statement object. Returns the Connection object Throws SQLException if a database access error occurs.

Top of Page

Copyright © 2003 Sun Microsystems, Inc.