/* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * 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 . */ package com.sun.star.wizards.table; import java.util.HashMap; import com.sun.star.awt.TextEvent; import com.sun.star.awt.VclWindowPeerAttribute; import com.sun.star.awt.XTextListener; import com.sun.star.beans.PropertyValue; import com.sun.star.lang.XInitialization; import com.sun.star.lang.XMultiServiceFactory; import com.sun.star.sdb.CommandType; import com.sun.star.sdb.application.DatabaseObject; import com.sun.star.sdbc.SQLException; import com.sun.star.task.XJobExecutor; import com.sun.star.uno.UnoRuntime; import com.sun.star.wizards.common.*; import com.sun.star.wizards.db.DatabaseObjectWizard; import com.sun.star.wizards.db.TableDescriptor; import com.sun.star.wizards.ui.*; public class TableWizard extends DatabaseObjectWizard implements XTextListener { private static String slblFields; private static String slblSelFields; private Finalizer curFinalizer; private ScenarioSelector curScenarioSelector; private FieldFormatter curFieldFormatter; private PrimaryKeyHandler curPrimaryKeyHandler; HashMap fielditems; private int wizardmode; private String tablename; private String serrToManyFields; private String serrTableNameexists; private String scomposedtablename; private TableDescriptor curTableDescriptor; public static final int SOMAINPAGE = 1; public static final int SOFIELDSFORMATPAGE = 2; public static final int SOPRIMARYKEYPAGE = 3; public static final int SOFINALPAGE = 4; private String sMsgColumnAlreadyExists = PropertyNames.EMPTY_STRING; private String m_tableName; public TableWizard( XMultiServiceFactory xMSF, PropertyValue[] i_wizardContext ) { super( xMSF, 41200, i_wizardContext ); super.addResourceHandler(); String sTitle = m_oResource.getResText("RID_TABLE_1"); Helper.setUnoPropertyValues(xDialogModel, new String[] { PropertyNames.PROPERTY_HEIGHT, PropertyNames.PROPERTY_MOVEABLE, PropertyNames.PROPERTY_NAME, PropertyNames.PROPERTY_POSITION_X, PropertyNames.PROPERTY_POSITION_Y, PropertyNames.PROPERTY_STEP, PropertyNames.PROPERTY_TABINDEX, PropertyNames.PROPERTY_TITLE, PropertyNames.PROPERTY_WIDTH }, new Object[] { 218, Boolean.TRUE, "DialogTable", 102, 41, 1, Short.valueOf((short) 0), sTitle, 330 }); drawNaviBar(); fielditems = new HashMap(); //TODO if reportResources cannot be gotten dispose officedocument if (getTableResources()) { setRightPaneHeaders(m_oResource, "RID_TABLE_", 8, 4); } } @Override protected void leaveStep(int nOldStep, int nNewStep) { switch (nOldStep) { case SOMAINPAGE: curScenarioSelector.addColumnsToDescriptor(); break; case SOFIELDSFORMATPAGE: curFieldFormatter.updateColumnofColumnDescriptor(); String[] sfieldnames = curFieldFormatter.getFieldNames(); super.setStepEnabled(SOFIELDSFORMATPAGE, sfieldnames.length > 0); curScenarioSelector.setSelectedFieldNames(sfieldnames); break; case SOPRIMARYKEYPAGE: break; case SOFINALPAGE: break; default: break; } } @Override protected void enterStep(int nOldStep, int nNewStep) { switch (nNewStep) { case SOMAINPAGE: break; case SOFIELDSFORMATPAGE: curFieldFormatter.initialize(curTableDescriptor, this.curScenarioSelector.getSelectedFieldNames()); break; case SOPRIMARYKEYPAGE: curPrimaryKeyHandler.initialize(); break; case SOFINALPAGE: curFinalizer.initialize(curScenarioSelector.getFirstTableName()); break; default: break; } } private boolean iscompleted(int _ndialogpage) { switch (_ndialogpage) { case SOMAINPAGE: return curScenarioSelector.iscompleted(); case SOFIELDSFORMATPAGE: return this.curFieldFormatter.iscompleted(); case SOPRIMARYKEYPAGE: if (curPrimaryKeyHandler != null) { return this.curPrimaryKeyHandler.iscompleted(); } case SOFINALPAGE: return this.curFinalizer.iscompleted(); default: return false; } } public void setcompleted(int _ndialogpage, boolean _biscompleted) { boolean bScenarioiscompleted = _biscompleted; boolean bPrimaryKeysiscompleted = _biscompleted; boolean bFinalPageiscompleted = _biscompleted; if (_ndialogpage == SOMAINPAGE) { curFinalizer.initialize(curScenarioSelector.getFirstTableName()); } else { bScenarioiscompleted = iscompleted(SOMAINPAGE); } if (_ndialogpage != TableWizard.SOPRIMARYKEYPAGE && (this.curPrimaryKeyHandler != null)) { bPrimaryKeysiscompleted = iscompleted(SOPRIMARYKEYPAGE); } if (_ndialogpage != TableWizard.SOFINALPAGE) { bFinalPageiscompleted = iscompleted(SOFINALPAGE); // Basically the finalpage is always enabled } if (bScenarioiscompleted) { super.setStepEnabled(SOFIELDSFORMATPAGE, true); super.setStepEnabled(SOPRIMARYKEYPAGE, true); if (bPrimaryKeysiscompleted) { super.enablefromStep(SOFINALPAGE, true); super.enableFinishButton(bFinalPageiscompleted); } else { super.enablefromStep(SOFINALPAGE, false); enableNextButton(false); } } else if (_ndialogpage == SOFIELDSFORMATPAGE) { super.enablefromStep(super.getCurrentStep() + 1, iscompleted(SOFIELDSFORMATPAGE)); } else { super.enablefromStep(super.getCurrentStep() + 1, false); } } /* public static void main(String args[]) { String ConnectStr = "uno:socket,host=localhost,port=8100;urp,negotiate=0,forcesynchronous=1;StarOffice.NamingService"; PropertyValue[] curproperties = null; try { XMultiServiceFactory xLocMSF = com.sun.star.wizards.common.Desktop.connect(ConnectStr); TableWizard CurTableWizard = new TableWizard(xLocMSF); if (xLocMSF != null) { System.out.println("Connected to " + ConnectStr); curproperties = new PropertyValue[1]; curproperties[0] = Properties.createProperty("DataSourceName", "Bibliography"); //curproperties[0] = Properties.createProperty("DatabaseLocation", "file:///path/to/database.odb"); CurTableWizard.startTableWizard(xLocMSF, curproperties); } } catch (Exception exception) { exception.printStackTrace(System.err); } } */ private void buildSteps() { curScenarioSelector = new ScenarioSelector(this, this.curTableDescriptor, slblFields, slblSelFields); curFieldFormatter = new FieldFormatter(this); if ( this.curTableDescriptor.supportsPrimaryKeys() ) { curPrimaryKeyHandler = new PrimaryKeyHandler(this, curTableDescriptor); } curFinalizer = new Finalizer(this, curTableDescriptor); enableNavigationButtons(false, false, false); } private boolean createTable() { boolean bIsSuccessful = true; boolean bTableCreated = false; String schemaname = curFinalizer.getSchemaName(); String catalogname = curFinalizer.getCatalogName(); if (curTableDescriptor.supportsPrimaryKeys()) { String[] keyfieldnames = curPrimaryKeyHandler.getPrimaryKeyFields(); if (keyfieldnames != null && keyfieldnames.length > 0) { boolean bIsAutoIncrement = curPrimaryKeyHandler.isAutoIncremented(); bIsSuccessful = curTableDescriptor.createTable(catalogname, schemaname, tablename, keyfieldnames, bIsAutoIncrement); bTableCreated = true; } } if (!bTableCreated) { bIsSuccessful = curTableDescriptor.createTable(catalogname, schemaname, tablename); } if ((!bIsSuccessful) && (curPrimaryKeyHandler.isAutomaticMode())) { curTableDescriptor.dropColumnbyName(curPrimaryKeyHandler.getAutomaticFieldName()); } return bIsSuccessful; } @Override public boolean finishWizard() { super.switchToStep(super.getCurrentStep(), SOFINALPAGE); tablename = curFinalizer.getTableName(curScenarioSelector.getFirstTableName()); scomposedtablename = curFinalizer.getComposedTableName(tablename); if (this.curTableDescriptor.isSQL92CheckEnabled()) { Desktop.removeSpecialCharacters(curTableDescriptor.xMSF, Configuration.getLocale(this.curTableDescriptor.xMSF), tablename); } if ( tablename.length() > 0 ) { if (!curTableDescriptor.hasTableByName(scomposedtablename)) { wizardmode = curFinalizer.finish(); if (createTable()) { final boolean editTableDesign = (wizardmode == Finalizer.MODIFYTABLEMODE ); loadSubComponent( DatabaseObject.TABLE, curTableDescriptor.getComposedTableName(), editTableDesign ); m_tableName = curTableDescriptor.getComposedTableName(); super.xDialog.endExecute(); return true; } } else { String smessage = JavaTools.replaceSubString(serrTableNameexists, tablename, "%TABLENAME"); super.showMessageBox("WarningBox", com.sun.star.awt.VclWindowPeerAttribute.OK, smessage); curFinalizer.setFocusToTableNameControl(); } } return false; } private void callFormWizard() { try { Object oFormWizard = this.xMSF.createInstance("com.sun.star.wizards.form.CallFormWizard"); NamedValueCollection wizardContext = new NamedValueCollection(); wizardContext.put( PropertyNames.ACTIVE_CONNECTION, curTableDescriptor.DBConnection ); wizardContext.put( "DataSource", curTableDescriptor.getDataSource() ); wizardContext.put( PropertyNames.COMMAND_TYPE, CommandType.TABLE ); wizardContext.put( PropertyNames.COMMAND, scomposedtablename ); wizardContext.put( "DocumentUI", m_docUI ); XInitialization xInitialization = UnoRuntime.queryInterface( XInitialization.class, oFormWizard ); xInitialization.initialize( wizardContext.getPropertyValues() ); XJobExecutor xJobExecutor = UnoRuntime.queryInterface( XJobExecutor.class, oFormWizard ); xJobExecutor.trigger(PropertyNames.START); } catch (Exception e) { e.printStackTrace(System.err); } } @Override public void cancelWizard() { xDialog.endExecute(); } private void insertFormRelatedSteps() { addRoadmap(); int i = 0; i = insertRoadmapItem(0, true, m_oResource.getResText("RID_TABLE_2"), SOMAINPAGE); i = insertRoadmapItem(i, false, m_oResource.getResText("RID_TABLE_3"), SOFIELDSFORMATPAGE); if (this.curTableDescriptor.supportsPrimaryKeys()) { i = insertRoadmapItem(i, false, m_oResource.getResText("RID_TABLE_4"), SOPRIMARYKEYPAGE); } i = insertRoadmapItem(i, false, m_oResource.getResText("RID_TABLE_5"), SOFINALPAGE); // Orderby is always supported setRoadmapInteractive(true); setRoadmapComplete(true); setCurrentRoadmapItemID((short) 1); } public String startTableWizard( ) { try { curTableDescriptor = new TableDescriptor(xMSF, super.xWindow, this.sMsgColumnAlreadyExists); if ( curTableDescriptor.getConnection( m_wizardContext ) ) { buildSteps(); createWindowPeer(); curTableDescriptor.setWindowPeer(this.xControl.getPeer()); insertFormRelatedSteps(); short RetValue = executeDialog(); xComponent.dispose(); if ( RetValue == 0 ) { if ( wizardmode == Finalizer.STARTFORMWIZARDMODE ) callFormWizard(); return m_tableName; } } } catch (java.lang.Exception jexception) { jexception.printStackTrace(System.err); } return PropertyNames.EMPTY_STRING; } private boolean getTableResources() { super.m_oResource.getResText("RID_TABLE_1"); slblFields = m_oResource.getResText("RID_TABLE_19"); slblSelFields = m_oResource.getResText("RID_TABLE_25"); serrToManyFields = m_oResource.getResText("RID_TABLE_47"); serrTableNameexists = m_oResource.getResText("RID_TABLE_48"); sMsgColumnAlreadyExists = m_oResource.getResText("RID_TABLE_51"); return true; } public boolean verifyfieldcount(int _icount) { try { int maxfieldcount = curTableDescriptor.getMaxColumnsInTable(); if (_icount >= (maxfieldcount - 1)) { // keep one column as reserve for the automatically created key String smessage = serrToManyFields; smessage = JavaTools.replaceSubString(smessage, String.valueOf(maxfieldcount), "%COUNT"); showMessageBox("ErrorBox", VclWindowPeerAttribute.OK, smessage); return false; } } catch (SQLException e) { e.printStackTrace(System.err); } return true; } /* (non-Javadoc) * @see com.sun.star.awt.XTextListener#textChanged(com.sun.star.awt.TextEvent) */ public void textChanged(TextEvent aTextEvent) { if (this.curTableDescriptor.isSQL92CheckEnabled()) { Object otextcomponent = UnoDialog.getModel(aTextEvent.Source); String sName = (String) Helper.getUnoPropertyValue(otextcomponent, "Text"); sName = Desktop.removeSpecialCharacters(curTableDescriptor.xMSF, Configuration.getLocale(curTableDescriptor.xMSF), sName); Helper.setUnoPropertyValue(otextcomponent, "Text", sName); } } }