我是在Eclipse中先新建一个项目,再新建一个oracle数据库的连接测试的类.运行后出现如下问题: 我已经把class12.jar放到项目的lib目录下了,tomcat中项目的lib也放了.但是问题还是存在.
-----正在链接数据库-------
java.lang.ClassNotFoundException: oracle.jdbc.drive.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.web.test.main(test.java:12)
测试类代码:
package com.web;import java.sql.*; public class test { public test(){}
public static void main(String[] args) {
Connection con;
try{
System.out.println("-----正在链接数据库-------");
Class.forName("oracle.jdbc.drive.OracleDriver");
System.out.println("-------正在--链接--数据库-----");
String url = "jdbc:oracle:thin:@localhost:1521:ora9i";
con = DriverManager.getConnection(url,"system","admin");
System.out.println("已经连接到数据库...welcome...");
Statement stmt = con.createStatement();
String query = "select * from info";
stmt.execute(query);
ResultSet rs = stmt.getResultSet();
while(rs.next()){
int i = rs.getInt(1);
String name = rs.getString(2);
System.out.println(Integer.toString(i)+" "+name);
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
-----正在链接数据库-------
java.lang.ClassNotFoundException: oracle.jdbc.drive.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:200)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:188)
at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:276)
at java.lang.ClassLoader.loadClass(ClassLoader.java:251)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.web.test.main(test.java:12)
测试类代码:
package com.web;import java.sql.*; public class test { public test(){}
public static void main(String[] args) {
Connection con;
try{
System.out.println("-----正在链接数据库-------");
Class.forName("oracle.jdbc.drive.OracleDriver");
System.out.println("-------正在--链接--数据库-----");
String url = "jdbc:oracle:thin:@localhost:1521:ora9i";
con = DriverManager.getConnection(url,"system","admin");
System.out.println("已经连接到数据库...welcome...");
Statement stmt = con.createStatement();
String query = "select * from info";
stmt.execute(query);
ResultSet rs = stmt.getResultSet();
while(rs.next()){
int i = rs.getInt(1);
String name = rs.getString(2);
System.out.println(Integer.toString(i)+" "+name);
}
rs.close();
stmt.close();
con.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货