JSP连接ORACLE数据库时出现的问题

crespo1414 2006-09-25 04:54:25

<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*" %>
<html>
<body>
<%
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());//++
//Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
String url="jdbc:oracle:thin:@192.168.255.239:1521:ORCDB";
String username="wenlinguo";
String password="wenlinguo";
Connection conn=DriverManager.getConnection(url,username,password);
Statement stmt=conn.createStatement();//++
//Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from xy.test_user";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next()) { %>
您的第一个字段内容为： <%= rs.getString(1) %>
您的第二个字段内容为： <%= rs.getString(2) %>
您的第三个字段内内容： <%= rs.getString(3) %>
<% } %>
<% out.print("数据库操作成功，恭喜你"); %>
<% rs.close();
stmt.close();
conn.close(); %>
</body>
</html>
----------------------------------------------------------------------------------------
type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jasper.JasperException: Unable to compile class for JSP

An error occurred at line: 5 in the jsp file: /jdbc_ora/test_ora.jsp
Generated servlet error:
D:\Program Files\Tomcat 5.0\work\Catalina\localhost\myjsp\org\apache\jsp\jdbc_005fora\test_005fora_jsp.java:48: package oracle.jdbc does not exist
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());//++
^
1 error

org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:332)
org.apache.jasper.compiler.Compiler.generateClass(Compiler.java:412)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:472)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:451)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:511)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:295)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.

...全文