| gvSIG desktop 1

import com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard.ConnectionSettings;

package com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

import java.awt.BorderLayout;

import java.awt.FlowLayout;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.util.HashMap;

import java.util.Iterator;

import javax.swing.DefaultComboBoxModel;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JTextField;

import com.hardcode.driverManager.DriverLoadException;

import com.iver.andami.PluginServices;

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

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

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

import com.iver.utiles.swing.JComboBox;

import com.iver.utiles.swing.wizard.Step;

import com.iver.utiles.swing.wizard.WizardControl;

/**

 * DOCUMENT ME!

 *

 * @author Fernando Gonz?lez Cort?s

 */

public class ConnectionPanel extends JPanel implements Step {

    private static String passw = null;

    private JPanel jPanelLabels = null;

    private JLabel jLabel = null;

    private JTextField txtHost = null;

    private JPanel jPanelTexts = null;

    private JTextField txtPort = null;

    private JLabel jLabel1 = null;

    private JLabel jLabel2 = null;

    private JTextField txtUser = null;

    private JLabel jLabel3 = null;

    private JPasswordField txtPassword = null;

    private JLabel jLabel4 = null;

    private JTextField txtBD = null;

    private JLabel jLabel5 = null;

    private JComboBox cmbDriver = null;

    private JLabel jLabel6 = null;

    private com.iver.utiles.swing.JComboBox cmbName = null;

    private HashMap cs = new HashMap();

    private JPanel jPanel = null;

    /**

     * This is the default constructor

     */

    public ConnectionPanel() {

        super();

        initialize();

    }

    /**

     * This method initializes this

     */

    private void initialize() {

        this.setLayout(null);

        this.setSize(335, 240);

        this.add(getJPanel(), null);

        if (passw != null)

            txtPassword.setText(passw);

    }

    /**

     * This method initializes jPanel

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanelLabels() {

        if (jPanelLabels == null) {

            FlowLayout flowLayout3 = new FlowLayout();

            flowLayout3.setVgap(15);

            jLabel5 = new JLabel();

            jLabel4 = new JLabel();

            jLabel3 = new JLabel();

            jLabel2 = new JLabel();

            jLabel1 = new JLabel();

            jLabel = new JLabel();

            jPanelLabels = new JPanel();

            jPanelLabels.setLayout(flowLayout3);

            jPanelLabels.setName("jPanelLabels");

            jPanelLabels.setPreferredSize(new java.awt.Dimension(150,400));

            jLabel.setText(PluginServices.getText(this, "host") + ":");

            jLabel.setPreferredSize(new java.awt.Dimension(140,19));

            jLabel.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel.setName("jLabel");

            jLabel1.setText(PluginServices.getText(this, "puerto")+":");

            jLabel1.setPreferredSize(new java.awt.Dimension(140,19));

            jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.TRAILING);

            jLabel1.setName("jLabel1");

            jLabel2.setText(PluginServices.getText(this, "usuario")+":");

            jLabel2.setName("jLabel2");

            jLabel2.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);

            jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel2.setPreferredSize(new java.awt.Dimension(140,19));

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

            jLabel3.setName("jLabel3");

            jLabel3.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);

            jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel3.setPreferredSize(new java.awt.Dimension(140,19));

            jLabel4.setText(PluginServices.getText(this, "bd")+":");

            jLabel4.setName("jLabel4");

            jLabel4.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);

            jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel4.setPreferredSize(new java.awt.Dimension(140,19));

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

            jLabel5.setName("jLabel5");

            jLabel5.setHorizontalTextPosition(javax.swing.SwingConstants.RIGHT);

            jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel5.setPreferredSize(new java.awt.Dimension(140,19));

            jPanelLabels.add(getJLabel6(), null);

            jPanelLabels.add(jLabel, null);

            jPanelLabels.add(jLabel1, null);

            jPanelLabels.add(jLabel2, null);

            jPanelLabels.add(jLabel3, null);

            jPanelLabels.add(jLabel4, null);

            jPanelLabels.add(jLabel5, null);

        }

        return jPanelLabels;

    }

    /**

     * This method initializes txtHost

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtHost() {

        if (txtHost == null) {

            txtHost = new JTextField();

            txtHost.setPreferredSize(new java.awt.Dimension(170, 19));

            txtHost.setName("txtHost");

        }

        return txtHost;

    }

    /**

     * This method initializes jPanel1

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanelTexts() {

        if (jPanelTexts == null) {

            FlowLayout flowLayout2 = new FlowLayout(FlowLayout.LEFT);        	

            flowLayout2.setVgap(15);

            jPanelTexts = new JPanel();

            jPanelTexts.setLayout(flowLayout2);

            jPanelTexts.setPreferredSize(new java.awt.Dimension(200,400));

            jPanelTexts.setName("jPanelText");

            jPanelTexts.add(getCmbName(), null);

            jPanelTexts.add(getTxtHost(), null);

            jPanelTexts.add(getTxtPort(), null);

            jPanelTexts.add(getTxtUser(), null);

            jPanelTexts.add(getTxtPassword(), null);

            jPanelTexts.add(getTxtBD(), null);

            jPanelTexts.add(getCmbDriver(), null);

        }

        return jPanelTexts;

    }

    /**

     * This method initializes txtPort

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtPort() {

        if (txtPort == null) {

            txtPort = new JTextField();

            txtPort.setPreferredSize(new java.awt.Dimension(40, 19));

            txtPort.setName("txtPort");

            txtPort.setText("3306");

            txtPort.setHorizontalAlignment(javax.swing.JTextField.LEFT);

        }

        return txtPort;

    }

    /**

     * This method initializes txtUser

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtUser() {

        if (txtUser == null) {

            txtUser = new JTextField();

            txtUser.setPreferredSize(new java.awt.Dimension(170, 19));

            txtUser.setName("txtUser");

        }

        return txtUser;

    }

    /**

     * This method initializes txtPassword

     *

     * @return javax.swing.JTextField

     */

    private JPasswordField getTxtPassword() {

        if (txtPassword == null) {

            txtPassword = new JPasswordField();

            txtPassword.setPreferredSize(new java.awt.Dimension(170, 19));

            txtPassword.setName("txtPassword");

        }

        return txtPassword;

    }

    /**

     * This method initializes txtBD

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtBD() {

        if (txtBD == null) {

            txtBD = new JTextField();

            txtBD.setPreferredSize(new java.awt.Dimension(170, 19));

            txtBD.setName("txtBD");

        }

        return txtBD;

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getHost() {

        return getTxtHost().getText();

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getPort() {

        return getTxtPort().getText();

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getUser() {

        return getTxtUser().getText();

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getSettingsName() {

        return getCmbName().getSelectedItem().toString();

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getPassword() {

        passw = String.copyValueOf(getTxtPassword().getPassword());

        return passw;

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getDBName() {

        return getTxtBD().getText();

    }

    /**

     * DOCUMENT ME!

     *

     * @param drivers DOCUMENT ME!

     */

    public void setDrivers(String[] drivers) {

        DefaultComboBoxModel model = new DefaultComboBoxModel();

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

            model.addElement(drivers[i]);

        }

        getCmbDriver().setModel(model);

        //Para que refresque el textbox del puerto

        if (drivers.length > 0)

            cmbDriver.setSelectedIndex(0);

    }

    /**

     * @return ConnectionSettings based on values in this panel

     */

    public ConnectionSettings getConnectionSettings()

    {

        ConnectionSettings cs = new ConnectionSettings();

        cs.setDb(getDBName());

        cs.setDriver(getDriver());

        cs.setHost(getHost());

        cs.setPort(getPort());

        cs.setUser(getUser());

        cs.setPassw(getPassword());

        cs.setName(getSettingsName());

        return cs;

    }

    /**

     * Makes persistent the connection settings of this panel.

     */

    public void saveConnectionSettings()

    {

    	ConnectionSettings cs = new ConnectionSettings();

        cs.setDb(getDBName());

        cs.setDriver(getDriver());

        cs.setHost(getHost());

        cs.setPort(getPort());

        cs.setUser(getUser());

        cs.setPassw(getPassword());

        cs.setName(getSettingsName());

        PluginServices ps = PluginServices.getPluginServices(this);

        XMLEntity xml = ps.getPersistentXML();

        try {

            String[] connections = xml.getStringArrayProperty("jdbc-connections");

            String[] newConnections = new String[connections.length + 1];

            System.arraycopy(connections, 0, newConnections, 0, connections.length);

            newConnections[connections.length] = cs.toString();

            xml.putProperty("jdbc-connections", newConnections);

        } catch (NotExistInXMLEntity e) {

            xml.putProperty("jdbc-connections", new String[] { cs.toString() });

        }

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getDriver() {

        return cmbDriver.getSelectedItem().toString();

    }

    /**

     * DOCUMENT ME!

     *

     * @param cs DOCUMENT ME!

     */

    public void setSettings(HashMap cs) {

        this.cs = cs;

        ((DefaultComboBoxModel) getCmbName().getModel()).removeAllElements();

        Iterator i = cs.keySet().iterator();

        while (i.hasNext()) {

            String item = (String) i.next();

            ((DefaultComboBoxModel) getCmbName().getModel()).addElement(item);

        }

    }

    /**

     * @see com.iver.utiles.swing.wizard.Step#init(com.iver.utiles.swing.wizard.WizardControl)

     */

    public void init(WizardControl w) {

    }

    /**

     * This method initializes cmbDriver

     *

     * @return com.iver.utiles.swing.JComboBox

     */

    private JComboBox getCmbDriver() {

        if (cmbDriver == null) {

            cmbDriver = new JComboBox();

            cmbDriver.setPreferredSize(new java.awt.Dimension(170, 19));

            cmbDriver.setName("cmbDriver");

            cmbDriver.addActionListener(new ActionListener() {

                public void actionPerformed(ActionEvent e) {

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

                    VectorialJDBCDriver driver;

                    try {

                        driver = (VectorialJDBCDriver) LayerFactory.getDM().getDriver(driverName);

                        getTxtPort().setText(Integer.toString(driver.getDefaultPort()));

                    } catch (DriverLoadException e1) {

                        getTxtPort().setText("");

                    }

                }

            });

        }

        return cmbDriver;

    }

    /**

     * DOCUMENT ME!

     *

     * @return

     */

    public boolean done() {

        return (getTxtBD().getText().length() > 0) &&

        (getTxtHost().getText().length() > 0) &&

        (getCmbName().getSelectedItem() != null) &&

        (getCmbName().getSelectedItem().toString().length() > 0);

    }

    /**

     * This method initializes jLabel6

     *

     * @return javax.swing.JLabel

     */

    private JLabel getJLabel6() {

        if (jLabel6 == null) {

            jLabel6 = new JLabel();

            jLabel6.setText(PluginServices.getText(this, "connection_name")+":");

            jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);

            jLabel6.setPreferredSize(new java.awt.Dimension(140,19));

        }

        return jLabel6;

    }

    /**

     * This method initializes jComboBox

     *

     * @return com.iver.utiles.swing.JComboBox

     */

    private com.iver.utiles.swing.JComboBox getCmbName() {

        if (cmbName == null) {

            cmbName = new com.iver.utiles.swing.JComboBox();

            cmbName.setEditable(true);

            cmbName.setPreferredSize(new java.awt.Dimension(170, 19));

            cmbName.setModel(new DefaultComboBoxModel());

            cmbName.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        Object item = cmbName.getSelectedItem();

                        if (item == null) {

                            return;

                        }

                        ConnectionSettings c = (ConnectionSettings) cs.get(item.toString());

                        if (c != null) {

                            getTxtHost().setText(c.getHost());

                            getTxtPort().setText(c.getPort());

                            getTxtBD().setText(c.getDb());

                            getTxtUser().setText(c.getUser());

                            if (c.getPassw() != null)

                                getTxtPassword().setText(c.getPassw());

                            getCmbDriver().setSelectedItem(c.getDriver());

                        }

                    }

                });

        }

        return cmbName;

    }

    /**

     * This method initializes jPanel

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel() {

    	if (jPanel == null) {

    		jPanel = new JPanel();

    		jPanel.setLayout(new BorderLayout());

    		jPanel.setBounds(0, 0, 400, 240);

    		jPanel.add(getJPanelLabels(), java.awt.BorderLayout.WEST);

    		jPanel.add(getJPanelTexts(), java.awt.BorderLayout.EAST);

    	}

    	return jPanel;

    }

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

package com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

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 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) {

   	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;

   }

}

/*

 * Created on 26-oct-2005

 *

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

 *

 * Copyright (C) 2004 IVER T.I. 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

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

package com.iver.cit.gvsig.jdbc_spatial;

import java.awt.BorderLayout;

import java.awt.event.ActionListener;

import java.util.ArrayList;

import java.util.HashMap;

import javax.swing.JButton;

import javax.swing.JDialog;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import org.gvsig.gui.beans.AcceptCancelPanel;

import com.iver.andami.PluginServices;

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

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

import com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard.ConnectionPanel;

import com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard.ConnectionSettings;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

public class DlgConnection extends JDialog {

    private JPanel jContentPane = null;

    private ConnectionPanel jConnPanel = null;

    private JButton jBtnOK = null;

    private JPanel jPanel1 = null;

    private JButton jBtnCancel = null;

    private ConnectionSettings connSettings = null;

    /**

     * This is the default constructor

     */

    public DlgConnection() {

        super();

        initialize();

    }

    private void setPreferences()

    {

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

        if (xml == null) {

            xml = new XMLEntity();

        }

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

            String[] servers = new String[0];

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

        }

        try {

            String[] servers = xml.getStringArrayProperty("jdbc-connections");

            HashMap settings = new HashMap();

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

                ConnectionSettings cs = new ConnectionSettings();

                cs.setFromString(servers[i]);

                settings.put(cs.getName(), cs);

            }

            getJConnPanel().setSettings(settings);

        } catch (NotExistInXMLEntity e) {

        }

    }

    /**

     * This method initializes this

     *

     * @return void

     */

    private void initialize() {

        this.setSize(320, 332);

        this.setTitle(PluginServices.getText(this, "database_connection"));

        this.setContentPane(getJContentPane());

        setPreferences();

        jConnPanel.setDrivers(getDriverNames());

    }

    private String[] getDriverNames(){

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

        ArrayList ret = new ArrayList();

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

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

            boolean is = false;

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

    }

    /**

     * This method initializes jContentPane

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJContentPane() {

        if (jContentPane == null) {

            jContentPane = new JPanel();

            jContentPane.setLayout(new BorderLayout());

            jContentPane.add(getJConnPanel(), java.awt.BorderLayout.CENTER);

            jContentPane.add(getJPanel1(), java.awt.BorderLayout.SOUTH);

        }

        return jContentPane;

    }

    /**

     * This method initializes jPanel

     *

     * @return javax.swing.JPanel

     */

    private ConnectionPanel getJConnPanel() {

    	if (jConnPanel == null) {

    		jConnPanel = new ConnectionPanel();

    	}

    	return jConnPanel;

    }

    /**

     * This method initializes jPanel1

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel1() {

    	if (jPanel1 == null) {

    		ActionListener okAction = new java.awt.event.ActionListener() {

                public void actionPerformed(java.awt.event.ActionEvent e) {

                	if (!jConnPanel.done()) {

                		JOptionPane.showMessageDialog(DlgConnection.this, "No estan todos los datos rellenos", "Error", JOptionPane.ERROR_MESSAGE);

                		return;

                	}

                	jConnPanel.saveConnectionSettings();

                    connSettings = jConnPanel.getConnectionSettings();

                    dispose();

                }

    		};

            ActionListener cancelAction = new java.awt.event.ActionListener() {

    			public void actionPerformed(java.awt.event.ActionEvent e) {

                    connSettings = null;

    				dispose();

    			}

    		};

    		jPanel1 = new AcceptCancelPanel(okAction, cancelAction);

    	}

    	return jPanel1;

    }

    public ConnectionSettings getConnSettings() {

        return connSettings;

    }

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