Application: gvSIG desktop

/* 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 org.gvsig.geodb;

import org.gvsig.about.AboutManager;

import org.gvsig.about.AboutParticipant;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.app.ApplicationManager;

import org.gvsig.app.extension.AddLayer;

import org.gvsig.geodb.vectorialdb.wizard.WizardDB;

import org.gvsig.geodb.vectorialdb.wizard.WizardVectorialDB;

/**

 * This extension adds the export-to-oracle button.

 *

 * @author jldominguez

 *

 */

public class ExtDB_Spatial extends Extension {

	public void initialize() {

	    //do nothing

    }

    public void execute(String actionCommand) {

        //do nothing

    }

    public boolean isEnabled() {

        return isVisible();

        // return true;

    }

    /**

     * Is visible when there is one vector layer selected

     */

    public boolean isVisible() {

        return false;

    }

	@Override

	public void postInitialize() {

		super.postInitialize();

	      addAboutInfo();

		ApplicationLocator.getManager().registerAddTableWizard("DB",

				"DB Tables", WizardDB.class);

    	AddLayer.addWizard(WizardVectorialDB.class);

	}

	   private void addAboutInfo() {

	        ApplicationManager application = ApplicationLocator.getManager();

	        AboutManager about = application.getAbout();

	        about.addDeveloper("PRODEVELOP", getClass().getClassLoader()

	            .getResource("prodevelop.html"), 2);

	        AboutParticipant participant = about.getDeveloper("PRODEVELOP");

	        participant.addContribution(

	            "GeoDB",

	            "Soporte para pool de conexiones con BBDD", 

	            2006,1,1, 

	            2007,12,31

	        );      

	    }

}

package org.gvsig.geodb.vectorialdb;

import java.awt.BorderLayout;

import java.awt.Dimension;

import java.awt.FlowLayout;

import java.awt.Rectangle;

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 javax.swing.SwingConstants;

import org.gvsig.andami.PluginServices;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.exception.InitializeException;

import org.gvsig.fmap.dal.exception.ProviderNotRegisteredException;

import org.gvsig.fmap.dal.resource.db.DBParameters;

import org.gvsig.utils.NotExistInXMLEntity;

import org.gvsig.utils.XMLEntity;

import org.gvsig.utils.swing.JComboBox;

import org.gvsig.utils.swing.wizard.Step;

import org.gvsig.utils.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 org.gvsig.utils.swing.JComboBox cmbName = null;

    private HashMap cs = new HashMap();

    private JPanel jPanel = null;

	private JLabel jLabelSchema = null;

	private ConnectionPanel XYZ = null;

	private JPanel jPanel1 = null;

	private JPanel jPanelLabels1 = null;

	private JLabel jLabel61 = null;

	private JLabel jLabel7 = null;

	private JLabel jLabel11 = null;

	private JLabel jLabel21 = null;

	private JLabel jLabel31 = null;

	private JLabel jLabel51 = null;

	private JPanel jPanelTexts1 = null;

	private JComboBox cmbName1 = null;

	private JTextField txtHost1 = null;

	private JTextField txtPort1 = null;

	private JTextField txtUser1 = null;

	private JPasswordField txtPassword1 = null;

	private JTextField txtBD1 = null;

	private JComboBox cmbDriver1 = null;

	private JTextField txtSchema = 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) {

            String string = PluginServices.getText(this, "schema") + ":";

            jLabelSchema = new JLabel();

            jLabelSchema.setName("jLabel4");

            jLabelSchema.setHorizontalAlignment(SwingConstants.RIGHT);

            jLabelSchema.setHorizontalTextPosition(SwingConstants.RIGHT);

            jLabelSchema.setText(string);

            jLabelSchema.setPreferredSize(new Dimension(140, 19));

            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(jLabelSchema, 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 Dimension(200, 300));

            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(getTxtSchema(), 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("");

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

        if (getCmbName().getSelectedItem() == null){

            return null;

        }        

        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.setSchema(getSchema());

        cs.setDriver(getDriver());

        cs.setHost(getHost());

        cs.setPort(getPort());

        cs.setUser(getUser());

        cs.setPassw(getPassword());

        cs.setName(getSettingsName());

        return cs;

    }

    public String getSchema() {

		return txtSchema.getText();

	}

    /**

     * Makes persistent the connection settings of this panel.

     */

    public void saveConnectionSettings()

    {

    	ConnectionSettings cs = new ConnectionSettings();

        cs.setDb(getDBName());

        cs.setSchema(getSchema());

        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 org.gvsig.utils.swing.wizard.Step#init(org.gvsig.utils.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();

                    DataManager dm = DALLocator.getDataManager();

                    DBParameters dsp=null;

					try {

						dsp = (DBParameters) dm

								.createServerExplorerParameters(driverName);

					} catch (InitializeException e1) {

						// TODO Auto-generated catch block

						e1.printStackTrace();

					} catch (ProviderNotRegisteredException e1) {

						// TODO Auto-generated catch block

						e1.printStackTrace();

					}

					// String port = dsp.getPort() + "";

					// getTxtPort().setText(port);

                }

            });

        }

        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 org.gvsig.utils.swing.JComboBox getCmbName() {

        if (cmbName == null) {

            cmbName = new org.gvsig.utils.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, 363, 240);

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

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

    	}

    	return jPanel;

    }

	/**

	 * This method initializes XYZ

	 *

	 * @return com.iver.cit.gvsig.jdbc_spatial.gui.jdbcwizard.ConnectionPanel

	 */

	private ConnectionPanel getXYZ() {

		if (XYZ == null) {

			XYZ = new ConnectionPanel();

			XYZ.setLayout(null);

			XYZ.setSize(new java.awt.Dimension(335,240));

			XYZ.add(getJPanel1(), null);

		}

		return XYZ;

	}

	/**

	 * This method initializes jPanel1

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanel1() {

		if (jPanel1 == null) {

			jPanel1 = new JPanel();

			jPanel1.setLayout(new BorderLayout());

			jPanel1.setBounds(new Rectangle(0, 0, 363, 240));

			jPanel1.add(getJPanelLabels1(), java.awt.BorderLayout.WEST);

			jPanel1.add(getJPanelTexts1(), java.awt.BorderLayout.EAST);

		}

		return jPanel1;

	}

	/**

	 * This method initializes jPanelLabels1

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanelLabels1() {

		if (jPanelLabels1 == null) {

			jLabel51 = new JLabel();

			jLabel51.setName("jLabel5");

			jLabel51.setHorizontalAlignment(SwingConstants.RIGHT);

			jLabel51.setHorizontalTextPosition(SwingConstants.RIGHT);

			jLabel51.setText(PluginServices.getText(getXYZ(), "driver") + ":");

			jLabel51.setPreferredSize(new Dimension(140, 19));

			jLabel31 = new JLabel();

			jLabel31.setName("jLabel3");

			jLabel31.setHorizontalAlignment(SwingConstants.RIGHT);

			jLabel31.setHorizontalTextPosition(SwingConstants.RIGHT);

			jLabel31.setText(PluginServices.getText(getXYZ(), "password") + ":");

			jLabel31.setPreferredSize(new Dimension(140, 19));

			jLabel21 = new JLabel();

			jLabel21.setName("jLabel2");

			jLabel21.setHorizontalAlignment(SwingConstants.RIGHT);

			jLabel21.setHorizontalTextPosition(SwingConstants.RIGHT);

			jLabel21.setText(PluginServices.getText(getXYZ(), "usuario") + ":");

			jLabel21.setPreferredSize(new Dimension(140, 19));

			jLabel11 = new JLabel();

			jLabel11.setName("jLabel1");

			jLabel11.setHorizontalAlignment(SwingConstants.TRAILING);

			jLabel11.setText(PluginServices.getText(getXYZ(), "puerto") + ":");

			jLabel11.setPreferredSize(new Dimension(140, 19));

			jLabel7 = new JLabel();

			jLabel7.setName("jLabel");

			jLabel7.setHorizontalAlignment(SwingConstants.RIGHT);

			jLabel7.setText(PluginServices.getText(getXYZ(), "host") + ":");

			jLabel7.setPreferredSize(new Dimension(140, 19));

			jLabel61 = new JLabel();

			jLabel61.setPreferredSize(new Dimension(140, 19));

			jLabel61.setText(PluginServices.getText(getXYZ(), "connection_name") + ":");

			jLabel61.setHorizontalAlignment(SwingConstants.RIGHT);

			FlowLayout flowLayout31 = new FlowLayout();

			flowLayout31.setVgap(15);

			jPanelLabels1 = new JPanel();

			jPanelLabels1.setPreferredSize(new Dimension(150, 400));

			jPanelLabels1.setLayout(flowLayout31);

			jPanelLabels1.setName("jPanelLabels");

			jPanelLabels1.add(jLabel61, null);

			jPanelLabels1.add(jLabel7, null);

			jPanelLabels1.add(jLabel11, null);

			jPanelLabels1.add(jLabel21, null);

			jPanelLabels1.add(jLabel31, null);

			jPanelLabels1.add(jLabelSchema, jLabelSchema.getName());

			jPanelLabels1.add(jLabel51, null);

		}

		return jPanelLabels1;

	}

	/**

	 * This method initializes jPanelTexts1

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanelTexts1() {

		if (jPanelTexts1 == null) {

			FlowLayout flowLayout21 = new FlowLayout(FlowLayout.LEFT);

			flowLayout21.setVgap(15);

			jPanelTexts1 = new JPanel();

			jPanelTexts1.setPreferredSize(new Dimension(200, 300));

			jPanelTexts1.setLayout(flowLayout21);

			jPanelTexts1.setName("jPanelText");

			jPanelTexts1.add(getCmbName1(), null);

			jPanelTexts1.add(getTxtHost1(), null);

			jPanelTexts1.add(getTxtPort1(), null);

			jPanelTexts1.add(getTxtUser1(), null);

			jPanelTexts1.add(getTxtPassword1(), null);

			jPanelTexts1.add(getTxtBD1(), null);

			jPanelTexts1.add(getCmbDriver1(), null);

		}

		return jPanelTexts1;

	}

	/**

	 * This method initializes cmbName1

	 *

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

	 */

	private JComboBox getCmbName1() {

		if (cmbName1 == null) {

			cmbName1 = new JComboBox();

			cmbName1.setPreferredSize(new Dimension(170, 19));

			cmbName1.setModel(new DefaultComboBoxModel());

			cmbName1.setEditable(true);

		}

		return cmbName1;

	}

	/**

	 * This method initializes txtHost1

	 *

	 * @return javax.swing.JTextField

	 */

	private JTextField getTxtHost1() {

		if (txtHost1 == null) {

			txtHost1 = new JTextField();

			txtHost1.setName("txtHost");

			txtHost1.setPreferredSize(new Dimension(170, 19));

		}

		return txtHost1;

	}

	/**

	 * This method initializes txtPort1

	 *

	 * @return javax.swing.JTextField

	 */

	private JTextField getTxtPort1() {

		if (txtPort1 == null) {

			txtPort1 = new JTextField();

			txtPort1.setName("txtPort");

			txtPort1.setText("");

			txtPort1.setHorizontalAlignment(JTextField.LEFT);

			txtPort1.setPreferredSize(new Dimension(40, 19));

		}

		return txtPort1;

	}

	/**

	 * This method initializes txtUser1

	 *

	 * @return javax.swing.JTextField

	 */

	private JTextField getTxtUser1() {

		if (txtUser1 == null) {

			txtUser1 = new JTextField();

			txtUser1.setName("txtUser");

			txtUser1.setPreferredSize(new Dimension(170, 19));

		}

		return txtUser1;

	}

	/**

	 * This method initializes txtPassword1

	 *

	 * @return javax.swing.JPasswordField

	 */

	private JPasswordField getTxtPassword1() {

		if (txtPassword1 == null) {

			txtPassword1 = new JPasswordField();

			txtPassword1.setName("txtPassword");

			txtPassword1.setPreferredSize(new Dimension(170, 19));

		}

		return txtPassword1;

	}

	/**

	 * This method initializes txtBD1

	 *

	 * @return javax.swing.JTextField

	 */

	private JTextField getTxtBD1() {

		if (txtBD1 == null) {

			txtBD1 = new JTextField();

			txtBD1.setName("txtBD");

			txtBD1.setPreferredSize(new Dimension(170, 19));

		}

		return txtBD1;

	}

	/**

	 * This method initializes cmbDriver1

	 *

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

	 */

	private JComboBox getCmbDriver1() {

		if (cmbDriver1 == null) {

			cmbDriver1 = new JComboBox();

			cmbDriver1.setName("cmbDriver");

			cmbDriver1.setPreferredSize(new Dimension(170, 19));

		}

		return cmbDriver1;

	}

	/**

	 * This method initializes txtSchema

	 *

	 * @return javax.swing.JTextField

	 */

	private JTextField getTxtSchema() {

		if (txtSchema == null) {

			txtSchema = new JTextField();

			txtSchema.setName("txtBD");

			txtSchema.setPreferredSize(new Dimension(170, 19));

		}

		return txtSchema;

	}

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

package org.gvsig.geodb.vectorialdb;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.exception.InitializeException;

import org.gvsig.fmap.dal.exception.ProviderNotRegisteredException;

import org.gvsig.fmap.dal.resource.db.DBParameters;

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class ConnectionSettings {

    private String host;

    private String port;

    private String db;

    private String schema;

    private String driver;

    private String user;

    private String name;

    private String passw;

    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[] 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(){

    	DataManager dm=DALLocator.getDataManager();

    	try {

			DBParameters dsp=(DBParameters)dm.createStoreParameters(getDriver());

		} catch (InitializeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (ProviderNotRegisteredException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

        String connectionString = "";//vecDriver.getConnectionStringBeginning() + "//" + getHost();

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

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

        return connectionString;

    }

	public String getSchema() {

		return schema;

	}

	public void setSchema(String schema) {

		this.schema = schema;

	}

}

/* 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 org.gvsig.geodb.vectorialdb.wizard;

import javax.swing.JCheckBox;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

/**

 * 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(FeatureAttributeDescriptor descriptor) {

    	name = descriptor.getName();

        type = descriptor.getDataTypeName();

        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 org.gvsig.geodb.vectorialdb.wizard;

/**

 * 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 org.gvsig.geodb.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.Iterator;

import java.util.List;

import javax.swing.JButton;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JPasswordField;

import javax.swing.JTextField;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.andami.ui.mdiManager.IWindow;

import org.gvsig.andami.ui.mdiManager.WindowInfo;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorerParameters;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.exception.ValidateDataParametersException;

import org.gvsig.fmap.dal.serverexplorer.db.DBServerExplorerParameters;

import org.gvsig.fmap.mapcontrol.swing.dynobject.DynObjectEditor;

import org.gvsig.gui.beans.Messages;

import org.gvsig.tools.service.ServiceException;

/**

 * Lets the user input the connection parameters.

 *

 * @author jldominguez

 *

 */

public class VectorialDBConnectionParamsDialog extends JPanel implements IWindow,

    ActionListener, KeyListener {

    private static final long serialVersionUID = -5493563028200403559L;

    private static final Logger LOG = LoggerFactory

        .getLogger(VectorialDBConnectionParamsDialog.class);

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

    private JButton cancelButton = null;

    private JButton okButton = null;

    private JButton advancedButton = 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 DBServerExplorerParameters params = null;

    /**

     * This method initializes

     *

     */

    public VectorialDBConnectionParamsDialog() {

        super();

        initialize();

    }

    public void showDialog() {

        PluginServices.getMDIManager().addWindow(this);

    }

    /**

     * This method initializes this

     *

     */

    private void initialize() {

        winfo.setWidth(370);

        winfo.setHeight(317 - 25);

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

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

        this.setLayout(null);

        this.add(getCancelButton(), null);

        this.add(getOkButton(), null);

        this.add(getAdvancedButton(), 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(124, 292, 90, 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(30, 292, 90, 26));

        }

        return okButton;

    }

	/**

	 * This method initializes okButton

	 *

	 * @return javax.swing.JButton

	 */

	private JButton getAdvancedButton() {

		if (advancedButton == null) {

			advancedButton = new JButton();

			advancedButton.setText(PluginServices.getText(this, "advanced"));

			advancedButton.addActionListener(this);

			advancedButton.setBounds(new java.awt.Rectangle(218, 292, 90, 26));

		}

		return advancedButton;

	}

	/**

	 * 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, 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, 141, 21));

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

            userLabel = new JLabel();

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

                ":");

            dbLabelWarning = new JLabel();

            dbLabelWarning.setBounds(new java.awt.Rectangle(10, 155, 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));

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

    }

    /**

     * This method initializes driverComboBox

     *

     * @return javax.swing.JComboBox

     */

    private JComboBox getDriverComboBox() {

        if (driverComboBox == null) {

            driverComboBox = new JComboBox();

            driverComboBox.addActionListener(this);

            DataManager dm = DALLocator.getDataManager();

            List<String> explorers = dm.getExplorerProviders();

            Iterator<String> iter = explorers.iterator();