Application: gvSIG desktop

/*

 * To change this license header, choose License Headers in Project Properties.

 * To change this template file, choose Tools | Templates

 * and open the template in the editor.

 */

package org.gvsig.exportto.swing.prov.jdbc.panel;

import java.awt.Color;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import javax.swing.JTextField;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorerParameters;

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

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

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

public class DBConnectionPanel extends DBConnectionPanelLayout {

    Map<String, JDBCServerExplorerParameters> parameters = null;

    private static class ServerExplorerParametersComboItem {

        private JDBCServerExplorerParameters params;

        private String label;

        public ServerExplorerParametersComboItem(String label, JDBCServerExplorerParameters params) {

            this.params = params;

            this.label = label;

        }

        public ServerExplorerParametersComboItem(JDBCServerExplorerParameters params) {

            this(params.getExplorerName(), params);

        }

        public String toString() {

            return this.label;

        }

        public JDBCServerExplorerParameters getParams() {

            return this.params;

        }

    }

    public DBConnectionPanel() {

        initComponents();

    }

    public void setServerExplorerParameters(Map<String, JDBCServerExplorerParameters> parameters) {

        this.parameters = parameters;

        if (parameters == null) {

            this.lblConnectionName.setVisible(false);

            this.cboConnections.setVisible(false);

            this.botManage.setVisible(false);

            return;

        }

        Iterator<Map.Entry<String, JDBCServerExplorerParameters>> it = parameters.entrySet().iterator();

        while (it.hasNext()) {

            Map.Entry<String, JDBCServerExplorerParameters> entry = it.next();

            this.cboConnections.addItem(

                    new ServerExplorerParametersComboItem(entry.getKey(), entry.getValue())

            );

        }

        this.lblConnectionName.setVisible(true);

        this.cboConnections.setVisible(true);

        this.botManage.setVisible(true);

    }

    protected void initComponents() {

        this.cboConnections.setEditable(true);

        this.cboConnections.addItemListener(new ItemListener() {

            public void itemStateChanged(ItemEvent e) {

                onChangeConnection();

            }

        });

        this.cboConnectors.addItemListener(new ItemListener() {

            public void itemStateChanged(ItemEvent e) {

                onChangeConnector();

            }

        });

        fillConnectors();

        this.botManage.setEnabled(false); // TODO

        this.lblConnectionName.setVisible(false);

        this.cboConnections.setVisible(false);

        this.botManage.setVisible(false);

    }

    public void setServerExplorerParameters(JDBCServerExplorerParameters parameters) {

        this.txtServer.setText(parameters.getHost());

        Integer port = parameters.getPort();

        if( port == null ) {

            this.txtPort.setText("");

        } else {

            this.txtPort.setText(String.valueOf(port));

        }

        this.txtDataBase.setText(parameters.getDBName());

        this.txtUsername.setText(parameters.getUser());

        this.txtPassword.setText(parameters.getPassword());

    }

    public JDBCServerExplorerParameters getServerExplorerParameters() {

        JDBCServerExplorerParameters connector = this.getConnector();

        JDBCServerExplorerParameters params = (JDBCServerExplorerParameters) connector.getCopy();

        params.setHost(this.getServer());

        params.setPort(this.getPort());

        params.setDBName(this.getDataBaseName());

        params.setUser(this.getUsername());

        params.setPassword(this.getPassword());

        if( this.getConnectionName()!=null ) {

            this.parameters.put(this.getConnectionName(), params);

        }

        return params;

    }

    public void setConnection(JDBCServerExplorerParameters parameters) {

        this.setServerExplorerParameters(parameters);

    }

    public JDBCServerExplorerParameters getConnection() {

        return this.getServerExplorerParameters();

    }

    public void setConnectionName(String connectionName) {

        JTextField txtConnections = (JTextField) this.cboConnections.getEditor().getEditorComponent();

        txtConnections.setText(connectionName);

    }

    public String getConnectionName() {

        JTextField txtConnections = (JTextField) this.cboConnections.getEditor().getEditorComponent();

        String value = txtConnections.getText();

        return StringUtils.defaultIfBlank(value, null);

    }

    public JDBCServerExplorerParameters getConnector() {

        ServerExplorerParametersComboItem item = (ServerExplorerParametersComboItem) this.cboConnectors.getSelectedItem();

        JDBCServerExplorerParameters value = item.getParams();

        return value;

    }

    public String getConnectorName() {

        JDBCServerExplorerParameters value = this.getConnector();

        if (value == null) {

            return null;

        }

        return StringUtils.defaultIfBlank(value.getExplorerName(), null);

    }

    public String getServer() {

        return StringUtils.defaultIfBlank(this.txtServer.getText(), null);

    }

    public int getPort() {

        String svalue = StringUtils.defaultIfBlank(this.txtPort.getText(), null);

        int ivalue = -1;

        try {

            ivalue = Integer.parseInt(svalue);

        } catch (Exception ex) {

            ivalue = -1;

        }

        return ivalue;

    }

    public String getDataBaseName() {

        return StringUtils.defaultIfBlank(this.txtDataBase.getText(), null);

    }

    public String getUsername() {

        return StringUtils.defaultIfBlank(this.txtUsername.getText(), null);

    }

    public String getPassword() {

        return StringUtils.defaultIfBlank(this.txtPassword.getText(), null);

    }

    private void onChangeConnector() {

        ServerExplorerParametersComboItem item = (ServerExplorerParametersComboItem) this.cboConnectors.getSelectedItem();

        JDBCServerExplorerParameters connector = item.getParams();

        if (connector == null) {

            return;

        }

        this.setServerExplorerParameters(connector);

    }

    private void onChangeConnection() {

        ServerExplorerParametersComboItem item = (ServerExplorerParametersComboItem) this.cboConnections.getSelectedItem();

        JDBCServerExplorerParameters connection = item.getParams();

        if (connection == null) {

            return;

        }

        this.setServerExplorerParameters(connection);

    }

    private void fillConnectors() {

        DataManager dataManager = DALLocator.getDataManager();

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

        DataServerExplorerParameters params;

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

        while (it.hasNext()) {

            String explorerName = it.next();

            try {

                params = dataManager.createServerExplorerParameters(explorerName);

            } catch (DataException e) {

                continue;

            }

            if (params instanceof JDBCServerExplorerParameters) {

                JDBCServerExplorerParameters dbParams = (JDBCServerExplorerParameters) params;

                this.cboConnectors.addItem(

                        new ServerExplorerParametersComboItem(dbParams)

                );

            }

        }

    }

}