1*d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3*d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*d1766043SAndrew Rist * distributed with this work for additional information 6*d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9*d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10cdf0e10cSrcweir * 11*d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 13*d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*d1766043SAndrew Rist * software distributed under the License is distributed on an 15*d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17*d1766043SAndrew Rist * specific language governing permissions and limitations 18*d1766043SAndrew Rist * under the License. 19cdf0e10cSrcweir * 20*d1766043SAndrew Rist *************************************************************/ 21*d1766043SAndrew Rist 22*d1766043SAndrew Rist 23cdf0e10cSrcweir#ifndef __com_sun_star_sdb_XCommandPreparation_idl__ 24cdf0e10cSrcweir#define __com_sun_star_sdb_XCommandPreparation_idl__ 25cdf0e10cSrcweir 26cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_SQLException_idl__ 27cdf0e10cSrcweir#include <com/sun/star/sdbc/SQLException.idl> 28cdf0e10cSrcweir#endif 29cdf0e10cSrcweir 30cdf0e10cSrcweir module com { module sun { module star { module sdbc { 31cdf0e10cSrcweir published interface XPreparedStatement; 32cdf0e10cSrcweir};};};}; 33cdf0e10cSrcweir 34cdf0e10cSrcweir module com { module sun { module star { module sdb { 35cdf0e10cSrcweir 36cdf0e10cSrcweir 37cdf0e10cSrcweir/** is used for preparation of commands. 38cdf0e10cSrcweir 39cdf0e10cSrcweir <p> 40cdf0e10cSrcweir A command could be a table, query, or any kind of SQL statement 41cdf0e10cSrcweir prepared by the user. 42cdf0e10cSrcweir </p> 43cdf0e10cSrcweir */ 44cdf0e10cSrcweirpublished interface XCommandPreparation: com::sun::star::uno::XInterface 45cdf0e10cSrcweir{ 46cdf0e10cSrcweir 47cdf0e10cSrcweir /** creates a 48cdf0e10cSrcweir <type scope="com::sun::star::sdbc">PreparedStatement</type> 49cdf0e10cSrcweir object for sending parameterized SQL statements to the database. 50cdf0e10cSrcweir 51cdf0e10cSrcweir <p> 52cdf0e10cSrcweir A SQL statement with or without IN parameters can be 53cdf0e10cSrcweir pre-compiled and stored in a PreparedStatement object. This 54cdf0e10cSrcweir object can then be used to efficiently execute this statement 55cdf0e10cSrcweir multiple times. 56cdf0e10cSrcweir </p> 57cdf0e10cSrcweir @param command 58cdf0e10cSrcweir the command to be prepared. Any SQL statement. 59cdf0e10cSrcweir @param commandType 60cdf0e10cSrcweir kind of the command 61cdf0e10cSrcweir <type scope="com::sun::star::sdb">CommandType</type> 62cdf0e10cSrcweir @returns 63cdf0e10cSrcweir the PreparedStatement object 64cdf0e10cSrcweir @throws com::sun::star::sdbc::SQLException 65cdf0e10cSrcweir if a database access error occurs. 66cdf0e10cSrcweir */ 67cdf0e10cSrcweir com::sun::star::sdbc::XPreparedStatement prepareCommand([in]string command, [in] long commandType) 68cdf0e10cSrcweir raises (com::sun::star::sdbc::SQLException); 69cdf0e10cSrcweir}; 70cdf0e10cSrcweir 71cdf0e10cSrcweir//============================================================================= 72cdf0e10cSrcweir 73cdf0e10cSrcweir}; }; }; }; 74cdf0e10cSrcweir 75cdf0e10cSrcweir/*=========================================================================== 76cdf0e10cSrcweir===========================================================================*/ 77cdf0e10cSrcweir#endif 78