org.jdal.db.DatabaseManager.java Source code

Introduction

Here is the source code for org.jdal.db.DatabaseManager.java

Source

/*
 * Copyright 2009-2012 the original author or authors.
 *
 * Licensed under the Apache 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.apache.org/licenses/LICENSE-2.0
 *
 * 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.jdal.db;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.util.Properties;

import javax.swing.JOptionPane;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.jdal.swing.ViewDialog;

/**
 * @author Jose Luis Martin - (jlm@joseluismartin.info)
 *
 */
public class DatabaseManager {

    private static final Log log = LogFactory.getLog(DatabaseManager.class);

    private String applicationName;

    /**
     * @param applicationName
     */
    public DatabaseManager(String applicationName) {
        this.applicationName = applicationName;
    }

    public DbConnection getDbConnection(String path) {
        File properties = new File(path);
        Properties prop = new Properties();
        DbConnection conn = new DbConnection();

        try {
            if (!properties.exists())
                if (!properties.createNewFile())
                    return null;

            prop.load(new FileInputStream(properties));
            conn.fromProperties(prop);

            if (conn.test()) // Connection OK
                return conn;

            while (askToCreateConnection() && createConnection(conn) != null) {
                if (conn.test()) {
                    prop = conn.toProperties();
                    prop.store(new FileOutputStream(properties), "");
                    return conn;
                }
            }

        } catch (Exception e) {
            log.error(e);
        }
        // failed
        return null;
    }

    public DbConnection createConnection() {
        return createConnection(new DbConnection());
    }

    public DbConnection createConnection(DbConnection conn) {
        DbConnectionForm dbf = new DbConnectionForm(conn);
        dbf.init();
        ViewDialog<DbConnection> dlg = new ViewDialog<DbConnection>();
        dlg.setView(dbf);
        dlg.init();
        dlg.setSize(500, 400);
        dlg.setModal(true);
        dlg.setVisible(true);

        if (dlg.getValue() != ViewDialog.OK)
            return null;

        return dlg.getModel();
    }

    /**
     * @return true if user want to create a new database configuration.
     */
    public boolean askToCreateConnection() {
        return JOptionPane.showConfirmDialog(null, "There isn't a database connection configured for "
                + applicationName
                + "\nor configuration is not working.\nDo you want to create one now ?") == JOptionPane.OK_OPTION;
    }

}