| gvSIG desktop 1

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde;

import java.sql.SQLException;

import java.util.ArrayList;

import javax.swing.JOptionPane;

import org.apache.log4j.Logger;

import com.iver.andami.PluginServices;

import com.iver.andami.plugins.Extension;

import com.iver.cit.gvsig.sde.gui.sdewizard2.ConnectionSettings;

import com.iver.cit.gvsig.sde.gui.sdewizard2.ConnectionWithParamsSDE;

import com.iver.cit.gvsig.sde.gui.sdewizard2.SDEConnectionManagerDialog;

import com.iver.cit.gvsig.sde.gui.sdewizard2.SingleSDEConnectionManager;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

/**

 * This extension allows the user to access the single connection manager dialog.

 *

 * @see com.iver.cit.gvsig.fmap.drivers.jdbc.utils.SingleJDBCConnectionManager

 *

 * @author jldominguez

 *

 */

public class SingleSDEConnectionExtension extends Extension {

    private static Logger logger = Logger.getLogger(SingleSDEConnectionExtension.class.getName());

    /**

     * This method simply loads the connections stored in gvSIG's persistence file

     * as closed connections

     */

    public void initialize() {

        loadPersistenceConnections();

    }

    /**

     * The only command available is the one to open the connection manager

     * dialog ("GESTOR_SDE")

     */

    public void execute(String actionCommand) {

        if (actionCommand.compareToIgnoreCase("GESTOR_SDE") == 0) {

            SDEConnectionManagerDialog dlg = new SDEConnectionManagerDialog();

            dlg.showDialog();

            saveAllToPersistence();

            return;

        }

    }

	public boolean isEnabled() {

		return true;

	}

	public boolean isVisible() {

		return true;

	}

    private void saveAllToPersistence() {

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        xml.remove("sde-connections");

        ConnectionWithParamsSDE[] all = SingleSDEConnectionManager.instance()

                                                                .getAllConnections();

        if (all == null) {

            return;

        }

        for (int i = 0; i < all.length; i++) {

            addToPersistence(all[i]);

        }

    }

    private void addToPersistence(ConnectionWithParamsSDE cwp) {

        if (cwp == null) {

            return;

        }

        ConnectionSettings _cs = new ConnectionSettings();

        _cs.setHost(cwp.getHost());

        _cs.setPort(cwp.getPort());

        _cs.setDb(cwp.getDb());

        _cs.setDriver(cwp.getDrvName());

        _cs.setUser(cwp.getUser());

        _cs.setName(cwp.getName());

        String newstr = _cs.toString();

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        String[] old = null;

        if (xml.contains("sde-connections")) {

            old = xml.getStringArrayProperty("sde-connections");

        }

        ArrayList oldl = stringArrayToArrayList(old);

        oldl.add(newstr);

        String[] newarr = (String[]) oldl.toArray(new String[0]);

        xml.remove("sde-connections");

        xml.putProperty("sde-connections", newarr);

        PluginServices.getPluginServices(this).setPersistentXML(xml);

    }

    private ArrayList stringArrayToArrayList(String[] arr) {

        ArrayList resp = new ArrayList();

        if ((arr != null) && (arr.length > 0)) {

            for (int i = 0; i < arr.length; i++) {

                resp.add(arr[i]);

            }

        }

        return resp;

    }

    private void loadPersistenceConnections() {

        XMLEntity xml = PluginServices.getPluginServices(this).getPersistentXML();

        if (xml == null) {

            xml = new XMLEntity();

        }

        if (!xml.contains("sde-connections")) {

            String[] servers = new String[0];

            xml.putProperty("sde-connections", servers);

        }

        // add drivers to connection manager

        String[] servers = null;

        try {

            servers = xml.getStringArrayProperty("sde-connections");

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects sde-connections: " +

                e.getMessage());

            return;

        }

        for (int i = 0; i < servers.length; i++) {

            ConnectionSettings cs = new ConnectionSettings();

            boolean params_ok = true;

            try {

            	cs.setFromString(servers[i]);

            } catch (Exception ex) {

            	logger.error("Found misconfigured connection: " + servers[i]);

            	params_ok = false;

            }

            if (params_ok) addDisconnected(cs);

        }

    }

    private void addDisconnected(ConnectionSettings _cs) {

        try {

            SingleSDEConnectionManager.instance()

                                       .getConnection(_cs.getDriver(),

                _cs.getUser(), null, _cs.getName(), _cs.getHost(),

                _cs.getPort(), _cs.getDb(), false);

        }

        catch (SQLException e) {

            System.err.println("While getting connection: " + e.getMessage());

            showConnectionErrorMessage(e.getMessage());

        }

    }

    private void showConnectionErrorMessage(String _msg) {

        String msg = (_msg.length() > 300) ? "" : (": " + _msg);

        String title = PluginServices.getText(this, "connection_error");

        JOptionPane.showMessageDialog(null, title + msg, title,

            JOptionPane.ERROR_MESSAGE);

    }

 public void terminate() {

        SingleSDEConnectionManager.instance().closeAllBeforeTerminate();

    }

}

 *

 *

 *

 *

 *

 *

 *

 *

/**

 * SDE Extension.

 *

 * @author Vicente Caballero Navarro

 */

public class ExtSDE extends Extension {

    public void initialize() {

        System.out.println("A?ado Wizard SDE.");

        AddLayer.addWizard(com.iver.cit.gvsig.sde.gui.sdewizard2.WizardSDE.class);

    }

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import java.awt.Component;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import javax.swing.JList;

import javax.swing.JOptionPane;

import javax.swing.ListCellRenderer;

import javax.swing.ListSelectionModel;

import javax.swing.UIManager;

import javax.swing.border.Border;

import javax.swing.border.EmptyBorder;

import org.apache.log4j.Logger;

import com.iver.andami.PluginServices;

/**

 * Utility class to keep the list of available tables.

 *

 * @author jldominguez

 *

 */

public class AvailableTablesCheckBoxList extends JList {

    protected static Border noFocusBorder = new EmptyBorder(1, 1, 1, 1);

    private static Logger logger = Logger.getLogger(AvailableTablesCheckBoxList.class.getName());

    private WizardSDE parent = null;

    private TablesListItem actingTable = null;

    public AvailableTablesCheckBoxList(WizardSDE p) {

        parent = p;

        setCellRenderer(new CellRenderer());

        addMouseListener(new MouseAdapter() {

                public void mousePressed(MouseEvent e) {

                    int index = locationToIndex(e.getPoint());

                    if (index == -1) {

                        return;

                    }

                    actingTable = (TablesListItem) getModel().getElementAt(index);

                    if ((e.getClickCount() == 2) || (e.getX() < 15)) {

                        if (!actingTable.isActivated()) {

                            actingTable.activate();

                        }

                        actingTable.setSelected(!actingTable.isSelected());

                        if (actingTable.isSelected()) {

                            actingTable.setEnabledPanels(true);

                        }

                        else {

                            actingTable.setEnabledPanels(false);

                        }

                        repaint();

                    }

                    try {

                        parent.setSettingsPanels(actingTable);

                        parent.checkFinishable();

                    }

                    catch (Exception e1) {

                        actingTable.setEnabledPanels(false);

                        actingTable.setSelected(false);

                        logger.error("While setting selected table: " +

                            e1.getMessage(), e1);

                        showConnectionErrorMessage(e1.getMessage());

                    }

                }

            });

        setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

    }

    private void showConnectionErrorMessage(String _msg) {

        String msg = (_msg.length() > 300) ? "" : (": " + _msg);

        String title = PluginServices.getText(this, "connection_error");

        JOptionPane.showMessageDialog(this, title + msg, title,

            JOptionPane.ERROR_MESSAGE);

    }

    protected class CellRenderer implements ListCellRenderer {

        public Component getListCellRendererComponent(JList list, Object value,

            int index, boolean isSelected, boolean cellHasFocus) {

            TablesListItem checkbox = (TablesListItem) value;

            checkbox.setBackground(isSelected ? getSelectionBackground()

                                              : getBackground());

            checkbox.setForeground(isSelected ? getSelectionForeground()

                                              : getForeground());

            checkbox.setEnabled(isEnabled());

            checkbox.setFont(getFont());

            checkbox.setFocusPainted(false);

            checkbox.setBorderPainted(true);

            checkbox.setBorder(isSelected

                ? UIManager.getBorder("List.focusCellHighlightBorder")

                : noFocusBorder);

            return checkbox;

        }

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import java.awt.Color;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.KeyEvent;

import java.awt.event.KeyListener;

import java.util.ArrayList;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JTextField;

import org.apache.log4j.Logger;

import com.hardcode.driverManager.DriverLoadException;

import com.iver.andami.PluginServices;

import com.iver.andami.ui.mdiManager.IWindow;

import com.iver.andami.ui.mdiManager.WindowInfo;

import com.iver.cit.gvsig.fmap.drivers.sde.VectorialSDEDriver;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

/**

 * Lets the user input the connection parameters.

 *

 * @author jldominguez

 *

 */

public class SDEConnectionParamsDialog extends JPanel implements IWindow,

    ActionListener, KeyListener {

    private static Logger logger = Logger.getLogger(SDEConnectionParamsDialog.class.getName());

    private WindowInfo winfo = new WindowInfo(8); // MODAL only

    private JButton cancelButton = null;

    private JButton okButton = null;

    private JPanel paramsPanel = null;

    private JComboBox driverComboBox = null;

    private JTextField portTextField = null;

    private JTextField dbTextField = null;

    private JTextField userTextField = null;

    private JPasswordField passwordField = null;

    private JLabel driverLabel = null;

    private JLabel portLabel = null;

    private JLabel dbLabel = null;

    private JLabel userLabel = null;

    private JLabel pwLabel = null;

    private boolean okPressed = false;

    private JTextField urlTextField = null;

    private JLabel urlLabel = null;

    private JCheckBox connectedCheckBox = null;

    private JLabel connectedLabel = null;

    private JLabel connNameLabel = null;

    private JTextField connNameTextField = null;

    /**

     * This method initializes

     *

     */

    public SDEConnectionParamsDialog() {

        super();

        initialize();

    }

    public void showDialog() {

        PluginServices.getMDIManager().addWindow(this);

    }

    /**

     * This method initializes this

     *

     */

    private void initialize() {

        winfo.setWidth(370);

        winfo.setHeight(275 - 25);

        winfo.setTitle(PluginServices.getText(this, "connection_parameters"));

        this.setSize(new java.awt.Dimension(360, 287));

        this.setLayout(null);

        this.add(getCancelButton(), null);

        this.add(getOkButton(), null);

        this.add(getParamsPanel(), null);

    }

    public WindowInfo getWindowInfo() {

        return winfo;

    }

    /**

     * This method initializes cancelButton

     *

     * @return javax.swing.JButton

     */

    private JButton getCancelButton() {

        if (cancelButton == null) {

            cancelButton = new JButton();

            cancelButton.setText(PluginServices.getText(this, "cancel"));

            cancelButton.addActionListener(this);

            cancelButton.setBounds(new java.awt.Rectangle(185, 250, 106, 26));

        }

        return cancelButton;

    }

    /**

     * This method initializes okButton

     *

     * @return javax.swing.JButton

     */

    private JButton getOkButton() {

        if (okButton == null) {

            okButton = new JButton();

            okButton.setText(PluginServices.getText(this, "ok"));

            okButton.addActionListener(this);

            okButton.setBounds(new java.awt.Rectangle(70, 250, 106, 26));

        }

        return okButton;

    }

    /**

     * This method initializes paramsPanel

     *

     * @return javax.swing.JPanel

     */

    private JPanel getParamsPanel() {

        if (paramsPanel == null) {

            connNameLabel = new JLabel();

            connNameLabel.setBounds(new java.awt.Rectangle(10, 30, 141, 21));

            connNameLabel.setText(PluginServices.getText(this, "connection_name") +

                ":");

            connectedLabel = new JLabel();

            connectedLabel.setBounds(new java.awt.Rectangle(10, 205, 141, 21));

            connectedLabel.setText(PluginServices.getText(this, "connected") +

                ":");

            urlLabel = new JLabel();

            urlLabel.setBounds(new java.awt.Rectangle(10, 80, 141, 21));

            urlLabel.setText(PluginServices.getText(this, "server_url") + ":");

            pwLabel = new JLabel();

            pwLabel.setBounds(new java.awt.Rectangle(10, 180, 141, 21));

            pwLabel.setText(PluginServices.getText(this, "password") + ":");

            userLabel = new JLabel();

            userLabel.setBounds(new java.awt.Rectangle(10, 155, 141, 21));

            userLabel.setText(PluginServices.getText(this, "user") + ":");

            dbLabel = new JLabel();

            dbLabel.setBounds(new java.awt.Rectangle(10, 130, 141, 21));

            dbLabel.setText(PluginServices.getText(this, "database_name") +

                ":");

            portLabel = new JLabel();

            portLabel.setBounds(new java.awt.Rectangle(10, 105, 141, 21));

            portLabel.setText(PluginServices.getText(this, "port") + ":");

            driverLabel = new JLabel();

            driverLabel.setBounds(new java.awt.Rectangle(10, 55, 141, 21));

            driverLabel.setText(PluginServices.getText(this, "driver") + ":");

            paramsPanel = new JPanel();

            paramsPanel.setBounds(new java.awt.Rectangle(10, 10, 336, 231));

            paramsPanel.setBorder(javax.swing.BorderFactory.createTitledBorder(

                    null, PluginServices.getText(this, "connection_params"),

                    javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

                    javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

            paramsPanel.setLayout(null);

            paramsPanel.add(getPortTextField(), null);

            paramsPanel.add(getDriverComboBox(), null);

            paramsPanel.add(getDbTextField(), null);

            paramsPanel.add(getUserTextField(), null);

            paramsPanel.add(getPasswordField(), null);

            paramsPanel.add(driverLabel, null);

            paramsPanel.add(portLabel, null);

            paramsPanel.add(dbLabel, null);

            paramsPanel.add(userLabel, null);

            paramsPanel.add(pwLabel, null);

            paramsPanel.add(getUrlTextArea(), null);

            paramsPanel.add(urlLabel, null);

            paramsPanel.add(getConnectedCheckBox(), null);

            paramsPanel.add(connectedLabel, null);

            paramsPanel.add(connNameLabel, null);

            paramsPanel.add(getConnNameTextField(), null);

        }

        return paramsPanel;

    }

    /**

     * This method initializes driverComboBox

     *

     * @return javax.swing.JComboBox

     */

    private JComboBox getDriverComboBox() {

        if (driverComboBox == null) {

            driverComboBox = new JComboBox();

            driverComboBox.addActionListener(this);

            String[] drvName = getDriverNames();

            for (int i = 0; i < drvName.length; i++)

                driverComboBox.addItem(drvName[i]);

            driverComboBox.setBounds(new java.awt.Rectangle(155, 55, 166, 21));

        }

        return driverComboBox;

    }

    /**

     * This method initializes portTextField

     *

     * @return javax.swing.JTextField

     */

    private JTextField getPortTextField() {

        if (portTextField == null) {

            portTextField = new JTextField();

            portTextField.addKeyListener(this);

            portTextField.setBounds(new java.awt.Rectangle(155, 105, 166, 21));

        }

        return portTextField;

    }

    /**

     * This method initializes dbTextField

     *

     * @return javax.swing.JTextField

     */

    private JTextField getDbTextField() {

        if (dbTextField == null) {

            dbTextField = new JTextField();

            dbTextField.addKeyListener(this);

            dbTextField.setBounds(new java.awt.Rectangle(155, 130, 166, 21));

        }

        return dbTextField;

    }

    /**

     * This method initializes userTextField

     *

     * @return javax.swing.JTextField

     */

    private JTextField getUserTextField() {

        if (userTextField == null) {

            userTextField = new JTextField();

            userTextField.addKeyListener(this);

            userTextField.setBounds(new java.awt.Rectangle(155, 155, 166, 21));

        }

        return userTextField;

    }

    /**

     * This method initializes passwordField

     *

     * @return javax.swing.JPasswordField

     */

    private JPasswordField getPasswordField() {

        if (passwordField == null) {

            passwordField = new JPasswordField();

            passwordField.addKeyListener(this);

            passwordField.setBounds(new java.awt.Rectangle(155, 180, 166, 21));

        }

        return passwordField;

    }

    private String[] getDriverNames() {

        Class[] classes = new Class[] { VectorialSDEDriver.class };

        ArrayList ret = new ArrayList();

        String[] driverNames = LayerFactory.getDM().getDriverNames();

        for (int i = 0; i < driverNames.length; i++) {

            for (int j = 0; j < classes.length; j++) {

                if (LayerFactory.getDM().isA(driverNames[i], classes[j])) {

                    ret.add(driverNames[i]);

                }

            }

        }

        return (String[]) ret.toArray(new String[0]);

    }

    public void actionPerformed(ActionEvent arg0) {

        Object src = arg0.getSource();

        if (src == connectedCheckBox) {

            if (connectedCheckBox.isSelected()) {

                passwordField.setEnabled(true);

                passwordField.setBackground(Color.WHITE);

            }

            else {

                passwordField.setText("");

                passwordField.setEnabled(false);

                passwordField.setBackground(Color.LIGHT_GRAY);

            }

        }

        if (src == okButton) {

            okPressed = true;

            PluginServices.getMDIManager().closeWindow(this);

            return;

        }

        if (src == cancelButton) {

            okPressed = false;

            PluginServices.getMDIManager().closeWindow(this);

            return;

        }

        if (src == driverComboBox) {

            String driverName = driverComboBox.getSelectedItem().toString();

            VectorialSDEDriver driver;

            try {

                driver = (VectorialSDEDriver) LayerFactory.getDM()

                                                           .getDriver(driverName);

                portTextField.setText("" + driver.getDefaultPort());

            }

            catch (DriverLoadException e1) {

                portTextField.setText("");

            }

            return;

        }

    }

    public boolean isOkPressed() {

        return okPressed;

    }

    public boolean hasToBeConnected() {

        return connectedCheckBox.isSelected();

    }

    public String getConnectionDriverName() {

        return driverComboBox.getSelectedItem().toString();

    }

    public String getConnectionServerUrl() {

        return urlTextField.getText();

    }

    public String getConnectionPort() {

        return portTextField.getText();

    }

    public String getConnectionDBName() {

        return dbTextField.getText();

    }

    public String getConnectionUser() {

        return userTextField.getText();

    }

    public String getConnectionPassword() {

        String resp = new String(passwordField.getPassword());

        return resp;

    }

    private JTextField getUrlTextArea() {

        if (urlTextField == null) {

            urlTextField = new JTextField();

            urlTextField.addKeyListener(this);

            urlTextField.setBounds(new java.awt.Rectangle(155, 80, 166, 21));

        }

        return urlTextField;

    }

    /**

     * This method initializes connectedCheckBox

     *

     * @return javax.swing.JCheckBox

     */

    private JCheckBox getConnectedCheckBox() {

        if (connectedCheckBox == null) {

            connectedCheckBox = new JCheckBox();

            connectedCheckBox.setSelected(true);

            connectedCheckBox.addActionListener(this);

            connectedCheckBox.setBounds(new java.awt.Rectangle(155, 205, 26, 21));

        }

        return connectedCheckBox;

    }

    public String getConnectionName() {

        return getConnNameTextField().getText();

    }

    /**

     * This method initializes connNameTextField

     *

     * @return javax.swing.JTextField

     */

    private JTextField getConnNameTextField() {

        if (connNameTextField == null) {

            connNameTextField = new JTextField();

            connNameTextField.addKeyListener(this);

            connNameTextField.setBounds(new java.awt.Rectangle(155, 30, 166, 21));

        }

        return connNameTextField;

    }

    public void keyPressed(KeyEvent e) {

    }

    public void keyReleased(KeyEvent e) {

        if (e.getKeyChar() != '\n') {

            return;

        }

        Object src = e.getSource();

        if (src == passwordField) {

            ActionEvent aevt = new ActionEvent(okButton,

                    ActionEvent.ACTION_PERFORMED, "");

            actionPerformed(aevt);

        }

        else {

            if (src instanceof JTextField) {

                ((JTextField) src).transferFocus();

            }

        }

    }

    public void keyTyped(KeyEvent e) {

    }

    public void loadValues(ConnectionWithParamsSDE cwp) {

        getPortTextField().setText(cwp.getPort());

        selectThisInDriverCombo(cwp.getDrvName());

        getDbTextField().setText(cwp.getDb());

        getUserTextField().setText(cwp.getUser());

        if (cwp.getPw() == null) {

            getPasswordField().setText("");

        }

        else {

            getPasswordField().setText(cwp.getPw());

        }

        getUrlTextArea().setText(cwp.getHost());

        boolean connected = false;

//        try {

            connected = (cwp.getConnection() != null) &&

                (!cwp.getConnection().isClosed());

//        }

//        catch (SQLException e) {

//            logger.error("While checking connection: " + e.getMessage());

//            connected = false;

//        }

        getConnectedCheckBox().setSelected(connected);

        getConnNameTextField().setText(cwp.getName());

    }

    private void selectThisInDriverCombo(String drvName) {

        int size = getDriverComboBox().getItemCount();

        for (int i = 0; i < size; i++) {

            Object item = getDriverComboBox().getItemAt(i);

            if (item.toString().compareToIgnoreCase(drvName) == 0) {

                getDriverComboBox().setSelectedIndex(i);

                return;

            }

        }

    }

} //  @jve:decl-index=0:visual-constraint="10,10"

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import com.hardcode.driverManager.DriverLoadException;

import com.iver.cit.gvsig.fmap.drivers.DefaultDBDriver;

import com.iver.cit.gvsig.fmap.drivers.VectorialJDBCDriver;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

/**

 *

 * Utility class. Keeps connection parameters.

 *

 * @author jldominguez

 * @author Fernando Gonz?lez Cort?s

 */

public class ConnectionSettings {

    private String host;

    private String port;

    private String db;

    private String driver;

    private String user;

    private String name;

    private String passw = null;

    public String getDb() {

        return db;

    }

    public void setDb(String db) {

        this.db = db;

    }

    public String getDriver() {

        return driver;

    }

    public void setDriver(String driver) {

        this.driver = driver;

    }

    public String getHost() {

        return host;

    }

    public void setHost(String host) {

        this.host = host;

    }

    public String getPort() {

        return port;

    }

    public void setPort(String port) {

        this.port = port;

    }

    public String getUser() {

        return user;

    }

    public void setUser(String user) {

        this.user = user;

    }

    public void setName(String name) {

        this.name = name;

    }

    public String getName() {

        return name;

    }

    public String toString() {

        return host + "," + port + "," + db + "," + driver + "," + user + "," +

        name;

    }

    public void setFromString(String _str) throws Exception {

    	String str = _str;

    	if (str.endsWith(",")) str = str + " ";

    	if (str.startsWith(",")) str = " " + str;

        String[] values = str.split(",");

        host = values[0];

        port = values[1];

        db = values[2];

        driver = values[3];

        user = values[4];

        name = values[5];

        if (values.length == 7) {

            passw = values[6];

        }

    }

    public String getPassw() {

        return passw;

    }

    public void setPassw(String passw) {

        this.passw = passw;

    }

    public String getConnectionString() throws DriverLoadException {

        VectorialJDBCDriver vecDriver = (VectorialJDBCDriver) LayerFactory.getDM()

                                                                          .getDriver(getDriver());

        if (vecDriver instanceof DefaultDBDriver) {

            return ((DefaultDBDriver) vecDriver).getConnectionString(getHost(),

                getPort(), getDb(), getUser(), getPassw());

        }

        String connectionString = vecDriver.getConnectionStringBeginning() +

            "//" + getHost();

        connectionString += (":" + getPort());

        connectionString += ("/" + getDb());

        return connectionString;

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import javax.swing.JCheckBox;

/**

 * Used to instantiate field list items. Shows the database dependent type name.

 *

 * @author jldominguez

 *

 */

public class FieldsListItem extends JCheckBox {

    private String name = "[No name]";

    private String type = "[No type]";

    public FieldsListItem(String _name, String _type) {

        name = _name;

        type = _type;

        setText(toString());

        setSelected(true);

    }

    public String toString() {

        return name + " [" + type + "]";

    }

    public String getName() {

        return name;

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import javax.swing.tree.DefaultMutableTreeNode;

/**

 * Utility class used to manage the connection tree.

 * @author jldominguez

 *

 */

public class SDEConnectionTreeNode extends DefaultMutableTreeNode {

    private String label;

    public SDEConnectionTreeNode(String drvname) {

        label = drvname;

        setAllowsChildren(true);

    }

    public String toString() {

        return label;

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

/**

 * Utility class to deal with combo boxes.

 *

 * @author jldominguez

 *

 */

public class FieldComboItem {

    private String name = "";

    public FieldComboItem(String _name) {

        name = _name;

    }

    public String toString() {

        return name;

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package com.iver.cit.gvsig.sde.gui.sdewizard2;

import java.sql.SQLException;

import javax.swing.JCheckBox;

import com.esri.sde.sdk.client.SeConnection;

import com.esri.sde.sdk.client.SeException;

import com.esri.sde.sdk.client.SeRegisteredColumn;

import com.esri.sde.sdk.client.SeTable;

import com.iver.cit.gvsig.fmap.MapControl;

import com.iver.cit.gvsig.fmap.drivers.sde.VectorialSDEDriver;

/**

 * Utility class that represents a table list item as a selectable check box.