Application: gvSIG desktop

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. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* ${year} IVER T.I. S.A.   {{Task}}

*/

package org.gvsig.geodb.vectorialdb.wizard;

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

/**

 * DOCUMENT ME!

 *

 * @author Vicente Caballero Navarro

 */

public class MyExplorer {

    private DBServerExplorerParameters dbExplorerParameters;

    private String name;

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public DBServerExplorerParameters getDbSeverExplorerParameters() {

        return dbExplorerParameters;

    }

    /**

     * DOCUMENT ME!

     *

     * @param dbExplorerParameters DOCUMENT ME!

     */

    public void setDbExplorerParameters(

        DBServerExplorerParameters dbExplorerParameters) {

        this.dbExplorerParameters = dbExplorerParameters;

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getName() {

        return name;

    }

    /**

     * DOCUMENT ME!

     *

     * @param name DOCUMENT ME!

     */

    public void setName(String name) {

        this.name = name;

    }

	public String toString() {

		return getName();

	}

}

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

* 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., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

package org.gvsig.geodb.vectorialdb.wizard;

import java.awt.BorderLayout;

import java.awt.Window;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import java.util.Map.Entry;

import javax.swing.DefaultListModel;

import javax.swing.ImageIcon;

import javax.swing.JComboBox;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.ListSelectionModel;

import javax.swing.event.ListSelectionEvent;

import javax.swing.event.ListSelectionListener;

import org.apache.commons.collections.map.HashedMap;

import org.cresques.cts.IProjection;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.PluginsLocator;

import org.gvsig.andami.PluginsManager;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.app.ApplicationLocator;

import org.gvsig.app.ApplicationManager;

import org.gvsig.app.gui.WizardPanel;

import org.gvsig.app.prepareAction.PrepareContext;

import org.gvsig.app.project.Project;

import org.gvsig.app.project.ProjectManager;

import org.gvsig.app.project.documents.table.TableDocument;

import org.gvsig.app.project.documents.table.TableManager;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataStoreParameters;

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

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

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

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

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

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

import org.gvsig.fmap.dal.store.db.DBStoreParameters;

import org.gvsig.fmap.mapcontext.layers.FLayer;

import org.gvsig.fmap.mapcontrol.MapControl;

import org.gvsig.geodb.ExtDB_Spatial;

import org.gvsig.gui.beans.swing.JButton;

import org.gvsig.tools.dynobject.DynObject;

public class WizardDB extends WizardPanel implements ActionListener,

		ListSelectionListener {

	/**

     * 

     */

    private static final long serialVersionUID = -7045762275505941695L;

    private static final String WIZARD_TAB_NAME = "DB";

	private static Logger logger = LoggerFactory.getLogger(WizardDB.class

			.getName());

    private JPanel namePanel = null;

	private JPanel tablesPanel = null;

	private JScrollPane tablesScrollPane = null;

	private AvailableTablesCheckBoxList tablesList = null;

	private JComboBox datasourceComboBox = null;

	private UserSelectedFieldsPanel fieldsPanel = null;

	private UserSelectedFieldsPanel emptyFieldsPanel = null;

	private JButton dbButton = null;

	private DBServerExplorerParameters dbExplorerParameters;

    private UserTableSettingsPanel settingsPanel = null;

	protected UserTableSettingsPanel emptySettingsPanel = null;

	private PrepareContext prepareDSContext;

    public WizardDB() {

		super();

		initialize();

	}

	protected void initialize() {

		setTabName(WIZARD_TAB_NAME);

		setLayout(null);

		setSize(512, 478);

		emptyFieldsPanel = new UserSelectedFieldsPanel(null, true, this);

		add(emptyFieldsPanel);

        add(getNamePanel(), null);

		loadVectorialDBDatasourcesCombo(null);

		add(getTablesPanel(), null);

        emptySettingsPanel = createSettingsPanel(null);

        add(emptySettingsPanel);

	}

    @SuppressWarnings("rawtypes")

    private void loadVectorialDBDatasourcesCombo(MyExplorer sel) {

        PluginsManager manager = PluginsLocator.getManager();

        DynObject values = manager.getPlugin(ExtDB_Spatial.class).getPluginProperties();

        Map connections = (Map) values.getDynValue("db_connections");

        if (connections != null){

            Iterator it = connections.entrySet().iterator();

            getDatasourceComboBox().removeAllItems();

            getDatasourceComboBox().addItem("");

            while (it.hasNext()){

                Map.Entry entry = (Entry) it.next();

                MyExplorer myExplorer = new MyExplorer();

                myExplorer.setDbExplorerParameters((DBServerExplorerParameters) entry.getValue());

                myExplorer.setName((String) entry.getKey());

                getDatasourceComboBox().addItem(myExplorer);

                if(sel!=null && sel.getName().equalsIgnoreCase(myExplorer.getName())){

                    getDatasourceComboBox().setSelectedItem(myExplorer);

                }

            }

        } else {

            connections = new HashedMap();

            values.setDynValue("db_connections", connections);

        }

	}

	public void initWizard() {

	}

    @Override

    public void execute() {

        executeWizard();

    }

    @Override

    public Object executeWizard() {

		TablesListItem[] tables = getSelectedTables();

		DataManager man = DALLocator.getDataManager();

		FeatureStore store;

		String docName;

		TableDocument document;

		Project project = ProjectManager.getInstance().getCurrentProject();

		ApplicationManager appGvSIGMan = ApplicationLocator.getManager();

		PrepareContext context = this.getPrepareDataStoreContext();

		DBStoreParameters storeParams;

        List<TableDocument> tabledocs =

            new ArrayList<TableDocument>(tables.length);

		for (TablesListItem table : tables) {

			storeParams = getParameterForTable(table);

			try {

				storeParams = (DBStoreParameters) appGvSIGMan

						.prepareOpenDataStoreParameters(storeParams, context);

			} catch (Exception e2) {

				NotificationManager.addError(e2);

				continue;

			}

			UserTableSettingsPanel userTableSettingsPanel = table

					.getUserTableSettingsPanel();

			docName = userTableSettingsPanel.getUserLayerName();

			try {

				store = (FeatureStore) man.openStore(storeParams.getDataStoreName(), storeParams);

			} catch (Exception e) {

				NotificationManager.addError(e);

                return null;

			}

			try {

				appGvSIGMan.pepareOpenDataSource(

						store, context);

			} catch (Exception e) {

				NotificationManager.addError(e);

				store.dispose();

                return null;

			}

			document = (TableDocument) ProjectManager.getInstance().createDocument(TableManager.TYPENAME, docName);

			document.setStore(store);

            // project.add(document);

            tabledocs.add(document);

		}

        return tabledocs;

	}

	protected DBStoreParameters getParameterForTable(TablesListItem table) {

		DBStoreParameters parameters = table.getParameters();

		UserTableSettingsPanel userTableSettingsPanel = table

				.getUserTableSettingsPanel();

		String fidField = userTableSettingsPanel.getIdFieldName();

		//IF is a multiple PK, remove the {} symbols

		if (fidField.startsWith("{") && fidField.endsWith("}")) {

			fidField = fidField.substring(1, fidField.length()-1);

		}

		String[] pkFields = fidField.split(",");  	    

		String[] fields = table.getUserSelectedFieldsPanel()

				.getUserSelectedFields(pkFields, null);

		if (userTableSettingsPanel.isSqlActive()) {

			String whereClause = userTableSettingsPanel

					.getWhereClause();

			parameters.setBaseFilter(whereClause);

		} else {

			parameters.setBaseFilter("");

		}

		parameters.setFields(fields);

		return parameters;

	}

	@SuppressWarnings({ "rawtypes", "unchecked" })

    protected TablesListItem[] getSelectedTables() {

		int count = tablesList.getModel().getSize();

		ArrayList resp = new ArrayList();

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

			TablesListItem item = (TablesListItem) tablesList.getModel()

					.getElementAt(i);

			if (item.isSelected()) {

				resp.add(item);

			}

		}

		return (TablesListItem[]) resp.toArray(new TablesListItem[0]);

	}

	/**

	 * This method initializes namePanel

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getNamePanel() {

		if (namePanel == null) {

			namePanel = new JPanel();

			namePanel.setLayout(null);

			namePanel.setBounds(new java.awt.Rectangle(5, 5, 501, 51));

			namePanel.setBorder(javax.swing.BorderFactory.createTitledBorder(

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

					javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

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

					null));

			namePanel.add(getDatasourceComboBox(), null);

			namePanel.add(getJdbcButton(), null);

		}

		return namePanel;

	}

	/**

	 * This method initializes tablesPanel

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getTablesPanel() {

		if (tablesPanel == null) {

			tablesPanel = new JPanel();

			tablesPanel.setLayout(new BorderLayout());

			tablesPanel.setBorder(javax.swing.BorderFactory.createTitledBorder(

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

					javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

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

					null));

			tablesPanel.setBounds(new java.awt.Rectangle(5, 55, 246, 166));

			tablesPanel

					.add(getTablesScrollPane(), java.awt.BorderLayout.CENTER);

		}

		return tablesPanel;

	}

	/**

	 * This method initializes settingsPanel

	 *

	 * @return javax.swing.JPanel

	 */

	/**

	 * This method initializes tablesScrollPane

	 *

	 * @return javax.swing.JScrollPane

	 */

	private JScrollPane getTablesScrollPane() {

		if (tablesScrollPane == null) {

			tablesScrollPane = new JScrollPane();

			tablesScrollPane.setViewportView(getTablesList());

		}

		return tablesScrollPane;

	}

	/**

	 * This method initializes tablesList

	 *

	 * @return javax.swing.JList

	 */

	protected AvailableTablesCheckBoxList getTablesList() {

		if (tablesList == null) {

			tablesList = new AvailableTablesCheckBoxList(this);

			tablesList.addListSelectionListener(this);

			tablesList.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

		}

		return tablesList;

	}

	/**

	 * This method initializes layerNameTextField

	 *

	 * @return javax.swing.JTextField

	 */

	/**

	 * This method initializes jComboBox

	 *

	 * @return javax.swing.JComboBox

	 */

	private JComboBox getDatasourceComboBox() {

		if (datasourceComboBox == null) {

			datasourceComboBox = new JComboBox();

			datasourceComboBox

					.setBounds(new java.awt.Rectangle(10, 20, 446, 21));

			datasourceComboBox.addActionListener(this);

		}

		return datasourceComboBox;

	}

	public void actionPerformed(ActionEvent arg0) {

		if (datasourceComboBox.getItemCount() == 0) {

			setEmptyPanels();

		}

		Object src = arg0.getSource();

		if (src == datasourceComboBox) {

            Object selected = datasourceComboBox.getSelectedItem();

            if (selected instanceof MyExplorer) {

                MyExplorer sel_obj = (MyExplorer) selected;

                if (sel_obj == null) {

                    return;

                }

                getDatasourceComboBox().repaint();

                dbExplorerParameters = sel_obj.getDbSeverExplorerParameters();

            }

		} else if (src == dbButton) {

			MyExplorer sel = addNewConnection();

			if (sel != null) {

				dbExplorerParameters = sel.getDbSeverExplorerParameters();

				loadVectorialDBDatasourcesCombo(sel);

				getDatasourceComboBox().setSelectedItem(sel);

			}

		}

		updateTableList(dbExplorerParameters);

	}

	@SuppressWarnings({ "unchecked", "rawtypes" })

    private MyExplorer addNewConnection() {

		MyExplorer myExplorer = new MyExplorer();

		DBServerExplorerParameters resp = null;

		VectorialDBConnectionParamsDialog newco = new VectorialDBConnectionParamsDialog();

		newco.showDialog();

		if (newco.isOkPressed()) {

			try {

				resp = newco.getParameters();

			} catch (Exception e) {

				showConnectionErrorMessage(e.getMessage());

				return null;

			}

			PluginsManager manager = PluginsLocator.getManager();

            DynObject values = manager.getPlugin(ExtDB_Spatial.class).getPluginProperties();

            Map connections = (Map) values.getDynValue("db_connections");

            if(connections == null){

                connections = new HashedMap();

                values.setDynValue("db_connections", connections);

            }

            connections.put(newco.getConnectionName(), resp);

//			SingleVectorialDBConnectionExtension.saveAllToPersistence();

			myExplorer.setDbExplorerParameters(resp);

			myExplorer.setName(newco.getConnectionName());

			return myExplorer;

		} else {

			return null;

		}

	}

	protected TablesListItem createTabeListItem(DBServerExplorer dbExplorer,

			DBStoreParameters param) {

		return new TablesListItem(dbExplorer, param, this);

	}

	@SuppressWarnings("rawtypes")

    private void updateTableList(

			DBServerExplorerParameters dbSeverExplorerParameters2) {

		if (dbSeverExplorerParameters2 == null) {

			return;

		}

		DataManager dm = DALLocator.getDataManager();

		DBServerExplorer dbExplorer;

		try {

			dbExplorer = (DBServerExplorer) dm.openServerExplorer(dbSeverExplorerParameters2.getExplorerName(), dbSeverExplorerParameters2);

			// TODO: use the mode to filter tables with geometries when opening

			// a view document

			List parameters = dbExplorer.list();

			DefaultListModel lmodel = new DefaultListModel();

			Iterator iter = parameters.iterator();

			DBStoreParameters param;

			int count = 0;

			while (iter.hasNext()) {

				param = (DBStoreParameters) iter.next();

				lmodel.addElement(createTabeListItem(dbExplorer, param));

				count++;

			}

			getTablesList().setModel(lmodel);