JSP连接Oracle数据库出错,希望大家帮忙啊,急急急!拜托了!
我的类路径是:D:\tomcat\webapps\ROOT\WEB-INF\classes\yourpackage
jsp路径:D:\tomcat\webapps\ROOT\
调用路径:http://130.1.1.213:8080/connOracle.jsp
openOracle.java
package yourpackage;
import java.sql.*;
public class openOracle
{
String sDBDriver="oracle.jdbc.driver.OracleDriver"; String sConnStr="jdbc:oracle:thin:@130.1.1.213:1521:yourservername";
Connection conn=null;
ResultSet rs=null;
public openOracle()
{
try{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("openOracle();"+e.getMessage());
}
}
public ResultSet executeQuery(String sql)
{
rs=null;
try{
conn=DriverManager.getConnection(sConnStr,"username","password");
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sql);
}
catch(SQLException ex){
System.err.println("aq.executeQuery:"+ex.getMessage());
}
return rs;
}
}
connOracle.jsp
<%@ page contentType="text/html;charset=GBK"%>
<%@ page language="java"import="java.sql.*"%>
<jsp:useBean id="db" scope="page" class="yourpackage.openOracle">
<%
String sql="select * from user";
ResultSet rs=db.executeQuery(sql);
String mess="";
if(rs.next())
{
mess="连接成功!";
}
else
{
mess="连接失败!";
}
rs.close();
%>
<HTML>
<HEAD>
<meta charset="gb2312">
<META HTTP-EQUIV="Content-Type" ONTENT="text/html;charset=gb2312">
<TITLE>
数据库连接测试
</TITLE>
</HEAD>
<BODY>
<H2>
数据库连接测试结果:
<%=mess %>
</H2>
<P>
</P>
</BODY>
</HTML>
openOracle.java可以正常编译,可是当运行connOracle.jsp却出错。类似于:
org.apache.jasper.JasperException: oracle.jdbc.driver.OracleDriver
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
这些东西。
我也看过类似我这个问题的贴子,但还是不懂。只是将classes12.zip压缩包放在
哪个目录下吗?还用不用重新指定环境变量?还下载什么驱动吗?用不用修改什么文件?
真希望那位高手指点一番,最好是详细些,请把具体的操作好好给我讲件,在此先谢过了,拜托各位了!多谢!!!