高手请看!!!
我用这个来显示出查询的结果,有什么问题?会出现以下错误!!!
javax.servlet.ServletException: [Microsoft][ODBC Driver Manager] Invalid cursor state
<jsp:useBean id="socialexBean" scope="page" class="socialexp.socialBean" />
<%@ page language="java" import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%!
String Query_name="SELECT name FROM student WHERE class=";
String classnumber;
%>
<HTML>
<HEAD>
</HEAD>
<BODY>
<%
classnumber=request.getParameter("schoolcontent");
if(classnumber!="请选择"){
ResultSet RSS=socialexBean.executeQuery(Query_name+classnumber);
%>
<%
while(RSS.next())%>
<%
out.print("<tr><td>"+RSS.getString("name")+"</tr>");
RSS.close();
}
%>
</table>
</BODY>
</HTML>