最近用jsp和oracle9i一起调试一个在线测试系统，tomcat座服务器，遇到连接错误

NLP爱好者 2007-10-30 06:14:27

我的jsp代码是：
<%@page contentType="text/html;charset=GBK"%>
<%@page import="java.sql.*" errorPage="error.jsp"%>
<jsp:useBean id="conn" scope="page" class="db.ConnOracle"/>

<%!
ResultSet rs = null;

String classid = "";
String classname = "";
String kaoshitime = "";
String kaotishumu = "";
String kaojuanshumu = "";

String oper = "";
String sql = "";

int result = 0;
%>

<html>

<head>
<title>班级信息管理</title>
<link rel="stylesheet" href="TESTSYS/test/admin/style.css" type="text/css" media="screen">
</head>

<Body class="ss">
<center>

<%
request.setCharacterEncoding("GBK");

classid = request.getParameter("classid");
classname = request.getParameter("classname");
kaoshitime = request.getParameter("kaoshitime");
kaotishumu = request.getParameter("kaotishumu");
kaojuanshumu= request.getParameter("kaojuanshumu");

oper = request.getParameter("oper");

// 避免用户直接在浏览器地址栏输入页面地址所产生的Exception
if(classid==null || classid.equals("")) {
out.println("<center>");
out.println("请进行合法操作！");
out.println("</center>");
return;
}

try{
rs = conn.executeQuery("select * from classinfo where classid='"+classid+"'");
if(!rs.next()) {
out.println("<center>");
out.println("数据库没有代号为" + classid + "的班级信息！ ");
out.println("单击这里<a href=javascript:history.back()>返回</a> ");
out.println("</center>");
} else {
if(oper.equals("修改")) {
sql = "update classinfo set classname='" + classname + "'";

sql+= ",kaoshitime=" + kaoshitime ;

sql+= ",kaotishumu=" + kaotishumu ;

sql+= ",kaojuanshumu=" + kaojuanshumu ;

sql+= " where classid='" + classid + "'";

} else if(oper.equals("删除")){
sql = "delete from classinfo";
sql+= "where classid ='" + classid + "'";

}
result = conn.executeUpdate( sql );
}
}catch(Exception ee) {
out.println("<center>");
out.println("课程信息更新失败！ ");
out.println("请将下列信息告知管理员 ");
out.println(ee.toString() + " ");
out.println("单击这里<a href=javascript:history.back()>返回</a> ");
out.println("</center>");
}
%>
<jsp:forward page="classmanager.jsp"/>
</center>
</Body>

</htm

在tomcat下调试现如下错误：

HTTP Status 500 -

--------------------------------------------------------------------------------

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
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:558)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

root cause

java.lang.ArrayIndexOutOfBoundsException: 2185
org.apache.jasper.compiler.JspReader.peekChar(JspReader.java:193)
org.apache.jasper.compiler.JspReader.isSpace(JspReader.java:386)
org.apache.jasper.compiler.JspReader.isDelimiter(JspReader.java:453)
org.apache.jasper.compiler.JspReader.parseToken(JspReader.java:434)
org.apache.jasper.compiler.Parser.checkUnbalancedEndTag(Parser.java:1737)
org.apache.jasper.compiler.Parser.parseElements(Parser.java:1599)
org.apache.jasper.compiler.Parser.parse(Parser.java:171)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:247)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:149)
org.apache.jasper.compiler.ParserController.parse(ParserController.java:135)
org.apache.jasper.compiler.Compiler.generateJava(Compiler.java:237)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:456)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:439)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:552)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:291)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

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

--------------------------------------------------------------------------------

Apache Tomcat/5.0.16

是个菜鸟，刚接触数据库
那位高手帮帮我，我看了一天了。
我的tomcat都没有问题，帮我看下上面颜色标记连接数据库的那段程序，谢谢！！

...全文