dbaccess/source/ui/dlg/detailpages.cxx

   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 #include <config_java.h>
  21 #include <core_resource.hxx>
  22 #include "detailpages.hxx"
  23 #include <sqlmessage.hxx>
  24 #include <dsmeta.hxx>
  25 #include "advancedsettings.hxx"
  26 #include "DbAdminImpl.hxx"
  27 #include <dsitems.hxx>
  28 #include "dbfindex.hxx"
  29 #include "dsnItem.hxx"
  30
  31 #include <IItemSetHelper.hxx>
  32 #include <strings.hrc>
  33
  34 #include <svl/itemset.hxx>
  35 #include <svl/stritem.hxx>
  36 #include <svl/eitem.hxx>
  37 #include <svl/intitem.hxx>
  38 #if HAVE_FEATURE_JAVA
  39 #include <jvmaccess/virtualmachine.hxx>
  40 #endif
  41 #include <connectivity/CommonTools.hxx>
  42 #include "DriverSettings.hxx"
  43
  44 namespace dbaui
  45 {
  46
  47     using namespace ::com::sun::star::uno;
  48
  49     OCommonBehaviourTabPage::OCommonBehaviourTabPage(weld::Container* pPage, weld::DialogController* pController,
  50         const OUString& rUIXMLDescription, const OUString& rId, const SfxItemSet& rCoreAttrs,
  51         OCommonBehaviourTabPageFlags nControlFlags)
  52         : OGenericAdministrationPage(pPage, pController, rUIXMLDescription, rId, rCoreAttrs)
  53         , m_nControlFlags(nControlFlags)
  54     {
  55         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseOptions)
  56         {
  57             m_xOptionsLabel = m_xBuilder->weld_label(u"optionslabel"_ustr);
  58             m_xOptionsLabel->show();
  59             m_xOptions = m_xBuilder->weld_entry(u"options"_ustr);
  60             m_xOptions->show();
  61             m_xOptions->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
  62         }
  63
  64         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseCharset)
  65         {
  66             m_xDataConvertLabel = m_xBuilder->weld_label(u"charsetheader"_ustr);
  67             m_xDataConvertLabel->show();
  68             m_xCharsetLabel = m_xBuilder->weld_label(u"charsetlabel"_ustr);
  69             m_xCharsetLabel->show();
  70             m_xCharset.reset(new CharSetListBox(m_xBuilder->weld_combo_box(u"charset"_ustr)));
  71             m_xCharset->show();
  72             m_xCharset->connect_changed(LINK(this, OCommonBehaviourTabPage, CharsetSelectHdl));
  73         }
  74     }
  75
  76     IMPL_LINK_NOARG(OCommonBehaviourTabPage, CharsetSelectHdl, weld::ComboBox&, void)
  77     {
  78         callModifiedHdl();
  79     }
  80
  81     OCommonBehaviourTabPage::~OCommonBehaviourTabPage()
  82     {
  83         m_xCharset.reset();
  84     }
  85
  86     void OCommonBehaviourTabPage::fillWindows(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
  87     {
  88         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseOptions)
  89         {
  90             _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xOptionsLabel.get()));
  91         }
  92
  93         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseCharset)
  94         {
  95             _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xCharsetLabel.get()));
  96         }
  97     }
  98
  99     void OCommonBehaviourTabPage::fillControls(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 100     {
 101         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseOptions)
 102             _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::Entry>(m_xOptions.get()));
 103
 104         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseCharset)
 105             _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::ComboBox>(m_xCharset->get_widget()));
 106     }
 107
 108     void OCommonBehaviourTabPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 109     {
 110         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 111         bool bValid, bReadonly;
 112         getFlags(_rSet, bValid, bReadonly);
 113
 114         // collect the items
 115         const SfxStringItem* pOptionsItem = _rSet.GetItem<SfxStringItem>(DSID_ADDITIONALOPTIONS);
 116         const SfxStringItem* pCharsetItem = _rSet.GetItem<SfxStringItem>(DSID_CHARSET);
 117
 118         // forward the values to the controls
 119         if (bValid)
 120         {
 121             if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseOptions)
 122             {
 123                 m_xOptions->set_text(pOptionsItem->GetValue());
 124                 m_xOptions->save_value();
 125             }
 126
 127             if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseCharset)
 128             {
 129                 m_xCharset->SelectEntryByIanaName( pCharsetItem->GetValue() );
 130             }
 131         }
 132         OGenericAdministrationPage::implInitControls(_rSet, _bSaveValue);
 133     }
 134
 135     bool OCommonBehaviourTabPage::FillItemSet(SfxItemSet* _rSet)
 136     {
 137         bool bChangedSomething = false;
 138
 139         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseOptions)
 140         {
 141             fillString(*_rSet,m_xOptions.get(),DSID_ADDITIONALOPTIONS,bChangedSomething);
 142         }
 143
 144         if (m_nControlFlags & OCommonBehaviourTabPageFlags::UseCharset)
 145         {
 146             if ( m_xCharset->StoreSelectedCharSet( *_rSet, DSID_CHARSET ) )
 147                 bChangedSomething = true;
 148         }
 149
 150         return bChangedSomething;
 151     }
 152
 153     // ODbaseDetailsPage
 154     ODbaseDetailsPage::ODbaseDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& _rCoreAttrs)
 155         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/dbasepage.ui"_ustr, u"DbasePage"_ustr,
 156                                     _rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset)
 157         , m_xShowDeleted(m_xBuilder->weld_check_button(u"showDelRowsCheckbutton"_ustr))
 158         , m_xFT_Message(m_xBuilder->weld_label(u"specMessageLabel"_ustr))
 159         , m_xIndexes(m_xBuilder->weld_button(u"indiciesButton"_ustr))
 160     {
 161         m_xIndexes->connect_clicked(LINK(this, ODbaseDetailsPage, OnButtonClicked));
 162         m_xShowDeleted->connect_toggled(LINK(this, ODbaseDetailsPage, OnButtonToggled));
 163     }
 164
 165     ODbaseDetailsPage::~ODbaseDetailsPage()
 166     {
 167     }
 168
 169     std::unique_ptr<SfxTabPage> ODriversSettings::CreateDbase(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet)
 170     {
 171         return std::make_unique<ODbaseDetailsPage>(pPage, pController, *_rAttrSet);
 172     }
 173
 174     void ODbaseDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 175     {
 176         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 177         bool bValid, bReadonly;
 178         getFlags(_rSet, bValid, bReadonly);
 179
 180         // get the DSN string (needed for the index dialog)
 181         const SfxStringItem* pUrlItem = _rSet.GetItem<SfxStringItem>(DSID_CONNECTURL);
 182         const DbuTypeCollectionItem* pTypesItem = _rSet.GetItem<DbuTypeCollectionItem>(DSID_TYPECOLLECTION);
 183         ::dbaccess::ODsnTypeCollection* pTypeCollection = pTypesItem ? pTypesItem->getCollection() : nullptr;
 184         if (pTypeCollection && pUrlItem && pUrlItem->GetValue().getLength())
 185             m_sDsn = pTypeCollection->cutPrefix(pUrlItem->GetValue());
 186
 187         // get the other relevant items
 188         const SfxBoolItem* pDeletedItem = _rSet.GetItem<SfxBoolItem>(DSID_SHOWDELETEDROWS);
 189
 190         if ( bValid )
 191         {
 192             m_xShowDeleted->set_active(pDeletedItem->GetValue());
 193             m_xFT_Message->set_visible(m_xShowDeleted->get_active());
 194         }
 195
 196         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 197     }
 198
 199     bool ODbaseDetailsPage::FillItemSet( SfxItemSet* _rSet )
 200     {
 201         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(_rSet);
 202
 203         fillBool(*_rSet, m_xShowDeleted.get(), DSID_SHOWDELETEDROWS, false, bChangedSomething);
 204         return bChangedSomething;
 205     }
 206
 207     IMPL_LINK_NOARG(ODbaseDetailsPage, OnButtonClicked, weld::Button&, void)
 208     {
 209         ODbaseIndexDialog aIndexDialog(GetFrameWeld(), m_sDsn);
 210         aIndexDialog.run();
 211     }
 212
 213     IMPL_LINK_NOARG(ODbaseDetailsPage, OnButtonToggled, weld::Toggleable&, void)
 214     {
 215         m_xFT_Message->set_visible(m_xShowDeleted->get_active());
 216         // it was the checkbox -> we count as modified from now on
 217         callModifiedHdl();
 218     }
 219
 220
 221     // OAdoDetailsPage
 222     OAdoDetailsPage::OAdoDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 223         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/autocharsetpage.ui"_ustr, u"AutoCharset"_ustr,
 224                                     rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset )
 225     {
 226
 227     }
 228
 229     std::unique_ptr<SfxTabPage> ODriversSettings::CreateAdo(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* rAttrSet)
 230     {
 231         return std::make_unique<OAdoDetailsPage>(pPage, pController, *rAttrSet);
 232     }
 233
 234     // OOdbcDetailsPage
 235     OOdbcDetailsPage::OOdbcDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 236         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/odbcpage.ui"_ustr, u"ODBC"_ustr, rCoreAttrs,
 237                                     OCommonBehaviourTabPageFlags::UseCharset | OCommonBehaviourTabPageFlags::UseOptions)
 238         , m_xUseCatalog(m_xBuilder->weld_check_button(u"useCatalogCheckbutton"_ustr))
 239     {
 240         m_xUseCatalog->connect_toggled(LINK(this, OGenericAdministrationPage, OnControlModifiedButtonClick));
 241     }
 242
 243     OOdbcDetailsPage::~OOdbcDetailsPage()
 244     {
 245     }
 246
 247     std::unique_ptr<SfxTabPage> ODriversSettings::CreateODBC(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* pAttrSet)
 248     {
 249         return std::make_unique<OOdbcDetailsPage>(pPage, pController, *pAttrSet);
 250     }
 251
 252     bool OOdbcDetailsPage::FillItemSet( SfxItemSet* _rSet )
 253     {
 254         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(_rSet);
 255         fillBool(*_rSet,m_xUseCatalog.get(),DSID_USECATALOG,false,bChangedSomething);
 256         return bChangedSomething;
 257     }
 258     void OOdbcDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 259     {
 260         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 261         bool bValid, bReadonly;
 262         getFlags(_rSet, bValid, bReadonly);
 263
 264         const SfxBoolItem* pUseCatalogItem = _rSet.GetItem<SfxBoolItem>(DSID_USECATALOG);
 265
 266         if ( bValid )
 267             m_xUseCatalog->set_active(pUseCatalogItem->GetValue());
 268
 269         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 270     }
 271     // OOdbcDetailsPage
 272     OUserDriverDetailsPage::OUserDriverDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 273         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/userdetailspage.ui"_ustr, u"UserDetailsPage"_ustr,
 274                                     rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset | OCommonBehaviourTabPageFlags::UseOptions)
 275         , m_xFTHostname(m_xBuilder->weld_label(u"hostnameft"_ustr))
 276         , m_xEDHostname(m_xBuilder->weld_entry(u"hostname"_ustr))
 277         , m_xPortNumber(m_xBuilder->weld_label(u"portnumberft"_ustr))
 278         , m_xNFPortNumber(m_xBuilder->weld_spin_button(u"portnumber"_ustr))
 279         , m_xUseCatalog(m_xBuilder->weld_check_button(u"usecatalog"_ustr))
 280     {
 281         m_xUseCatalog->connect_toggled(LINK(this, OGenericAdministrationPage, OnControlModifiedButtonClick));
 282     }
 283
 284     OUserDriverDetailsPage::~OUserDriverDetailsPage()
 285     {
 286     }
 287
 288     std::unique_ptr<SfxTabPage> ODriversSettings::CreateUser(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* pAttrSet)
 289     {
 290         return std::make_unique<OUserDriverDetailsPage>(pPage, pController, *pAttrSet);
 291     }
 292
 293     bool OUserDriverDetailsPage::FillItemSet( SfxItemSet* _rSet )
 294     {
 295         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(_rSet);
 296
 297         fillInt32(*_rSet,m_xNFPortNumber.get(),DSID_CONN_PORTNUMBER,bChangedSomething);
 298         fillString(*_rSet,m_xEDHostname.get(),DSID_CONN_HOSTNAME,bChangedSomething);
 299         fillBool(*_rSet,m_xUseCatalog.get(),DSID_USECATALOG,false,bChangedSomething);
 300
 301         return bChangedSomething;
 302     }
 303     void OUserDriverDetailsPage::fillControls(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 304     {
 305         OCommonBehaviourTabPage::fillControls(_rControlList);
 306         _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::Entry>(m_xEDHostname.get()));
 307         _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::Toggleable>(m_xUseCatalog.get()));
 308         _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::SpinButton>(m_xNFPortNumber.get()));
 309     }
 310     void OUserDriverDetailsPage::fillWindows(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 311     {
 312         OCommonBehaviourTabPage::fillWindows(_rControlList);
 313         _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xFTHostname.get()));
 314         _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xPortNumber.get()));
 315     }
 316     void OUserDriverDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 317     {
 318         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 319         bool bValid, bReadonly;
 320         getFlags(_rSet, bValid, bReadonly);
 321
 322         const SfxBoolItem* pUseCatalogItem = _rSet.GetItem<SfxBoolItem>(DSID_USECATALOG);
 323         const SfxStringItem* pHostName = _rSet.GetItem<SfxStringItem>(DSID_CONN_HOSTNAME);
 324         const SfxInt32Item* pPortNumber = _rSet.GetItem<SfxInt32Item>(DSID_CONN_PORTNUMBER);
 325
 326         if ( bValid )
 327         {
 328             m_xEDHostname->set_text(pHostName->GetValue());
 329             m_xEDHostname->save_value();
 330
 331             m_xNFPortNumber->set_value(pPortNumber->GetValue());
 332             m_xNFPortNumber->save_value();
 333
 334             m_xUseCatalog->set_active(pUseCatalogItem->GetValue());
 335         }
 336
 337         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 338     }
 339     // OMySQLODBCDetailsPage
 340     OMySQLODBCDetailsPage::OMySQLODBCDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 341         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/autocharsetpage.ui"_ustr, u"AutoCharset"_ustr,
 342                                     rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset )
 343     {
 344     }
 345
 346     std::unique_ptr<SfxTabPage> ODriversSettings::CreateMySQLODBC(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* pAttrSet)
 347     {
 348         return std::make_unique<OMySQLODBCDetailsPage>(pPage, pController, *pAttrSet);
 349     }
 350
 351     // OMySQLJDBCDetailsPage
 352     OGeneralSpecialJDBCDetailsPage::OGeneralSpecialJDBCDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs ,sal_uInt16 _nPortId, bool bShowSocket)
 353         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/generalspecialjdbcdetailspage.ui"_ustr, u"GeneralSpecialJDBCDetails"_ustr,
 354                                     rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset)
 355         , m_nPortId(_nPortId)
 356         , m_bUseClass(true)
 357         , m_xEDHostname(m_xBuilder->weld_entry(u"hostNameEntry"_ustr))
 358         , m_xNFPortNumber(m_xBuilder->weld_spin_button(u"portNumberSpinbutton"_ustr))
 359         , m_xFTSocket(m_xBuilder->weld_label(u"socketLabel"_ustr))
 360         , m_xEDSocket(m_xBuilder->weld_entry(u"socketEntry"_ustr))
 361         , m_xFTDriverClass(m_xBuilder->weld_label(u"driverClassLabel"_ustr))
 362         , m_xEDDriverClass(m_xBuilder->weld_entry(u"jdbcDriverClassEntry"_ustr))
 363         , m_xTestJavaDriver(m_xBuilder->weld_button(u"testDriverClassButton"_ustr))
 364     {
 365         const SfxStringItem* pUrlItem = rCoreAttrs.GetItem<SfxStringItem>(DSID_CONNECTURL);
 366         const DbuTypeCollectionItem* pTypesItem = rCoreAttrs.GetItem<DbuTypeCollectionItem>(DSID_TYPECOLLECTION);
 367         ::dbaccess::ODsnTypeCollection* pTypeCollection = pTypesItem ? pTypesItem->getCollection() : nullptr;
 368         if (pTypeCollection && pUrlItem && pUrlItem->GetValue().getLength() )
 369         {
 370             m_sDefaultJdbcDriverName = pTypeCollection->getJavaDriverClass(pUrlItem->GetValue());
 371         }
 372         if ( m_sDefaultJdbcDriverName.getLength() )
 373         {
 374             m_xEDDriverClass->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
 375             m_xTestJavaDriver->connect_clicked(LINK(this,OGeneralSpecialJDBCDetailsPage,OnTestJavaClickHdl));
 376         }
 377         else
 378         {
 379             m_bUseClass = false;
 380             m_xFTDriverClass->hide();
 381             m_xEDDriverClass->hide();
 382             m_xTestJavaDriver->hide();
 383         }
 384
 385         m_xFTSocket->set_visible(bShowSocket && !m_bUseClass);
 386         m_xEDSocket->set_visible(bShowSocket && !m_bUseClass);
 387
 388         m_xEDHostname->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
 389         m_xNFPortNumber->connect_value_changed(LINK(this,OGenericAdministrationPage,OnControlSpinButtonModifyHdl));
 390         m_xEDSocket->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
 391     }
 392
 393     OGeneralSpecialJDBCDetailsPage::~OGeneralSpecialJDBCDetailsPage()
 394     {
 395     }
 396
 397     bool OGeneralSpecialJDBCDetailsPage::FillItemSet( SfxItemSet* _rSet )
 398     {
 399         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(_rSet);
 400         if ( m_bUseClass )
 401             fillString(*_rSet,m_xEDDriverClass.get(),DSID_JDBCDRIVERCLASS,bChangedSomething);
 402         fillString(*_rSet,m_xEDHostname.get(),DSID_CONN_HOSTNAME,bChangedSomething);
 403         fillString(*_rSet,m_xEDSocket.get(),DSID_CONN_SOCKET,bChangedSomething);
 404         fillInt32(*_rSet,m_xNFPortNumber.get(),m_nPortId,bChangedSomething );
 405
 406         return bChangedSomething;
 407     }
 408     void OGeneralSpecialJDBCDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 409     {
 410         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 411         bool bValid, bReadonly;
 412         getFlags(_rSet, bValid, bReadonly);
 413
 414         const SfxStringItem* pDrvItem = _rSet.GetItem<SfxStringItem>(DSID_JDBCDRIVERCLASS);
 415         const SfxStringItem* pHostName = _rSet.GetItem<SfxStringItem>(DSID_CONN_HOSTNAME);
 416         const SfxInt32Item* pPortNumber = _rSet.GetItem<SfxInt32Item>(m_nPortId);
 417         const SfxStringItem* pSocket = _rSet.GetItem<SfxStringItem>(DSID_CONN_SOCKET);
 418
 419         if ( bValid )
 420         {
 421             if ( m_bUseClass )
 422             {
 423                 m_xEDDriverClass->set_text(pDrvItem->GetValue());
 424                 m_xEDDriverClass->save_value();
 425             }
 426
 427             m_xEDHostname->set_text(pHostName->GetValue());
 428             m_xEDHostname->save_value();
 429
 430             m_xNFPortNumber->set_value(pPortNumber->GetValue());
 431             m_xNFPortNumber->save_value();
 432
 433             m_xEDSocket->set_text(pSocket->GetValue());
 434             m_xEDSocket->save_value();
 435         }
 436
 437         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 438
 439         // to get the correct value when saveValue was called by base class
 440         if ( m_bUseClass && o3tl::trim(m_xEDDriverClass->get_text()).empty() )
 441         {
 442             m_xEDDriverClass->set_text(m_sDefaultJdbcDriverName);
 443             m_xEDDriverClass->save_value();
 444         }
 445     }
 446     IMPL_LINK_NOARG(OGeneralSpecialJDBCDetailsPage, OnTestJavaClickHdl, weld::Button&, void)
 447     {
 448         assert(m_pAdminDialog && "No Admin dialog set! ->GPF");
 449         OSL_ENSURE(m_bUseClass,"Who called me?");
 450
 451         bool bSuccess = false;
 452 #if HAVE_FEATURE_JAVA
 453         try
 454         {
 455             if (!o3tl::trim(m_xEDDriverClass->get_text()).empty())
 456             {
 457 // TODO change jvmaccess
 458                 ::rtl::Reference< jvmaccess::VirtualMachine > xJVM = ::connectivity::getJavaVM( m_pAdminDialog->getORB() );
 459                 m_xEDDriverClass->set_text(m_xEDDriverClass->get_text().trim()); // fdo#68341
 460                 bSuccess = ::connectivity::existsJavaClassByName(xJVM,m_xEDDriverClass->get_text());
 461             }
 462         }
 463         catch(Exception&)
 464         {
 465         }
 466 #endif
 467         TranslateId pMessage = bSuccess ? STR_JDBCDRIVER_SUCCESS : STR_JDBCDRIVER_NO_SUCCESS;
 468         const MessageType mt = bSuccess ? MessageType::Info : MessageType::Error;
 469         OSQLMessageBox aMsg(GetFrameWeld(), DBA_RES(pMessage), OUString(), MessBoxStyle::Ok | MessBoxStyle::DefaultOk, mt);
 470         aMsg.run();
 471     }
 472
 473     void OGeneralSpecialJDBCDetailsPage::callModifiedHdl(weld::Widget* pControl)
 474     {
 475         if (m_bUseClass && pControl == m_xEDDriverClass.get())
 476             m_xTestJavaDriver->set_sensitive(!o3tl::trim(m_xEDDriverClass->get_text()).empty());
 477
 478         // tell the listener we were modified
 479         OGenericAdministrationPage::callModifiedHdl();
 480     }
 481
 482     // MySQLNativePage
 483     MySQLNativePage::MySQLNativePage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 484         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/mysqlnativepage.ui"_ustr, u"MysqlNativePage"_ustr, rCoreAttrs, OCommonBehaviourTabPageFlags::UseCharset)
 485         , m_xMySQLSettingsContainer(m_xBuilder->weld_widget(u"MySQLSettingsContainer"_ustr))
 486         , m_xMySQLSettings(new MySQLNativeSettings(m_xMySQLSettingsContainer.get(), LINK(this,OGenericAdministrationPage,OnControlModified)))
 487         , m_xSeparator1(m_xBuilder->weld_label(u"connectionheader"_ustr))
 488         , m_xSeparator2(m_xBuilder->weld_label(u"userheader"_ustr))
 489         , m_xUserNameLabel(m_xBuilder->weld_label(u"usernamelabel"_ustr))
 490         , m_xUserName(m_xBuilder->weld_entry(u"username"_ustr))
 491         , m_xPasswordRequired(m_xBuilder->weld_check_button(u"passwordrequired"_ustr))
 492     {
 493         m_xUserName->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
 494     }
 495
 496     MySQLNativePage::~MySQLNativePage()
 497     {
 498         m_xMySQLSettings.reset();
 499     }
 500
 501     void MySQLNativePage::fillControls(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 502     {
 503         OCommonBehaviourTabPage::fillControls( _rControlList );
 504         m_xMySQLSettings->fillControls( _rControlList );
 505
 506         _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::Entry>(m_xUserName.get()));
 507         _rControlList.emplace_back(new OSaveValueWidgetWrapper<weld::Toggleable>(m_xPasswordRequired.get()));
 508     }
 509
 510     void MySQLNativePage::fillWindows(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 511     {
 512         OCommonBehaviourTabPage::fillWindows( _rControlList );
 513         m_xMySQLSettings->fillWindows( _rControlList);
 514
 515         _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xSeparator1.get()));
 516         _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xSeparator2.get()));
 517         _rControlList.emplace_back(new ODisableWidgetWrapper<weld::Label>(m_xUserNameLabel.get()));
 518     }
 519
 520     bool MySQLNativePage::FillItemSet( SfxItemSet* _rSet )
 521     {
 522         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet( _rSet );
 523
 524         bChangedSomething |= m_xMySQLSettings->FillItemSet( _rSet );
 525
 526         if (m_xUserName->get_value_changed_from_saved())
 527         {
 528             _rSet->Put( SfxStringItem( DSID_USER, m_xUserName->get_text() ) );
 529             _rSet->Put( SfxStringItem( DSID_PASSWORD, OUString()));
 530             bChangedSomething = true;
 531         }
 532         fillBool(*_rSet,m_xPasswordRequired.get(),DSID_PASSWORDREQUIRED,false,bChangedSomething);
 533
 534         return bChangedSomething;
 535     }
 536     void MySQLNativePage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 537     {
 538         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 539         bool bValid, bReadonly;
 540         getFlags(_rSet, bValid, bReadonly);
 541
 542         m_xMySQLSettings->implInitControls( _rSet );
 543
 544         const SfxStringItem* pUidItem = _rSet.GetItem<SfxStringItem>(DSID_USER);
 545         const SfxBoolItem* pAllowEmptyPwd = _rSet.GetItem<SfxBoolItem>(DSID_PASSWORDREQUIRED);
 546
 547         if ( bValid )
 548         {
 549             m_xUserName->set_text(pUidItem->GetValue());
 550             m_xUserName->save_value();
 551             m_xPasswordRequired->set_active(pAllowEmptyPwd->GetValue());
 552         }
 553
 554         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 555     }
 556
 557     std::unique_ptr<SfxTabPage> ODriversSettings::CreateMySQLJDBC( weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet )
 558     {
 559         return std::make_unique<OGeneralSpecialJDBCDetailsPage>(pPage, pController, *_rAttrSet,DSID_MYSQL_PORTNUMBER);
 560     }
 561
 562     std::unique_ptr<SfxTabPage> ODriversSettings::CreateMySQLNATIVE(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* pAttrSet)
 563     {
 564         return std::make_unique<MySQLNativePage>(pPage, pController, *pAttrSet);
 565     }
 566
 567     std::unique_ptr<SfxTabPage> ODriversSettings::CreateOracleJDBC(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet)
 568     {
 569         return std::make_unique<OGeneralSpecialJDBCDetailsPage>(pPage, pController, *_rAttrSet,DSID_ORACLE_PORTNUMBER, false);
 570     }
 571
 572     // OLDAPDetailsPage
 573     OLDAPDetailsPage::OLDAPDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 574         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/ldappage.ui"_ustr, u"LDAP"_ustr,
 575                                     rCoreAttrs, OCommonBehaviourTabPageFlags::NONE)
 576         , m_xETBaseDN(m_xBuilder->weld_entry(u"baseDNEntry"_ustr))
 577         , m_xCBUseSSL(m_xBuilder->weld_check_button(u"useSSLCheckbutton"_ustr))
 578         , m_xNFPortNumber(m_xBuilder->weld_spin_button(u"portNumberSpinbutton"_ustr))
 579         , m_xNFRowCount(m_xBuilder->weld_spin_button(u"LDAPRowCountspinbutton"_ustr))
 580     {
 581         m_xETBaseDN->connect_changed(LINK(this,OGenericAdministrationPage,OnControlEntryModifyHdl));
 582         m_xNFPortNumber->connect_value_changed(LINK(this,OGenericAdministrationPage,OnControlSpinButtonModifyHdl));
 583         m_xNFRowCount->connect_value_changed(LINK(this,OGenericAdministrationPage,OnControlSpinButtonModifyHdl));
 584
 585         m_iNormalPort = 389;
 586         m_iSSLPort    = 636;
 587         m_xCBUseSSL->connect_toggled(LINK(this, OLDAPDetailsPage, OnCheckBoxClick));
 588     }
 589
 590     OLDAPDetailsPage::~OLDAPDetailsPage()
 591     {
 592     }
 593
 594     std::unique_ptr<SfxTabPage> ODriversSettings::CreateLDAP(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet)
 595     {
 596         return std::make_unique<OLDAPDetailsPage>(pPage, pController, *_rAttrSet);
 597     }
 598
 599     bool OLDAPDetailsPage::FillItemSet( SfxItemSet* _rSet )
 600     {
 601         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(_rSet);
 602
 603         fillString(*_rSet,m_xETBaseDN.get(),DSID_CONN_LDAP_BASEDN,bChangedSomething);
 604         fillInt32(*_rSet,m_xNFPortNumber.get(),DSID_CONN_LDAP_PORTNUMBER,bChangedSomething);
 605         fillInt32(*_rSet,m_xNFRowCount.get(),DSID_CONN_LDAP_ROWCOUNT,bChangedSomething);
 606         fillBool(*_rSet,m_xCBUseSSL.get(),DSID_CONN_LDAP_USESSL,false,bChangedSomething);
 607         return bChangedSomething;
 608     }
 609
 610     IMPL_LINK(OLDAPDetailsPage, OnCheckBoxClick, weld::Toggleable&, rCheckBox, void)
 611     {
 612         OnControlModifiedButtonClick(rCheckBox);
 613         callModifiedHdl();
 614         if (m_xCBUseSSL->get_active())
 615         {
 616             m_iNormalPort = m_xNFPortNumber->get_value();
 617             m_xNFPortNumber->set_value(m_iSSLPort);
 618         }
 619         else
 620         {
 621             m_iSSLPort = m_xNFPortNumber->get_value();
 622             m_xNFPortNumber->set_value(m_iNormalPort);
 623         }
 624     }
 625
 626     void OLDAPDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 627     {
 628         // check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 629         bool bValid, bReadonly;
 630         getFlags(_rSet, bValid, bReadonly);
 631
 632         const SfxStringItem* pBaseDN = _rSet.GetItem<SfxStringItem>(DSID_CONN_LDAP_BASEDN);
 633         const SfxBoolItem* pUseSSL = _rSet.GetItem<SfxBoolItem>(DSID_CONN_LDAP_USESSL);
 634         const SfxInt32Item* pPortNumber = _rSet.GetItem<SfxInt32Item>(DSID_CONN_LDAP_PORTNUMBER);
 635         const SfxInt32Item* pRowCount = _rSet.GetItem<SfxInt32Item>(DSID_CONN_LDAP_ROWCOUNT);
 636
 637         if ( bValid )
 638         {
 639             m_xETBaseDN->set_text(pBaseDN->GetValue());
 640             m_xNFPortNumber->set_value(pPortNumber->GetValue());
 641             m_xNFRowCount->set_value(pRowCount->GetValue());
 642             m_xCBUseSSL->set_active(pUseSSL->GetValue());
 643         }
 644
 645         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 646     }
 647
 648     // OTextDetailsPage
 649     OTextDetailsPage::OTextDetailsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet& rCoreAttrs)
 650         : OCommonBehaviourTabPage(pPage, pController, u"dbaccess/ui/emptypage.ui"_ustr, u"EmptyPage"_ustr, rCoreAttrs, OCommonBehaviourTabPageFlags::NONE)
 651         , m_xTextConnectionHelper(new OTextConnectionHelper(m_xContainer.get(), TC_EXTENSION | TC_HEADER | TC_SEPARATORS | TC_CHARSET))
 652     {
 653     }
 654
 655     OTextDetailsPage::~OTextDetailsPage()
 656     {
 657         m_xTextConnectionHelper.reset();
 658     }
 659
 660     std::unique_ptr<SfxTabPage> ODriversSettings::CreateText(weld::Container* pPage, weld::DialogController* pController,  const SfxItemSet* pAttrSet)
 661     {
 662         return std::make_unique<OTextDetailsPage>(pPage, pController, *pAttrSet);
 663     }
 664
 665     void OTextDetailsPage::fillControls(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 666     {
 667         OCommonBehaviourTabPage::fillControls(_rControlList);
 668         m_xTextConnectionHelper->fillControls(_rControlList);
 669
 670     }
 671     void OTextDetailsPage::fillWindows(std::vector< std::unique_ptr<ISaveValueWrapper> >& _rControlList)
 672     {
 673         OCommonBehaviourTabPage::fillWindows(_rControlList);
 674         m_xTextConnectionHelper->fillWindows(_rControlList);
 675
 676     }
 677     void OTextDetailsPage::implInitControls(const SfxItemSet& _rSet, bool _bSaveValue)
 678     {
 679         // first check whether or not the selection is invalid or readonly (invalid implies readonly, but not vice versa)
 680         bool bValid, bReadonly;
 681         getFlags(_rSet, bValid, bReadonly);
 682
 683         m_xTextConnectionHelper->implInitControls(_rSet, bValid);
 684         OCommonBehaviourTabPage::implInitControls(_rSet, _bSaveValue);
 685     }
 686
 687     bool OTextDetailsPage::FillItemSet( SfxItemSet* rSet )
 688     {
 689         bool bChangedSomething = OCommonBehaviourTabPage::FillItemSet(rSet);
 690         bChangedSomething = m_xTextConnectionHelper->FillItemSet(*rSet, bChangedSomething);
 691         return bChangedSomething;
 692     }
 693
 694     bool OTextDetailsPage::prepareLeave()
 695     {
 696         return m_xTextConnectionHelper->prepareLeave();
 697     }
 698
 699     std::unique_ptr<SfxTabPage> ODriversSettings::CreateGeneratedValuesPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet)
 700     {
 701         return std::make_unique<GeneratedValuesPage>(pPage, pController, *_rAttrSet);
 702     }
 703
 704     std::unique_ptr<SfxTabPage> ODriversSettings::CreateSpecialSettingsPage(weld::Container* pPage, weld::DialogController* pController, const SfxItemSet* _rAttrSet)
 705     {
 706         OUString eType = ODbDataSourceAdministrationHelper::getDatasourceType( *_rAttrSet );
 707         DataSourceMetaData aMetaData( eType );
 708         return std::make_unique<SpecialSettingsPage>(pPage, pController, *_rAttrSet, aMetaData);
 709     }
 710 }   // namespace dbaui
 711
 712 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */