get Google Cloud DB mysql Connection - Java java.sql

Java examples for java.sql:MySQL

  1. HOME
  2. Java
  3. java.sql
  4. MySQL

Description

get Google Cloud DB mysql Connection

Demo Code

/*/*from  w  w w  .j  a v  a 2s  .c  o m*/
 * 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.
 */
//package com.java2s;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class Main {
    public static void main(String[] argv) throws Exception {
        System.out.println(getGoogleCloudDBConnection());
    }

    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/My Database";
            String user = "userName";
            String pass = "password";
            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 Tutorials