Application: gvSIG desktop

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

	</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>

			</includes>

		</dependencySet>

		<dependencySet>

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

			</outputDirectory>

			<includes>

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

			</includes>

		</dependencySet>

		<dependencySet>

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

			</outputDirectory>

			<includes>

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

				<include>postgresql:postgresql</include>

			</includes>

		</dependencySet>

		<dependencySet>

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

			</outputDirectory>

			<includes>

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

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

			</includes>

		</dependencySet>		

	</dependencySets>

</assembly>

#maven.buildNumber.plugin properties file

#Tue Oct 26 12:06:59 CEST 2010

buildNumber=2020

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

<plugin-config>

	<libraries library-dir="lib"/>

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

	<resourceBundle name="text"/>

	<extensions>

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

			description="Opens DB connections manager"

			active="true">

			<menu text="Ver/gestor_db" action-command="GESTOR_VECTORIALDB" key="j"

				tooltip="abrir_gestor_de_orig_db"

				position="3"/>

		</extension>

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

			description="Support to access Spatial databases"

			active="true">

		</extension>

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

			description="Exportar a diversos formatos"

			active="true">

			<menu text="Capa/export_to/postgis" action-command="POSTGIS"/>

			<menu text="Capa/export_to/mysql" action-command="MYSQL"/>

		</extension>

	</extensions>

</plugin-config>

#

#Tue Oct 26 12:07:00 CEST 2010

state=devel

name=extGeoDB

official=true

code=org.gvsig.geodb

operating-system=all

architecture=all

java-version=j1_5

gvSIG-version=2.0.0

version=2.0-SNAPSHOT

type=plugin

build=2020

description=Base POM for all GvSIG extension projects. This pom knows\n\t\thow to build and made an extension for GvSIG. The property\n\t\t"build-dir" must be set up correctly.

/* 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.andami.plugins.Extension;

import org.gvsig.app.ApplicationLocator;

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 {

//    private DALDbLibrary dbLibrary;

//    private DBStoreLibrary dbStoreLibrary;

//	private JDBCLibrary jdbcLibrary;

//	private PostgreSQLLibrary posgresqlLibrary;

//	private MySQLLibrary mysqlLibrary;

	public void initialize() {

//    	dbLibrary = new DALDbLibrary();

//    	dbStoreLibrary = new DBStoreLibrary();

//		jdbcLibrary = new JDBCLibrary();

//		posgresqlLibrary = new PostgreSQLLibrary();

//		mysqlLibrary = new MySQLLibrary();

//

//

//		dbLibrary.initialize();

//		dbStoreLibrary.initialize();

//		jdbcLibrary.initialize();

//		posgresqlLibrary.initialize();

//		mysqlLibrary.initialize();

    }

    public void execute(String actionCommand) {

    }

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

//		dbLibrary.postInitialize();

//		dbStoreLibrary.postInitialize();

//		jdbcLibrary.postInitialize();

//		posgresqlLibrary.postInitialize();

//		mysqlLibrary.postInitialize();

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

				"DB Tables", WizardDB.class);

    	AddLayer.addWizard(WizardVectorialDB.class);

	}

}

package org.gvsig.geodb;

import java.awt.Component;

import javax.swing.JComponent;

import javax.swing.JOptionPane;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.app.project.documents.view.ViewDocument;

import org.gvsig.app.project.documents.view.gui.DefaultViewPanel;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

import org.gvsig.tools.dispose.DisposableIterator;

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

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

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

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

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

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

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

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

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

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

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorer;

import org.gvsig.fmap.dal.store.jdbc.JDBCServerExplorerParameters;

import org.gvsig.fmap.dal.store.mysql.MySQLServerExplorer;

import org.gvsig.fmap.dal.store.postgresql.PostgreSQLServerExplorer;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.mapcontext.MapContext;

import org.gvsig.fmap.mapcontext.exceptions.LoadLayerException;

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

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

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

import org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect;

import org.gvsig.geodb.vectorialdb.ConnectionSettings;

import org.gvsig.geodb.vectorialdb.DlgConnection;

import org.gvsig.tools.evaluator.AbstractEvaluator;

import org.gvsig.tools.evaluator.EvaluatorData;

import org.gvsig.tools.evaluator.EvaluatorException;

import org.gvsig.utils.PostProcessSupport;

public class ExportToDB extends Extension {

	/**

	 * @see org.gvsig.andami.plugins.IExtension#initialize()

	 */

	public void initialize() {

	}

	/**

	 * @see org.gvsig.andami.plugins.IExtension#execute(java.lang.String)

	 */

	public void execute(String actionCommand) {

		org.gvsig.andami.ui.mdiManager.IWindow f = PluginServices.getMDIManager()

				.getActiveWindow();

		if (f instanceof DefaultViewPanel) {

			DefaultViewPanel vista = (DefaultViewPanel) f;

			ViewDocument model = vista.getModel();

			MapContext mapa = model.getMapContext();

			FLayers layers = mapa.getLayers();

			FLayer[] actives = layers.getActives();

			try {

				// NOTA: SI HAY UNA SELECCI?N, SOLO SE SALVAN LOS SELECCIONADOS

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

					if (actives[i] instanceof FLyrVect) {

						FLyrVect lv = (FLyrVect) actives[i];

//						saveToDXF(mapa,lv);

						/////////

						long numSelec = ((FeatureSelection)lv.getFeatureStore().getSelection()).getSize();

						if (numSelec > 0) {

							int resp = JOptionPane.showConfirmDialog(

									(Component) PluginServices.getMainFrame(),

									PluginServices.getText(this,"se_van_a_guardar_") + numSelec

											+ PluginServices.getText(this,"features_desea_continuar"),

									PluginServices.getText(this,"export_to"), JOptionPane.YES_NO_OPTION);

							if (resp != JOptionPane.YES_OPTION) {

								continue;

							}

						} // if numSelec > 0

						// if (actionCommand.equals("SHP")) {

						// saveToSHP(mapa, lv);

						// }

						// if (actionCommand.equals("DXF")) {

						// saveToDXF(mapa, lv);

						// }

						if (actionCommand.equals("POSTGIS")) {

							saveToJDBC(mapa, lv, PostgreSQLServerExplorer.NAME);

						}

						if (actionCommand.equals("MYSQL")) {

							saveToJDBC(mapa, lv, MySQLServerExplorer.NAME);

						}

//						if (actionCommand.equals("GML")) {

//							saveToGml(mapa, lv);

//						}

					} // actives[i]

				} // for

			} catch (Exception e) {

				NotificationManager.showMessageError(e.getMessage(),e);

			}

		}

	}

	public void saveToJDBC(MapContext mapContext, FLyrVect layer,

			String explorerName) {

		try {

			String tableName = JOptionPane.showInputDialog(PluginServices

					.getText(this, "intro_tablename"));

			if (tableName == null) {

				return;

			}

			FeatureAttributeDescriptor[] pks = layer.getFeatureStore()

					.getDefaultFeatureType()

					.getPrimaryKey();

			String pkName = null;

			if (pks == null || pks.length < 1) {

				pkName = JOptionPane.showInputDialog(PluginServices.getText(this,"input_pk_field_name"));

			}

			tableName = tableName.toLowerCase();

			DlgConnection dlg = new DlgConnection();

			dlg.setModal(true);

			dlg.setVisible(true);

			ConnectionSettings cs = dlg.getConnSettings();

			if (cs == null) {

				return;

			}

			DataManager datamanager=DALLocator.getDataManager();

			JDBCServerExplorerParameters explorerParam = (JDBCServerExplorerParameters) datamanager

					.createServerExplorerParameters(explorerName);

			explorerParam.setHost(cs.getHost());

			if (cs.getPort() != null && cs.getPort().length() > 0) {

				explorerParam.setPort(Integer.valueOf(cs.getPort()));

			}

			explorerParam.setDBName(cs.getDb());

			explorerParam.setUser(cs.getUser());

			explorerParam.setPassword(cs.getPassw());

			if (cs.getSchema() != null && cs.getSchema().length() > 0) {

				explorerParam.setSchema(cs.getSchema());

			}

			JDBCServerExplorer explorer = (JDBCServerExplorer) datamanager

					.createServerExplorer(explorerParam);

			NewFeatureStoreParameters newStoreParams = (NewFeatureStoreParameters) explorer

					.getAddParameters();

			((DBStoreParameters) newStoreParams).setTable(tableName);

			if (export(explorer, newStoreParams, null, layer.getFeatureStore(),pkName)) {

				openLayer(newStoreParams, tableName, mapContext);

			}

		} catch (DataException e) {

			NotificationManager.addError(e.getMessage(), e);

		} catch (ValidateDataParametersException e) {

			NotificationManager.addError(e.getMessage(), e);

		}

	}

	class GeometryTypeEvaluator extends AbstractEvaluator{

		private FeatureType featureType=null;

		private int type=0;

		private FeatureSelection selection;

		private boolean hasSelection=false;

		public GeometryTypeEvaluator(FeatureType ft, int t, FeatureSelection selection) {

			featureType=ft;

			type=t;

			this.selection=selection;

			hasSelection=selection.getSelectedCount()>0;

			this.getFieldsInfo().addFieldValue(

					ft.getDefaultGeometryAttributeName());

		}

		public Object evaluate(EvaluatorData data) throws EvaluatorException {

			if (hasSelection){

				if (!selection.isSelected((Feature)data)){

					return false;

				}

			}

			Geometry geometry=(Geometry) data.getDataValue(featureType.getDefaultGeometryAttributeName());

			return new Boolean(geometry.getType()==type);

		}

		public String getName() {

			return "GeometryTypeEvaluator";

		}

	}

	private void openLayer(NewFeatureStoreParameters newParams, String name, MapContext mapContext) throws ReadException {

		int res = JOptionPane.showConfirmDialog(

				(JComponent) PluginServices.getMDIManager().getActiveWindow()

				, PluginServices.getText(this, "insertar_en_la_vista_la_capa_creada"),

				PluginServices.getText(this,"insertar_capa"),

				JOptionPane.YES_NO_OPTION);

		if (res == JOptionPane.YES_OPTION){

			PostProcessSupport.executeCalls();

			LayerFactory layerFactory=LayerFactory.getInstance();

			try {

				FLayer newLayer = layerFactory.getInstance().createLayer(

						name,newParams);

				mapContext.getLayers().addLayer(newLayer);

			} catch (LoadLayerException e) {

				throw new ReadException("Load layer",e);

			}

		}

	}

	private boolean export(JDBCServerExplorer explorer,

			NewFeatureStoreParameters params, FeatureSet set,

			FeatureStore featureStore, String pkName) {

		DisposableIterator it1 = null;

		FeatureStore target = null;

		try {

			EditableFeatureType fType = featureStore.getDefaultFeatureType()

					.getEditable();

			if (pkName != null) {

				EditableFeatureAttributeDescriptor pk = fType.add(pkName,

						DataTypes.LONG);

				pk.setIsPrimaryKey(true);

				pk.setIsAutomatic(true);

			}

			params.setDefaultFeatureType(fType);

			explorer.add(params.getDataStoreName(),params, true);

			DataManager manager = DALLocator.getDataManager();

			target = (FeatureStore) manager

					.createStore(params);

			FeatureType targetType = target.getDefaultFeatureType();

			target.edit(FeatureStore.MODE_APPEND);

			if (set == null) {

				set = featureStore.getFeatureSet();

			}

			it1 = set.iterator();

			while (it1.hasNext()) {

				Feature feature = (Feature) it1.next();

				target.insert(target.createNewFeature(targetType, feature));

			}

			target.finishEditing();

			return true;

		} catch (Exception e) {

			NotificationManager.showMessageError(e.getLocalizedMessage(),e);

			return false;

		} finally {

			if (it1 != null) {

				it1.dispose();

			}

			set.dispose();

			if (target != null) {

				target.dispose();

			}

		}

	}

	/**

	 * @see org.gvsig.andami.plugins.IExtension#isEnabled()

	 */

	public boolean isEnabled() {

		org.gvsig.andami.ui.mdiManager.IWindow f = PluginServices

				.getMDIManager().getActiveWindow();

		if (f == null) {

			return false;

		}

		if (!(f instanceof DefaultViewPanel)) {

			return false;

		}

		FLayers layers = ((DefaultViewPanel) f).getMapControl().getMapContext().getLayers();

		FLayer[] actives = layers.getActives();

		if (actives.length != 1) {

			return false;

		}

		if (!(actives[0] instanceof FLyrVect)) {

			return false;

		}

		return true;

	}

	/**

	 * @see org.gvsig.andami.plugins.IExtension#isVisible()

	 */

	public boolean isVisible() {

		org.gvsig.andami.ui.mdiManager.IWindow f = PluginServices.getMDIManager()

				.getActiveWindow();

		if (f == null) {

			return false;

		}

		if (f instanceof DefaultViewPanel) {

			return true;

		}

		return false;

	}

//	private int findFileByName(FieldDescription[] fields, String fieldName){

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

//        {

//        	FieldDescription f = fields[i];

//        	if (f.getFieldName().equalsIgnoreCase(fieldName))

//        	{

//        		return i;

//        	}

//        }

//

//		return -1;

//

//	}

}

/* 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 java.util.ArrayList;

import javax.swing.JOptionPane;

import org.apache.log4j.Logger;

import org.gvsig.andami.PluginServices;

import org.gvsig.andami.plugins.Extension;

import org.gvsig.geodb.vectorialdb.ConnectionSettings;

import org.gvsig.utils.NotExistInXMLEntity;

import org.gvsig.utils.XMLEntity;

/**

 * This extension allows the user to access the single connection manager dialog

 *

 * @see org.gvsig.fmap.drivers.formats.db.utils.SingleVectorialDBConnectionManager

 *

 * @author jldominguez

 *

 */

public class SingleVectorialDBConnectionExtension extends Extension {

    private static Logger logger = Logger.getLogger(SingleVectorialDBConnectionExtension.class.getName());

    /**

     * This method simply loads the connections stored in gvSIG's persistence file

     * as closed connections

     */

    public void initialize() {

        loadPersistenceConnections();

        registerIcons();

    }

    private void registerIcons(){

    	PluginServices.getIconTheme().register(

    			"conn-image",

    			this.getClass().getClassLoader().getResource("images/conn.png")

    	);

    	PluginServices.getIconTheme().register(

    			"disconn-image",

    			this.getClass().getClassLoader().getResource("images/disconn.png")

    	);

    }

    /**

     * The only command available is the one to open the connection manager

     * dialog ("GESTOR_JDBC")

     */

    public void execute(String actionCommand) {

//    	FIXME

//        if (actionCommand.compareToIgnoreCase("GESTOR_VECTORIALDB") == 0) {

//            VectorialDBConnectionManagerDialog dlg = new VectorialDBConnectionManagerDialog();

//            dlg.showDialog();

////            saveAllToPersistence();

//

//            return;

//        }

    }

    public boolean isEnabled() {

        return true;

    }

    public boolean isVisible() {

        return true;

    }

    public static void saveAllToPersistence() {

        SingleVectorialDBConnectionExtension ext=new SingleVectorialDBConnectionExtension();

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

        xml.putProperty("literalDBName",true);

        xml.remove("db-connections");

//        ConnectionWithParams[] all = SingleVectorialDBConnectionManager.instance()

//                                                                .getAllConnections();

//

//        if (all == null) {

//        	PluginServices.getPluginServices(ext).setPersistentXML(xml);

//            return;

//        }

//

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

//            addToPersistence(all[i],ext);

//        }

    }

//    private static void addToPersistence(ConnectionWithParams cwp, Extension ext) {

//        if (cwp == null) {

//            return;

//        }

//

//        ConnectionSettings _cs = new ConnectionSettings();

//

//        _cs.setHost(cwp.getHost());

//        _cs.setPort(cwp.getPort());

//        _cs.setDb(cwp.getDb());

//        _cs.setDriver(cwp.getDrvName());

//        _cs.setUser(cwp.getUser());

//        _cs.setName(cwp.getName());

//

//        String newstr = _cs.toString();

//

//        XMLEntity xml = PluginServices.getPluginServices(ext).getPersistentXML();

//

//        String[] old = null;

//

//        if (xml.contains("db-connections")) {

//            old = xml.getStringArrayProperty("db-connections");

//        }

//

//        ArrayList oldl = stringArrayToArrayList(old);

//        oldl.add(newstr);

//

//        String[] newarr = (String[]) oldl.toArray(new String[0]);

//

//        xml.remove("db-connections");

//        xml.putProperty("db-connections", newarr);

//        PluginServices.getPluginServices(ext).setPersistentXML(xml);

//    }

    private static ArrayList stringArrayToArrayList(String[] arr) {

        ArrayList resp = new ArrayList();

        if ((arr != null) && (arr.length > 0)) {

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

                resp.add(arr[i]);

            }

        }

        return resp;

    }

    private void loadPersistenceConnections() {

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

        boolean literalDBNames;

        if (!xml.contains("literalDBName")){

        	// For back compatibility

        	literalDBNames = false;

        }else{

        	// For back compatibility: Normaly always true

        	literalDBNames = xml.getBooleanProperty("literalDBName");

        }

        if (xml == null) {

            xml = new XMLEntity();

        }

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

            String[] servers = new String[0];

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

        }

        // add drivers to connection manager

        String[] servers = null;

        try {

            servers = xml.getStringArrayProperty("db-connections");

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects db-connections: " +

                e.getMessage());

            return;

        }

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

            ConnectionSettings cs = new ConnectionSettings();

            boolean params_ok = true;

            try {

            	cs.setFromString(servers[i]);

            	// For back compatibility

            	if (!literalDBNames){

            		cs.setDb(cs.getDb().toLowerCase());

            	}

            } catch (Exception ex) {

            	logger.error("Found misconfigured connection: " + servers[i]);

            	params_ok = false;

            }

            if (params_ok) {

				addDisconnected(cs);

			}

        }

        PluginServices ps= PluginServices.getPluginServices("com.iver.cit.gvsig.jdbc_spatial");

        if (ps==null) {

			return;

		}

        XMLEntity xmlJDBC =ps.getPersistentXML();

        if (xmlJDBC==null || !xmlJDBC.contains("jdbc-connections")) {

			return;

		}

//      add drivers to connection manager

        String[] serversOld = null;

        try {

            serversOld = xmlJDBC.getStringArrayProperty("jdbc-connections");

        }

        catch (NotExistInXMLEntity e) {

            System.err.println(

                "Error while getting projects jdbc-connections: " +

                e.getMessage());

            return;

        }

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

            ConnectionSettings cs = new ConnectionSettings();

            boolean params_ok = true;

            try {

            	cs.setFromString(serversOld[i]);

            	cs.setDb(cs.getDb().toLowerCase());

            } catch (Exception ex) {

            	logger.error("Found misconfigured connection: " + serversOld[i]);

            	params_ok = false;

            }

            if (params_ok) {

				addDisconnected(cs);

			}

        }

    }

    private void addDisconnected(ConnectionSettings _cs) {

//        try {

//            SingleVectorialDBConnectionManager.instance()

//                                       .getConnection(_cs.getDriver(),

//                _cs.getUser(), null, _cs.getName(), _cs.getHost(),

//                _cs.getPort(), _cs.getDb(), false);

//        }

//        catch (DBException e) {

//            System.err.println("While getting connection: " + e.getMessage());

//            showConnectionErrorMessage(e.getMessage());

//        }

    }

    private void showConnectionErrorMessage(String _msg) {

        String msg = (_msg.length() > 300) ? "" : (": " + _msg);

        String title = PluginServices.getText(this, "connection_error");

        JOptionPane.showMessageDialog(null, title + msg, title,

            JOptionPane.ERROR_MESSAGE);

    }

    public void terminate() {

    	saveAllToPersistence();

//        SingleVectorialDBConnectionManager.instance().closeAllBeforeTerminate();

    }

}

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

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

    	}