connectivity/source/drivers/mozab/MPreparedStatement.hxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: MPreparedStatement.hxx,v $
  10  * $Revision: 1.8.56.1 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30 #ifndef CONNECTIVITY_SPREPAREDSTATEMENT_HXX
  31 #define CONNECTIVITY_SPREPAREDSTATEMENT_HXX
  32
  33 #ifndef CONNECTIVITY_SRESULTSET_HXX
  34 #include "MResultSet.hxx"
  35 #endif
  36 #include "MStatement.hxx"
  37 #include <com/sun/star/sdbc/XPreparedStatement.hpp>
  38 #include <com/sun/star/sdbc/XParameters.hpp>
  39 #include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp>
  40 #include <com/sun/star/io/XInputStream.hpp>
  41 #include <com/sun/star/sdbc/XMultipleResults.hpp>
  42 #include <cppuhelper/compbase5.hxx>
  43
  44 namespace connectivity
  45 {
  46     namespace mozab
  47     {
  48
  49         class OBoundParam;
  50         typedef ::cppu::ImplHelper5<    ::com::sun::star::sdbc::XPreparedStatement,
  51                                         ::com::sun::star::sdbc::XParameters,
  52                                         ::com::sun::star::sdbc::XResultSetMetaDataSupplier,
  53                                         ::com::sun::star::sdbc::XMultipleResults,
  54                                         ::com::sun::star::lang::XServiceInfo> OPreparedStatement_BASE;
  55
  56         class OPreparedStatement :  public  OCommonStatement,
  57                                     public  OPreparedStatement_BASE
  58         {
  59         protected:
  60             struct Parameter
  61             {
  62                 ::com::sun::star::uno::Any  aValue;
  63                 sal_Int32                   nDataType;
  64
  65                 Parameter(const ::com::sun::star::uno::Any& rValue,
  66                           sal_Int32                         rDataType) : aValue(rValue),nDataType(rDataType)
  67                 {
  68                 }
  69
  70             };
  71
  72             ::std::vector< Parameter>       m_aParameters;
  73             //====================================================================
  74             // Data attributes
  75             //====================================================================
  76             sal_Int32                       m_nNumParams;       // Number of parameter markers
  77                                                                 //  for the prepared statement
  78
  79             ::rtl::OUString                             m_sSqlStatement;
  80             ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSetMetaData >  m_xMetaData;
  81             sal_Bool                                    m_bPrepared;
  82             ::rtl::Reference< OResultSet >              m_pResultSet;
  83             ::vos::ORef<connectivity::OSQLColumns>      m_xParamColumns;    // the parameter columns
  84             OValueRow                                   m_aParameterRow;
  85
  86
  87             void checkParameterIndex(sal_Int32 _parameterIndex);
  88
  89         protected:
  90             virtual void SAL_CALL setFastPropertyValue_NoBroadcast(sal_Int32 nHandle,
  91                                                                    const ::com::sun::star::uno::Any& rValue)
  92                                                                         throw (::com::sun::star::uno::Exception);
  93             virtual ~OPreparedStatement();
  94
  95             virtual void SAL_CALL disposing();
  96
  97             // OCommonStatement overridables
  98             virtual StatementType
  99                             parseSql( const ::rtl::OUString& sql , sal_Bool bAdjusted = sal_False) throw ( ::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException );
 100             virtual void    initializeResultSet( OResultSet* _pResult );
 101             virtual void    clearCachedResultSet();
 102             virtual void    cacheResultSet( const ::rtl::Reference< OResultSet >& _pResult );
 103
 104
 105             void checkAndResizeParameters(sal_Int32 parameterIndex);
 106             void setParameter(sal_Int32 parameterIndex, const ORowSetValue& x);
 107
 108             sal_uInt32 AddParameter(connectivity::OSQLParseNode * pParameter,
 109                                 const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet>& _xCol);
 110             void scanParameter(OSQLParseNode* pParseNode,::std::vector< OSQLParseNode*>& _rParaNodes);
 111             void describeColumn(OSQLParseNode* _pParameter,OSQLParseNode* _pNode,const OSQLTable& _xTable);
 112             void describeParameter();
 113
 114         public:
 115             DECLARE_SERVICE_INFO();
 116             // ein Konstruktor, der fuer das Returnen des Objektes benoetigt wird:
 117             OPreparedStatement( OConnection* _pConnection,const ::rtl::OUString& sql);
 118             void lateInit();
 119
 120             //XInterface
 121             virtual ::com::sun::star::uno::Any SAL_CALL queryInterface( const ::com::sun::star::uno::Type & rType ) throw(::com::sun::star::uno::RuntimeException);
 122             virtual void SAL_CALL acquire() throw();
 123             virtual void SAL_CALL release() throw();
 124             //XTypeProvider
 125             virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes(  ) throw(::com::sun::star::uno::RuntimeException);
 126
 127             // XPreparedStatement
 128             virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL executeQuery(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 129             virtual sal_Int32 SAL_CALL executeUpdate(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 130             virtual sal_Bool SAL_CALL execute(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 131             virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection > SAL_CALL getConnection(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 132             // XParameters
 133             virtual void SAL_CALL setNull( sal_Int32 parameterIndex, sal_Int32 sqlType ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 134             virtual void SAL_CALL setObjectNull( sal_Int32 parameterIndex, sal_Int32 sqlType, const ::rtl::OUString& typeName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 135             virtual void SAL_CALL setBoolean( sal_Int32 parameterIndex, sal_Bool x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 136             virtual void SAL_CALL setByte( sal_Int32 parameterIndex, sal_Int8 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 137             virtual void SAL_CALL setShort( sal_Int32 parameterIndex, sal_Int16 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 138             virtual void SAL_CALL setInt( sal_Int32 parameterIndex, sal_Int32 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 139             virtual void SAL_CALL setLong( sal_Int32 parameterIndex, sal_Int64 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 140             virtual void SAL_CALL setFloat( sal_Int32 parameterIndex, float x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 141             virtual void SAL_CALL setDouble( sal_Int32 parameterIndex, double x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 142             virtual void SAL_CALL setString( sal_Int32 parameterIndex, const ::rtl::OUString& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 143             virtual void SAL_CALL setBytes( sal_Int32 parameterIndex, const ::com::sun::star::uno::Sequence< sal_Int8 >& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 144             virtual void SAL_CALL setDate( sal_Int32 parameterIndex, const ::com::sun::star::util::Date& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 145             virtual void SAL_CALL setTime( sal_Int32 parameterIndex, const ::com::sun::star::util::Time& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 146             virtual void SAL_CALL setTimestamp( sal_Int32 parameterIndex, const ::com::sun::star::util::DateTime& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 147             virtual void SAL_CALL setBinaryStream( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 148             virtual void SAL_CALL setCharacterStream( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::io::XInputStream >& x, sal_Int32 length ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 149             virtual void SAL_CALL setObject( sal_Int32 parameterIndex, const ::com::sun::star::uno::Any& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 150             virtual void SAL_CALL setObjectWithInfo( sal_Int32 parameterIndex, const ::com::sun::star::uno::Any& x, sal_Int32 targetSqlType, sal_Int32 scale ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 151             virtual void SAL_CALL setRef( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XRef >& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 152             virtual void SAL_CALL setBlob( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XBlob >& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 153             virtual void SAL_CALL setClob( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XClob >& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 154             virtual void SAL_CALL setArray( sal_Int32 parameterIndex, const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XArray >& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 155             virtual void SAL_CALL clearParameters(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 156             // XResultSetMetaDataSupplier
 157             virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSetMetaData > SAL_CALL getMetaData(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 158             // XMultipleResults
 159             virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSet > SAL_CALL getResultSet(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 160             virtual sal_Int32 SAL_CALL getUpdateCount(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 161             virtual sal_Bool SAL_CALL getMoreResults(  ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException);
 162
 163         public:
 164             using OCommonStatement::executeQuery;
 165             using OCommonStatement::executeUpdate;
 166             using OCommonStatement::execute;
 167         protected:
 168             using OPropertySetHelper::getFastPropertyValue;
 169         };
 170     }
 171 }
 172 #endif // CONNECTIVITY_SPREPAREDSTATEMENT_HXX