和9i连接的问题!!
我在做和9i的连接,"importe.oracle.jdbc.driver.*;"不能导入(输入时候没有提示),我也用过"oci8"也没有用,都是出现下面的找不到驱动!难道9i的驱动改了?请哥哥姐姐指点一下,谢谢!!
import java.sql.*;
public class DB
{
public static void main(String[] args)
{
try
{
String dbUrl="jdbc:oracle:thin:@localhost:1521:DBSUN";
String user="Scott";
String password="tiger";
Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
Connection con=DriverManager.getConnection(dbUrl,user,password);
Statement s=con.createStatement();
ResultSet rs=s.executeQuery("Select * from emp");
System.out.println("EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO");
while(rs.next())
{
System.out.print(rs.getString("EMPNO")+" ");
System.out.print(rs.getString("ENAME")+" ");
System.out.print(rs.getString("JOB")+" ");
System.out.print(rs.getString("MGR")+" ");
System.out.print(rs.getString("HIREDATE")+" ");
System.out.print(rs.getString("SAL")+" ");
System.out.print(rs.getString("COMM")+" ");
System.out.print(rs.getString("DEPTNO")+"");
}
rs.close();
s.close();
con.close();
}
catch(Exception e)
{
e.getMessage();
e.printStackTrace();
}
}
}
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:199)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:187)
at java.lang.ClassLoader.loadClass(ClassLoader.java:289)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:274)
at java.lang.ClassLoader.loadClass(ClassLoader.java:235)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:141)
at DB.main(DB.java:13)
问题点数:20、回复次数:2Top
1 楼blackfish99(于小鱼)回复于 2003-11-03 15:59:27 得分 7
你去下载一个ORACLE的JDBC驱动程序 CLASSES12.JAR 在开发和运行环境的CLASS路径中配上就行了Top
2 楼beckhambobo(beckham)回复于 2003-11-03 16:58:18 得分 13
下载一个:
http://otn.oracle.com/software/tech/java/sqlj_jdbc/index.htmlTop




