package com.briup.jdbc;

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

/**
 * Created by shuai
 * on 2017/8/17.
 */
public class JDBCTest {
    public static void main(String[] args) {

        Connection conn;

        try {
            // 1.注冊驅(qū)動
            Class.forName("oracle.jdbc.driver.OracleDriver");

            // 2.創(chuàng)建連接 url 數(shù)據(jù)庫的連接實例
            conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.102:1521:XE", "briup", "briup");

            System.out.println(conn);

        } catch (Exception e) { // 因為異常往上拋
            e.printStackTrace();
        }
    }
}

java.sql.SQLException: Io 異常: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:441)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:247)
    at com.briup.jdbc.JDBCTest.main(JDBCTest.java:20)

url 完全正確的情況下 只要關(guān)閉 虛擬機中 windows 防火墻就可以了

oracle.jdbc.driver.T4CConnection@61e4705b

Process finished with exit code 0

可以在命令行測試連接

ShuaideMacBook-Pro:~ shuai$ telnet 192.168.1.102 1521
Trying 192.168.1.102...
Connected to 192.168.1.102.
Escape character is '^]'.

Mac 在 windows 虛擬機中配置 oracle