The Free and Open Productivity Suite
QA Volunteers Needed -- Help us test OpenOffice

Developer's Guide

API

SDK

Tips 'n' Tricks

Miscellaneous

Content for Apache OpenOffice version 3.4.
Overview Module Use Devguide Index
Methods' Summary Attributes' Summary Methods' Details Attributes' Details

:: com :: sun :: star :: sdb ::

interface XCommandPreparation
Description
is used for preparation of commands.

A command could be a table, query, or any kind of SQL statement prepared by the user.

Developers Guide
Database - PreparedStatement From DataSource Queries
Methods' Summary
prepareCommand creates a ::com::sun::star::sdbc::PreparedStatement object for sending parameterized SQL statements to the database.  
Methods' Details
prepareCommand
::com::sun::star::sdbc::XPreparedStatement
prepareCommand( [in] string  command,
[in] long  commandType )
raises( ::com::sun::star::sdbc::SQLException );
Description
creates a ::com::sun::star::sdbc::PreparedStatement object for sending parameterized SQL statements to the database.

A SQL statement with or without IN parameters can be pre-compiled and stored in a PreparedStatement object. This object can then be used to efficiently execute this statement multiple times.

Parameter command
the command to be prepared. Any SQL statement.
Parameter commandType
kind of the command CommandType
Returns
the PreparedStatement object
Throws
com::sun::star::sdbc::SQLException if a database access error occurs.
Top of Page

Copyright © 2012, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.

Apache Feather

Copyright & License | Privacy | Contact Us | Donate

Apache, the Apache feather logo, and OpenOffice 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.