JDBC连接oracle数据库问题?
ToGo 2003-07-10 09:36:36 import java.sql.*;
public class JDBCExample{
public static void main(String args[]){
/*
if(args.length<1){
System.err.println("Usage:");
System.err.println(" java JDBCExample < db server hostname >");
System.exit(1);
}
String serverName = args[0];
*/
String serverName = "localhost";
try{
//new oracle.jdbc.driver.OracleDriver();
Class.forName("oracle.jdbc.driver.OracleDriver");
//System.setProperty("jdbc.drivers","oracle.jdbc.driver.OracleDriver");
String url="jdbc:oracle:thin:@"+serverName+":1521:zzy";
//System.out.println(url);
Connection conn=DriverManager.getConnection(url,"scott","tiger");
Statement stmt=conn.createStatement();
//创建表
//stmt.execute("create table zzyTest1(id int, name char(20), phone char(10))");
//插入新数据
//stmt.executeUpdate("insert into zzyTest1 values(55,'kisduu','655')");
//更新数据
//stmt.executeUpdate("update mytable3 set phone = '33445566' where id = 55");
//*查询数据
//ResultSet rs=stmt.executeQuery("select * from zztTest1");
//while(rs.next()){
//System.out.println("data1: "+rs.getInt(1));
//System.out.println("\tdata2: "+rs.getString(2));
//System.out.println("\tdata3: "+rs.getString(3));
//}
//*/
//删除表
//stmt.execute("drop table mytable4");
//rs.close();
//conn.close();
}catch(Exception e){
e.printStackTrace();
}
}
}
编译通过,运行
出现以下错误?
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at java.net.URLClassLoader$1.run(URLClassLoader.java:198)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:186)
at java.lang.ClassLoader.loadClass(ClassLoader.java:299)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:265)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at JDBCExample.main(JDBCExample.java:30)
如何解决?谢谢