1*caf5cd79SAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*caf5cd79SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*caf5cd79SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*caf5cd79SAndrew Rist * distributed with this work for additional information 6*caf5cd79SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*caf5cd79SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*caf5cd79SAndrew Rist * "License"); you may not use this file except in compliance 9*caf5cd79SAndrew Rist * with the License. You may obtain a copy of the License at 10*caf5cd79SAndrew Rist * 11*caf5cd79SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*caf5cd79SAndrew Rist * 13*caf5cd79SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*caf5cd79SAndrew Rist * software distributed under the License is distributed on an 15*caf5cd79SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*caf5cd79SAndrew Rist * KIND, either express or implied. See the License for the 17*caf5cd79SAndrew Rist * specific language governing permissions and limitations 18*caf5cd79SAndrew Rist * under the License. 19*caf5cd79SAndrew Rist * 20*caf5cd79SAndrew Rist *************************************************************/ 21*caf5cd79SAndrew Rist 22*caf5cd79SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir #ifndef _CONNECTIVITY_CALC_CONNECTION_HXX_ 25cdf0e10cSrcweir #define _CONNECTIVITY_CALC_CONNECTION_HXX_ 26cdf0e10cSrcweir 27cdf0e10cSrcweir #include "file/FConnection.hxx" 28cdf0e10cSrcweir 29cdf0e10cSrcweir namespace com { namespace sun { namespace star { namespace sheet { 30cdf0e10cSrcweir class XSpreadsheetDocument; 31cdf0e10cSrcweir } } } } 32cdf0e10cSrcweir 33cdf0e10cSrcweir 34cdf0e10cSrcweir namespace connectivity 35cdf0e10cSrcweir { 36cdf0e10cSrcweir namespace calc 37cdf0e10cSrcweir { 38cdf0e10cSrcweir class ODriver; 39cdf0e10cSrcweir class OCalcConnection : public file::OConnection 40cdf0e10cSrcweir { 41cdf0e10cSrcweir // the spreadsheet document: 42cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sheet::XSpreadsheetDocument > m_xDoc; 43cdf0e10cSrcweir ::rtl::OUString m_sPassword; 44cdf0e10cSrcweir String m_aFileName; 45cdf0e10cSrcweir oslInterlockedCount m_nDocCount; 46cdf0e10cSrcweir 47cdf0e10cSrcweir public: 48cdf0e10cSrcweir OCalcConnection(ODriver* _pDriver); 49cdf0e10cSrcweir virtual ~OCalcConnection(); 50cdf0e10cSrcweir 51cdf0e10cSrcweir virtual void construct(const ::rtl::OUString& _rUrl, 52cdf0e10cSrcweir const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::PropertyValue >& _rInfo ) 53cdf0e10cSrcweir throw( ::com::sun::star::sdbc::SQLException); 54cdf0e10cSrcweir 55cdf0e10cSrcweir // XServiceInfo 56cdf0e10cSrcweir DECLARE_SERVICE_INFO(); 57cdf0e10cSrcweir 58cdf0e10cSrcweir // OComponentHelper 59cdf0e10cSrcweir virtual void SAL_CALL disposing(void); 60cdf0e10cSrcweir 61cdf0e10cSrcweir // XConnection 62cdf0e10cSrcweir virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData > SAL_CALL getMetaData( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 63cdf0e10cSrcweir virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbcx::XTablesSupplier > createCatalog(); 64cdf0e10cSrcweir virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XStatement > SAL_CALL createStatement( ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 65cdf0e10cSrcweir virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XPreparedStatement > SAL_CALL prepareStatement( const ::rtl::OUString& sql ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 66cdf0e10cSrcweir virtual ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XPreparedStatement > SAL_CALL prepareCall( const ::rtl::OUString& sql ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException); 67cdf0e10cSrcweir 68cdf0e10cSrcweir // no interface methods 69cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sheet::XSpreadsheetDocument> acquireDoc(); 70cdf0e10cSrcweir void releaseDoc(); 71cdf0e10cSrcweir 72cdf0e10cSrcweir class ODocHolder 73cdf0e10cSrcweir { 74cdf0e10cSrcweir OCalcConnection* m_pConnection; 75cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sheet::XSpreadsheetDocument> m_xDoc; 76cdf0e10cSrcweir public: ODocHolder(OCalcConnection * _pConnection)77cdf0e10cSrcweir ODocHolder(OCalcConnection* _pConnection) : m_pConnection(_pConnection) 78cdf0e10cSrcweir { 79cdf0e10cSrcweir m_xDoc = m_pConnection->acquireDoc(); 80cdf0e10cSrcweir } ~ODocHolder()81cdf0e10cSrcweir ~ODocHolder() 82cdf0e10cSrcweir { 83cdf0e10cSrcweir m_xDoc.clear(); 84cdf0e10cSrcweir m_pConnection->releaseDoc(); 85cdf0e10cSrcweir } getDoc() const86cdf0e10cSrcweir ::com::sun::star::uno::Reference< ::com::sun::star::sheet::XSpreadsheetDocument> getDoc() const { return m_xDoc; } 87cdf0e10cSrcweir }; 88cdf0e10cSrcweir }; 89cdf0e10cSrcweir } 90cdf0e10cSrcweir } 91cdf0e10cSrcweir 92cdf0e10cSrcweir #endif // _CONNECTIVITY_CALC_CONNECTION_HXX_ 93cdf0e10cSrcweir 94