如何连接甲骨文数据库

Question

在这里，我正在尝试将安装在本地机器中的预言机与DSN bam连接。我得到了java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver例外。任何人请帮助我解决此问题。

public class JdbcConnectionExample {
    public static void main(String[] args) {
        // TODO Auto-generated method stub
         try {
                Class.forName("oracle.jdbc.driver.OracleDriver");
                Connection con = DriverManager
                    .getConnection("jdbc:oracle:thin:@localhost:1521:bam"
                        ,"system","tiger");
                Statement stmt = con.createStatement();
                System.out.println("Created DB Connection....");
                ResultSet rs = stmt.executeQuery("select * from tt");
                while(rs.next()){
                    System.out.println(rs.getString("ename"));
                    System.out.println(rs.getInt("age"));
                }
                rs.close();
                con.close();
            } catch (ClassNotFoundException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
    }
 }

日志在这里

java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
    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 com.bam.sqlex.JdbcConnectionExample.main(JdbcConnectionExample.java:14)

Answer 1

可能是你还没有从这里添加 oracle 驱动程序下载 jar 的 jar

Answer 2

java.lang.ClassNotFoundException： oracle.jdbc.driver.OracleDriver

毫无疑问，您缺少Oralce罐子，请将其纳入您的项目

Answer 3

Class.forName("oracle.jdbc.driver.OracleDriver");

您必须检查此类是否已添加到类路径中。