blob: 1e921f2eef60833f2282c0a701f25f55f9500288 [file] [log] [blame]
/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
// MARKER(update_precomp.py): autogen include statement, do not remove
#include "precompiled_dbaccess.hxx"
#ifndef DBAUI_DBSETUPCONNECTIONPAGES_HXX
#include "DBSetupConnectionPages.hxx"
#endif
#ifndef _DBAUI_SQLMESSAGE_HXX_
#include "sqlmessage.hxx"
#endif
#ifndef _DBU_RESOURCE_HRC_
#include "dbu_resource.hrc"
#endif
#ifndef _DBAUI_AUTOCONTROLS_HRC_
#include "AutoControls.hrc"
#endif
#ifndef _DBAUI_DBADMINSETUP_HRC_
#include "dbadminsetup.hrc"
#endif
#ifndef _SFXITEMSET_HXX
#include <svl/itemset.hxx>
#endif
#ifndef _SFXSTRITEM_HXX
#include <svl/stritem.hxx>
#endif
#ifndef _SFXENUMITEM_HXX
#include <svl/eitem.hxx>
#endif
#ifndef _SFXINTITEM_HXX
#include <svl/intitem.hxx>
#endif
#ifndef _DBAUI_DATASOURCEITEMS_HXX_
#include "dsitems.hxx"
#endif
#include "dsnItem.hxx"
#ifndef _DBA_DBACCESS_HELPID_HRC_
#include "dbaccess_helpid.hrc"
#endif
#ifndef _DBAUI_LOCALRESACCESS_HXX_
#include "localresaccess.hxx"
#endif
#ifndef _SV_MSGBOX_HXX
#include <vcl/msgbox.hxx>
#endif
#ifndef _SV_MNEMONIC_HXX
#include <vcl/mnemonic.hxx>
#endif
#ifndef _SVTOOLS_CJKOPTIONS_HXX
#include <svl/cjkoptions.hxx>
#endif
#include <jvmaccess/virtualmachine.hxx>
#ifndef _CONNECTIVITY_COMMONTOOLS_HXX_
#include <connectivity/CommonTools.hxx>
#endif
#ifndef DBAUI_DRIVERSETTINGS_HXX
#include "DriverSettings.hxx"
#endif
#ifndef _DBAUI_DBADMIN_HXX_
#include "dbadmin.hxx"
#endif
#ifndef _COMPHELPER_TYPES_HXX_
#include <comphelper/types.hxx>
#endif
#ifndef _COM_SUN_STAR_UI_DIALOGS_XFOLDERPICKER_HPP_
#include <com/sun/star/ui/dialogs/XFolderPicker.hpp>
#endif
// #106016# ------------------------------------
#ifndef _COM_SUN_STAR_TASK_XINTERACTIONHANDLER_HPP_
#include <com/sun/star/task/XInteractionHandler.hpp>
#endif
#include <com/sun/star/sdbc/XDriverAccess.hpp>
#include "dbustrings.hrc"
#ifndef SVTOOLS_FILENOTATION_HXX_
#include <svl/filenotation.hxx>
#endif
#include <unotools/localfilehelper.hxx>
#include <unotools/ucbhelper.hxx>
#include <ucbhelper/commandenvironment.hxx>
#include "finteraction.hxx"
#include <connectivity/CommonTools.hxx>
#include "dbaccess_helpid.hrc"
#include <unotools/pathoptions.hxx>
#include <svtools/roadmapwizard.hxx>
#include "TextConnectionHelper.hxx"
//.........................................................................
namespace dbaui
{
//.........................................................................
using namespace ::com::sun::star;
// using namespace ::com::sun::star::ucb;
// using namespace ::com::sun::star::ui::dialogs;
// using namespace ::com::sun::star::sdbc;
// using namespace ::com::sun::star::beans;
// using namespace ::com::sun::star::lang;
// using namespace ::com::sun::star::container;
// using namespace ::dbtools;
// using namespace ::svt;
OGenericAdministrationPage* OTextConnectionPageSetup::CreateTextTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OTextConnectionPageSetup( pParent, _rAttrSet ) );
}
//========================================================================
//= OTextConnectionPageSetup
//========================================================================
DBG_NAME(OTextConnectionPageSetup)
//------------------------------------------------------------------------
OTextConnectionPageSetup::OTextConnectionPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OConnectionTabPageSetup(pParent, PAGE_DBWIZARD_TEXT, _rCoreAttrs, STR_TEXT_HELPTEXT, STR_TEXT_HEADERTEXT, STR_TEXT_PATH_OR_FILE)
{
DBG_CTOR(OTextConnectionPageSetup,NULL);
m_pTextConnectionHelper = new OTextConnectionHelper( this, TC_EXTENSION | TC_SEPARATORS );
m_pTextConnectionHelper->SetClickHandler(LINK( this, OTextConnectionPageSetup, ImplGetExtensionHdl ) );
FreeResource();
}
// -----------------------------------------------------------------------
OTextConnectionPageSetup::~OTextConnectionPageSetup()
{
DELETEZ(m_pTextConnectionHelper);
DBG_DTOR(OTextConnectionPageSetup,NULL);
}
IMPL_LINK(OTextConnectionPageSetup, ImplGetExtensionHdl, OTextConnectionHelper*, /*_pTextConnectionHelper*/)
{
SetRoadmapStateValue((m_pTextConnectionHelper->GetExtension().Len() > 0) && OConnectionTabPageSetup::checkTestConnection());
callModifiedHdl();
return sal_True;
}
bool OTextConnectionPageSetup::checkTestConnection()
{
bool bDoEnable = OConnectionTabPageSetup::checkTestConnection();
bDoEnable = (m_pTextConnectionHelper->GetExtension().Len() > 0) && bDoEnable;
return bDoEnable;
}
// -----------------------------------------------------------------------
void OTextConnectionPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
OConnectionTabPageSetup::fillControls(_rControlList);
m_pTextConnectionHelper->fillControls(_rControlList);
}
// -----------------------------------------------------------------------
void OTextConnectionPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
OConnectionTabPageSetup::fillWindows(_rControlList);
m_pTextConnectionHelper->fillWindows(_rControlList);
}
// -----------------------------------------------------------------------
void OTextConnectionPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
// first check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
sal_Bool bValid, bReadonly;
getFlags(_rSet, bValid, bReadonly);
OConnectionTabPageSetup::implInitControls( _rSet, _bSaveValue);
m_pTextConnectionHelper->implInitControls(_rSet, bValid);
}
// -----------------------------------------------------------------------
sal_Bool OTextConnectionPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = OConnectionTabPageSetup::FillItemSet(_rSet);
bChangedSomething = m_pTextConnectionHelper->FillItemSet(_rSet, bChangedSomething);
return bChangedSomething;
}
sal_Bool OTextConnectionPageSetup::prepareLeave(){
return m_pTextConnectionHelper->prepareLeave();
}
OGenericAdministrationPage* OLDAPConnectionPageSetup::CreateLDAPTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OLDAPConnectionPageSetup( pParent, _rAttrSet ) );
}
//========================================================================
//= OLDAPPageSetup
//========================================================================
OLDAPConnectionPageSetup::OLDAPConnectionPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OGenericAdministrationPage(pParent, ModuleRes(PAGE_DBWIZARD_LDAP), _rCoreAttrs)
,m_aFTHeaderText (this, ModuleRes(FT_LDAP_HEADERTEXT))
,m_aFTHelpText (this, ModuleRes(FT_LDAP_HELPTEXT))
,m_aFTHostServer (this, ModuleRes(FT_AUTOHOSTNAME))
,m_aETHostServer (this, ModuleRes(ET_AUTOHOSTNAME))
,m_aFTBaseDN (this, ModuleRes(FT_AUTOBASEDN))
,m_aETBaseDN (this, ModuleRes(ET_AUTOBASEDN))
,m_aFTPortNumber (this, ModuleRes(FT_AUTOPORTNUMBER))
,m_aNFPortNumber (this, ModuleRes(NF_AUTOPORTNUMBER))
,m_aFTDefaultPortNumber (this, ModuleRes(FT_AUTOPORTNUMBERDEFAULT))
,m_aCBUseSSL (this, ModuleRes(CB_WIZ_USESSL))
{
SetControlFontWeight(&m_aFTHeaderText);
m_aFTDefaultPortNumber.SetText(String(ModuleRes(STR_LDAP_DEFAULT)));
m_aETHostServer.SetModifyHdl(getControlModifiedLink());
m_aETBaseDN.SetModifyHdl(getControlModifiedLink());
m_aNFPortNumber.SetModifyHdl(getControlModifiedLink());
m_aCBUseSSL.SetToggleHdl(getControlModifiedLink());
SetRoadmapStateValue(sal_False);
FreeResource();
}
// -----------------------------------------------------------------------
sal_Bool OLDAPConnectionPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = sal_False;
fillString(_rSet,&m_aETBaseDN,DSID_CONN_LDAP_BASEDN, bChangedSomething);
fillInt32(_rSet,&m_aNFPortNumber,DSID_CONN_LDAP_PORTNUMBER,bChangedSomething);
if ( m_aETHostServer.GetText() != m_aETHostServer.GetSavedValue() )
{
DbuTypeCollectionItem* pCollectionItem = PTR_CAST(DbuTypeCollectionItem, _rSet.GetItem(DSID_TYPECOLLECTION));
::dbaccess::ODsnTypeCollection* pCollection = NULL;
if (pCollectionItem)
pCollection = pCollectionItem->getCollection();
DBG_ASSERT(pCollection, "OLDAPConnectionPageSetup::FillItemSet : really need a DSN type collection !");
String sUrl = pCollection->getPrefix( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("sdbc:address:ldap:")));
sUrl += m_aETHostServer.GetText();
_rSet.Put(SfxStringItem(DSID_CONNECTURL, sUrl));
bChangedSomething = sal_True;
}
// fillString(_rSet,&m_aETHostServer, DSID_CONNECTURL, bChangedSomething);
fillBool(_rSet,&m_aCBUseSSL,DSID_CONN_LDAP_USESSL,bChangedSomething);
return bChangedSomething;
}
// -----------------------------------------------------------------------
void OLDAPConnectionPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETHostServer));
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETBaseDN));
_rControlList.push_back(new OSaveValueWrapper<NumericField>(&m_aNFPortNumber));
_rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aCBUseSSL));
}
// -----------------------------------------------------------------------
void OLDAPConnectionPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTHelpText));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTHostServer));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTBaseDN));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTPortNumber));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDefaultPortNumber));
}
// -----------------------------------------------------------------------
void OLDAPConnectionPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
// check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
sal_Bool bValid, bReadonly;
getFlags(_rSet, bValid, bReadonly);
SFX_ITEMSET_GET(_rSet, pBaseDN, SfxStringItem, DSID_CONN_LDAP_BASEDN, sal_True);
SFX_ITEMSET_GET(_rSet, pPortNumber, SfxInt32Item, DSID_CONN_LDAP_PORTNUMBER, sal_True);
if ( bValid )
{
m_aETBaseDN.SetText(pBaseDN->GetValue());
m_aNFPortNumber.SetValue(pPortNumber->GetValue());
}
OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
callModifiedHdl();
}
// -----------------------------------------------------------------------
IMPL_LINK(OLDAPConnectionPageSetup, OnEditModified, Edit*, /*_pEdit*/)
{
sal_Bool bRoadmapState = ((m_aETHostServer.GetText().Len() != 0 ) && ( m_aETBaseDN.GetText().Len() != 0 ) && (m_aFTPortNumber.GetText().Len() != 0 ));
SetRoadmapStateValue(bRoadmapState);
callModifiedHdl();
return 0L;
}
// ----------------------------------------------------------------------- //OGenericAdministrationPage*
OMySQLIntroPageSetup* OMySQLIntroPageSetup::CreateMySQLIntroTabPage( Window* _pParent, const SfxItemSet& _rAttrSet )
{
return ( new OMySQLIntroPageSetup( _pParent, _rAttrSet) );
}
DBG_NAME(OMySQLIntroPageSetup)
OMySQLIntroPageSetup::OMySQLIntroPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OGenericAdministrationPage(pParent, ModuleRes(PAGE_DBWIZARD_MYSQL_INTRO), _rCoreAttrs)
,m_aRB_ODBCDatabase(this, ModuleRes(RB_CONNECTVIAODBC))
,m_aRB_JDBCDatabase(this, ModuleRes(RB_CONNECTVIAJDBC))
,m_aRB_NATIVEDatabase(this, ModuleRes(RB_CONNECTVIANATIVE))
,m_aFT_ConnectionMode(this, ModuleRes(FT_MYSQLCONNECTIONMODE))
,m_aFT_Helptext(this, ModuleRes(FT_MYSQL_HELPTEXT))
,m_aFT_Headertext(this, ModuleRes(FT_MYSQL_HEADERTEXT))
{
DBG_CTOR(OMySQLIntroPageSetup,NULL);
SetControlFontWeight(&m_aFT_Headertext);
m_aRB_ODBCDatabase.SetToggleHdl(LINK(this, OMySQLIntroPageSetup, OnSetupModeSelected));
m_aRB_JDBCDatabase.SetToggleHdl(LINK(this, OMySQLIntroPageSetup, OnSetupModeSelected));
m_aRB_NATIVEDatabase.SetToggleHdl(LINK(this, OMySQLIntroPageSetup, OnSetupModeSelected));
FreeResource();
}
IMPL_LINK(OMySQLIntroPageSetup, OnSetupModeSelected, RadioButton*, /*_pBox*/)
{
maClickHdl.Call( this );
return true;
}
// -----------------------------------------------------------------------
OMySQLIntroPageSetup::~OMySQLIntroPageSetup()
{
DBG_DTOR(OMySQLIntroPageSetup,NULL);
}
// -----------------------------------------------------------------------
void OMySQLIntroPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool /*_bSaveValue*/)
{
// show the "Connect directly" option only if the driver is installed
DbuTypeCollectionItem* pCollectionItem = PTR_CAST(DbuTypeCollectionItem, _rSet.GetItem(DSID_TYPECOLLECTION));
bool bHasMySQLNative = ( pCollectionItem != NULL ) && pCollectionItem->getCollection()->hasDriver( "sdbc:mysqlc:" );
if ( bHasMySQLNative )
m_aRB_NATIVEDatabase.Show();
// if any of the options is checked, then there's nothing to do
if ( m_aRB_ODBCDatabase.IsChecked() || m_aRB_JDBCDatabase.IsChecked() || m_aRB_NATIVEDatabase.IsChecked() )
return;
// prefer "native" or "JDBC"
if ( bHasMySQLNative )
m_aRB_NATIVEDatabase.Check();
else
m_aRB_JDBCDatabase.Check();
}
// -----------------------------------------------------------------------
void OMySQLIntroPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
{
}
// -----------------------------------------------------------------------
void OMySQLIntroPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
{
}
// -----------------------------------------------------------------------
sal_Bool OMySQLIntroPageSetup::FillItemSet(SfxItemSet& /*_rSet*/)
{
OSL_ENSURE(sal_False,"Who called me?! Please ask oj for more information.");
return sal_True;
}
OMySQLIntroPageSetup::ConnectionType OMySQLIntroPageSetup::getMySQLMode()
{
if (m_aRB_JDBCDatabase.IsChecked())
return VIA_JDBC;
else if (m_aRB_NATIVEDatabase.IsChecked())
return VIA_NATIVE;
else
return VIA_ODBC;
}
// =======================================================================
// = MySQLNativeSetupPage
// =======================================================================
// -----------------------------------------------------------------------
MySQLNativeSetupPage::MySQLNativeSetupPage( Window* _pParent, const SfxItemSet& _rCoreAttrs )
:OGenericAdministrationPage( _pParent, ModuleRes( PAGE_DBWIZARD_MYSQL_NATIVE ), _rCoreAttrs )
,m_aHeader ( this, ModuleRes( FT_SETUP_WIZARD_HEADER ) )
,m_aHelpText ( this, ModuleRes( FT_SETUP_WIZARD_HELP ) )
,m_aMySQLSettings ( *this, getControlModifiedLink() )
{
SetControlFontWeight( &m_aHeader );
LayoutHelper::positionBelow( m_aHelpText, m_aMySQLSettings, UnrelatedControls, 0 );
m_aMySQLSettings.Show();
SetRoadmapStateValue(sal_False);
FreeResource();
}
// -----------------------------------------------------------------------
OGenericAdministrationPage* MySQLNativeSetupPage::Create( Window* pParent, const SfxItemSet& _rAttrSet )
{
return new MySQLNativeSetupPage( pParent, _rAttrSet );
}
// -----------------------------------------------------------------------
void MySQLNativeSetupPage::fillControls( ::std::vector< ISaveValueWrapper* >& _rControlList )
{
m_aMySQLSettings.fillControls( _rControlList );
}
// -----------------------------------------------------------------------
void MySQLNativeSetupPage::fillWindows( ::std::vector< ISaveValueWrapper* >& _rControlList )
{
_rControlList.push_back( new ODisableWrapper< FixedText >( &m_aHelpText ) );
m_aMySQLSettings.fillWindows( _rControlList );
}
// -----------------------------------------------------------------------
sal_Bool MySQLNativeSetupPage::FillItemSet( SfxItemSet& _rSet )
{
return m_aMySQLSettings.FillItemSet( _rSet );
}
// -----------------------------------------------------------------------
void MySQLNativeSetupPage::implInitControls( const SfxItemSet& _rSet, sal_Bool _bSaveValue )
{
m_aMySQLSettings.implInitControls( _rSet );
OGenericAdministrationPage::implInitControls( _rSet, _bSaveValue );
OnModified( NULL );
}
// -----------------------------------------------------------------------
Link MySQLNativeSetupPage::getControlModifiedLink()
{
return LINK( this, MySQLNativeSetupPage, OnModified );
}
// -----------------------------------------------------------------------
IMPL_LINK( MySQLNativeSetupPage, OnModified, Edit*, _pEdit )
{
SetRoadmapStateValue( m_aMySQLSettings.canAdvance() );
return OGenericAdministrationPage::getControlModifiedLink().Call( _pEdit );
}
//========================================================================
//= OMySQLJDBCConnectionPageSetup
//========================================================================
OGeneralSpecialJDBCConnectionPageSetup::OGeneralSpecialJDBCConnectionPageSetup( Window* pParent,sal_uInt16 _nResId, const SfxItemSet& _rCoreAttrs ,sal_uInt16 _nPortId, sal_uInt16 _nDefaultPortResId, sal_uInt16 _nHelpTextResId, sal_uInt16 _nHeaderTextResId, sal_uInt16 _nDriverClassId)
:OGenericAdministrationPage(pParent, ModuleRes(_nResId), _rCoreAttrs)
,m_aFTHelpText (this, ModuleRes(FT_AUTOWIZARDHELPTEXT))
,m_aFTDatabasename (this, ModuleRes(FT_AUTODATABASENAME))
,m_aETDatabasename (this, ModuleRes(ET_AUTODATABASENAME))
,m_aFTHostname (this, ModuleRes(FT_AUTOHOSTNAME))
,m_aETHostname (this, ModuleRes(ET_AUTOHOSTNAME))
,m_aFTPortNumber (this, ModuleRes(FT_AUTOPORTNUMBER))
,m_aFTDefaultPortNumber (this, ModuleRes(FT_AUTOPORTNUMBERDEFAULT))
,m_aNFPortNumber (this, ModuleRes(NF_AUTOPORTNUMBER))
,m_aFTDriverClass (this, ModuleRes(FT_AUTOJDBCDRIVERCLASS))
,m_aETDriverClass (this, ModuleRes(ET_AUTOJDBCDRIVERCLASS))
,m_aPBTestJavaDriver (this, ModuleRes(PB_AUTOTESTDRIVERCLASS))
,m_nPortId(_nPortId)
{
m_aFTDriverClass.SetText(String(ModuleRes(_nDriverClassId)));
m_aFTDefaultPortNumber.SetText(String(ModuleRes(_nDefaultPortResId)));
String sHelpText = String(ModuleRes(_nHelpTextResId));
m_aFTHelpText.SetText(sHelpText);
//TODO this code snippet is redundant
SetHeaderText(FT_AUTOWIZARDHEADER, _nHeaderTextResId);
m_aETDatabasename.SetModifyHdl(getControlModifiedLink());
m_aETHostname.SetModifyHdl(getControlModifiedLink());
m_aNFPortNumber.SetModifyHdl(getControlModifiedLink());
m_aETDriverClass.SetModifyHdl(LINK(this, OGeneralSpecialJDBCConnectionPageSetup, OnEditModified));
m_aPBTestJavaDriver.SetClickHdl(LINK(this,OGeneralSpecialJDBCConnectionPageSetup,OnTestJavaClickHdl));
SFX_ITEMSET_GET(_rCoreAttrs, pUrlItem, SfxStringItem, DSID_CONNECTURL, sal_True);
SFX_ITEMSET_GET(_rCoreAttrs, pTypesItem, DbuTypeCollectionItem, DSID_TYPECOLLECTION, sal_True);
::dbaccess::ODsnTypeCollection* pTypeCollection = pTypesItem ? pTypesItem->getCollection() : NULL;
if (pTypeCollection && pUrlItem && pUrlItem->GetValue().Len() )
{
m_sDefaultJdbcDriverName = pTypeCollection->getJavaDriverClass(pUrlItem->GetValue());
}
SetRoadmapStateValue(sal_False);
FreeResource();
}
// -----------------------------------------------------------------------
OGenericAdministrationPage* OGeneralSpecialJDBCConnectionPageSetup::CreateMySQLJDBCTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OGeneralSpecialJDBCConnectionPageSetup( pParent,
PAGE_DBWIZARD_MYSQL_JDBC,
_rAttrSet,
DSID_MYSQL_PORTNUMBER ,
STR_MYSQL_DEFAULT,
STR_MYSQLJDBC_HELPTEXT,
STR_MYSQLJDBC_HEADERTEXT,
STR_MYSQL_DRIVERCLASSTEXT) );
}
// -----------------------------------------------------------------------
OGenericAdministrationPage* OGeneralSpecialJDBCConnectionPageSetup::CreateOracleJDBCTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OGeneralSpecialJDBCConnectionPageSetup( pParent,
PAGE_DBWIZARD_ORACLE,
_rAttrSet,
DSID_ORACLE_PORTNUMBER,
STR_ORACLE_DEFAULT,
STR_ORACLE_HELPTEXT,
STR_ORACLE_HEADERTEXT,
STR_ORACLE_DRIVERCLASSTEXT) );
}
// -----------------------------------------------------------------------
void OGeneralSpecialJDBCConnectionPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETDatabasename));
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETDriverClass));
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETHostname));
_rControlList.push_back(new OSaveValueWrapper<NumericField>(&m_aNFPortNumber));
}
// -----------------------------------------------------------------------
void OGeneralSpecialJDBCConnectionPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTHelpText));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDatabasename));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTHostname));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTPortNumber));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDefaultPortNumber));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDriverClass));
}
// -----------------------------------------------------------------------
sal_Bool OGeneralSpecialJDBCConnectionPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = sal_False;
fillString(_rSet,&m_aETDriverClass,DSID_JDBCDRIVERCLASS,bChangedSomething);
fillString(_rSet,&m_aETHostname,DSID_CONN_HOSTNAME,bChangedSomething);
fillString(_rSet,&m_aETDatabasename,DSID_DATABASENAME,bChangedSomething);
fillInt32(_rSet,&m_aNFPortNumber,m_nPortId,bChangedSomething );
return bChangedSomething;
}
// -----------------------------------------------------------------------
void OGeneralSpecialJDBCConnectionPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
// check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
sal_Bool bValid, bReadonly;
getFlags(_rSet, bValid, bReadonly);
SFX_ITEMSET_GET(_rSet, pDatabaseName, SfxStringItem, DSID_DATABASENAME, sal_True);
SFX_ITEMSET_GET(_rSet, pDrvItem, SfxStringItem, DSID_JDBCDRIVERCLASS, sal_True);
SFX_ITEMSET_GET(_rSet, pHostName, SfxStringItem, DSID_CONN_HOSTNAME, sal_True);
SFX_ITEMSET_GET(_rSet, pPortNumber, SfxInt32Item, m_nPortId, sal_True);
if ( bValid )
{
m_aETDatabasename.SetText(pDatabaseName->GetValue());
m_aETDatabasename.ClearModifyFlag();
m_aETDriverClass.SetText(pDrvItem->GetValue());
m_aETDriverClass.ClearModifyFlag();
m_aETHostname.SetText(pHostName->GetValue());
m_aETHostname.ClearModifyFlag();
m_aNFPortNumber.SetValue(pPortNumber->GetValue());
m_aNFPortNumber.ClearModifyFlag();
}
OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
// to get the correct value when saveValue was called by base class
if ( !m_aETDriverClass.GetText().Len() )
{
m_aETDriverClass.SetText(m_sDefaultJdbcDriverName);
m_aETDriverClass.SetModifyFlag();
}
callModifiedHdl();
sal_Bool bRoadmapState = ((m_aETDatabasename.GetText().Len() != 0 ) && ( m_aETHostname.GetText().Len() != 0 ) && (m_aNFPortNumber.GetText().Len() != 0 ) && ( m_aETDriverClass.GetText().Len() != 0 ));
SetRoadmapStateValue(bRoadmapState);
}
// -----------------------------------------------------------------------
IMPL_LINK(OGeneralSpecialJDBCConnectionPageSetup, OnTestJavaClickHdl, PushButton*, /*_pButton*/)
{
OSL_ENSURE(m_pAdminDialog,"No Admin dialog set! ->GPF");
sal_Bool bSuccess = sal_False;
try
{
if ( m_aETDriverClass.GetText().Len() )
{
// TODO chage jvmaccess
::rtl::Reference< jvmaccess::VirtualMachine > xJVM = ::connectivity::getJavaVM(m_pAdminDialog->getORB());
bSuccess = ::connectivity::existsJavaClassByName(xJVM,m_aETDriverClass.GetText());
}
}
catch(::com::sun::star::uno::Exception&)
{
}
sal_uInt16 nMessage = bSuccess ? STR_JDBCDRIVER_SUCCESS : STR_JDBCDRIVER_NO_SUCCESS;
OSQLMessageBox aMsg( this, String( ModuleRes( nMessage ) ), String() );
aMsg.Execute();
return 0L;
}
// -----------------------------------------------------------------------
IMPL_LINK(OGeneralSpecialJDBCConnectionPageSetup, OnEditModified, Edit*, _pEdit)
{
if ( _pEdit == &m_aETDriverClass )
m_aPBTestJavaDriver.Enable( m_aETDriverClass.GetText().Len() != 0 );
sal_Bool bRoadmapState = ((m_aETDatabasename.GetText().Len() != 0 ) && ( m_aETHostname.GetText().Len() != 0 ) && (m_aNFPortNumber.GetText().Len() != 0 ) && ( m_aETDriverClass.GetText().Len() != 0 ));
SetRoadmapStateValue(bRoadmapState);
callModifiedHdl();
return 0L;
}
// -----------------------------------------------------------------------
OGenericAdministrationPage* OJDBCConnectionPageSetup::CreateJDBCTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OJDBCConnectionPageSetup( pParent, _rAttrSet));
}
//========================================================================
//= OMySQLJDBCConnectionPageSetup
//========================================================================
OJDBCConnectionPageSetup::OJDBCConnectionPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs)
:OConnectionTabPageSetup(pParent, PAGE_DBWIZARD_JDBC, _rCoreAttrs, STR_JDBC_HELPTEXT, STR_JDBC_HEADERTEXT, STR_COMMONURL)
,m_aFTDriverClass (this, ModuleRes(FT_AUTOJDBCDRIVERCLASS))
,m_aETDriverClass (this, ModuleRes(ET_AUTOJDBCDRIVERCLASS))
,m_aPBTestJavaDriver (this, ModuleRes(PB_AUTOTESTDRIVERCLASS))
{
m_aETDriverClass.SetModifyHdl(LINK(this, OJDBCConnectionPageSetup, OnEditModified));
m_aPBTestJavaDriver.SetClickHdl(LINK(this,OJDBCConnectionPageSetup,OnTestJavaClickHdl));
FreeResource();
}
// -----------------------------------------------------------------------
void OJDBCConnectionPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETDriverClass));
}
// -----------------------------------------------------------------------
void OJDBCConnectionPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTDriverClass));
}
// -----------------------------------------------------------------------
sal_Bool OJDBCConnectionPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = OConnectionTabPageSetup::FillItemSet(_rSet);
fillString(_rSet,&m_aETDriverClass,DSID_JDBCDRIVERCLASS,bChangedSomething);
return bChangedSomething;
}
// -----------------------------------------------------------------------
void OJDBCConnectionPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
// check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
sal_Bool bValid, bReadonly;
getFlags(_rSet, bValid, bReadonly);
SFX_ITEMSET_GET(_rSet, pDrvItem, SfxStringItem, DSID_JDBCDRIVERCLASS, sal_True);
if ( bValid )
{
if ( !pDrvItem->GetValue().Len() )
{
String sDefaultJdbcDriverName = m_pCollection->getJavaDriverClass(m_eType);
if ( sDefaultJdbcDriverName.Len() )
{
m_aETDriverClass.SetText(sDefaultJdbcDriverName);
m_aETDriverClass.SetModifyFlag();
} // if ( sDefaultJdbcDriverName.Len() )
} // if ( !pJdbcDrvItem->GetValue().Len() )
else
{
m_aETDriverClass.SetText(pDrvItem->GetValue());
m_aETDriverClass.ClearModifyFlag();
}
}
sal_Bool bEnable = pDrvItem->GetValue().Len() != 0;
m_aPBTestJavaDriver.Enable(bEnable);
OConnectionTabPageSetup::implInitControls(_rSet, _bSaveValue);
SetRoadmapStateValue(checkTestConnection());
}
bool OJDBCConnectionPageSetup::checkTestConnection()
{
OSL_ENSURE(m_pAdminDialog,"No Admin dialog set! ->GPF");
sal_Bool bEnableTestConnection = !m_aConnectionURL.IsVisible() || (m_aConnectionURL.GetTextNoPrefix().Len() != 0);
bEnableTestConnection = bEnableTestConnection && (m_aETDriverClass.GetText().Len() != 0);
return bEnableTestConnection;
// m_aTestConnection.Enable(bEnableTestConnection);
}
// -----------------------------------------------------------------------
IMPL_LINK(OJDBCConnectionPageSetup, OnTestJavaClickHdl, PushButton*, /*_pButton*/)
{
OSL_ENSURE(m_pAdminDialog,"No Admin dialog set! ->GPF");
sal_Bool bSuccess = sal_False;
try
{
if ( m_aETDriverClass.GetText().Len() )
{
// TODO chage jvmaccess
::rtl::Reference< jvmaccess::VirtualMachine > xJVM = ::connectivity::getJavaVM(m_pAdminDialog->getORB());
bSuccess = xJVM.is() && ::connectivity::existsJavaClassByName(xJVM,m_aETDriverClass.GetText());
}
}
catch(::com::sun::star::uno::Exception&)
{
}
sal_uInt16 nMessage = bSuccess ? STR_JDBCDRIVER_SUCCESS : STR_JDBCDRIVER_NO_SUCCESS;
OSQLMessageBox aMsg( this, String( ModuleRes( nMessage ) ), String() );
aMsg.Execute();
return 0L;
}
// -----------------------------------------------------------------------
IMPL_LINK(OJDBCConnectionPageSetup, OnEditModified, Edit*, _pEdit)
{
if ( _pEdit == &m_aETDriverClass )
m_aPBTestJavaDriver.Enable( m_aETDriverClass.GetText().Len() != 0 );
SetRoadmapStateValue(checkTestConnection());
// tell the listener we were modified
callModifiedHdl();
return 0L;
}
OGenericAdministrationPage* OSpreadSheetConnectionPageSetup::CreateSpreadSheetTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OSpreadSheetConnectionPageSetup( pParent, _rAttrSet ) );
}
DBG_NAME(OSpreadSheetConnectionPageSetup)
OSpreadSheetConnectionPageSetup::OSpreadSheetConnectionPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OConnectionTabPageSetup(pParent, PAGE_DBWIZARD_SPREADSHEET, _rCoreAttrs, STR_SPREADSHEET_HELPTEXT, STR_SPREADSHEET_HEADERTEXT, STR_SPREADSHEETPATH)
, m_aCBPasswordrequired(this, ModuleRes(CB_SPREADSHEETPASSWORDREQUIRED))
{
DBG_CTOR(OSpreadSheetConnectionPageSetup,NULL);
m_aCBPasswordrequired.SetToggleHdl(getControlModifiedLink());
FreeResource();
}
// -----------------------------------------------------------------------
OSpreadSheetConnectionPageSetup::~OSpreadSheetConnectionPageSetup()
{
DBG_DTOR(OSpreadSheetConnectionPageSetup,NULL);
}
void OSpreadSheetConnectionPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& /*_rControlList*/)
{
}
// -----------------------------------------------------------------------
void OSpreadSheetConnectionPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
OConnectionTabPageSetup::fillControls(_rControlList);
_rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aCBPasswordrequired));
}
// -----------------------------------------------------------------------
void OSpreadSheetConnectionPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool _bSaveValue)
{
OConnectionTabPageSetup::implInitControls(_rSet, _bSaveValue);
}
// -----------------------------------------------------------------------
sal_Bool OSpreadSheetConnectionPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = OConnectionTabPageSetup::FillItemSet(_rSet);
fillBool(_rSet,&m_aCBPasswordrequired,DSID_PASSWORDREQUIRED,bChangedSomething);
return bChangedSomething;
}
OGenericAdministrationPage* OAuthentificationPageSetup::CreateAuthentificationTabPage( Window* pParent, const SfxItemSet& _rAttrSet )
{
return ( new OAuthentificationPageSetup( pParent, _rAttrSet) );
}
DBG_NAME(OAuthentificationPageSetup)
OAuthentificationPageSetup::OAuthentificationPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OGenericAdministrationPage(pParent, ModuleRes(PAGE_DBWIZARD_AUTHENTIFICATION), _rCoreAttrs )
, m_aFTHelpText (this, ModuleRes(FT_AUTHENTIFICATIONHELPTEXT))
, m_aFTHeaderText (this, ModuleRes(FT_AUTHENTIFICATIONHEADERTEXT))
, m_aFTUserName (this, ModuleRes(FT_GENERALUSERNAME))
, m_aETUserName (this, ModuleRes(ET_GENERALUSERNAME))
, m_aCBPasswordRequired (this, ModuleRes(CB_GENERALPASSWORDREQUIRED))
, m_aPBTestConnection (this, ModuleRes(PB_TESTCONNECTION))
{
DBG_CTOR(OAuthentificationPageSetup,NULL);
SetControlFontWeight(&m_aFTHeaderText);
m_aETUserName.SetModifyHdl(getControlModifiedLink());
m_aCBPasswordRequired.SetClickHdl(getControlModifiedLink());
m_aPBTestConnection.SetClickHdl(LINK(this,OGenericAdministrationPage,OnTestConnectionClickHdl));
FreeResource();
LayoutHelper::fitSizeRightAligned( m_aPBTestConnection );
}
// -----------------------------------------------------------------------
OAuthentificationPageSetup::~OAuthentificationPageSetup()
{
DBG_DTOR(OAuthentificationPageSetup,NULL);
}
void OAuthentificationPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTHelpText));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTUserName));
_rControlList.push_back(new ODisableWrapper<PushButton>(&m_aPBTestConnection));
}
// -----------------------------------------------------------------------
void OAuthentificationPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new OSaveValueWrapper<Edit>(&m_aETUserName));
_rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aCBPasswordRequired));
}
// -----------------------------------------------------------------------
void OAuthentificationPageSetup::implInitControls(const SfxItemSet& _rSet, sal_Bool /*_bSaveValue*/)
{
// check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
sal_Bool bValid, bReadonly;
getFlags(_rSet, bValid, bReadonly);
SFX_ITEMSET_GET(_rSet, pUidItem, SfxStringItem, DSID_USER, sal_True);
SFX_ITEMSET_GET(_rSet, pAllowEmptyPwd, SfxBoolItem, DSID_PASSWORDREQUIRED, sal_True);
m_aETUserName.SetText(pUidItem->GetValue());
m_aCBPasswordRequired.Check(pAllowEmptyPwd->GetValue());
m_aETUserName.ClearModifyFlag();
}
// -----------------------------------------------------------------------
sal_Bool OAuthentificationPageSetup::FillItemSet( SfxItemSet& _rSet )
{
sal_Bool bChangedSomething = sal_False;
if (m_aETUserName.GetText() != m_aETUserName.GetSavedValue())
{
_rSet.Put(SfxStringItem(DSID_USER, m_aETUserName.GetText()));
_rSet.Put(SfxStringItem(DSID_PASSWORD, String()));
bChangedSomething = sal_True;
}
fillBool(_rSet,&m_aCBPasswordRequired,DSID_PASSWORDREQUIRED,bChangedSomething);
return bChangedSomething;
}
OGenericAdministrationPage* OFinalDBPageSetup::CreateFinalDBTabPageSetup( Window* pParent, const SfxItemSet& _rAttrSet)
{
return ( new OFinalDBPageSetup( pParent, _rAttrSet) );
}
DBG_NAME(OFinalDBPageSetup)
OFinalDBPageSetup::OFinalDBPageSetup( Window* pParent, const SfxItemSet& _rCoreAttrs )
:OGenericAdministrationPage(pParent, ModuleRes(PAGE_DBWIZARD_FINAL), _rCoreAttrs )
, m_aFTFinalHeader (this, ModuleRes(FT_FINALHEADER))
, m_aFTFinalHelpText (this, ModuleRes(FT_FINALHELPTEXT))
, m_aRBRegisterDataSource (this, ModuleRes(RB_REGISTERDATASOURCE))
, m_aRBDontregisterDataSource (this, ModuleRes(RB_DONTREGISTERDATASOURCE))
, m_aFTAdditionalSettings (this, ModuleRes(FT_ADDITIONALSETTINGS))
, m_aCBOpenAfterwards (this, ModuleRes(CB_OPENAFTERWARDS))
, m_aCBStartTableWizard (this, ModuleRes(CB_STARTTABLEWIZARD))
, m_aFTFinalText (this, ModuleRes(FT_FINALTEXT))
{
DBG_CTOR(OFinalDBPageSetup,NULL);
String stext = m_aFTFinalHeader.GetText();
SetControlFontWeight(&m_aFTFinalHeader);
m_aCBOpenAfterwards.SetClickHdl(LINK(this, OFinalDBPageSetup, OnOpenSelected));
m_aCBStartTableWizard.SetClickHdl(getControlModifiedLink());
m_aRBRegisterDataSource.SetState(sal_True);
FreeResource();
sal_Int32 nUnrelatedHeight = LogicToPixel( Size( 0, UNRELATED_CONTROLS ), MAP_APPFONT ).Height();
sal_Int32 nRelatedHeight = LogicToPixel( Size( 0, RELATED_CONTROLS ), MAP_APPFONT ).Height();
::std::pair<Window*,sal_Int32> pWindows[] = {
::std::pair<Window*,sal_Int32>(&m_aFTFinalHelpText,nRelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aRBRegisterDataSource,nRelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aRBDontregisterDataSource,nUnrelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aFTAdditionalSettings,nRelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aCBOpenAfterwards,nRelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aCBStartTableWizard,nUnrelatedHeight)
,::std::pair<Window*,sal_Int32>(&m_aFTFinalText,nUnrelatedHeight)
};
Point aPos(m_aFTFinalHeader.GetPosPixel());
Size aStart(m_aFTFinalHeader.GetSizePixel());
aPos.Y() += aStart.Height() + nUnrelatedHeight;
sal_Int32 nCount = sizeof(pWindows) / sizeof(pWindows[0]);
for (sal_Int32 i=0; i < nCount; ++i)
{
aPos.X() = pWindows[i].first->GetPosPixel().X();
Size aSize = pWindows[i].first->GetSizePixel();
FixedText* pText = dynamic_cast<FixedText*>(pWindows[i].first);
if ( pText )
aSize = pText->CalcMinimumSize(aSize.Width());
pWindows[i].first->SetPosSizePixel(aPos,aSize);
aPos.Y() += aSize.Height() + pWindows[i].second;
}
}
// -----------------------------------------------------------------------
OFinalDBPageSetup::~OFinalDBPageSetup()
{
DBG_DTOR(OFinalDBPageSetup,NULL);
}
sal_Bool OFinalDBPageSetup::IsDatabaseDocumentToBeRegistered()
{
return m_aRBRegisterDataSource.IsChecked() && m_aRBRegisterDataSource.IsEnabled();
}
sal_Bool OFinalDBPageSetup::IsDatabaseDocumentToBeOpened()
{
return m_aCBOpenAfterwards.IsChecked() && m_aCBOpenAfterwards.IsEnabled();
}
sal_Bool OFinalDBPageSetup::IsTableWizardToBeStarted()
{
return m_aCBStartTableWizard.IsChecked() && m_aCBStartTableWizard.IsEnabled();
}
void OFinalDBPageSetup::fillWindows(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTFinalHeader));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTFinalHelpText));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTAdditionalSettings));
_rControlList.push_back(new ODisableWrapper<FixedText>(&m_aFTFinalText));
}
// -----------------------------------------------------------------------
void OFinalDBPageSetup::fillControls(::std::vector< ISaveValueWrapper* >& _rControlList)
{
_rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aCBOpenAfterwards));
_rControlList.push_back(new OSaveValueWrapper<CheckBox>(&m_aCBStartTableWizard));
_rControlList.push_back(new OSaveValueWrapper<RadioButton>(&m_aRBRegisterDataSource));
_rControlList.push_back(new OSaveValueWrapper<RadioButton>(&m_aRBDontregisterDataSource));
}
// -----------------------------------------------------------------------
void OFinalDBPageSetup::implInitControls(const SfxItemSet& /*_rSet*/, sal_Bool /*_bSaveValue*/)
{
m_aCBOpenAfterwards.Check();
}
void OFinalDBPageSetup::enableTableWizardCheckBox( sal_Bool _bSupportsTableCreation)
{
m_aCBStartTableWizard.Enable(_bSupportsTableCreation);
}
// -----------------------------------------------------------------------
sal_Bool OFinalDBPageSetup::FillItemSet( SfxItemSet& /*_rSet*/ )
{
return sal_True;
}
// -----------------------------------------------------------------------------
IMPL_LINK(OFinalDBPageSetup, OnOpenSelected, CheckBox*, _pBox)
{
m_aCBStartTableWizard.Enable( _pBox->IsEnabled() && _pBox->IsChecked() );
callModifiedHdl();
// outta here
return 0L;
}
//.........................................................................
}
// namespace dbaui
//.........................................................................