1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir #ifndef _CONNECTIVITY_EVOAB_PREPAREDSTATEMENT_HXX_ 29*cdf0e10cSrcweir #define _CONNECTIVITY_EVOAB_PREPAREDSTATEMENT_HXX_ 30*cdf0e10cSrcweir 31*cdf0e10cSrcweir #include "NStatement.hxx" 32*cdf0e10cSrcweir #include "NConnection.hxx" 33*cdf0e10cSrcweir #include "NDatabaseMetaData.hxx" 34*cdf0e10cSrcweir #include "NResultSet.hxx" 35*cdf0e10cSrcweir #include <com/sun/star/sdbc/XPreparedStatement.hpp> 36*cdf0e10cSrcweir #include <com/sun/star/sdbc/XParameters.hpp> 37*cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSetMetaDataSupplier.hpp> 38*cdf0e10cSrcweir #include <com/sun/star/sdbc/XPreparedBatchExecution.hpp> 39*cdf0e10cSrcweir #include <com/sun/star/io/XInputStream.hpp> 40*cdf0e10cSrcweir 41*cdf0e10cSrcweir namespace connectivity 42*cdf0e10cSrcweir { 43*cdf0e10cSrcweir namespace evoab 44*cdf0e10cSrcweir { 45*cdf0e10cSrcweir 46*cdf0e10cSrcweir class OBoundParam; 47*cdf0e10cSrcweir typedef ::cppu::ImplHelper5< ::com::sun::star::sdbc::XPreparedStatement, 48*cdf0e10cSrcweir ::com::sun::star::sdbc::XParameters, 49*cdf0e10cSrcweir ::com::sun::star::sdbc::XResultSetMetaDataSupplier, 50*cdf0e10cSrcweir ::com::sun::star::sdbc::XMultipleResults, 51*cdf0e10cSrcweir ::com::sun::star::lang::XServiceInfo> OPreparedStatement_BASE; 52*cdf0e10cSrcweir 53*cdf0e10cSrcweir class OEvoabPreparedStatement :public OCommonStatement 54*cdf0e10cSrcweir ,public OPreparedStatement_BASE 55*cdf0e10cSrcweir { 56*cdf0e10cSrcweir protected: 57*cdf0e10cSrcweir struct Parameter 58*cdf0e10cSrcweir { 59*cdf0e10cSrcweir ::com::sun::star::uno::Any aValue; 60*cdf0e10cSrcweir sal_Int32 nDataType; 61*cdf0e10cSrcweir 62*cdf0e10cSrcweir Parameter(const ::com::sun::star::uno::Any& rValue, 63*cdf0e10cSrcweir sal_Int32 rDataType) : aValue(rValue),nDataType(rDataType) 64*cdf0e10cSrcweir { 65*cdf0e10cSrcweir } 66*cdf0e10cSrcweir 67*cdf0e10cSrcweir }; 68*cdf0e10cSrcweir 69*cdf0e10cSrcweir ::std::vector< Parameter> m_aParameters; 70*cdf0e10cSrcweir //==================================================================== 71*cdf0e10cSrcweir // Data attributes 72*cdf0e10cSrcweir //==================================================================== 73*cdf0e10cSrcweir 74*cdf0e10cSrcweir // our SQL statement 75*cdf0e10cSrcweir ::rtl::OUString m_sSqlStatement; 76*cdf0e10cSrcweir // the EBookQuery we're working with 77*cdf0e10cSrcweir QueryData m_aQueryData; 78*cdf0e10cSrcweir // our meta data 79*cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XResultSetMetaData > m_xMetaData; 80*cdf0e10cSrcweir 81*cdf0e10cSrcweir protected: 82*cdf0e10cSrcweir virtual ~OEvoabPreparedStatement(); 83*cdf0e10cSrcweir 84*cdf0e10cSrcweir public: 85*cdf0e10cSrcweir OEvoabPreparedStatement( OEvoabConnection* _pConnection ); 86*cdf0e10cSrcweir 87*cdf0e10cSrcweir void construct( const ::rtl::OUString& _sql ); 88*cdf0e10cSrcweir 89*cdf0e10cSrcweir protected: 90*cdf0e10cSrcweir DECLARE_SERVICE_INFO(); 91*cdf0e10cSrcweir //XInterface 92*cdf0e10cSrcweir virtual ::com::sun::star::uno::Any SAL_CALL queryInterface( const ::com::sun::star::uno::Type & rType ) throw(::com::sun::star::uno::RuntimeException); 93*cdf0e10cSrcweir virtual void SAL_CALL acquire() throw(); 94*cdf0e10cSrcweir virtual void SAL_CALL release() throw(); 95*cdf0e10cSrcweir //XTypeProvider 96*cdf0e10cSrcweir virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes( ) throw(::com::sun::star::uno::RuntimeException); 97*cdf0e10cSrcweir 98*cdf0e10cSrcweir // XPreparedStatement 99*cdf0e10cSrcweir 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); 100*cdf0e10cSrcweir virtual sal_Int32 SAL_CALL executeUpdate( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 101*cdf0e10cSrcweir virtual sal_Bool SAL_CALL execute( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 102*cdf0e10cSrcweir 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); 103*cdf0e10cSrcweir // XParameters 104*cdf0e10cSrcweir virtual void SAL_CALL setNull( sal_Int32 parameterIndex, sal_Int32 sqlType ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 105*cdf0e10cSrcweir 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); 106*cdf0e10cSrcweir virtual void SAL_CALL setBoolean( sal_Int32 parameterIndex, sal_Bool x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 107*cdf0e10cSrcweir virtual void SAL_CALL setByte( sal_Int32 parameterIndex, sal_Int8 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 108*cdf0e10cSrcweir virtual void SAL_CALL setShort( sal_Int32 parameterIndex, sal_Int16 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 109*cdf0e10cSrcweir virtual void SAL_CALL setInt( sal_Int32 parameterIndex, sal_Int32 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 110*cdf0e10cSrcweir virtual void SAL_CALL setLong( sal_Int32 parameterIndex, sal_Int64 x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 111*cdf0e10cSrcweir virtual void SAL_CALL setFloat( sal_Int32 parameterIndex, float x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 112*cdf0e10cSrcweir virtual void SAL_CALL setDouble( sal_Int32 parameterIndex, double x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 113*cdf0e10cSrcweir virtual void SAL_CALL setString( sal_Int32 parameterIndex, const ::rtl::OUString& x ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 114*cdf0e10cSrcweir 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); 115*cdf0e10cSrcweir 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); 116*cdf0e10cSrcweir 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); 117*cdf0e10cSrcweir 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); 118*cdf0e10cSrcweir 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); 119*cdf0e10cSrcweir 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); 120*cdf0e10cSrcweir 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); 121*cdf0e10cSrcweir 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); 122*cdf0e10cSrcweir 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); 123*cdf0e10cSrcweir 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); 124*cdf0e10cSrcweir 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); 125*cdf0e10cSrcweir 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); 126*cdf0e10cSrcweir virtual void SAL_CALL clearParameters( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 127*cdf0e10cSrcweir // XCloseable 128*cdf0e10cSrcweir virtual void SAL_CALL close( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 129*cdf0e10cSrcweir // XResultSetMetaDataSupplier 130*cdf0e10cSrcweir 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); 131*cdf0e10cSrcweir // XMultipleResults 132*cdf0e10cSrcweir 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); 133*cdf0e10cSrcweir virtual sal_Int32 SAL_CALL getUpdateCount( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 134*cdf0e10cSrcweir virtual sal_Bool SAL_CALL getMoreResults( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 135*cdf0e10cSrcweir }; 136*cdf0e10cSrcweir } 137*cdf0e10cSrcweir } 138*cdf0e10cSrcweir #endif // CONNECTIVITY_SPREPAREDSTATEMENT_HXX 139