| gvSIG desktop 1

/*

 * Created on 23-abr-2004

 *

 * To change the template for this generated file go to

 * Window>Preferences>Java>Code Generation>Code and Comments

 */

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

 *

 * Copyright (C) 2004 IVER T.I. 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

 *

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *

 *   +34 963163400

 *   dac@iver.es

 */

package com.iver.cit.gvsig.gui.wizards;

import com.iver.andami.PluginServices;

import com.iver.andami.Utilities;

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

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

import com.iver.cit.gvsig.gui.wms.LayerInfo;

import com.iver.cit.gvsig.gui.wms.LayerListModel;

import com.iver.cit.gvsig.gui.wms.LayerTreeModel;

import com.iver.cit.gvsig.gui.wms.WizardData;

import com.iver.cit.gvsig.gui.wms.WizardDataSource;

import com.iver.cit.gvsig.gui.wms.WizardListener;

import com.iver.cit.gvsig.gui.wms.WizardListenerSupport;

import com.iver.utiles.NotExistInXMLEntity;

import com.iver.utiles.XMLEntity;

import com.iver.utiles.swing.JComboBox;

import org.apache.log4j.Logger;

import java.awt.geom.Rectangle2D;

import java.net.MalformedURLException;

import java.net.URL;

import java.util.ArrayList;

import java.util.HashSet;

import java.util.Iterator;

import java.util.TreeSet;

import javax.swing.DefaultComboBoxModel;

import javax.swing.DefaultListModel;

import javax.swing.JPanel;

import javax.swing.JTextField;

import javax.swing.tree.TreePath;

import javax.swing.JLabel;

import java.awt.BorderLayout;

import java.awt.CardLayout;

import java.awt.GridLayout;

import javax.swing.JPasswordField;

/**

 * DOCUMENT ME!

 *

 * @author Fernando Gonz?lez Cort?s

 */

public class JDBCWizard extends WizardPanel {

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

        private int page = 0;

        private boolean conectado = false;

        private javax.swing.JPanel jContentPane = null;

        private JComboBox cmbHost = null;

        private javax.swing.JPanel panelPage1 = null;

        private LayerListModel selectedLayersModel = new LayerListModel();

        private javax.swing.JPanel jPanel1 = null;

        private WizardListenerSupport listenerSupport = new WizardListenerSupport();

        private WizardDataSource dataSource;

        private JPanel jPanel = null;

        private JLabel jLabel = null;

        private JTextField jTxtUser = null;

        private JLabel jLabel1 = null;

        private JPasswordField jTxtPassword = null;

        private JLabel jLabel2 = null;

        private JTextField jTxtNomTabla = null;

        private JLabel jLabel3 = null;

        private JTextField jTxtSqlFields = null;

        private JLabel jLabel4 = null;

        private JTextField jTxtSqlWhere = null;

        /**

         * This is the default constructor

         */

        public JDBCWizard() {

                super();

                initialize();

        }

        /**

         * This method initializes this

         */

        private void initialize() {

                this.setSize(510, 311);

                this.setLayout(null);

                this.setPreferredSize(new java.awt.Dimension(750, 320));

                this.setVisible(true);

                this.add(getPanelPage1(), null);

                listenerSupport.callStateChanged(true);

                // activarVisualizarBotones();

        }

        /**

         * DOCUMENT ME!

         *

         * @param host DOCUMENT ME!

         */

        private void addHost(String host) {

                host = host.trim();

                DefaultComboBoxModel model = (DefaultComboBoxModel) getTxtHost()

                                                                                                                                .getModel();

                if (model.getIndexOf(host) < 0) {

                        model.addElement(host);

                        PluginServices ps = PluginServices.getPluginServices(this);

                        XMLEntity xml = ps.getPersistentXML();

                        try {

                                String[] servers = xml.getStringArrayProperty("wms-servers");

                                String[] newServers = new String[servers.length + 1];

                                System.arraycopy(servers, 0, newServers, 0, servers.length);

                                newServers[servers.length] = host;

                                xml.putProperty("jdbc-servers", newServers);

                        } catch (NotExistInXMLEntity e) {

                                xml.putProperty("jdbc-servers", new String[] { host });

                        }

                        ps.setPersistentXML(xml);

                }

        }

        /**

         * DOCUMENT ME!

         */

        private void rellenarControles() {

                try {

                        String host = cmbHost.getModel().getSelectedItem().toString();

                        // if (!host.endsWith("?")) {

                        //         host += "?";

                        // }

                        WizardData data = dataSource.detalles(new URL(host));

                        addHost(host);

                        conectado = true;

                        // activarVisualizarBotones();

                } catch (Exception e) {

                        listenerSupport.callError(e);

                }

        }

        /**

         * This method initializes txtHost

         *

         * @return javax.swing.JTextField

         */

        private javax.swing.JComboBox getTxtHost() {

                if (cmbHost == null) {

                        cmbHost = new JComboBox();

                        cmbHost.setModel(new DefaultComboBoxModel());

                        cmbHost.setPreferredSize(new java.awt.Dimension(350, 20));

                        cmbHost.setEditable(true);

                        XMLEntity xml = PluginServices.getPluginServices(this)

                                                                                  .getPersistentXML();

                        if (xml == null)

                                xml = new XMLEntity();

                        String[] servers = null;

                        if (!xml.contains("jdbc-servers")) {

                                servers = new String[2];

                                servers[0] = "jdbc:postgresql://localhost/latin1";

                                servers[1] = "jdbc:mysql://192.168.0.198/test";

                                xml.putProperty("jdbc-servers", servers);

                        }

                        try {

                                servers = xml.getStringArrayProperty("jdbc-servers");

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

                                        ((DefaultComboBoxModel) cmbHost.getModel()).addElement(servers[i]);

                                }

                        } catch (NotExistInXMLEntity e) {

                        }

                }

                return cmbHost;

        }

        /**

         * This method initializes panelPage1

         *

         * @return javax.swing.JPanel

         */

        private javax.swing.JPanel getPanelPage1() {

                if (panelPage1 == null) {

                        panelPage1 = new javax.swing.JPanel();

                        panelPage1.setLayout(new BorderLayout());

                        panelPage1.setPreferredSize(new java.awt.Dimension(480, 220));

                        panelPage1.setVisible(true);

                        panelPage1.setBounds(15, 5, 480, 262);

                        panelPage1.add(getJPanel1(), java.awt.BorderLayout.NORTH);

                        panelPage1.add(getJPanel(), java.awt.BorderLayout.CENTER);

                }

                return panelPage1;

        }

        /**

         * This method initializes jPanel1

         *

         * @return javax.swing.JPanel

         */

        private javax.swing.JPanel getJPanel1() {

                if (jPanel1 == null) {

                        jPanel1 = new javax.swing.JPanel();

                        jPanel1.add(getTxtHost(), null);

                        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(

                                        null, PluginServices.getText(this, "Cadena de conexi?n"),

                                        javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION,

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

                }

                return jPanel1;

        }

        /**

         * DOCUMENT ME!

         *

         * @param listener

         */

        public void addWizardListener(WizardListener listener) {

                listenerSupport.addWizardListener(listener);

        }

        /**

         * DOCUMENT ME!

         *

         * @param listener

         */

        public void removeWizardListener(WizardListener listener) {

                listenerSupport.removeWizardListener(listener);

        }

        /**

         * DOCUMENT ME!

         *

         * @return

         */

        public WizardDataSource getDataSource() {

                return dataSource;

        }

        /**

         * DOCUMENT ME!

         *

         * @param source

         */

        public void setDataSource(WizardDataSource source) {

                dataSource = source;

        }

        public String getUrlConnect() {

                        return cmbHost.getModel().getSelectedItem().toString();

        }

        /**

         * DOCUMENT ME!

         *

         * @return Nombre de la capa que aparece en el TOC.

         */

        public String getLayerName() {

                return jTxtNomTabla.getText();

        }

        public String getUser() {

                return jTxtUser.getText();

        }

        public String getPassword() {

                return jTxtPassword.getText();

        }

        public String getSqlFields()

        {

            return jTxtSqlFields.getText();

        }

        public String getSqlWhere()

        {

            return jTxtSqlWhere.getText();

        }

        /**

         * This method initializes jPanel        

         *         

         * @return javax.swing.JPanel        

         */    

        private JPanel getJPanel() {

                if (jPanel == null) {

                        jPanel = new JPanel();

                        jLabel = new JLabel();

                        jLabel1 = new JLabel();

                        jLabel2 = new JLabel();

                        jLabel3 = new JLabel();

                        jLabel4 = new JLabel();

                        jPanel.setLayout(null);

                        jLabel.setText("Usuario:");

                        jLabel.setName("jLabel");

                        jLabel.setSize(80, 19);

                        jLabel.setLocation(151, 12);

                        jLabel1.setBounds(149, 41, 82, 19);

                        jLabel1.setText("Contrase?a:");

                        jLabel2.setBounds(121, 67, 110, 20);

                        jLabel2.setText("Nombre de la tabla:");

                        jLabel3.setBounds(26, 96, 205, 22);

                        jLabel3.setText("Campos a recuperar (Primero the_geom):");

                        jLabel4.setBounds(125, 130, 106, 22);

                        jLabel4.setText("Cl?usula Where:");

                        jPanel.add(jLabel, null);

                        jPanel.add(getJTxtUser(), null);

                        jPanel.add(jLabel1, null);

                        jPanel.add(getJTxtPassword(), null);

                        jPanel.add(jLabel2, null);

                        jPanel.add(getJTxtNomTabla(), null);

                        jPanel.add(jLabel3, null);

                        jPanel.add(getJTxtSqlFields(), null);

                        jPanel.add(jLabel4, null);

                        jPanel.add(getJTxtSqlWhere(), null);

                }

                return jPanel;

        }

        /**

         * This method initializes jTextField        

         *         

         * @return javax.swing.JTextField        

         */    

        private JTextField getJTxtUser() {

                if (jTxtUser == null) {

                        jTxtUser = new JTextField();

                        jTxtUser.setName("jTextField");

                        jTxtUser.setColumns(0);

                        jTxtUser.setBounds(241, 12, 169, 19);

                        jTxtUser.setText("postgres");

                        jTxtUser.addFocusListener(new java.awt.event.FocusListener() { 

                                public void focusLost(java.awt.event.FocusEvent e) {

                                    listenerSupport.callStateChanged(true);

                                        System.out.println("focusLost()"); // TODO Auto-generated Event stub focusLost()

                                }

                                public void focusGained(java.awt.event.FocusEvent e) {} 

                        });

                }

                return jTxtUser;

        }

        /**

         * This method initializes jPasswordField        

         *         

         * @return javax.swing.JPasswordField        

         */    

        private JPasswordField getJTxtPassword() {

                if (jTxtPassword == null) {

                        jTxtPassword = new JPasswordField();

                        jTxtPassword.setBounds(241, 39, 169, 20);

                }

                return jTxtPassword;

        }

        /**

         * This method initializes jTextField        

         *         

         * @return javax.swing.JTextField        

         */    

        private JTextField getJTxtNomTabla() {

                if (jTxtNomTabla == null) {

                        jTxtNomTabla = new JTextField();

                        jTxtNomTabla.setBounds(241, 66, 169, 20);

                }

                return jTxtNomTabla;

        }

        /**

         * This method initializes jTextField        

         *         

         * @return javax.swing.JTextField        

         */    

        private JTextField getJTxtSqlFields() {

                if (jTxtSqlFields == null) {

                        jTxtSqlFields = new JTextField();

                        jTxtSqlFields.setBounds(241, 96, 169, 24);

                        jTxtSqlFields.setText("ASBINARY(the_geom, 'XDR')");

                }

                return jTxtSqlFields;

        }

        /**

         * This method initializes jTextField        

         *         

         * @return javax.swing.JTextField        

         */    

        private JTextField getJTxtSqlWhere() {

                if (jTxtSqlWhere == null) {

                        jTxtSqlWhere = new JTextField();

                        jTxtSqlWhere.setBounds(241, 129, 169, 24);

                }

                return jTxtSqlWhere;

        }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.gui.WizardPanel#execute()

     */

    public void execute() {

        // TODO Auto-generated method stub

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.gui.WizardPanel#getLayer()

     */

    public FLayer getLayer() {

        // TODO Auto-generated method stub

        return null;

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.gui.WizardPanel#initWizard()

     */

    public void initWizard() {

        // TODO Auto-generated method stub

    }

      }

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

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

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

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

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