JSP错误 - Java / Web 开发

org.apache.jasper.JasperException: Exception in JSP: /spinformation2.jsp:38

35: String Kecheng="select Lc,Lesson.Lname,Lkind,Lss,Lat,Lsy from Score,Lesson where Lesson.Lname=Score.Lname and Sno='"+session.getAttribute("Sno")+"' and Sct='2009-2010'";
36: ResultSet rk=stmt.executeQuery(Kecheng);
37: rk.next();
38: String Lc=rs.getString(1);
39: String Lname=rs.getString(2); 
40: String Lkind=rs.getString(3);
41: String Lss=rs.getString(4);


Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:506)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


起 因 

javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:843)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:776)
org.apache.jsp.spinformation2_jsp._jspService(spinformation2_jsp.java:203)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:80