org.kuali.test.ui.components.dialogs.DatabaseDlg.java Source code

Introduction

Here is the source code for org.kuali.test.ui.components.dialogs.DatabaseDlg.java

Source

/*
 * Copyright 2014 The Kuali Foundation
 * 
 * Licensed under the Educational Community License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 * 
 * http://www.opensource.org/licenses/ecl2.php
 * 
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

package org.kuali.test.ui.components.dialogs;

import java.awt.BorderLayout;
import java.awt.Dimension;
import javax.swing.JCheckBox;
import javax.swing.JComboBox;
import javax.swing.JComponent;
import javax.swing.JPasswordField;
import javax.swing.JTextField;
import org.apache.commons.lang3.StringUtils;
import org.kuali.test.DatabaseConnection;
import org.kuali.test.DatabaseType;
import org.kuali.test.creator.TestCreator;
import org.kuali.test.ui.base.BaseSetupDlg;
import org.kuali.test.ui.utils.UIUtils;
import org.kuali.test.utils.Utils;

/**
 *
 * @author rbtucker
 */
public class DatabaseDlg extends BaseSetupDlg {
    private DatabaseConnection dbconnection;
    private JTextField name;
    private JTextField url;
    private JTextField schema;
    private JTextField driver;
    private JTextField username;
    private JPasswordField password;
    private JComboBox type;
    private JCheckBox configuredTablesOnly;

    /**
     * 
     * Creates new form PlatformDlg
     * @param mainFrame
     */
    public DatabaseDlg(TestCreator mainFrame) {
        this(mainFrame, null);
    }

    /**
     * Creates new form DatabaseDlg
     * @param mainFrame
     * @param dbconnection
     */
    public DatabaseDlg(TestCreator mainFrame, DatabaseConnection dbconnection) {
        super(mainFrame);
        this.dbconnection = dbconnection;
        if (dbconnection != null) {
            setTitle("Edit database connection " + dbconnection.getName());
            setEditmode(true);
        } else {
            setTitle("Add new database connection");
            this.dbconnection = DatabaseConnection.Factory.newInstance();
            this.dbconnection.setName("new database connection");
            this.dbconnection.setType(DatabaseType.ORACLE);
        }

        initComponents();
    }

    @SuppressWarnings("unchecked")
    private void initComponents() {

        String[] labels = { "Name", "DB Type", "Connection URL", "Driver", "Schema", "User Name", "Password", "" };

        name = new JTextField(dbconnection.getName(), 20);
        name.setEditable(!isEditmode());

        type = new JComboBox(Utils.getXmlEnumerations(DatabaseType.class));
        type.setSelectedItem(dbconnection.getType());
        url = new JTextField(dbconnection.getJdbcUrl(), 30);
        driver = new JTextField(dbconnection.getJdbcDriver(), 30);
        schema = new JTextField(dbconnection.getSchema(), 15);
        username = new JTextField(dbconnection.getUsername(), 20);

        String pass = "";

        if (StringUtils.isNotBlank(dbconnection.getPassword())) {
            try {
                pass = Utils.decrypt(getMainframe().getEncryptionPassword(), dbconnection.getPassword());
            }

            catch (Exception ex) {
                UIUtils.showError(this, "Decrypt Exception", "Password decryption failed");
                pass = "";
            }
        }

        password = new JPasswordField(pass, 20);

        configuredTablesOnly = new JCheckBox("Configured Tables Only");

        configuredTablesOnly.setSelected(dbconnection.getConfiguredTablesOnly());

        JComponent[] components = { name, type, url, driver, schema, username, password, configuredTablesOnly };

        getContentPane().add(UIUtils.buildEntryPanel(labels, components), BorderLayout.CENTER);

        addStandardButtons();
        setDefaultBehavior();
    }

    /**
     *
     * @return
     */
    @Override
    protected boolean save() {
        boolean retval = false;
        try {
            boolean oktosave = true;
            if (StringUtils.isNotBlank(name.getText()) && StringUtils.isNotBlank(url.getText())
                    && StringUtils.isNotBlank(schema.getText()) && StringUtils.isNotBlank(username.getText())
                    && StringUtils.isNotBlank(password.getText()) && StringUtils.isNotBlank(driver.getText())) {

                if (!isEditmode()) {
                    if (databaseConnectionNameExists()) {
                        oktosave = false;
                        displayExistingNameAlert("Database Connection", name.getText());
                    }
                }
            } else {
                displayRequiredFieldsMissingAlert("Database Connection",
                        "name, type, url, driver, schema, user name, password");
                oktosave = false;
            }

            if (oktosave) {
                if (!isEditmode()) {
                    dbconnection = getConfiguration().getDatabaseConnections().addNewDatabaseConnection();
                }

                dbconnection.setName(name.getText());
                dbconnection.setJdbcUrl(url.getText());
                dbconnection.setJdbcDriver(driver.getText());
                dbconnection.setSchema(schema.getText());
                dbconnection.setUsername(username.getText());
                dbconnection.setPassword(Utils.encrypt(getMainframe().getEncryptionPassword(), password.getText()));
                dbconnection.setConfiguredTablesOnly(configuredTablesOnly.isSelected());
                dbconnection.setType(DatabaseType.Enum.forString(type.getSelectedItem().toString()));

                setSaved(true);
                getConfiguration().setModified(true);
                dispose();
                retval = true;
            }
        }

        catch (Exception ex) {
            UIUtils.showError(this, "Save Error",
                    "Error occurred while attempting to save database connection - " + ex.toString());
        }

        return retval;
    }

    private boolean databaseConnectionNameExists() {
        boolean retval = false;
        String newname = name.getText();

        for (String nm : getDatabaseConnectionNames()) {
            if (nm.equalsIgnoreCase(newname)) {
                retval = false;
                break;
            }
        }

        return retval;
    }

    /**
     *
     * @return
     */
    @Override
    public Object getNewRepositoryObject() {
        return dbconnection;
    }

    /**
     *
     * @return
     */
    @Override
    protected String getDialogName() {
        return "database-connection-setup";
    }

    @Override
    public Dimension getPreferredSize() {
        return new Dimension(600, 450);
    }

}