Java JDBC Connection Create getConnection(@Nonnull String connectUrl)

Description

get Connection

License

Apache License

Declaration

public static Connection getConnection(@Nonnull String connectUrl) throws SQLException 

Method Source Code

//package com.java2s;
/*//from  ww w.  ja  v a 2s . co m
 * @(#)$Id$
 *
 * Copyright 2003-2004 The Apache Software Foundation
 * Copyright 2006-2008 Makoto YUI
 *
 * 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.
 * 
 * Contributors:
 *     Makoto YUI - ported from jakarta commons DBUtils
 */

import java.sql.Connection;
import java.sql.DriverManager;

import java.sql.SQLException;

import javax.annotation.Nonnull;
import javax.annotation.Nullable;

public class Main {
    public static Connection getConnection(@Nonnull String connectUrl, @Nullable String driverClassName,
            @Nullable String userName, @Nullable String password) throws ClassNotFoundException, SQLException {
        if (driverClassName != null) {
            Class.forName(driverClassName);
        }
        final Connection conn;
        if (userName == null) {
            conn = DriverManager.getConnection(connectUrl);
        } else {
            conn = DriverManager.getConnection(connectUrl, userName, password);
        }
        return conn;
    }

    public static Connection getConnection(@Nonnull String connectUrl, @Nullable String userName,
            @Nullable String password) throws SQLException {
        final Connection conn;
        if (userName == null) {
            conn = DriverManager.getConnection(connectUrl);
        } else {
            conn = DriverManager.getConnection(connectUrl, userName, password);
        }
        return conn;
    }

    public static Connection getConnection(@Nonnull String connectUrl) throws SQLException {
        return DriverManager.getConnection(connectUrl);
    }
}

Related

1. getConnection()
2. getConnection()
3. getConnection()
4. getConnection()
5. getConnection()
6. getConnection(final String driver, final String url)
7. getConnection(final String driverName, final String driverUrl, final String userName, final String password)
8. getConnection(final String url)
9. getConnection(final String url, final String username, final String password, final String driverClass)