Java JDBC SQLServer Connection getConnection()

Description

Returns a connection for database.

License

Apache License

Declaration

public static Connection getConnection() 

Method Source Code

//package com.java2s;
/*******************************************************************************
 * Copyright 2012 Persistent Systems Ltd.
 * //www.  j a  va  2 s  .c o m
 * 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.
 ******************************************************************************/

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

public class Main {
    /**
     * Returns a connection for database.
     * 
     * @return
     */
    public static Connection getConnection() {
        Connection connection = null;

        try {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
            connection = DriverManager.getConnection(
                    "jdbc:sqlserver://<server>.database.windows.net;databaseName=Company", "<user>@<server>",
                    "<password>");
        } catch (InstantiationException e) {
            e.printStackTrace();
        } catch (IllegalAccessException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return connection;
    }
}

Related

1. GetConnection()
2. getConnection()