java - 找不到适合 jdbc 的驱动程序

Question

这是我第一次在 Java 中做 sql 工作，我所做的只是编写一个简单的程序来打开和关闭连接

package exercises;

import java.sql.*;

public class JdbcEx1 {
    static Connection conn = null;
    static String dbURL = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
    static String user = "labs";
    static String password = "labs";

    public JdbcEx1() {}

    public static void main (String args[]) throws SQLException {

        try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
        } catch (ClassNotFoundException e){
            System.err.println(e.getMessage());
        }

        try {
            conn = DriverManager.getConnection(dbURL, user, password);
            conn.clearWarnings();
            System.out.println("Connection opened! for driver ==>Oracle 11XE");
        } catch (SQLException e) {
            System.err.println(e.getMessage());
        } finally {
            if(!conn.isClosed()) {
                conn.close();
                System.out.println("Connection Close! Oracle");
            }
        }

    }
}

每当我尝试运行它时，我都会收到以下错误:

oracle.jdbc.driver.OracleDriver找不到适合 jdbc:oracle:thin:@127.0.0.1:1521:XE 的驱动程序

我真的不知道发生了什么事，我已经尝试用调试器多次运行它，但这让我更加困惑

Answer 1

你指出的ojdbc6.jar文件的路径:

C:\Program Files\Java\jre1.8.0_60\lib\ext ,

必须在环境变量 CLASSPATH 中指定。

You need to have the ojdbc6.jar in your classpath environment variable in order to have JDBC 4.0 standard support.