com.commander4j.db.JDatabaseParameters.java Source code

Introduction

Here is the source code for com.commander4j.db.JDatabaseParameters.java

Source

package com.commander4j.db;

import org.apache.commons.lang3.StringUtils;

/**
 * @author David Garratt
 * 
 *         Project Name : Commander4j
 * 
 *         Filename : JDatabaseParameters.java
 * 
 *         Package Name : com.commander4j.db
 * 
 *         License : GNU General Public License
 * 
 *         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 3 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, see http://www.commander4j.com/website/license.html.
 * 
 */

public class JDatabaseParameters {

    private String jdbcDriver;

    private String jdbcUsername;

    private String jdbcPassword;

    private String jdbcPasswordEncryption;

    private String jdbcDatabaseDateTimeToken;

    private String jdbcDatabaseSelectLimit;

    private String jdbcDatabaseSchema;

    private String jdbcServer;

    private String jdbcPort;

    private String jdbcSID;

    private String jdbcDatabase;

    public JDatabaseParameters() {
        jdbcDriver = "";
        jdbcUsername = "";
        jdbcPassword = "";
        jdbcPasswordEncryption = "";
        jdbcDatabaseDateTimeToken = "";
        jdbcDatabaseSelectLimit = "";
        jdbcDatabaseSchema = "";
        jdbcServer = "";
        jdbcPort = "";
        jdbcSID = "";
        jdbcDatabase = "";
    }

    public void setjdbcDriver(String value) {
        jdbcDriver = value;
    }

    public void setjdbcUsername(String value) {
        jdbcUsername = value;
    }

    public void setjdbcPassword(String value) {
        jdbcPassword = value;
    }

    public void setjdbcPasswordEncryption(String value) {
        jdbcPasswordEncryption = value;
    }

    public void setjdbcDatabaseDateTimeToken(String value) {
        jdbcDatabaseDateTimeToken = value;
    }

    public void setjdbcDatabaseSelectLimit(String value) {
        jdbcDatabaseSelectLimit = value;
    }

    public void setjdbcDatabaseSchema(String value) {
        jdbcDatabaseSchema = com.commander4j.util.JUtility.replaceNullStringwithBlank(value);
    }

    public void setjdbcServer(String value) {
        jdbcServer = value;
    }

    public void setjdbcPort(String value) {
        jdbcPort = value;
    }

    public void setjdbcSID(String value) {
        jdbcSID = value;
    }

    public void setjdbcDatabase(String value) {
        jdbcDatabase = value;
    }

    public String getjdbcDriver() {
        return jdbcDriver;
    }

    public String getjdbcUsername() {
        return jdbcUsername;
    }

    public String getjdbcPassword() {
        return jdbcPassword;
    }

    public String getjdbcPasswordEncryption() {
        return jdbcPasswordEncryption;
    }

    public String getjdbcConnectString() {

        String value = "";

        if (getjdbcDriver().equals("com.mysql.cj.jdbc.Driver")) {
            if (getjdbcPort().equals("")) {
                value = "jdbc:mysql://jdbcServer/jdbcDatabase?connectTimeout=5&socketTimeout=0&autoReconnect=true";
            } else {
                value = "jdbc:mysql://jdbcServer:jdbcPort/jdbcDatabase?connectTimeout=5&socketTimeout=0&autoReconnect=true";
            }
        }

        if (getjdbcDriver().equals("oracle.jdbc.driver.OracleDriver")) {
            value = "jdbc:oracle:thin:@//jdbcServer:jdbcPort/jdbcSID";
        }

        if (getjdbcDriver().equals("com.microsoft.sqlserver.jdbc.SQLServerDriver")) {

            value = "jdbc:sqlserver://jdbcServer\\jdbcSID:jdbcPort;databaseName=jdbcDatabase;selectMethod=direct";

        }

        value = value.replaceAll("jdbcServer", getjdbcServer());

        if (getjdbcPort().equals("")) {
            value = value.replaceAll(":jdbcPort", "");
        } else {
            value = value.replaceAll("jdbcPort", getjdbcPort());
        }

        if (getjdbcSID().equals("")) {
            value = StringUtils.remove(value, "\\jdbcSID");
        } else {
            value = value.replaceAll("jdbcSID", getjdbcSID());
        }

        value = value.replaceAll("jdbcDatabase", getjdbcDatabase());

        return value;
    }

    public String getjdbcDatabaseDateTimeToken() {
        return jdbcDatabaseDateTimeToken;
    }

    public String getjdbcDatabaseSelectLimit() {
        return jdbcDatabaseSelectLimit;
    }

    public String getjdbcDatabaseSchema() {
        return jdbcDatabaseSchema;
    }

    public String getjdbcServer() {
        String result = jdbcServer;
        result = StringUtils.removeIgnoreCase(result, ";selectMethod=direct");
        result = StringUtils.removeIgnoreCase(result, ";autoReconnect=true");
        return result;
    }

    public String getjdbcPort() {
        return jdbcPort;
    }

    public String getjdbcSID() {
        return jdbcSID;
    }

    public String getjdbcDatabase() {
        String result = jdbcDatabase;
        result = StringUtils.removeIgnoreCase(result, ";selectMethod=direct");
        result = StringUtils.removeIgnoreCase(result, ";autoReconnect=true");
        return result;
    }

}