Application: gvSIG desktop

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

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://maven.apache.org/POM/4.0.0

                      http://maven.apache.org/xsd/maven-4.0.0.xsd">

    <modelVersion>4.0.0</modelVersion>

    <artifactId>org.gvsig.geodb</artifactId>

    <packaging>jar</packaging>

    <version>2.0-SNAPSHOT</version>

    <name>Database connectors</name>

    <description>Connection manager to spatial databases.

 - PostgreSQL

 - MySQL

 - H2</description>

    <parent>

        <groupId>org.gvsig</groupId>

        <artifactId>gvsig-base-extension-pom</artifactId>

        <version>2.0-SNAPSHOT</version>

    </parent>

    <dependencies>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal</artifactId>

            <classifier>spi</classifier>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.metadata.lib.basic.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db</artifactId>

            <classifier>store.jdbc</classifier>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db</artifactId>

            <classifier>store.postgresql</classifier>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.dal.db</artifactId>

            <classifier>store.mysql</classifier>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.ui</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.app</artifactId>

            <version>2.0-SNAPSHOT</version>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.app.document.table.app.mainplugin</artifactId>

            <version>2.0.0-SNAPSHOT</version>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.about.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.andami</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.utils</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.mapcontext</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.geometry</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.tools.lib</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.projection</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.fmap.control</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.personaldb.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.personaldb.lib.impl</artifactId>

            <scope>compile</scope>

        </dependency>    

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.timesupport.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>    

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>commons-collections</groupId>

            <artifactId>commons-collections</artifactId>

            <scope>compile</scope>

        </dependency>	

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.i18n</artifactId>

            <scope>compile</scope>

        </dependency>   

    </dependencies>

    <properties>

        <build-dir>${basedir}/../build</build-dir>

        <eclipse.project.name>extGeoDB</eclipse.project.name>

        <package.info.dependencies>required: org.gvsig.app.document.table.app.mainplugin -ge 2</package.info.dependencies>

        <package.info.state>testing</package.info.state>

        <!-- alpha-devel -->

        <package.info.categories>Formats,Database</package.info.categories>

    </properties>

    <build>

        <sourceDirectory>src</sourceDirectory>

        <!-- <testSourceDirectory>src-test</testSourceDirectory> -->

        <plugins>

            <!-- TODO: MAKE TESTS WORK AND REMOVE THIS OPTION -->

            <plugin>

                <groupId>org.apache.maven.plugins</groupId>

                <artifactId>maven-surefire-plugin</artifactId>

                <configuration>

                    <skipTests>true</skipTests>

                </configuration>

            </plugin>

        </plugins>

    </build>

</project>

#Translations for language [es]

more_provider_parameters_needed_message=El driver seleccionado necesita par?metros adicionales.\nA continuaci?n se abrir? el editor de propiedades avanzado.

more_provider_parameters_needed_title=Par?metros adicionales requeridos

_Advanced_properties=Propiedades avanzadas

_Get_view_extent=Capturar extensi?n de la vista

#Translations for language [en]

more_provider_parameters_needed_message=The selected driver requires more additional parameters.\nNext the advanced properties editor will be opened.

more_provider_parameters_needed_title=More parameters required

_Advanced_properties=Advanced properties

_Get_view_extent=Get view extent

<assembly>

	<id>distribution</id>

	<formats>

		<format>dir</format>

	</formats>

	<fileSets>

	<!-- Extructure for the extension -->

		<fileSet>

			<directory>config</directory>

			<outputDirectory>${extension.install.dir.name}</outputDirectory>

		</fileSet>

		<fileSet>

			<directory>images</directory>

			<outputDirectory>/${extension.install.dir.name}/images

			</outputDirectory>

		</fileSet>

        <fileSet>

            <directory>resources</directory>

            <outputDirectory>${extension.install.dir.name}</outputDirectory>

        </fileSet>

	</fileSets>

    <files>

        <file>

            <source>package.info</source>

            <outputDirectory>${extension.install.dir.name}

            </outputDirectory>

        </file>

    </files>

	<!--

		***********************************************************************

	-->

  <!-- *													   *-->

	<!--

		***********************************************************************

	-->

	<dependencySets>

		<dependencySet>

			<outputDirectory>${extension.install.dir.name}/${library-dir}

			</outputDirectory>

			<includes>

				<include>org.gvsig:org.gvsig.geodb</include>

				<include>org.gvsig:org.gvsig.fmap.dal.db</include>

				<include>org.gvsig:org.gvsig.fmap.dal.db:jar:store.jdbc</include>

				<include>commons-dbcp:commons-dbcp</include>

				<include>commons-collections:commons-collections</include>

				<include>commons-pool:commons-pool</include>

				<include>org.gvsig:org.gvsig.fmap.dal.db:jar:store.postgresql</include>

				<include>postgresql:postgresql</include>

				<include>org.gvsig:org.gvsig.fmap.dal.db:jar:store.mysql</include>

				<include>mysql:mysql-connector-java</include>

				<!-- Personal DB support -->

                <include>org.gvsig:org.gvsig.personaldb*</include>

				<include>com.h2database:h2</include>

			</includes>

		</dependencySet>

	</dependencySets>

</assembly>

#maven.buildNumber.plugin properties file

#Tue Nov 13 15:33:11 CET 2012

buildNumber=2070

<?xml version="1.0"?>

<!--

Definitions of plugin persistence org.gvsig.geodb.  

 -->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="org.gvsig.geodb">

      <description>plugin persistence org.gvsig.geodb</description>

      <fields>

        <field name="db_connections" type="map" classOfItems="org.gvsig.fmap.dal.serverexplorer.db.DBServerExplorerParameters" mandatory="false">

          <description>Connections</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

<html>

<body>

<img src="prodevelop-logo.png"><br>

<h2>PRODEVELOP</h2>

<br>

<p>EN CONSTRUCCION</p>

</body>

</html>

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

<plugin-config>

	<libraries library-dir="lib"/>

	<depends plugin-name="org.gvsig.app"/>

    <depends plugin-name="org.gvsig.app.document.table.app.mainplugin" />

	<resourceBundle name="text"/>

	<extensions>

		<extension class-name="org.gvsig.geodb.ExtDB_Spatial"

			description="Support to access Spatial databases"

			active="true">

		</extension>		

	</extensions>

</plugin-config>

/* 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.IconThemeHelper;

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

        IconThemeHelper.registerIcon("geodb", "geodb-connection-add", this);

        IconThemeHelper.registerIcon("geodb", "geodb-advanced-properties", this);

        IconThemeHelper.registerIcon("geodb", "geodb-get-view-extent", this);

    }

    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;

/**

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

    }

}