Application: gvSIG desktop

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

	<name>gvSIG_JDBC</name>

	<comment></comment>

	<projects>

	</projects>

	<buildSpec>

		<buildCommand>

			<name>org.eclipse.jdt.core.javabuilder</name>

			<arguments>

			</arguments>

		</buildCommand>

	</buildSpec>

	<natures>

		<nature>org.eclipse.jdt.core.javanature</nature>

	</natures>

</projectDescription>

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

	<depends plugin-name="com.iver.cit.gvsig" />

	<libraries library-dir="."/>

	<extensions>

		<extension class-name="com.iver.cit.gvsig.jdbc_spatial.ExtJDBC_Spatial"

			description="Support to access JDBC spatial databases PostgreSQL and mySQL"

			active="true"

			priority="1">

		</extension>		

	</extensions>

</plugin-config>

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

import com.iver.andami.PluginServices;

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

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

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

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.geom.Rectangle2D;

import javax.swing.ButtonGroup;

import javax.swing.DefaultListModel;

import javax.swing.JLabel;

import javax.swing.JList;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JScrollPane;

import javax.swing.JTextField;

import javax.swing.JButton;

/**

 * DOCUMENT ME!

 *

 * @author Fernando Gonz?lez Cort?s

 */

public class DBLayerDefinition extends JPanel implements Step {

    private JList lstTables = null;

    private JLabel jLabel = null;

    private JPanel pnlExtent = null;

    private JLabel jLabel1 = null;

    private JTextField txtMinX = null;

    private JLabel jLabel2 = null;

    private JTextField txtMaxX = null;

    private JLabel jLabel3 = null;

    private JTextField txtMinY = null;

    private JLabel jLabel4 = null;

    private JTextField txtMaxY = null;

    private DefaultListModel lstTablesModel = new DefaultListModel();

    private JRadioButton radFullTable = null;

    private JRadioButton radWorkingArea = null;

    private boolean advanced = false;

    private JScrollPane jScrollPane = null;

    private JPanel jPanel = null;

    private JTextField txtLayerName = null;

    private JPanel jPanel1 = null;

    private JLabel jLabel5 = null;

	private JButton jButton = null;

    /**

     * This is the default constructor

     */

    public DBLayerDefinition() {

        super();

        initialize();

    }

    /**

     * This method initializes this

     */

    private void initialize() {

        jLabel = new JLabel();

        this.setSize(509, 375);

        this.setPreferredSize(new java.awt.Dimension(1260, 180));

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

        jLabel.setPreferredSize(new java.awt.Dimension(330, 15));

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

        this.add(jLabel, null);

        this.add(getJScrollPane(), null);

        this.add(getJPanel(), null);

        this.add(getPnlExtent(), null);

        this.add(getJButton(), null);

        this.add(getJPanel1(), null);

        ButtonGroup bt = new ButtonGroup();

        bt.add(getRadFullTable());

        bt.add(getRadWorkingArea());

        enableExtent(false);

    }

    /**

     * This method initializes lstTables

     *

     * @return javax.swing.JList

     */

    private JList getLstTables() {

        if (lstTables == null) {

            lstTables = new JList();

            lstTables.setModel(lstTablesModel);

            lstTables.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);

        }

        return lstTables;

    }

    /**

     * This method initializes pnlExtent

     *

     * @return javax.swing.JPanel

     */

    private JPanel getPnlExtent() {

        if (pnlExtent == null) {

            jLabel4 = new JLabel();

            jLabel3 = new JLabel();

            jLabel2 = new JLabel();

            jLabel1 = new JLabel();

            pnlExtent = new JPanel();

            pnlExtent.setPreferredSize(new java.awt.Dimension(400,60));

            jLabel1.setText("MinX:");

            jLabel2.setText("MaxX:");

            jLabel3.setText("MinY:");

            jLabel4.setText("MaxY:");

            pnlExtent.add(jLabel1, null);

            pnlExtent.add(getTxtMinX(), null);

            pnlExtent.add(jLabel2, null);

            pnlExtent.add(getTxtMaxX(), null);

            pnlExtent.add(jLabel3, null);

            pnlExtent.add(getTxtMinY(), null);

            pnlExtent.add(jLabel4, null);

            pnlExtent.add(getTxtMaxY(), null);

        }

        return pnlExtent;

    }

    /**

     * This method initializes txtMinX

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtMinX() {

        if (txtMinX == null) {

            txtMinX = new JTextField();

            txtMinX.setPreferredSize(new java.awt.Dimension(100, 19));

        }

        return txtMinX;

    }

    /**

     * This method initializes txtMaxX

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtMaxX() {

        if (txtMaxX == null) {

            txtMaxX = new JTextField();

            txtMaxX.setPreferredSize(new java.awt.Dimension(100, 19));

        }

        return txtMaxX;

    }

    /**

     * This method initializes txtMinY

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtMinY() {

        if (txtMinY == null) {

            txtMinY = new JTextField();

            txtMinY.setPreferredSize(new java.awt.Dimension(100, 19));

        }

        return txtMinY;

    }

    /**

     * This method initializes txtMaxY

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtMaxY() {

        if (txtMaxY == null) {

            txtMaxY = new JTextField();

            txtMaxY.setPreferredSize(new java.awt.Dimension(100, 19));

        }

        return txtMaxY;

    }

    /**

     * DOCUMENT ME!

     *

     * @param tables DOCUMENT ME!

     */

    public void setTables(String[] tables) {

        lstTablesModel = new DefaultListModel();

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

            lstTablesModel.addElement(tables[i]);

        }

        getLstTables().setModel(lstTablesModel);

    }

    /**

     * DOCUMENT ME!

     *

     * @param rect DOCUMENT ME!

     */

    public void setExtent(Rectangle2D rect) {

        getTxtMinX().setText(String.valueOf(rect.getMinX()));

        getTxtMinY().setText(String.valueOf(rect.getMinY()));

        getTxtMaxX().setText(String.valueOf(rect.getMaxX()));

        getTxtMaxY().setText(String.valueOf(rect.getMaxY()));

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public Rectangle2D getExtent() {

        if (getRadFullTable().isSelected()) {

            return null;

        } else {

            return new Rectangle2D.Double(Double.parseDouble(

                    getTxtMinX().getText()),

                Double.parseDouble(getTxtMinY().getText()),

                Double.parseDouble(getTxtMaxX().getText()) -

                Double.parseDouble(getTxtMinX().getText()),

                Double.parseDouble(getTxtMaxY().getText()) -

                Double.parseDouble(getTxtMinY().getText()));

        }

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public boolean done() {

        boolean done = (getTable() != null) && (!getLayerName().trim().equals(""));

        if (getRadWorkingArea().isSelected()) {

            done = done && (getTxtMaxX().getText().length() > 0) &&

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

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

                (getTxtMinY().getText().length() > 0);

        }

        return done;

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getTable() {

        return (String) getLstTables().getSelectedValue();

    }

    /**

     * DOCUMENT ME!

     *

     * @return DOCUMENT ME!

     */

    public String getLayerName() {

        return (String) getTxtLayerName().getText();

    }

    public String getWhere(){

        throw new UnsupportedOperationException();

    }

    /**

     * This method initializes radFullTable

     *

     * @return javax.swing.JRadioButton

     */

    private JRadioButton getRadFullTable() {

        if (radFullTable == null) {

            radFullTable = new JRadioButton();

            radFullTable.setText(PluginServices.getText(this, "toda_la_tabla")+":");

            radFullTable.setSelected(true);

            radFullTable.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        enableExtent(radWorkingArea.isSelected());

                    }

                });

        }

        return radFullTable;

    }

    /**

     * DOCUMENT ME!

     *

     * @param enable DOCUMENT ME!

     */

    private void enableExtent(boolean enable) {

        for (int i = 0; i < pnlExtent.getComponentCount(); i++) {

            pnlExtent.getComponent(i).setEnabled(enable);

        }

    }

    /**

     * This method initializes radWorkingArea

     *

     * @return javax.swing.JRadioButton

     */

    private JRadioButton getRadWorkingArea() {

        if (radWorkingArea == null) {

            radWorkingArea = new JRadioButton();

            radWorkingArea.setText(PluginServices.getText(this, "area_trabajo")+":");

            radWorkingArea.addActionListener(new ActionListener() {

                    public void actionPerformed(ActionEvent e) {

                        enableExtent(radWorkingArea.isSelected());

                    }

                });

        }

        return radWorkingArea;

    }

    /**

     * This method initializes jScrollPane

     *

     * @return javax.swing.JScrollPane

     */

    private JScrollPane getJScrollPane() {

        if (jScrollPane == null) {

            jScrollPane = new JScrollPane();

            jScrollPane.setViewportView(getLstTables());

            jScrollPane.setPreferredSize(new java.awt.Dimension(270, 110));

        }

        return jScrollPane;

    }

    /**

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

     */

    public void init(WizardControl w) {

    }

    /**

     * This method initializes jPanel

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel() {

        if (jPanel == null) {

            jPanel = new JPanel();

            jPanel.add(getRadFullTable(), null);

            jPanel.add(getRadWorkingArea(), null);

        }

        return jPanel;

    }

    /**

     * This method initializes jTextField

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtLayerName() {

        if (txtLayerName == null) {

            txtLayerName = new JTextField();

            txtLayerName.setPreferredSize(new java.awt.Dimension(100, 19));

        }

        return txtLayerName;

    }

    /**

     * This method initializes jPanel1

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel1() {

        if (jPanel1 == null) {

            jLabel5 = new JLabel();

            jPanel1 = new JPanel();

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

            jPanel1.setPreferredSize(new java.awt.Dimension(383,29));

            jPanel1.add(jLabel5, null);

            jPanel1.add(getTxtLayerName(), null);

        }

        return jPanel1;

    }

    /**

     * @return

     */

    public Rectangle2D getWorkingArea() {

        if (getRadWorkingArea().isSelected()) {

            return new Rectangle2D.Double(

                    Double.parseDouble(getTxtMinX().getText()),

                    Double.parseDouble(getTxtMinY().getText()),

                    Double.parseDouble(getTxtMaxX().getText()) - Double.parseDouble(getTxtMinX().getText()),

                    Double.parseDouble(getTxtMaxY().getText()) - Double.parseDouble(getTxtMinY().getText())

                    );

        }else{

            return null;

        }

    }

	/**

	 * This method initializes jButton	

	 * 	

	 * @return javax.swing.JButton	

	 */    

	private JButton getJButton() {

		if (jButton == null) {

			jButton = new JButton();

			jButton.setText(PluginServices.getText(this, "importar_extent")+":");

			jButton.addActionListener(new ActionListener() {

                public void actionPerformed(ActionEvent e) {

                    View v = PluginServices.getMDIManager().getActiveView();

                    com.iver.cit.gvsig.gui.View vista = (com.iver.cit.gvsig.gui.View) v;

                    Rectangle2D r = vista.getModel().getMapContext().getViewPort().getAdjustedExtent();

                    getTxtMinX().setText(Double.toString(r.getMinX()));

                    getTxtMinY().setText(Double.toString(r.getMinY()));

                    getTxtMaxX().setText(Double.toString(r.getMaxX()));

                    getTxtMaxY().setText(Double.toString(r.getMaxY()));

                }

            });

		}

		return jButton;

	}

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

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

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class UserException extends Exception {

	/**

	 * @param string

	 */

	public UserException(String string) {

		super(string);

	}

}

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

import java.awt.FlowLayout;

import java.awt.GridLayout;

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.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 JPanel jPanel = null;

    private JLabel jLabel = null;

    private JTextField txtHost = null;

    private JPanel jPanel1 = 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();

    /**

     * This is the default constructor

     */

    public ConnectionPanel() {

        super();

        initialize();

    }

    /**

     * This method initializes this

     */

    private void initialize() {

        this.setSize(400, 240);

        this.add(getJPanel(), null);

        this.add(getJPanel1(), null);

    }

    /**

     * This method initializes jPanel

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel() {

        if (jPanel == null) {

            GridLayout gridLayout1 = new GridLayout();

            gridLayout1.setRows(7);

            jLabel5 = new JLabel();

            jLabel4 = new JLabel();

            jLabel3 = new JLabel();

            jLabel2 = new JLabel();

            jLabel1 = new JLabel();

            jLabel = new JLabel();

            jPanel = new JPanel();

            jPanel.setLayout(gridLayout1);

            jPanel.setPreferredSize(new java.awt.Dimension(160,225));

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

            jLabel.setPreferredSize(new java.awt.Dimension(80, 15));

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

            jLabel.setName("jLabel");

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

            jLabel1.setPreferredSize(new java.awt.Dimension(83, 15));

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

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

            jLabel3.setName("jLabel3");

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

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

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

            jLabel4.setName("jLabel4");

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

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

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

            jLabel5.setName("jLabel5");

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

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

            jPanel.add(getJLabel6(), null);

            jPanel.add(jLabel, null);

            jPanel.add(jLabel1, null);

            jPanel.add(jLabel2, null);

            jPanel.add(jLabel3, null);

            jPanel.add(jLabel4, null);

            jPanel.add(jLabel5, null);

        }

        return jPanel;

    }

    /**

     * This method initializes txtHost

     *

     * @return javax.swing.JTextField

     */

    private JTextField getTxtHost() {

        if (txtHost == null) {

            txtHost = new JTextField();

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

            txtHost.setName("txtHost");

        }

        return txtHost;

    }

    /**

     * This method initializes jPanel1

     *

     * @return javax.swing.JPanel

     */

    private JPanel getJPanel1() {

        if (jPanel1 == null) {

            jPanel1 = new JPanel();

            jPanel1.setPreferredSize(new java.awt.Dimension(135, 225));

            FlowLayout layout = new FlowLayout();

            layout.setVgap(12);

            jPanel1.setLayout(layout);

            jPanel1.add(getCmbName(), null);

            jPanel1.add(getTxtHost(), null);

            jPanel1.add(getTxtPort(), null);

            jPanel1.add(getTxtUser(), null);

            jPanel1.add(getTxtPassword(), null);

            jPanel1.add(getTxtBD(), null);

            jPanel1.add(getCmbDriver(), null);

        }

        return jPanel1;

    }

    /**

     * 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(120, 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(120, 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(120, 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() {

        return new String(getTxtPassword().getPassword());

    }

    /**

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

    }

    /**

     * 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(120, 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().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);

        }

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

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

                        }

                    }

                });

        }

        return cmbName;

    }

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

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

/**

 * @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;

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

    }

}

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

import javax.swing.JPanel;

import javax.swing.DefaultListModel;

import javax.swing.JLabel;

import javax.swing.JScrollPane;

import javax.swing.JList;

import com.iver.andami.PluginServices;

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class UniqueFieldSelection extends JPanel {

	private JLabel jLabel = null;

	private JScrollPane jScrollPane = null;

	private JList lstFields = null;

	private WizardJDBC w;

	/**

	 * This is the default constructor

	 */

	public UniqueFieldSelection() {

		super();

		initialize();

	}

	/**

	 * This method initializes this

	 * 

	 * @return void

	 */

	private  void initialize() {

		jLabel = new JLabel();

		this.setSize(300,200);

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

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

		jLabel.setPreferredSize(new java.awt.Dimension(315,15));

		this.add(jLabel, null);

		this.add(getJScrollPane(), null);

		this.add(getJScrollPane(), null);

	}

	/**

	 * This method initializes jScrollPane	

	 * 	

	 * @return javax.swing.JScrollPane	

	 */    

	private JScrollPane getJScrollPane() {

		if (jScrollPane == null) {

			jScrollPane = new JScrollPane();

			jScrollPane.setViewportView(getLstFields());

			jScrollPane.setPreferredSize(new java.awt.Dimension(260,131));

		}

		return jScrollPane;

	}

	/**

	 * This method initializes jList	

	 * 	

	 * @return javax.swing.JList	

	 */    

	private JList getLstFields() {

		if (lstFields == null) {

			lstFields = new JList();

			lstFields.addListSelectionListener(new javax.swing.event.ListSelectionListener() { 

				public void valueChanged(javax.swing.event.ListSelectionEvent e) {    

					w.callStateChanged(lstFields.getSelectedIndices().length > 0);

				}

			});

		}

		return lstFields;

	}

	public void setWizard(WizardJDBC w) {

		this.w = w;

	}

	/**

	 * @param fields

	 */

	public void setFields(String[] fields) {

		DefaultListModel model = new DefaultListModel();

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

			model.addElement(fields[i]);

		}

		lstFields.setModel(model);

	}

	public String getField(){

		return (String) getLstFields().getSelectedValue();

	}

}

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

import javax.swing.JPanel;

import javax.swing.DefaultListModel;

import javax.swing.JLabel;

import javax.swing.JList;

import javax.swing.JScrollPane;

import com.iver.andami.PluginServices;

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class GeomFieldSelection extends JPanel {

	private JLabel jLabel = null;

	private JList lstFields = null;

	private JScrollPane jScrollPane = null;

	/**

	 * This is the default constructor

	 */

	public GeomFieldSelection() {

		super();

		initialize();

	}

	/**

	 * This method initializes this

	 * 

	 * @return void

	 */

	private  void initialize() {

		jLabel = new JLabel();

		this.setSize(300,200);

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

		jLabel.setPreferredSize(new java.awt.Dimension(359,15));

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

		this.add(jLabel, null);

		this.add(getJScrollPane(), null);

	}

	/**

	 * This method initializes jList	

	 * 	

	 * @return javax.swing.JList	

	 */    

	private JList getLstFields() {

		if (lstFields == null) {

			lstFields = new JList();

			lstFields.setSelectionMode(javax.swing.ListSelectionModel.SINGLE_SELECTION);

		}

		return lstFields;

	}

	/**

	 * This method initializes jScrollPane	

	 * 	

	 * @return javax.swing.JScrollPane	

	 */    

	private JScrollPane getJScrollPane() {

		if (jScrollPane == null) {

			jScrollPane = new JScrollPane();

			jScrollPane.setViewportView(getLstFields());

			jScrollPane.setPreferredSize(new java.awt.Dimension(260,131));

		}

		return jScrollPane;

	}

	public boolean done() {

		return (lstFields.getSelectedIndex() != -1);

	}

	/**

	 * @param fields

	 */

	public void setFields(String[] fields) {

		DefaultListModel model = new DefaultListModel();

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

			model.addElement(fields[i]);

		}

		lstFields.setModel(model);

	}

	public String getField(){

		return (String) getLstFields().getSelectedValue();

	}

  }

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

import java.awt.BorderLayout;

import java.awt.CardLayout;

import java.awt.FlowLayout;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.HashMap;

import javax.swing.JButton;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.gdbms.engine.data.NoSuchTableException;

import com.iver.andami.PluginServices;

import com.iver.andami.messages.NotificationManager;

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

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

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

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

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

import com.iver.cit.gvsig.gui.WizardPanel;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.StringUtilities;

import com.iver.utiles.XMLEntity;

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class WizardJDBC extends WizardPanel{

	private JPanel pnlWizard = null;

	private JPanel jPanel1 = null;

	private JButton btnBack = null;

	private JButton btnNext = null;

	private ConnectionPanel connectionPanel = null;

	private DBLayerDefinition dbLayerDefinition = null;

	private FieldSelection fieldSelection = null;

	private int step = 0;

	private final int nsteps = 5;

	private static final String CONNECTION = "conn";

	private static final String LAYER_DEFINITION = "layerdef";

	private static final String FIELD_SELECTION= "fieldsel";

	private VectorialJDBCDriver driver;

	private GeomFieldSelection geomFieldSelection = null;

	private UniqueFieldSelection uniqueFieldSelection = null;

	private HashMap settings = new HashMap();

	/**

	 * This is the default constructor

	 */

	public WizardJDBC() {

		super();

		initialize();

	}

	/**

	 * This method initializes this

	 * 

	 * @return void

	 */

	private  void initialize() {

		setTabName("JDBC");

		this.setLayout(new BorderLayout());

		this.setSize(300, 270);

		this.add(getPnlWizard(), java.awt.BorderLayout.CENTER);

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

		connectionPanel.setDrivers(getDriverNames());

		enableButtons();

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

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

                ConnectionSettings cs = new ConnectionSettings();

                cs.setFromString(servers[i]);

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

            }

            getConnectionPanel().setSettings(settings);

        } catch (NotExistInXMLEntity e) {

        }

	}

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

	}

	private void enableButtons(){

		getBtnBack().setEnabled(step > 0);

		getBtnNext().setEnabled(step < nsteps - 1);

	}

	/**

	 * This method initializes pnlWizard	

	 * 	

	 * @return javax.swing.JPanel	

	 */    

	private JPanel getPnlWizard() {

		if (pnlWizard == null) {

			pnlWizard = new JPanel();

			pnlWizard.setLayout(new CardLayout());

			pnlWizard.add(getConnectionPanel(), CONNECTION);

			pnlWizard.add(getDbLayerDefinition(), LAYER_DEFINITION);

			pnlWizard.add(getFieldSelection(), FIELD_SELECTION);

			pnlWizard.add(getGeomFieldSelection(), getGeomFieldSelection().getName());

			pnlWizard.add(getUniqueFieldSelection(), getUniqueFieldSelection().getName());

		}

		return pnlWizard;

	}

	/**

	 * This method initializes jPanel1	

	 * 	

	 * @return javax.swing.JPanel	

	 */    

	private JPanel getJPanel1() {

		if (jPanel1 == null) {

			FlowLayout flowLayout1 = new FlowLayout();

			jPanel1 = new JPanel();

			jPanel1.setLayout(flowLayout1);

			jPanel1.setPreferredSize(new java.awt.Dimension(10,25));

			flowLayout1.setHgap(0);

			flowLayout1.setVgap(4);

			jPanel1.add(getBtnBack(), null);

			jPanel1.add(getBtnNext(), null);

		}

		return jPanel1;

	}

	/**

	 * This method initializes btnBack	

	 * 	

	 * @return javax.swing.JButton	

	 */    

	private JButton getBtnBack() {

		if (btnBack == null) {

			btnBack = new JButton();

			btnBack.setText(PluginServices.getText(this, "back"));

			btnBack.setPreferredSize(new java.awt.Dimension(63,18));

			btnBack.addActionListener(new java.awt.event.ActionListener() { 

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

					step--;

					enableButtons();

					((CardLayout)pnlWizard.getLayout()).previous(pnlWizard);

				}

			});

		}

		return btnBack;

	}

	/**

	 * This method initializes btnNext	

	 * 	

	 * @return javax.swing.JButton	

	 */    

	private JButton getBtnNext() {

		if (btnNext == null) {

			btnNext = new JButton();

			btnNext.setText(PluginServices.getText(this, "next"));

			btnNext.setPreferredSize(new java.awt.Dimension(62,18));

			btnNext.addActionListener(new java.awt.event.ActionListener() { 

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

					boolean done = false;

					if (step == 0) done = connectionPanel.done();

					else if (step == 1) done = dbLayerDefinition.done();

					else if (step == 2) done = fieldSelection.done();

					else if (step == 3) done = geomFieldSelection.done();

					if (done){

						try {

							if (step == 0){

								dbLayerDefinition.setTables(getTableNames());

							    saveConnection();

							}

							else if (step == 1) {

								fieldSelection.setFields(getTableFields());

							}else if (step == 2) {

								geomFieldSelection.setFields(getFields());

							}else if (step == 3) {

								uniqueFieldSelection.setFields(getTableFields());

							}

							step++;

							enableButtons();

							((CardLayout)pnlWizard.getLayout()).next(pnlWizard);

						} catch (SQLException e1) {

							NotificationManager.addError("No se pudieron obtener los metadatos de la base de datos", e1);

						} catch (DriverLoadException e1) {

							NotificationManager.addError("No se pudo cargar el driver", e1);

						}

					}else{

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

					}

				}

			});

		}

		return btnNext;

	}

    private void saveConnection() {

        ConnectionSettings cs = new ConnectionSettings();

        cs.setDb(connectionPanel.getDBName());

        cs.setDriver(connectionPanel.getDriver());

        cs.setHost(connectionPanel.getHost());

        cs.setPort(connectionPanel.getPort());

        cs.setUser(connectionPanel.getUser());

        cs.setName(connectionPanel.getSettingsName());

      //  if (settings.get(connectionPanel.getSettingsName())== null){

            settings.put(connectionPanel.getSettingsName(), cs);

    //        connectionPanel.setSettings(settings);

        //}

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

		}

		ps.setPersistentXML(xml);

    }

    private String[] getTableNames() throws SQLException, DriverLoadException {

		Connection c = DriverManager.getConnection(getConnectionString(), connectionPanel.getUser(),

				connectionPanel.getPassword());