:: com :: sun :: star :: sdbc ::
|
interface XPreparedStatement |
|
- Description
- provides the possibility 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
- 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
- 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
- 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
- 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 © 2000, 2014 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.
Privacy Policy | Impressum (Legal Info) | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.