Application: gvSIG desktop

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

import java.awt.Component;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.KeyEvent;

import java.awt.event.KeyListener;

import java.util.ArrayList;

import java.util.Iterator;

import java.util.List;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorer;

import org.gvsig.fmap.dal.DataServerExplorerParameters;

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

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

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

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

import org.gvsig.fmap.dal.store.oraclespatial.OracleSpatialResource;

import org.gvsig.fmap.dal.store.oraclespatial.OracleSpatialResourceParameters;

import org.gvsig.fmap.dal.store.oraclespatial.OracleSpatialServerExplorerParameters;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import com.iver.andami.PluginServices;

import com.iver.andami.messages.NotificationManager;

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

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

import com.iver.utiles.swing.JPasswordDlg;

import com.prodevelop.cit.gvsig.vectorialdb.wizard.VectorialDBConnectionParamsDialog;

/**

 * This dialog lets the user choose an available connection.

 * 

 * @author jldominguez

 * 

 */

public class OracleConnectionChooserPanel extends JPanel implements IWindow,

                ActionListener, KeyListener {

        private static Logger logger = LoggerFactory

                        .getLogger(OracleConnectionChooserPanel.class.getName());

        private DataManager manager = DALLocator.getDataManager();

        private JComboBox availableConnectionsComboBox = null;

        private JButton okButton = null;

        private JButton cancelButton = null;

        private JButton jdbcButton = null;

        private boolean okPressed = false;

        WindowInfo winfo = null;

        /**

         * This method initializes

         * 

         */

        public OracleConnectionChooserPanel() {

                super();

                initialize();

        }

        private void reloadCombo() {

                getAvailableConnectionsComboBox().removeAllItems();

                getAvailableConnectionsComboBox().addItem("");

                List<String> explorers = manager.getExplorerProviders();

                Iterator<String> iter = explorers.iterator();

                DataServerExplorerParameters exParam = null;

                String name;

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

                while (iter.hasNext()) {

                        name = iter.next();

                        try {

                                exParam = manager.createServerExplorerParameters(name);

                        } catch (DataException e) {

                                NotificationManager.addError(e);

                        }

                        if (exParam instanceof OracleSpatialServerExplorerParameters) {

                                dbExplorersNames.add(name);

                        }

                }

        }

        /**

         * This method initializes this

         * 

         */

        private void initialize() {

                winfo = new WindowInfo(WindowInfo.MODALDIALOG);

                winfo.setHeight(119 - 70);

                winfo.setWidth(395);

                winfo.setTitle(PluginServices.getText(this, "choose_connection"));

                this.setLayout(null);

                this.setSize(new java.awt.Dimension(395, 89));

                this.add(getAvailableConnectionsComboBox(), null);

                this.add(getJdbcButton(), null);

                this.add(getOkButton(), null);

                this.add(getCancelButton(), null);

                reloadCombo();

        }

        public WindowInfo getWindowInfo() {

                return winfo;

        }

        /**

         * This method initializes availableConnectionsComboBox

         * 

         * @return JComboBox

         */

        private JComboBox getAvailableConnectionsComboBox() {

                if (availableConnectionsComboBox == null) {

                        availableConnectionsComboBox = new JComboBox();

                        availableConnectionsComboBox.addActionListener(this);

                        availableConnectionsComboBox.setBounds(new java.awt.Rectangle(10,

                                        15, 371 - 31, 21));

                }

                return availableConnectionsComboBox;

        }

        /**

         * This method initializes okButton

         * 

         * @return JButton

         */

        private JButton getOkButton() {

                if (okButton == null) {

                        okButton = new JButton(PluginServices.getText(this, "ok"));

                        okButton.addActionListener(this);

                        okButton.addKeyListener(this);

                        okButton.setBounds(new java.awt.Rectangle(90, 50, 106, 26));

                }

                return okButton;

        }

        /**

         * This method initializes cancelButton

         * 

         * @return JButton

         */

        private JButton getCancelButton() {

                if (cancelButton == null) {

                        cancelButton = new JButton(PluginServices.getText(this, "cancel"));

                        cancelButton.addActionListener(this);

                        cancelButton.addKeyListener(this);

                        cancelButton.setBounds(new java.awt.Rectangle(200, 50, 106, 26));

                }

                return cancelButton;

        }

        public void actionPerformed(ActionEvent arg0) {

                Object src = arg0.getSource();

                if (src == okButton) {

                        okPressed = true;

                        PluginServices.getMDIManager().closeWindow(this);

                }

                if (src == cancelButton) {

                        okPressed = false;

                        PluginServices.getMDIManager().closeWindow(this);

                }

                if (src == availableConnectionsComboBox) {

                        OracleSpatialServerExplorerParameters selServerParams = getSelectedServerExplorerParams();

                        if (selServerParams == null) {

                                okButton.setEnabled(false);

                                return;

                        }

                        DataServerExplorer explorer = null;

                        try {

                                explorer = manager.createServerExplorer(selServerParams);

                        } catch (ValidateDataParametersException e) {

                                logger

                                                .error(

                                                                "Validate paramenters to create a Oracle server explorer",

                                                                e);

                        } catch (InitializeException e) {

                                logger.error("Creating Oracle server explorer ", e);

                        } catch (ProviderNotRegisteredException e) {

                                logger.error("Oracle Provider no registered", e);

                        }

                        if (explorer == null) {

                                if (!tryToConnect(selServerParams)) {

                                        okButton.setEnabled(false);

                                        availableConnectionsComboBox.setSelectedIndex(0);

                                        return;

                                }

                        }

                        // okButton.setEnabled(selServerParams.isConnected());

                        okButton.requestFocus();

                }

                if (src == jdbcButton) {

                        OracleSpatialServerExplorerParameters sel = addNewConnection();

                        if (sel != null) {

                                reloadCombo();

                                getAvailableConnectionsComboBox().setSelectedItem(sel);

                        }

                }

        }

        public OracleSpatialServerExplorerParameters getSelectedServerExplorerParams() {

                String servName = (String) availableConnectionsComboBox

                                .getSelectedItem();

                logger.debug("selected server name = " + servName);

                if (servName == null) {

                        return null;

                }

                OracleSpatialServerExplorerParameters params = null;

                try {

                        params = (OracleSpatialServerExplorerParameters) manager

                                        .createServerExplorerParameters(servName);

                } catch (DataException e) {

                        NotificationManager.addError(e);

                }

                return params;

        }

        public boolean isOkPressed() {

                return okPressed;

        }

        private boolean tryToConnect(

                        OracleSpatialServerExplorerParameters servParams) {

                JPasswordDlg dlg = new JPasswordDlg();

                String strMessage = PluginServices.getText(this, "conectar_jdbc");

                String strPassword = PluginServices.getText(this, "password");

                dlg.setMessage(strMessage + " [" + servParams.getJDBCDriverClassName()

                                + ", " + servParams.getHost() + ", " + servParams.getPort()

                                + ", " + servParams.getDBName() + ", " + servParams.getUser()

                                + "]. " + strPassword + "?");

                dlg.show();

                String clave = dlg.getPassword();

                if (clave == null) {

                        return false;

                }

                servParams.setPassword(clave);

                try {

                        manager.createServerExplorer(servParams);

                } catch (ValidateDataParametersException e) {

                        logger.error(

                                        "Validate paramenters to create a Oracle server explorer",

                                        e);

                        return false;

                } catch (InitializeException e) {

                        logger.error("Creating Oracle server explorer ", e);

                        return false;

                } catch (ProviderNotRegisteredException e) {

                        logger.error("Oracle Provider no registered", e);

                        return false;

                }

                return true;

        }

        private void showConnectionErrorMessage(String _msg) {

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

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

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

                                JOptionPane.ERROR_MESSAGE);

        }

        public void keyPressed(KeyEvent e) {

                Object src = e.getSource();

                if ((src == okButton) || (src == cancelButton)) {

                        ActionEvent aux = new ActionEvent(src,

                                        ActionEvent.ACTION_PERFORMED, "");

                        actionPerformed(aux);

                }

        }

        public void keyReleased(KeyEvent e) {

                // TODO Auto-generated method stub

        }

        public void keyTyped(KeyEvent e) {

                // TODO Auto-generated method stub

        }

        private OracleSpatialServerExplorerParameters addNewConnection() {

                OracleSpatialServerExplorerParameters servParams = null;

                VectorialDBConnectionParamsDialog newco = new VectorialDBConnectionParamsDialog();

                newco.showDialog();

                if (newco.isOkPressed()) {

                        String _drvname = newco.getConnectionDriverName();

                        String _host = newco.getConnectionServerUrl();

                        String _port = newco.getConnectionPort();

                        String _dbname = newco.getConnectionDBName();

                        String _user = newco.getConnectionUser();

                        String _pw = newco.getConnectionPassword();

                        String _conn_usr_name = newco.getConnectionName();

                        boolean hasToBeCon = newco.hasToBeConnected();

                        try {

                                servParams = new OracleSpatialServerExplorerParameters();

                                servParams.setJDBCDriverClassName(_drvname);

                                servParams.setUser(_user);

                                servParams.setPassword(_pw);

                                servParams.setHost(_host);                                

                                servParams.setPort(new Integer(_port));

                                servParams.setDBName(_dbname);

                                DataServerExplorer explorer = manager.createServerExplorer(servParams);

                                if(explorer == null){

                                        throw new Exception();

                                }

                        } catch (Exception e) {

                                showConnectionErrorMessage(e.getMessage(), newco);

                                return null;

                        }

                        return servParams;

                } else {

                        return null;

                }

        }

        private void showConnectionErrorMessage(String _msg, Component parent) {

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

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

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

                                JOptionPane.ERROR_MESSAGE);

        }

        private JButton getJdbcButton() {

                if (jdbcButton == null) {

                        jdbcButton = new JButton();

                        jdbcButton.addActionListener(this);

                        jdbcButton.setToolTipText(PluginServices.getText(this,

                                        "add_connection"));

                        jdbcButton.setBounds(new java.awt.Rectangle(381 - 26, 15, 26, 21));

                        String _file = createResourceUrl("images/jdbc.png").getFile();

                        jdbcButton.setIcon(new ImageIcon(_file));

                }

                return jdbcButton;

        }

        private java.net.URL createResourceUrl(String path) {

                return getClass().getClassLoader().getResource(path);

        }

        public Object getWindowProfile() {

                return WindowInfo.DIALOG_PROFILE;

        }

}