Java JDBC MySQL Connection getGoogleCloudDBConnection()

Description

get Google Cloud DB Connection

License

Apache License

Declaration

public static Connection getGoogleCloudDBConnection() throws Exception 

Method Source Code

//package com.java2s;
/*//from w ww.ja  v  a 2s  .c om
 * Copyright (c) 2011 Google Inc.
 *
 * 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 {
    public static Connection getGoogleCloudDBConnection() throws Exception {

        Class.forName("com.mysql.jdbc.Driver").newInstance();
        Connection conn = null;

        try {
            String url = "jdbc:mysql://173.194.248.217:3306/USM Marketing Intelligence Database";
            String user = "crgrass";
            String pass = "Swan!1dive";
            conn = DriverManager.getConnection(url, user, pass);

        } catch (SQLException ex) {
            //handle any errors
            System.out.println("SQLException: " + ex.getMessage());
            System.out.println("SQLState: " + ex.getSQLState());
            System.out.println("VendorError: " + ex.getErrorCode());
        }

        return conn;
    }
}

Related

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