(incubating) | The Free and Open Productivity Suite

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for OpenOffice.org version 3.3.
Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

:: com :: sun :: star :: sdbc ::

interface 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 © 1995, 2010, Oracle and/or its affiliates. All rights reserved. Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Apache OpenOffice is an effort undergoing incubation at The Apache Software Foundation (ASF), sponsored by the Apache Incubator. Incubation is required of all newly accepted projects until a further review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.

Copyright & License
Apache and the Apache feather logos are trademarks of The Apache Software Foundation. OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.