1d1766043SAndrew Rist/************************************************************** 2cdf0e10cSrcweir * 3d1766043SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4d1766043SAndrew Rist * or more contributor license agreements. See the NOTICE file 5d1766043SAndrew Rist * distributed with this work for additional information 6d1766043SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7d1766043SAndrew Rist * to you under the Apache License, Version 2.0 (the 8d1766043SAndrew Rist * "License"); you may not use this file except in compliance 9d1766043SAndrew Rist * with the License. You may obtain a copy of the License at 10d1766043SAndrew Rist * 11d1766043SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12d1766043SAndrew Rist * 13d1766043SAndrew Rist * Unless required by applicable law or agreed to in writing, 14d1766043SAndrew Rist * software distributed under the License is distributed on an 15d1766043SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16d1766043SAndrew Rist * KIND, either express or implied. See the License for the 17d1766043SAndrew Rist * specific language governing permissions and limitations 18d1766043SAndrew Rist * under the License. 19d1766043SAndrew Rist * 20d1766043SAndrew Rist *************************************************************/ 21d1766043SAndrew Rist 22d1766043SAndrew Rist 23cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_XPreparedStatement_idl__ 24cdf0e10cSrcweir#define __com_sun_star_sdbc_XPreparedStatement_idl__ 25cdf0e10cSrcweir 26cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 27cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 28cdf0e10cSrcweir#endif 29cdf0e10cSrcweir 30cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_SQLException_idl__ 31cdf0e10cSrcweir#include <com/sun/star/sdbc/SQLException.idl> 32cdf0e10cSrcweir#endif 33cdf0e10cSrcweir 34cdf0e10cSrcweir module com { module sun { module star { module sdbc { 35cdf0e10cSrcweir 36cdf0e10cSrcweir published interface XConnection; 37cdf0e10cSrcweir published interface XResultSet; 38cdf0e10cSrcweir 39cdf0e10cSrcweir 40*a893be29SPedro Giffuni/** provides the possibility of executing a precompiled SQL statement. 41cdf0e10cSrcweir 42cdf0e10cSrcweir 43cdf0e10cSrcweir <p> 44cdf0e10cSrcweir A SQL statement is pre-compiled and stored in a PreparedStatement object. 45cdf0e10cSrcweir This object can then be used to efficiently execute this statement multiple 46cdf0e10cSrcweir times. 47cdf0e10cSrcweir </p> 48cdf0e10cSrcweir */ 49cdf0e10cSrcweirpublished interface XPreparedStatement: com::sun::star::uno::XInterface 50cdf0e10cSrcweir{ 51cdf0e10cSrcweir 52cdf0e10cSrcweir /** executes the SQL query in this 53cdf0e10cSrcweir <code>PreparedStatement</code> 54cdf0e10cSrcweir object and returns the result set generated by the query. 55cdf0e10cSrcweir @returns 56cdf0e10cSrcweir the ResultSet object 57cdf0e10cSrcweir @throws SQLException 58cdf0e10cSrcweir if a database access error occurs. 59cdf0e10cSrcweir */ 60cdf0e10cSrcweir XResultSet executeQuery() raises (SQLException); 61cdf0e10cSrcweir //------------------------------------------------------------------------- 62cdf0e10cSrcweir 63cdf0e10cSrcweir /** executes the SQL INSERT, UPDATE or DELETE statement in this 64cdf0e10cSrcweir <type scope="com::sun::star::sdbc">PreparedStatement</type> 65cdf0e10cSrcweir object. 66cdf0e10cSrcweir <br/> 67cdf0e10cSrcweir In addition, SQL statements that return nothing, such as 68cdf0e10cSrcweir SQL DDL statements, can be executed. 69cdf0e10cSrcweir @returns 70cdf0e10cSrcweir either the row count for INSERT, UPDATE or DELETE statements; or 0 for SQL statements that return nothing 71cdf0e10cSrcweir @throws SQLException 72cdf0e10cSrcweir if a database access error occurs. 73cdf0e10cSrcweir */ 74cdf0e10cSrcweir long executeUpdate() raises (SQLException); 75cdf0e10cSrcweir //------------------------------------------------------------------------- 76cdf0e10cSrcweir 77cdf0e10cSrcweir /** executes any kind of SQL statement. 78cdf0e10cSrcweir 79cdf0e10cSrcweir 80cdf0e10cSrcweir <p> 81cdf0e10cSrcweir Some prepared statements return multiple results; the execute 82cdf0e10cSrcweir method handles these complex statements as well as the simpler 83cdf0e10cSrcweir form of statements handled by executeQuery and executeUpdate. 84cdf0e10cSrcweir </p> 85cdf0e10cSrcweir @returns 86cdf0e10cSrcweir <TRUE/> if successful 87cdf0e10cSrcweir @throws SQLException 88cdf0e10cSrcweir if a database access error occurs. 89cdf0e10cSrcweir */ 90cdf0e10cSrcweir boolean execute() raises (SQLException); 91cdf0e10cSrcweir //------------------------------------------------------------------------- 92cdf0e10cSrcweir 93cdf0e10cSrcweir /** returns the 94cdf0e10cSrcweir <type scope="com::sun::star::sdbc">Connection</type> 95cdf0e10cSrcweir object 96cdf0e10cSrcweir that produced this 97cdf0e10cSrcweir <type scope="com::sun::star::sdbc">Statement</type> 98cdf0e10cSrcweir object. 99cdf0e10cSrcweir @returns 100cdf0e10cSrcweir the Connection object 101cdf0e10cSrcweir @throws SQLException 102cdf0e10cSrcweir if a database access error occurs. 103cdf0e10cSrcweir */ 104cdf0e10cSrcweir XConnection getConnection() raises (SQLException); 105cdf0e10cSrcweir}; 106cdf0e10cSrcweir 107cdf0e10cSrcweir//============================================================================= 108cdf0e10cSrcweir 109cdf0e10cSrcweir}; }; }; }; 110cdf0e10cSrcweir 111cdf0e10cSrcweir/*=========================================================================== 112cdf0e10cSrcweir===========================================================================*/ 113cdf0e10cSrcweir#endif 114