| 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.prodevelop.cit.gvsig.vectorialdb.wizard;

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 java.util.Arrays;

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.Driver;

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.gdbms.engine.data.driver.AlphanumericDBDriver;

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.DBException;

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

import com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams;

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

/**

 * Lets the user input the connection parameters.

 *

 * @author jldominguez

 *

 */

public class DBConnectionParamsDialog extends JPanel implements IWindow,

    ActionListener, KeyListener {

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

    private WindowInfo winfo = new WindowInfo(WindowInfo.MODALDIALOG); // 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 dbLabelWarning = 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;

    // private JLabel schemaLabel = null;

    // private JTextField schemaTextField = null;

    // private JCheckBox schemaCheck = null;

    /**

     * This method initializes

     *

     */

    public DBConnectionParamsDialog() {

        super();

        initialize();

    }

    public void showDialog() {

        PluginServices.getMDIManager().addWindow(this);

    }

    /**

     * This method initializes this

     *

     */

    private void initialize() {

        winfo.setWidth(370);

        winfo.setHeight(317 );

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

        this.setSize(new java.awt.Dimension(360, 329+25));

        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, 292+25, 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, 292+25, 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, 247+25, 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, 222+25, 141, 21));

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

            userLabel = new JLabel();

            userLabel.setBounds(new java.awt.Rectangle(10, 197+25, 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") +

                ":");

            // schemaLabel = new JLabel();

            // schemaLabel.setBounds(new java.awt.Rectangle(10, 130+25, 141,

            // 21));

            // schemaLabel.setText(PluginServices.getText(this, "Schema") +

            // ":");

            dbLabelWarning = new JLabel();

            dbLabelWarning.setBounds(new java.awt.Rectangle(10, 155+25, 310, 41));

            dbLabelWarning.setText(PluginServices.getText(this, "warning_you_must_input_the_exact_name_this_difference_between_capital_letters_and_small_letters")

                );

            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, 273+25));

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

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

                    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(schemaLabel, null);

// paramsPanel.add(getSchemaField(), null);

            paramsPanel.add(dbLabelWarning, 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;

    }

    // private JTextField getSchemaField() {

    // if (schemaTextField == null) {

    // schemaTextField = new JTextField();

    // schemaTextField.addKeyListener(this);

    // schemaTextField.setBounds(new java.awt.Rectangle(155, 130+25, 166, 21));

    // }

    //

    // return schemaTextField;

    // }

        /**

     * This method initializes driverComboBox

     *

     * @return javax.swing.JComboBox

     */

    private JComboBox getDriverComboBox() {

        if (driverComboBox == null) {

            driverComboBox = new JComboBox();

            driverComboBox.setMaximumRowCount(20);

            driverComboBox.addActionListener(this);

            String[] drvName = getDriverNames();

            int len = drvName.length;

            String[] sorted = new String[len];

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

                    sorted[i] = "" + drvName[i];

            }

            Arrays.sort(sorted);

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

                driverComboBox.addItem(sorted[ (i + (2*len-2)) % len]);

            }

            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, 197+25, 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, 222+25, 166, 21));

        }

        return passwordField;

    }

    private String[] getDriverNames() {

        Class[] classes = new Class[] {

                        IVectorialDatabaseDriver.class,

                        AlphanumericDBDriver.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]);

                    continue;

                }

            }

        }

        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();

            Driver _drv;

            try {

                _drv = LayerFactory.getDM().getDriver(driverName);

                if (_drv instanceof IVectorialDatabaseDriver) {

                        IVectorialDatabaseDriver geo_drv = (IVectorialDatabaseDriver) _drv;

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

                } else {

                    if (_drv instanceof AlphanumericDBDriver) {

                            AlphanumericDBDriver alpha_drv = (AlphanumericDBDriver) _drv;

                            portTextField.setText(alpha_drv.getDefaultPort());

                    } else {

                            portTextField.setText("");

                    }

                }

            } 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, 247+25, 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(ConnectionWithParams 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 (DBException e) {

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

            connected = false;

        }

        getConnectedCheckBox().setSelected(connected);

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

        // if (cwp.getSchema() != null) {

        // getSchemaField().setText(cwp.getSchema());

        // }

    }

    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;

            }

        }

    }

        public Object getWindowProfile() {

                return WindowInfo.DIALOG_PROFILE;

        }

        public String getConnectionSchema() {

        // return this.schemaTextField.getText();

        return "";

        }

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

// [eiel-gestion-conexiones]