jsp连接oracle出错!!!
程序内容如下
<html>
<body>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="oracle.jdbc.driver.*" %>
<%
DriverManager.registerDriver(new OracleDriver());
Connection conn = DriverManager.getConnection("java:oracle:thin:@localhost:1521:orl","adm","123");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select city_name_cn from city where rownum<3" );
while( rs.next() )
{
String name = rs.getString("city_name_cn");
out.println(name);
}
%>
</body>
</html>
运行后,系统提示
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 5 in the jsp file: /test/orlc.jsp
Generated servlet error:
[javac] Compiling 1 source file
D:\Tomcat 4.1\work\Standalone\localhost\_\test\orlc_jsp.java:8: package oracle.jdbc.driver does not exist
import oracle.jdbc.driver.*;
^
D:\Tomcat 4.1\work\Standalone\localhost\_\test\orlc_jsp.java:49: cannot resolve symbol
symbol : class OracleDriver
location: class org.apache.jsp.orlc_jsp
DriverManager.registerDriver(new OracleDriver());
^
2 errors
我的配置为windows200server、jdk1.5、tomcat4.1,其他jsp程序都可以运行
目录为 D:\j2sdk1.4.2_05 D:\Tomcat 4.1
我的机子上装有oracle9,目录 D:\oracle\ora90
同时,已经将D:\oracle\ora90\jdbc\lib下的classes12.jar、classes12.zip
拷贝到了D:\j2sdk1.4.2_05\lib和D:\Tomcat 4.1\common\lib下
也将上述加入环境变量,但是D:\Tomcat 4.1\common\lib下classes12.jar、classes12.zip没有加入(网上查资料好像不要)
D:\j2sdk1.4.2_05\lib\classes12.jar;D:\j2sdk1.4.2_05\lib\classes12.zip;D:\oracle\ora90\jdbc\lib\classes12.jar;D:\oracle\ora90\jdbc\lib\classes12.zip
请大家看看这是什么回事
我的环境变量配置是否正确
谢谢了