mysqlc/source/mysqlc_preparedstatement.hxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #ifndef CONNECTIVITY_SPREPAREDSTATEMENT_HXX
  21 #define CONNECTIVITY_SPREPAREDSTATEMENT_HXX
  22 #include "mysqlc_statement.hxx"
  23 #include "mysqlc_resultset.hxx"
  24
  25 #include <com/sun/star/sdbc/XPreparedStatement.hpp>
  26 #include <com/sun/star/sdbc/XParameters.hpp>
  27 #include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp>
  28 #include <com/sun/star/sdbc/XPreparedBatchExecution.hpp>
  29 #include <com/sun/star/io/XInputStream.hpp>
  30
  31 #include <cppconn/prepared_statement.h>
  32
  33 namespace connectivity
  34 {
  35     namespace mysqlc
  36     {
  37         using ::com::sun::star::uno::Reference;
  38         using ::com::sun::star::uno::Any;
  39         using ::com::sun::star::uno::Type;
  40         using ::com::sun::star::sdbc::SQLException;
  41         using ::com::sun::star::uno::RuntimeException;
  42         using ::com::sun::star::sdbc::XResultSetMetaData;
  43
  44         typedef ::cppu::ImplHelper5<    ::com::sun::star::sdbc::XPreparedStatement,
  45                                         ::com::sun::star::sdbc::XParameters,
  46                                         ::com::sun::star::sdbc::XPreparedBatchExecution,
  47                                         ::com::sun::star::sdbc::XResultSetMetaDataSupplier,
  48                                         ::com::sun::star::lang::XServiceInfo> OPreparedStatement_BASE;
  49
  50         class OPreparedStatement :  public OCommonStatement,
  51                                     public OPreparedStatement_BASE
  52         {
  53         protected:
  54             unsigned int        m_paramCount;   // number of placeholders
  55             sal_Int32           m_nNumParams;   // Number of parameter markers for the prepared statement
  56             Reference< XResultSetMetaData > m_xMetaData;
  57
  58             void checkParameterIndex(sal_Int32 parameter);
  59
  60         protected:
  61             void SAL_CALL setFastPropertyValue_NoBroadcast(sal_Int32 nHandle, const Any& rValue)
  62                                                                                     throw (::com::sun::star::uno::Exception);
  63             virtual ~OPreparedStatement();
  64         public:
  65             DECLARE_SERVICE_INFO();
  66             OPreparedStatement(OConnection* _pConnection, sql::PreparedStatement * cppPrepStmt);
  67
  68             //XInterface
  69             Any SAL_CALL queryInterface(const Type & rType) throw(RuntimeException);
  70             void SAL_CALL acquire() throw();
  71             void SAL_CALL release() throw();
  72
  73             //XTypeProvider
  74             ::com::sun::star::uno::Sequence< Type > SAL_CALL getTypes()
  75                                                                                     throw(RuntimeException);
  76
  77             // XPreparedStatement
  78             Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL executeQuery() throw(SQLException, RuntimeException);
  79             sal_Int32 SAL_CALL executeUpdate() throw(SQLException, RuntimeException);
  80             sal_Bool SAL_CALL execute() throw(SQLException, RuntimeException);
  81             Reference< ::com::sun::star::sdbc::XConnection > SAL_CALL getConnection() throw(SQLException, RuntimeException);
  82
  83             // XStatement
  84             ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL executeQuery(const OUString& sql)
  85                                                 throw(SQLException, RuntimeException);
  86             sal_Int32 SAL_CALL executeUpdate(const OUString& sql)
  87                                                 throw(SQLException, RuntimeException);
  88             sal_Bool SAL_CALL execute( const OUString& sql )
  89                                                 throw(SQLException, RuntimeException);
  90
  91             // XParameters
  92             void SAL_CALL setNull(sal_Int32 parameter, sal_Int32 sqlType)           throw(SQLException, RuntimeException);
  93
  94             void SAL_CALL setObjectNull(sal_Int32 parameter, sal_Int32 sqlType, const OUString& typeName)
  95                                                                                     throw(SQLException, RuntimeException);
  96
  97             void SAL_CALL setBoolean(sal_Int32 parameter, sal_Bool x)               throw(SQLException, RuntimeException);
  98
  99             void SAL_CALL setByte(sal_Int32 parameter, sal_Int8 x)                  throw(SQLException, RuntimeException);
 100
 101             void SAL_CALL setShort(sal_Int32 parameter, sal_Int16 x)                throw(SQLException, RuntimeException);
 102
 103             void SAL_CALL setInt(sal_Int32 parameter, sal_Int32 x)                  throw(SQLException, RuntimeException);
 104
 105             void SAL_CALL setLong(sal_Int32 parameter, sal_Int64 x)                 throw(SQLException, RuntimeException);
 106
 107             void SAL_CALL setFloat(sal_Int32 parameter, float x)                    throw(SQLException, RuntimeException);
 108
 109             void SAL_CALL setDouble(sal_Int32 parameter, double x)                  throw(SQLException, RuntimeException);
 110
 111             void SAL_CALL setString(sal_Int32 parameter, const OUString& x)         throw(SQLException, RuntimeException);
 112
 113             void SAL_CALL setBytes(sal_Int32 parameter, const ::com::sun::star::uno::Sequence< sal_Int8 >& x)
 114                                                                                     throw(SQLException, RuntimeException);
 115
 116             void SAL_CALL setDate(sal_Int32 parameter, const ::com::sun::star::util::Date& x)
 117                                                                                     throw(SQLException, RuntimeException);
 118
 119             void SAL_CALL setTime(sal_Int32 parameter, const ::com::sun::star::util::Time& x)
 120                                                                                     throw(SQLException, RuntimeException);
 121             void SAL_CALL setTimestamp(sal_Int32 parameter, const ::com::sun::star::util::DateTime& x)
 122                                                                                     throw(SQLException, RuntimeException);
 123
 124             void SAL_CALL setBinaryStream(sal_Int32 parameter, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length)
 125                                                                                     throw(SQLException, RuntimeException);
 126
 127             void SAL_CALL setCharacterStream(sal_Int32 parameter, const Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length)
 128                                                                                     throw(SQLException, RuntimeException);
 129
 130             void SAL_CALL setObject(sal_Int32 parameter, const Any& x)              throw(SQLException, RuntimeException);
 131
 132             void SAL_CALL setObjectWithInfo(sal_Int32 parameter, const Any& x, sal_Int32 targetSqlType, sal_Int32 scale)
 133                                                                                     throw(SQLException, RuntimeException);
 134
 135             void SAL_CALL setRef(sal_Int32 parameter, const Reference< ::com::sun::star::sdbc::XRef >& x)
 136                                                                                     throw(SQLException, RuntimeException);
 137
 138             void SAL_CALL setBlob(sal_Int32 parameter, const Reference< ::com::sun::star::sdbc::XBlob >& x)
 139                                                                                     throw(SQLException, RuntimeException);
 140
 141             void SAL_CALL setClob(sal_Int32 parameter, const Reference< ::com::sun::star::sdbc::XClob >& x)
 142                                                                                     throw(SQLException, RuntimeException);
 143
 144             void SAL_CALL setArray(sal_Int32 parameter, const Reference< ::com::sun::star::sdbc::XArray >& x)
 145                                                                                     throw(SQLException, RuntimeException);
 146
 147             void SAL_CALL clearParameters() throw(SQLException, RuntimeException);
 148
 149             // XPreparedBatchExecution
 150             void SAL_CALL addBatch() throw(SQLException, RuntimeException);
 151             void SAL_CALL clearBatch() throw(SQLException, RuntimeException);
 152             ::com::sun::star::uno::Sequence< sal_Int32 > SAL_CALL executeBatch()    throw(SQLException, RuntimeException);
 153
 154             // XCloseable
 155             void SAL_CALL close() throw(SQLException, RuntimeException);
 156
 157             // XResultSetMetaDataSupplier
 158             Reference< ::com::sun::star::sdbc::XResultSetMetaData > SAL_CALL getMetaData()
 159                                                                                     throw(SQLException, RuntimeException);
 160         };
 161     } /* mysqlc */
 162 } /* connectivity */
 163 #endif // CONNECTIVITY_SPREPAREDSTATEMENT_HXX
 164
 165 /*
 166  * Local variables:
 167  * tab-width: 4
 168  * c-basic-offset: 4
 169  * End:
 170  * vim600: noet sw=4 ts=4 fdm=marker
 171  * vim<600: noet sw=4 ts=4
 172  */
 173
 174
 175 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */