HTTP status 500 错误

type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /chooseCourse.jsp at line 123120: rs1=stmt.executeQuery(sql1);
121: rs2=stmt.executeQuery(sql2);
122: int number;
123: number=rs1.getInt(1);
124: for ( int i=0; i< number; i++ )
125: {
126:   if(rs2.next()){
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:281)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(Unknown Source)
com.microsoft.sqlserver.jdbc.SQLServerResultSet.getInt(Unknown Source)
org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:183)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.

解决方案 »

  1.   

    定义了rs1 rs2
    我是刚学的，不太了解，高手帮帮我
      

  2.   

    <%@ page language="java" contentType="text/html; charset=gbk"
        pageEncoding="gbk"%>
        
     <%@page language="java" import="java.sql.*" %>   
    <%@page language="java" import="java.util.*" %>
     
        
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gbk">
    <title>在线选课</title>  <link rel="stylesheet" type="text/css" href="common\cmnStyle.css" TITLE="common"></link>  <script language="JAVASCRIPT">
    <%
        if ( session.getAttribute("errMsg") != null )
        {
    %>
            var sErrMsg = "<%=session.getAttribute("errMsg")%>";
    <%
        }
        else
        {
    %>
            var sErrMsg = "";
    <%
        }
    %>  </script>
    </head>
    <body><table border=0 cellpadding=0 cellspacing=0 height=10>
      <tr>
        <td>
          &nbsp;
        </td>
      </tr>
    </table>
    <form name="form_main" action="" method="post" 
          onsubmit="return checkInput();" onreset="resetForm()">
    <table border=0 cellpadding=0 cellspacing=2 bgcolor="#000000" align=center>
      <tr>
        <td>
          <table border=0 cellpadding=0 cellspacing=0 bgcolor="#ffffff" width=700>
            <tr>
              <td align=left height=20>
                欢迎你，<font color=blue><%=session.getAttribute("realname")%></font>！
              </td>
              <td align=right>
                <a href="ViewCourse.jsp">已选课程列表</a>
                &nbsp;| &nbsp;
                <a href="logout.jsp">退出登录</a>
                &nbsp;
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td>
          <table border=0 cellpadding=0 cellspacing=0 bgcolor="#ffffff" width=700>
            <tr>
              <td>
                <br>&nbsp;&nbsp;你可以选择的课程列表如下（<font color=#cccccc>灰色</font>按钮代表选课人数已满）：
              </td>
            </tr>
            <tr>
              <td height=5>
              </td>
            </tr>
            <tr>
              <td align=center height=300 valign=top>
                <table border=0 cellpadding=0 cellspacing=2 bgcolor="#ffffff" width=680>
                  <tr bgcolor=#cccccc height=18>
                    <td width=50 align=center>
                      课程编号
                    </td>
                    <td width=250 align=center>
                      课程名称
                    </td>
                    <td width=50 align=center>
                      授课老师
                    </td>
                    <td width=40 align=center>
                      学分
                    </td>
                    <td width=150 align=center>
                      上课时间
                    </td>
                    <td width=40 align=center>
                      操作
                    </td>
                    <td width=50 align=center>
                      限制人数
                    </td>
                    <td width=50 align=center>
                      已选人数
                    </td>
    <%
    ResultSet rs1=null;
    ResultSet rs2=null;
    ResultSet amount=null;
    Connection conn=null;
    Statement stmt=null;
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    String url ="jdbc:sqlserver://localhost:1433;dateBaseName = student";
    String user = "sa";
    String password = "1234";
    conn = DriverManager.getConnection(url, user, password);
    stmt=conn.createStatement();String sql1="use student;select count(*) from course";
    String sql2="use student;select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    rs1=stmt.executeQuery(sql1);
    rs2=stmt.executeQuery(sql2);
    int number;
    number=rs1.getInt(1);
    for ( int i=0; i< number; i++ )
    {
      if(rs2.next()){
    String sql3="use student;select count(*) from elective where elective.course_id=rs2.getString(1) order by course_id";
    amount=stmt.executeQuery(sql3);
    int total;
    total=amount.getInt(1);
      
      
    %>
                  <tr>
                    <td align=center>
                      <%=rs2.getString(1)%>
                    </td>
                    <td>
                      <%=rs2.getString(2)%>
                    </td>
                    <td>
                      <%=rs2.getString(3)%>
                    </td>
                    <td align=center>
                      <%=rs2.getString(4)%>
                    </td>
                    <td align=center>
                      <%=rs2.getString(5)%><br><%=rs2.getString(6)%>
                    </td>
                    <td align=center>
    <%
    //如果选课人数大于限制人数，不能再选了
    if ( rs2.getInt(7) <= total )
    {
    %>
                      <button disabled>选课</button>
    <%
    }
    else
    {
    %>
                      <button onclick="choose('<%=rs2.getString(1)%>')">选课</button>
    <%
    }
    %>
                    </td>
                    <td align=center>
                      <%=rs2.getString(7)%>
                    </td>
                    <td align=center>
                      <%= total%>
                    </td>
                  </tr>
    <%
    }
    }
    %>         
    </table>
              </td>
            </tr>
            <tr>
              <td height=10></td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
    <input type="hidden" name="courseId" value="">
    </form></body>
    </html>
      

  3.   

    rs1要先执行下rs1.next()再执行rs1.getInt(1);
    另外你的sql3语句拼装有问题
    String sql3="use student;select count(*) from elective where elective.course_id=rs2.getString(1) order by course_id";
      

  4.   

    按照你说的做了然后我把sql3里的getstring（）改成getint（）了，course_id也是int类型
    还是500错误
    type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /chooseCourse.jsp at line 123120: rs1=stmt.executeQuery(sql1);
    121: rs2=stmt.executeQuery(sql2);
    122: int number;
    123: rs1.next();
    124: number=rs1.getInt(1);
    125: for ( int i=0; i< number; i++ )
    126: {
    Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:283)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:183)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
    你帮我再看看吧
    谢谢
      

  5.   

    "use student;select count(*) from elective where elective.course_id=rs2.getString(1) order by course_id";
    你這不是自己找抽嗎幹嗎不直接用SQL查詢兩個表  還要從一個表查出結果  然後套到另一個表繼續查詢
      

  6.   

    这是不是问题所在啊，我做的是选课系统，rs2查询的是课程信息，然后我想用在sql3里查询出当前选这门课的人数，上面用的是有循环，感觉这样简单些，我没有用过，给指点一二
      

  7.   

    String sql2="use student;select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    String sql3="use student;select count(*) from elective where elective.course_id=rs2.getString(1) order by course_id";
    用下面的代替 select count(*),course.course_id,course_name,teacher,point,time_1,time_2,limited from course,elective where course.course_id=elective.course_id group by course.course_id order by course.course_id
      

  8.   

    谢谢你！还是有问题，我把那部分去掉了
    你在帮我看看吧！
    <%@ page language="java" contentType="text/html; charset=gbk"
        pageEncoding="gbk"%>
        
     <%@page language="java" import="java.sql.*" %>   
    <%@page language="java" import="java.util.*" %>
     
        
    <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=gbk">
    <title>在线选课</title>  <link rel="stylesheet" type="text/css" href="common\cmnStyle.css" TITLE="common"></link>  <script language="JAVASCRIPT">
    <%
        if ( session.getAttribute("errMsg") != null )
        {
    %>
            var sErrMsg = "<%=session.getAttribute("errMsg")%>";
    <%
        }
        else
        {
    %>
            var sErrMsg = "";
    <%
        }
    %>  </script>
    </head>
    <body><table border=0 cellpadding=0 cellspacing=0 height=10>
      <tr>
        <td>
          &nbsp;
        </td>
      </tr>
    </table>
    <form name="form_main" action="" method="post" 
          onsubmit="return checkInput();" onreset="resetForm()">
    <table border=0 cellpadding=0 cellspacing=2 bgcolor="#000000" align=center>
      <tr>
        <td>
          <table border=0 cellpadding=0 cellspacing=0 bgcolor="#ffffff" width=700>
            <tr>
              <td align=left height=20>
                欢迎你，<font color=blue><%=session.getAttribute("realname")%></font>！
              </td>
              <td align=right>
                <a href="ViewCourse.jsp">已选课程列表</a>
                &nbsp;| &nbsp;
                <a href="logout.jsp">退出登录</a>
                &nbsp;
              </td>
            </tr>
          </table>
        </td>
      </tr>
      <tr>
        <td>
          <table border=0 cellpadding=0 cellspacing=0 bgcolor="#ffffff" width=700>
            <tr>
              <td>
                <br>&nbsp;&nbsp;你可以选择的课程列表如下（<font color=#cccccc>灰色</font>按钮代表选课人数已满）：
              </td>
            </tr>
            <tr>
              <td height=5>
              </td>
            </tr>
            <tr>
              <td align=center height=300 valign=top>
                <table border=0 cellpadding=0 cellspacing=2 bgcolor="#ffffff" width=680>
                  <tr bgcolor=#cccccc height=18>
                    <td width=50 align=center>
                      课程编号
                    </td>
                    <td width=250 align=center>
                      课程名称
                    </td>
                    <td width=50 align=center>
                      授课老师
                    </td>
                    <td width=40 align=center>
                      学分
                    </td>
                    <td width=150 align=center>
                      上课时间
                    </td>
                    <td width=40 align=center>
                      操作
                    </td>
                    <td width=50 align=center>
                      限制人数
                    </td>
          
    <%
    ResultSet rs1=null;
    ResultSet rs2=null;
    //ResultSet amount=null;
    Connection conn=null;
    Statement stmt=null;
    Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    String url ="jdbc:sqlserver://localhost:1433;dateBaseName = student";
    String user = "sa";
    String password = "1234";
    conn = DriverManager.getConnection(url, user, password);
    stmt=conn.createStatement();String sql1="use student;select count(*) from course";
    String sql2="use student;select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    rs1=stmt.executeQuery(sql1);
    rs2=stmt.executeQuery(sql2);
    int number;
    rs1.next();
    number=rs1.getInt(1);
    for ( int i=0; i< number; i++ )
    {
      if(rs2.next()){
    //String sql3="use student;select count(*) from elective where elective.course_id=rs2.getInt(1) order by course_id";
    //amount=stmt.executeQuery(sql3);
    //int total;
    //amount.next();
    //total=amount.getInt(1);
      
      
    %>
                  <tr>
                    <td align=center>
                      <%=rs2.getString(1)%>
                    </td>
                    <td>
                      <%=rs2.getString(2)%>
                    </td>
                    <td>
                      <%=rs2.getString(3)%>
                    </td>
                    <td align=center>
                      <%=rs2.getString(4)%>
                    </td>
                    <td align=center>
                      <%=rs2.getString(5)%><br><%=rs2.getString(6)%>
                    </td>
                    <td align=center>
    <%
    //如果选课人数大于限制人数，不能再选了
    if ( rs2.getInt(7) <= 50 )
    {
    %>
                      <button disabled>选课</button>
    <%
    }
    else
    {
    %>
                      <button onclick="choose('<%=rs2.getString(1)%>')">选课</button>
    <%
    }
    %>
                    </td>
                    <td align=center>
                      <%=rs2.getString(7)%>
                    </td>
                   
                  </tr>
    <%
    }
    }
    %>         
    </table>
              </td>
            </tr>
            <tr>
              <td height=10></td>
            </tr>
          </table>
        </td>
      </tr>
    </table>
    <input type="hidden" name="courseId" value="">
    </form></body>
    </html>
      

  9.   

    你的代碼習慣很不規範  看起來很累
    rs2.getString(2)這種東西最好是賦值到變量裡面去 別總用來做後續操作。
    建議這些東西放在JAVA裡面寫
    數據庫連接也放在JAVA BEAN裡面 別放JSP裡面
      

  10.   


    第一你的sql语句最好不要带use student
    因为你的设置就已经指向了student数据库，你的sql语句在价格use student，就是多此一举。
    String sql1="use student;select count(*) from course";
    String sql2="use student;select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    将use stduent 去掉，改成String sql1="select count(*) from course";
    String sql2="select course_id,course_name,teacher,point,time_1,time_2,limited from course";第二
    for ( int i=0; i< number; i++ )
    {
      if(rs2.next()){
    不要这样写直接用while(rs2.next())
      

  11.   

    不用use student
    他出这样的错
    type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /chooseCourse.jsp at line 118115: 
    116: String sql1="select count(*) from course";
    117: String sql2="select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    118: rs1=stmt.executeQuery(sql1);
    119: rs2=stmt.executeQuery(sql2);
    120: int number;
    121: rs1.next();
    Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 对象名  'course' 无效。
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:277)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause com.microsoft.sqlserver.jdbc.SQLServerException: 对象名  'course' 无效。
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
    com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:178)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
      

  12.   

    type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /chooseCourse.jsp at line 121118: rs1=stmt.executeQuery(sql1);
    119: rs2=stmt.executeQuery(sql2);
    120: int number;
    121: rs1.next();
    122: number=rs1.getInt(1);
    123: for ( int i=0; i< number; i++ )
    124: {
    Stacktrace:
    org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:398)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause javax.servlet.ServletException: com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
    org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:277)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    root cause com.microsoft.sqlserver.jdbc.SQLServerException: 结果集已关闭。
    com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerResultSet.checkClosed(Unknown Source)
    com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(Unknown Source)
    org.apache.jsp.chooseCourse_jsp._jspService(chooseCourse_jsp.java:181)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    note The full stack trace of the root cause is available in the Apache Tomcat/6.0.18 logs.
      

  13.   


    你是2个不同的数据之间查询表？？int number;
    String sql2="use student;select course_id,course_name,teacher,point,time_1,time_2,limited from course";
    rs2=stmt.executeQuery(sql2);
    int i=0;
    while(rs2.next){
    ......//这里的业务操作你自己写
    i++;
    }
    number = i;
    直接这样就可以了，rs1都可以不要了。。
      

  14.   

    你ResultSet已经关闭，又使用了。检查下