我的程序里面连oracle数据库抱错,后来我就自己写了一个很简单的测试程序测了一下,可还是包错,我看程序应该是没有什么问题啊!并且我把oracle的驱动包也导进去了,所以应该是一点问题也没有啊!可是还是那个错误,郁闷了测试程序如下:package demo;import java.sql.*;public class JDBCTest
{
public static void main(String[] args)
{
Connection conn = null;
// Statement st = null;
// ResultSet rs = null;
try
{
String url = "oracle.jdbc.driver.OracleDriver";
String drivername = "jdbc:oracle:thin:@localhost:1521:ORAC";
String name = "scott";
String password = "tiger";
Class.forName(drivername).newInstance();
conn = DriverManager.getConnection(url,name,password);
System.out.println("连接oracle9i成功!!!");
}
catch(Exception ex)
{
ex.printStackTrace();
}
}}
抱错信息如下:java.lang.ClassNotFoundException: jdbc:oracle:thin:@localhost:1521:ORAC
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.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at demo.JDBCTest.main(JDBCTest.java:19)
{
public static void main(String[] args)
{
Connection conn = null;
// Statement st = null;
// ResultSet rs = null;
try
{
String url = "oracle.jdbc.driver.OracleDriver";
String drivername = "jdbc:oracle:thin:@localhost:1521:ORAC";
String name = "scott";
String password = "tiger";
Class.forName(drivername).newInstance();
conn = DriverManager.getConnection(url,name,password);
System.out.println("连接oracle9i成功!!!");
}
catch(Exception ex)
{
ex.printStackTrace();
}
}}
抱错信息如下:java.lang.ClassNotFoundException: jdbc:oracle:thin:@localhost:1521:ORAC
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.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at demo.JDBCTest.main(JDBCTest.java:19)
String drivername = "jdbc:oracle:thin:@localhost:1521:ORAC";
==============================================================================貌似应该
String drivername = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:ORAC";
String url = "oracle.jdbc.driver.OracleDriver";
String drivername = "jdbc:oracle:thin:@localhost:1521:ORAC";
3楼兄弟是正解