Java JDBC MySQL Connection getDBConnection(String urlFormat, String host, Integer port, String database, String user, String password)

Description

get DB Connection

License

Apache License

Parameter

Parameter	Description
urlFormat	a parameter
host	a parameter
port	a parameter
database	a parameter
user	a parameter
password	a parameter

Exception

Parameter	Description
SQLException	an exception

Declaration

public static Connection getDBConnection(String urlFormat, String host, Integer port, String database,
        String user, String password) throws SQLException 

Method Source Code

//package com.java2s;
/*/*w  ww. ja  v  a 2  s  .c  o  m*/
 * #%L
 * Util.java - method51 - University of Sussex - 2,013
 * %%
 * Copyright (C) 2013 - 2014 University of Sussex
 * %%
 * 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.
 * #L%
 */

import java.sql.*;

public class Main {
    /**
     * 
     * @param urlFormat
     * @param host
     * @param port
     * @param database
     * @param user
     * @param password
     * @return
     * @throws SQLException
     * @deprecated use {@link uk.ac.susx.tag.method51.twitter.params.MySQLConnectionParams#buildConnection()}
     */
    public static Connection getDBConnection(String urlFormat, String host, Integer port, String database,
            String user, String password) throws SQLException {
        String url;
        if (host.startsWith("jdbc:mysql://")) {
            url = host;
        } else {
            url = String.format(urlFormat, host, port, database);
        }

        return DriverManager.getConnection(url, user, password);
    }
}

Related

1. getDBConn()
2. getDbConnection()
3. getDBConnection()
4. getDBConnection(String database)
5. getDBConnection(String dbServer, String dbName, String dbUser, String dbPass)
6. getDMPConn()
7. getGoogleCloudDBConnection()
8. getIonMassList()
9. getJdbcConnection(String host, int port, String name, String user, String password)