Java Oracle localhost 数据库连接(java.lang.ClassNotFoundException)

Question

我目前正在使用这个简单的代码尝试连接到我在这台计算机上的数据库(使用 Java)

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

public class Main {
public static void main(String[] argv) throws Exception {       

    String driverName = "org.gjt.mm.mysql.Driver";
    Class.forName(driverName);

    String serverName = "localhost";
    String mydatabase = "xe";
    String url = "jdbc:mysql://" + serverName + "/" + mydatabase; 

    String username = "scott";
    String password = "tiger";
    Connection connection = DriverManager.getConnection(url, username, password);
   }
 }

出于某种原因，我不明白我收到了这个错误

Exception in thread "main" java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at Main.main(Main.java:10)

我认为这些类在 ojdbc5.jar 文件中？我不太确定如何修复此错误，所以任何帮助都会很棒。

Answer 1

如果加载 Oracle 类 而不是 MySQL，您可能会更成功:

String driverName = "oracle.jdbc.driver.OracleDriver";
Class.forName(driverName);


String serverName = "localhost";
String mydatabase = "xe";
String url = "jdbc:oracle:thin:@//" + serverName + ":1521/" + mydatabase;