怎么在一个页面多次操作...
我在同一个页面先后建了如下stmt:
<%@ include file="connstr.jsp"%>
<%Statement stmt=conn.createStatement();%>
<%
try{
String sql = "select * from news";
ResultSet rs=stmt.executeQuery(sql);
%>
<%=rs.getString("news")%>
<%
String sqll="select * from title order by id desc";
ResultSet rss=stmt.executeQuery(sqll);
%>
<%=rss.getString("name")%>
执行时就出现了一下错误:
javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Invalid operation for the current cursor position.
注释掉<%=rs.getString("news")%>或者<%=rss.getString("name")%>后执行就正常了。可在一个叶面里我要搜几个表,我该怎么办?