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>

    <groupId>org.gvsig</groupId>

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

    <packaging>jar</packaging>

    <version>2.0-SNAPSHOT</version>

    <name>Database conectors</name>

    <description>Connection manager to spatial databases.

 - PostgreSQL

 - MySQL

 - H2</description>

    <url>http://maven.apache.org</url>

    <parent>

        <groupId>org.gvsig</groupId>

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

        <version>2.0-SNAPSHOT</version>

    </parent>

    <distributionManagement>

        <site>

            <id>gvsig-repository</id>

            <url>${site-repository}/</url>

        </site>

    </distributionManagement>

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

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

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

#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

<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

#Fri Nov 18 13:16:56 CET 2011

buildNumber=2041

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

package org.gvsig.geodb.vectorialdb;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

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

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

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

/**

 * @author Fernando Gonz?lez Cort?s

 */

public class ConnectionSettings {

    private String host;

    private String port;

    private String db;

    private String schema;

    private String driver;

    private String user;

    private String name;

    private String passw;

    public String getDb() {

        return db;

    }

    public void setDb(String db) {

        this.db = db;

    }

    public String getDriver() {

        return driver;

    }

    public void setDriver(String driver) {

        this.driver = driver;

    }

    public String getHost() {

        return host;

    }

    public void setHost(String host) {

        this.host = host;

    }

    public String getPort() {

        return port;

    }

    public void setPort(String port) {

        this.port = port;

    }

    public String getUser() {

        return user;

    }

    public void setUser(String user) {

        this.user = user;

    }

    public void setName(String name) {

        this.name = name;

    }

    public String getName() {

        return name;

    }

    public String toString(){

        return host+","+port+","+db+","+driver+","+user+","+name;

    }

    public void setFromString(String str) {

        String[] values = str.split(",");

        host = values[0];

        port = values[1];

        db = values[2];

        driver = values[3];

        user = values[4];

        name = values[5];

        if (values.length == 7) {

			passw = values[6];

		}

    }

    public String getPassw() {

        return passw;

    }

    public void setPassw(String passw) {

        this.passw = passw;

    }

    public String getConnectionString(){

    	DataManager dm=DALLocator.getDataManager();

    	try {

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

		} catch (InitializeException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (ProviderNotRegisteredException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

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

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

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

        return connectionString;

    }

	public String getSchema() {

		return schema;

	}

	public void setSchema(String schema) {

		this.schema = schema;

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.geodb.vectorialdb.wizard;

import java.awt.Point;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.KeyEvent;

import java.awt.event.KeyListener;

import java.text.DecimalFormat;

import java.text.DecimalFormatSymbols;

import java.util.ArrayList;

import java.util.List;

import javax.swing.JCheckBox;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTextArea;

import javax.swing.JTextField;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.andami.PluginServices;

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

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

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

import org.gvsig.tools.service.ServiceException;

/**

 * Utility class that holds a single table settings controls.

 *

 * @author jldominguez

 *

 */

public class UserTableSettingsPanel extends JPanel implements ActionListener,

    KeyListener {

    private static final long serialVersionUID = -9205704982299200912L;

    private static Logger LOG = LoggerFactory

			.getLogger(UserTableSettingsPanel.class);

    private FieldComboItem[] ids;

    private String initLayerName = "";

    private JComboBox idComboBox = null;

    private JTextArea sqlTextArea = null;

    private JLabel idLabel = null;

    private JLabel sqlLabel = null;

    private JCheckBox activateSQLCheckBox = null;

    protected JLabel tableNamejLabel = null;

    private JTextField layerNameTextField = null;

    private JScrollPane sqlTextAreaScroll = null;

    protected WizardDB parent = null;

	private JButton advanzedButton;

	protected DBStoreParameters parameters;

    protected UserTableSettingsPanel() {

		super();

	}

	protected void setInitValues(FieldComboItem[] idComboItems,

			String initialLayerName, boolean empty, WizardDB _p,DBStoreParameters parameters) {

        parent = _p;

        initLayerName = initialLayerName;

		ids = idComboItems;

		this.parameters = parameters;

	}

    public UserTableSettingsPanel(FieldComboItem[] idComboItems,

        String initialLayerName, boolean empty, WizardDB _p,

			DBStoreParameters parameters) {

		setInitValues(idComboItems, initialLayerName, empty, _p, parameters);

        initialize(empty);

    }

    public boolean hasValidValues() {

        if (!combosHaveItems()) {

            return false;

        }

        if ((activateSQLCheckBox.isSelected()) &&

                (getSqlTextArea().getText().trim().length() == 0)) {

            return false;

        }

        if (getLayerNameTextField().getText().trim().length() == 0) {

            return false;

        }

        return true;

    }

    protected void initialize(boolean _empty) {

        tableNamejLabel = new JLabel();

        tableNamejLabel.setText(PluginServices.getText(this, "name"));

        tableNamejLabel.setSize(new java.awt.Dimension(86, 21));

        tableNamejLabel.setLocation(new java.awt.Point(5, 25));

        sqlLabel = new JLabel();

        // sqlLabel.setBounds(new java.awt.Rectangle(30, 90, 116, 21));

		sqlLabel.setBounds(new java.awt.Rectangle(30, 55, 116, 21));

        sqlLabel.setText(PluginServices.getText(this, "sql_restriction"));

        idLabel = new JLabel();

        // idLabel.setBounds(new java.awt.Rectangle(5, 55, 86, 21));

		idLabel.setBounds(new java.awt.Rectangle(260, 25, 86, 21));

        idLabel.setText(PluginServices.getText(this, "id_field"));

        setLayout(null);

        setBounds(new java.awt.Rectangle(3, 225, 501, 246));

        setBorder(javax.swing.BorderFactory.createTitledBorder(null,

                PluginServices.getText(this, "specify_table_settings"),

                javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

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

        add(getIdComboBox(), null);

        add(getSqlTextAreaScroll(), null);

        add(idLabel, null);

        add(sqlLabel, null);

        add(getActivateSQLCheckBox(), null);

        add(getLayerNameTextField(), null);

        add(tableNamejLabel, null);

        add(getAdvancedButton(), null);

        loadValues(_empty);

    }

    public void enableAlphaControls(boolean enable) {

        getIdComboBox().setEnabled(enable);

        getLayerNameTextField().setEnabled(enable);

        getSqlTextArea().setEnabled(enable);

        getActivateSQLCheckBox().setEnabled(enable);

        getAdvancedButton().setEnabled(enable);

    }

    public void enableSpatialControls(boolean enable) {

    }

    public void loadValues() {

        loadValues(false);

    }

    protected void loadValues(boolean is_empty) {

        if (is_empty) {

            enableAlphaControls(false);

            enableSpatialControls(false);

            getLayerNameTextField().setText("");

            getActivateSQLCheckBox().setSelected(false);

        }

        else {

            enableAlphaControls(true);

			enableSpatialControls(true);

			getActivateSQLCheckBox().setEnabled(true);

            getIdComboBox().removeAllItems();

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

                getIdComboBox().addItem(ids[i]);

            }

            getLayerNameTextField().setText(initLayerName);

        }

    }

    private JComboBox getIdComboBox() {

        if (idComboBox == null) {

            idComboBox = new JComboBox();

            // idComboBox.setBounds(new java.awt.Rectangle(105, 55, 126, 21));

			idComboBox.setBounds(new java.awt.Rectangle(351, 25, 134, 21));

        }

        return idComboBox;

    }

    private JButton getAdvancedButton() {

    	if (advanzedButton == null) {

			advanzedButton = new JButton();

			advanzedButton.setLocation(new Point(350, 110));

			advanzedButton.setText(PluginServices.getText(this,

					"advanced_properties"));

			advanzedButton.addActionListener(this);

		}

		return advanzedButton;

	}

    private JCheckBox getActivateSQLCheckBox() {

        if (activateSQLCheckBox == null) {

            activateSQLCheckBox = new JCheckBox();

            activateSQLCheckBox.addActionListener(this);

            //activateSQLCheckBox

					//.setBounds(new java.awt.Rectangle(5, 90, 21, 21));

			activateSQLCheckBox

					.setBounds(new java.awt.Rectangle(5, 55, 21, 21));

        }

        return activateSQLCheckBox;

    }

    private JTextField getLayerNameTextField() {

        if (layerNameTextField == null) {

            layerNameTextField = new JTextField();

            layerNameTextField.setSize(new java.awt.Dimension(118, 21));

			// layerNameTextField.setLocation(new java.awt.Point(105, 25));

			layerNameTextField.setLocation(new java.awt.Point(120, 25));

            layerNameTextField.addKeyListener(this);

        }

        return layerNameTextField;

    }

    private JTextArea getSqlTextArea() {

        if (sqlTextArea == null) {

            sqlTextArea = new JTextArea();

            sqlTextArea.setLineWrap(true);

            sqlTextArea.setWrapStyleWord(true);

            sqlTextArea.addKeyListener(this);

            // sqlTextArea.setBounds(new java.awt.Rectangle(160,90,326,41));

        }

        return sqlTextArea;

    }

    private JScrollPane getSqlTextAreaScroll() {

        if (sqlTextAreaScroll == null) {

            sqlTextAreaScroll = new JScrollPane();

            // sqlTextAreaScroll.setBounds(new java.awt.Rectangle(160, 90, 326,

			// 41));

			sqlTextAreaScroll

					.setBounds(new java.awt.Rectangle(160, 55, 326, 41));

            sqlTextAreaScroll.setViewportView(getSqlTextArea());

            sqlTextAreaScroll.updateUI();

        }

        return sqlTextAreaScroll;

    }

    public void actionPerformed(ActionEvent e) {

        Object src = e.getSource();

        if (src == activateSQLCheckBox) {

            enableSQLSettings(activateSQLCheckBox.isSelected());

            parent.checkFinishable();

        } else if (src == advanzedButton) {

        	List<String> toHide = new ArrayList<String>();

			toHide.add(DBStoreParameters.PASSWORD_PARAMTER_NAME);

			toHide.add(DBStoreParameters.HOST_PARAMTER_NAME);

			toHide.add(DBStoreParameters.PORT_PARAMTER_NAME);

			toHide.add(DBStoreParameters.USER_PARAMTER_NAME);

			toHide.add(DBStoreParameters.DBNAME_PARAMTER_NAME);

			toHide.add(DBStoreParameters.DEFAULTGEOMETRY_PARAMTER_NAME);

			toHide.add(DBStoreParameters.PKFIELDS_PARAMTER_NAME);

			toHide.add(DBStoreParameters.FIELDS_PARAMTER_NAME);

			toHide.add(DBStoreParameters.BASEFILTER_PARAMTER_NAME);

			toHide.add(DBStoreParameters.WORKINGAREA_PARAMTER_NAME);

			toHide.add(DBStoreParameters.TABLE_PARAMTER_NAME);

			toHide.add(DBStoreParameters.CRS_PARAMTER_NAME);

			try {

				parameters.validate();

			} catch (Exception ex) {

				// ignore... only for fill default values

			}

			try {

                DynObjectEditor editor = new DynObjectEditor(parameters);

                editor.editObject(true);

                } catch (ServiceException ex) {

                    LOG.error(

                        "Error creating a Swing component for the DynObject: "

                            + parameters, ex);

            }

			return;

        }

    }

    private void enableSQLSettings(boolean b) {

        sqlTextArea.setEnabled(b);

    }

    protected String getFormattedDouble(double d) {

        DecimalFormat df = new DecimalFormat("#.###");

        DecimalFormatSymbols dfs = new DecimalFormatSymbols();

        dfs.setDecimalSeparator('.');

        df.setDecimalFormatSymbols(dfs);

        return df.format(d);

    }

    public void keyPressed(KeyEvent e) {

    }

    public void keyReleased(KeyEvent e) {

        parent.checkFinishable();

    }

    public void keyTyped(KeyEvent e) {

    }

    public String getUserLayerName() {

        return getLayerNameTextField().getText();

    }

    public boolean combosHaveItems() {

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

            return false;

        }

        return true;

    }

    public void repaint() {

        super.repaint();

        getIdComboBox().updateUI();

    }

    public String getIdFieldName() {

        return getIdComboBox().getSelectedItem().toString();

    }

    public String getWhereClause() {

        return getSqlTextArea().getText();

    }

    public boolean isSqlActive() {

        return getActivateSQLCheckBox().isSelected();

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.geodb.vectorialdb.wizard;

import java.awt.Component;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import java.util.ArrayList;

import javax.swing.JList;

import javax.swing.ListCellRenderer;

import javax.swing.ListSelectionModel;

import javax.swing.UIManager;

import javax.swing.border.Border;

import javax.swing.border.EmptyBorder;

/**

 * Utility class to keep the list of available fields.

 *

 * @author jldominguez

 *

 */

public class AvailableFieldsCheckBoxList extends JList {

    protected static Border noFocusBorder = new EmptyBorder(1, 1, 1, 1);

    public AvailableFieldsCheckBoxList() {

        setCellRenderer(new CellRenderer());

        addMouseListener(new MouseAdapter() {

                public void mousePressed(MouseEvent e) {

                    int index = locationToIndex(e.getPoint());

                    if (index == -1) {

                        return;

                    }

                    FieldsListItem sel = (FieldsListItem) getModel()

                                                              .getElementAt(index);

                    if ((e.getClickCount() == 2) || (e.getX() < 15)) {

                        sel.setSelected(!sel.isSelected());

                    }

                }

            });

        setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

    }

    public Object[] getCheckedItems() {

        int size = getModel().getSize();

        ArrayList resp = new ArrayList();

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

            FieldsListItem item = (FieldsListItem) getModel().getElementAt(i);

            if (item.isSelected()) {

                resp.add(item);

            }

        }

        return resp.toArray();

    }

    public void checkAll(boolean b) {

        int size = getModel().getSize();

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

            FieldsListItem item = (FieldsListItem) getModel().getElementAt(i);

            item.setSelected(b);

        }

        updateUI();

    }

    protected class CellRenderer implements ListCellRenderer {

        public Component getListCellRendererComponent(JList list, Object value,

            int index, boolean isSelected, boolean cellHasFocus) {

            FieldsListItem checkbox = (FieldsListItem) value;

            checkbox.setBackground(isSelected ? getSelectionBackground()

                                              : getBackground());

            checkbox.setForeground(isSelected ? getSelectionForeground()

                                              : getForeground());

            checkbox.setEnabled(isEnabled());

            checkbox.setFont(getFont());

            checkbox.setFocusPainted(false);

            checkbox.setBorderPainted(true);

            checkbox.setBorder(isSelected

                ? UIManager.getBorder("List.focusCellHighlightBorder")

                : noFocusBorder);

            return checkbox;

        }

    }

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.geodb.vectorialdb.wizard;

import java.awt.Component;

import java.awt.event.MouseAdapter;

import java.awt.event.MouseEvent;

import javax.swing.JList;

import javax.swing.JOptionPane;

import javax.swing.ListCellRenderer;

import javax.swing.ListSelectionModel;

import javax.swing.UIManager;

import javax.swing.border.Border;

import javax.swing.border.EmptyBorder;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.gvsig.andami.PluginServices;

/**

 * Utility class to keep the list of available tables.

 *

 * @author jldominguez

 *

 */

public class AvailableTablesCheckBoxList extends JList {

    protected static Border noFocusBorder = new EmptyBorder(1, 1, 1, 1);

    private static final Logger LOG = LoggerFactory

        .getLogger(AvailableTablesCheckBoxList.class);

    private WizardDB parent = null;

    private TablesListItem actingTable = null;

    public AvailableTablesCheckBoxList(WizardDB p) {

        parent = p;

        setCellRenderer(new CellRenderer());

        addMouseListener(new MouseAdapter() {

                public void mousePressed(MouseEvent e) {

                    int index = locationToIndex(e.getPoint());

                    if (index == -1) {

                        return;

                    }

                    actingTable = (TablesListItem) getModel().getElementAt(index);

                    if ((e.getClickCount() == 2) || (e.getX() < 15)) {

                        if (!actingTable.isActivated()) {

                            actingTable.activate();

                        }

                        actingTable.setSelected(!actingTable.isSelected());

                        if (actingTable.isSelected()) {

                            actingTable.setEnabledPanels(true);

                        }

                        else {

                            actingTable.setEnabledPanels(false);

                        }

                        repaint();

                    }

                    try {

                        parent.setSettingsPanels(actingTable);

                        parent.checkFinishable();

                    }

                    catch (Exception e1) {

                        actingTable.setEnabledPanels(false);

                        actingTable.setSelected(false);

                    LOG.error(

                        "While setting selected table: " +

                            e1.getMessage(), e1);

                        showConnectionErrorMessage(e1.getMessage());

                    }

                }

            });

        setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

    }

    private void showConnectionErrorMessage(String _msg) {

    	if (_msg==null) {

			_msg="";

		}

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

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

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

            JOptionPane.ERROR_MESSAGE);

    }

    protected class CellRenderer implements ListCellRenderer {

        public Component getListCellRendererComponent(JList list, Object value,

            int index, boolean isSelected, boolean cellHasFocus) {

            TablesListItem checkbox = (TablesListItem) value;

            checkbox.setBackground(isSelected ? getSelectionBackground()

                                              : getBackground());

            checkbox.setForeground(isSelected ? getSelectionForeground()

                                              : getForeground());

            checkbox.setEnabled(isEnabled());

            checkbox.setFont(getFont());

            checkbox.setFocusPainted(false);

            checkbox.setBorderPainted(true);

            checkbox.setBorder(isSelected

                ? UIManager.getBorder("List.focusCellHighlightBorder")

                : noFocusBorder);

            return checkbox;

        }

    }

}

/* gvSIG. Geographic Information System of the Valencian Government

*

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

* of the Valencian Government (CIT)

*

* This program is free software; you can redistribute it and/or

* modify it under the terms of the GNU General Public License

* as published by the Free Software Foundation; either version 2

* of the License, or (at your option) any later version.

*

* This program is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program; if not, write to the Free Software

* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston,

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

package org.gvsig.geodb.vectorialdb.wizard;

import java.util.ArrayList;

import java.util.Iterator;

import org.gvsig.andami.messages.NotificationManager;

import org.gvsig.fmap.dal.DataTypes;

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

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

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

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

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

import org.gvsig.fmap.mapcontrol.MapControl;

public class TablesListItemVectorial extends TablesListItem {

	private MapControl mc;

	public TablesListItemVectorial(DBServerExplorer explorer,

			DBStoreParameters param,

			MapControl _mc, WizardVectorialDB _parent) {

		super(explorer, param, _parent);

		mc = _mc;

	}

    public UserTableSettingsPanel getUserTableSettingsPanel(String espView) {

		if (tableSettingsPanel == null) {

			String[] ids = new String[0];

			FeatureType ft = null;

			try {

				ft = explorer.getFeatureType(parameters);

			} catch (DataException e) {

				NotificationManager.addError(e);

				return null;

			}

			ArrayList auxAll = new ArrayList();

			String[] geos = new String[0];

			ArrayList auxGeo = new ArrayList();

			ArrayList auxId = new ArrayList();

			Iterator iter = ft.iterator();

			while (iter.hasNext()) {

				FeatureAttributeDescriptor dbattr = (FeatureAttributeDescriptor) iter

						.next();

				if (dbattr.getDataType().getType() == DataTypes.GEOMETRY) {

					auxGeo.add(dbattr.getName());

				}

				if (dbattr.isPrimaryKey()) {

					auxId.add(dbattr.getName());

				}

				auxAll.add(dbattr.getName());

			}

			geos = (String[]) auxGeo.toArray(new String[0]);

			if (auxId.size() > 0) {

				StringBuilder strb = new StringBuilder();

				strb.append('{');

				for (int i = 0; i < auxId.size() - 1; i++) {

					strb.append(((FeatureAttributeDescriptor) auxId.get(i))

							.getName());

					strb.append(',');

				}

				strb.append(auxId.get(auxId.size() - 1));

				strb.append('}');

				if (auxId.size() == 1) {

					auxAll.remove(auxId.get(0));

				}

				auxAll.add(0, strb.toString());

			}

			ids = (String[]) auxAll.toArray(new String[auxAll.size()]);

			int ids_size = ids.length;

			FieldComboItem[] ids_ci = new FieldComboItem[ids_size];

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

				ids_ci[i] = new FieldComboItem(ids[i]);

			}

			int geos_size = geos.length;

			FieldComboItem[] geos_ci = new FieldComboItem[geos_size];

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

				geos_ci[i] = new FieldComboItem(geos[i]);

			}

			tableSettingsPanel = new UserTableSettingsVectorialPanel(ids_ci,

					geos_ci,

					tableName, mc, false, (WizardVectorialDB) parent,

					getParameters(),

					currentProjection(espView,

							ids_ci, geos_ci));

		}

		return tableSettingsPanel;

	}

    public void setEnabledPanels(boolean b) {

    	super.setEnabledPanels(b);

		tableSettingsPanel.enableSpatialControls(b);

		tableSettingsPanel.enableAlphaControls(b);

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop and Generalitat Valenciana.

 *

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 *

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307,USA.

 *

 * For more information, contact:

 *

 *   Generalitat Valenciana

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *   +34 963862235

 *   gvsig@gva.es

 *   www.gvsig.gva.es

 *

 *    or

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.geodb.vectorialdb.wizard;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.util.ArrayList;

import javax.swing.DefaultListModel;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import org.gvsig.andami.PluginServices;

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

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

/**

 * Utility class that holds a single table field selection controls.

 *

 * @author jldominguez

 *

 */

public class UserSelectedFieldsPanel extends JPanel implements ActionListener {

    private FeatureAttributeDescriptor[] descriptors = null;

//    private String[] fieldTypes = null;

    private JScrollPane fieldsScrollPane = null;

    private AvailableFieldsCheckBoxList fieldsList = null;

    private JButton selAllFieldsButton = null;

    private JButton deselAllFieldsButton = null;

    private WizardDB parent = null;

    public UserSelectedFieldsPanel(FeatureAttributeDescriptor[] descriptors,

        boolean empty, WizardDB _p) {

        parent = _p;

        this.descriptors = descriptors;

//        fieldTypes = fTypes;

        initialize();

        if (empty) {

            enableControls(false);

        }

        else {

            setAllFieldsInTable(descriptors);

        }

    }

    public void loadValues() {

        setAllFieldsInTable(descriptors);

    }

    public String[] getUserSelectedFields(String idf, String geo) {

        String[] resp = getUserSelectedFields();

        if (idf != null) {

			resp = addBeginningIfNotContained(resp, idf);

		}

        if (geo != null) {

			resp = addBeginningIfNotContained(resp, geo);

		}

        return resp;

    }

    private String[] addBeginningIfNotContained(String[] arr, String item) {

        if (contains(arr, item)) {

            return arr;

        }

        else {

            int size = arr.length;

            String[] resp = new String[size + 1];

            resp[0] = item;

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

                resp[i + 1] = arr[i];

            }

            return resp;

        }

    }

    private String[] removeIfContained(String[] arr, String item) {

        if (!contains(arr, item)) {

            return arr;

        }

        else {

            int size = arr.length;

            ArrayList aux = new ArrayList();

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

				aux.add(arr[i]);

			}

            aux.remove(item);

            return (String[]) aux.toArray(new String[0]);

        }

    }

    private boolean contains(String[] arr, String item) {

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

            if (arr[i].compareTo(item) == 0) {

                return true;

            }

        }

        return false;

    }

    public void enableControls(boolean enable) {

        getFieldsList().setEnabled(enable);

        getSelAllFieldsButton().setEnabled(enable);

        getDeselAllFieldsButton().setEnabled(enable);

    }

    private void initialize() {

        setLayout(null);

        setBounds(new java.awt.Rectangle(255, 55, 251, 166));

        setBorder(javax.swing.BorderFactory.createTitledBorder(null,

                PluginServices.getText(this, "table_fields"),

                javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

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

        add(getFieldsScrollPane(), null);

        add(getSelAllFieldsButton(), null);

        add(getDeselAllFieldsButton(), null);

    }