java - 找不到适用于 jdbc : oracle: thin:@localhost:1521:orcl 的合适驱动程序

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能是 on-topic在这里，这个问题的解决方式不太可能帮助 future 的读者。

已关闭 4 年前。

Improve this question

**我的JDK:**1.8.0.112

**我的神谕:**11.2.0.2 Express

**我的 IDE:**Intelij Idea 13

我的代码:

封装型号；导入java.sql.*;

公共(public)类 PersonDA {

public static void main(String[] args)throws Exception {
    Class.forName("oracle.jdbc.driver.OracleDriver");
    Connection connection=DriverManager.getConnection("jdbc: oracle: thin:@localhost:1521:orcl","*****","********");
    Statement statement= connection.createStatement();
    ResultSet resultSet= statement.executeQuery("SELECT * FROM Person");

    while (  resultSet.next()){

        System.out.println(resultSet.getString("ID"));
        System.out.println(resultSet.getString("name"));

    }
    statement.close();
    connection.close();
}

}

异常(exception):线程“main”中出现异常 java.sql.SQLException: 没有找到适合 jdbc 的驱动程序: oracle: Thin:@localhost:1521:orcl

at java.sql.DriverManager.getConnection(DriverManager.java:689)

at java.sql.DriverManager.getConnection(DriverManager.java:247)

at model.PersonDA.main(PersonDA.java:8)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)

Answer 1

更改您的网址:

"jdbc: oracle: thin:@//localhost:1521:orcl"

对此:

"jdbc:oracle:thin:@localhost:1521:orcl"