我连接的是oracle数据库,代码如下:
package com;
import java.sql.*;
import java.io.*;
public class JdbcConnection
{
public static void main(String[] args)
{
//String s1="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:ora9i";
String s2 = "scott";
String s3 = "tiger";
String sql = "select empno,deptno from emp";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(url,s2,s3);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
int i= rs.getInt("empno");
System.out.println("empno is"+i);
int j = rs.getInt("deptno");
System.out.println("deptno is"+j);
}
}catch(Exception e)
{
e.printStackTrace();
}
}
}编译通过,但是运行时会出现以下错误(异常):
java.lang.ClassNotFoundException: oracle.jdbc.driver.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:268)
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:164)
at com.JdbcConnection.main(JdbcConnection.java:15)
是不是因为我的classes.jar没有导入有关系啊? 我应该如何作?请执教!谢谢!
package com;
import java.sql.*;
import java.io.*;
public class JdbcConnection
{
public static void main(String[] args)
{
//String s1="oracle.jdbc.driver.OracleDriver";
String url="jdbc:oracle:thin:@localhost:1521:ora9i";
String s2 = "scott";
String s3 = "tiger";
String sql = "select empno,deptno from emp";
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn=DriverManager.getConnection(url,s2,s3);
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(sql);
while(rs.next())
{
int i= rs.getInt("empno");
System.out.println("empno is"+i);
int j = rs.getInt("deptno");
System.out.println("deptno is"+j);
}
}catch(Exception e)
{
e.printStackTrace();
}
}
}编译通过,但是运行时会出现以下错误(异常):
java.lang.ClassNotFoundException: oracle.jdbc.driver.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:268)
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:164)
at com.JdbcConnection.main(JdbcConnection.java:15)
是不是因为我的classes.jar没有导入有关系啊? 我应该如何作?请执教!谢谢!
驱动包放到运行环境的WEB-INF/lib下
同意。。
如果找不到,可以EMAIL给你,要不要?