Application: gvSIG desktop

package es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

import java.awt.Component;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import org.apache.log4j.Logger;

import com.iver.andami.PluginServices;

import com.iver.cit.gvsig.SingleVectorialDBConnectionExtension;

import com.iver.cit.gvsig.fmap.drivers.DBException;

import com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams;

import com.iver.cit.gvsig.fmap.drivers.db.utils.SingleVectorialDBConnectionManager;

import com.iver.utiles.swing.JPasswordDlg;

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

import jwizardcomponent.JWizardComponents;

import jwizardcomponent.JWizardPanel;

public class NewOracleSpatialTableWizard extends JWizardPanel implements ItemListener, PropertyChangeListener, ActionListener {

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

        public NewOracleSpatialTableWizard(JWizardComponents wizardComponents) {

                super(wizardComponents);

                wizardComponents.addPropertyChangeListener(this);

                initialize();

        }

        private JLabel chooseConnLabel = null;

        private JComboBox datasourceComboBox;

        private ConnectionWithParams theConnWithParams = null;

        private JButton dbButton;

        /**

         * This method initializes this

         *

         */

        private void initialize() {

                datasourceComboBox = getDatasourceComboBox();

                loadVectorialDBDatasourcesCombo();

                chooseConnLabel = new JLabel();

                chooseConnLabel.setText(PluginServices.getText(this, "choose_connection"));

                chooseConnLabel.setBounds(new java.awt.Rectangle(14,9,300,21));

                dbButton = getJdbcButton();

        this.setLayout(null);

        this.setSize(new java.awt.Dimension(358,263));

        this.add(chooseConnLabel, null);

        this.add(datasourceComboBox, null);

        this.add(dbButton, null);

        getWizardComponents().getFinishButton().setEnabled(false);

        }

        public ConnectionWithParams getConnectionWithParams() {

                return theConnWithParams;

        }

    private JComboBox getDatasourceComboBox() {

        if (datasourceComboBox == null) {

            datasourceComboBox = new JComboBox();

            datasourceComboBox.setBounds(new java.awt.Rectangle(14,32,300,22));

            datasourceComboBox.addItemListener(this);

        }

        return datasourceComboBox;

    }        

    private void loadVectorialDBDatasourcesCombo() {

        getDatasourceComboBox().removeAllItems();

        getDatasourceComboBox().addItem(new ConnectionWithParams());

        ConnectionWithParams[] conn =

                SingleVectorialDBConnectionManager.instance().getAllConnections();

        if (conn == null) {

            return;

        }

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

            getDatasourceComboBox().addItem(conn[i]);

        }

    }

        public void itemStateChanged(ItemEvent e) {

                Object src = e.getSource();

                if (src == datasourceComboBox) {

            Object sel_obj = datasourceComboBox.getSelectedItem();

            if (sel_obj == null) {

                    getWizardComponents().getFinishButton().setEnabled(false);

                    theConnWithParams = null;

                return;

            }

            if (!(sel_obj instanceof ConnectionWithParams)) {

                    getWizardComponents().getFinishButton().setEnabled(false);

                    theConnWithParams = null;

                return;

            }

            ConnectionWithParams cwp = (ConnectionWithParams) sel_obj; 

            if (cwp.isNull()) {

                    getWizardComponents().getFinishButton().setEnabled(false);

                    theConnWithParams = null;

                return;

            }

            if (!cwp.isConnected()) {

                if (!tryToConnect(cwp)) {

                        getWizardComponents().getFinishButton().setEnabled(false);

                        theConnWithParams = null;

                        datasourceComboBox.setSelectedIndex(0);

                    return;

                }

            }

            theConnWithParams = cwp;

            getWizardComponents().getFinishButton().setEnabled(true);

            datasourceComboBox.repaint();

                }

        }    

    private boolean tryToConnect(ConnectionWithParams _cwp) {

        JPasswordDlg dlg = new JPasswordDlg();

        dlg.setLocationRelativeTo((Component)PluginServices.getMainFrame());

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

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

        dlg.setMessage(strMessage + " [" + _cwp.getDrvName() + ", " +

            _cwp.getHost() + ", " + _cwp.getPort() + ", " + _cwp.getDb() +

            ", " + _cwp.getUser() + "]. " + strPassword + "?");

        dlg.setVisible(true);

        String clave = dlg.getPassword();

        if (clave == null) {

            return false;

        }

        try {

            _cwp.connect(clave);

        }

        catch (DBException e) {

            showConnectionErrorMessage(e.getMessage());

            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 propertyChange(PropertyChangeEvent evt) {

                if (evt.getPropertyName().compareToIgnoreCase(JWizardComponents.CURRENT_PANEL_PROPERTY) == 0) {

                        if (evt.getNewValue() == this) {

                                boolean valid_conn = !(theConnWithParams == null);

                                getWizardComponents().getFinishButton().setEnabled(valid_conn);

                        }

                }

        }    

    private ConnectionWithParams addNewConnection() {

        ConnectionWithParams resp = 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 {

                resp = SingleVectorialDBConnectionManager.instance()

                                                  .getConnection(_drvname,

                        _user, _pw, _conn_usr_name, _host, _port, _dbname,

                        hasToBeCon);

            }

            catch (DBException e) {

                showConnectionErrorMessage(e.getMessage());

                return null;

            }

            SingleVectorialDBConnectionExtension.saveAllToPersistence();

            return resp;

        }

        else {

            return null;

        }

    }        

    /**

     * This method initializes jdbcButton

     *

     * @return javax.swing.JButton

     */

    private JButton getJdbcButton() {

        if (dbButton == null) {

            dbButton = new JButton();

            dbButton.addActionListener(this);

            dbButton.setToolTipText(PluginServices.getText(this,

                    "add_connection"));

            dbButton.setBounds(new java.awt.Rectangle(320, 32, 26, 21));

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

            dbButton.setIcon(new ImageIcon(_file));

        }

        return dbButton;

    }

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

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

    }

        public void actionPerformed(ActionEvent e) {

                Object src = e.getSource();

        if (src == dbButton) {

            ConnectionWithParams sel = addNewConnection();

            if (sel != null) {

                loadVectorialDBDatasourcesCombo();

                getDatasourceComboBox().setSelectedItem(sel);

            }

        }

        }    

}