Question

jsp中只进结果集不支持请求的操作

<%Connection conn=null;
try
{
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
String strConn="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=zikaoxitong";
String strUser="sa";
String strPassword="111111";
conn=DriverManager.getConnection(strConn,strUser,strPassword);
Statement stm=conn.createStatement();
String Id=request.getParameter("Id");
if(Id==null) Id="";
String Name=request.getParameter("Name");
if(Name==null) Name="";
String Date=request.getParameter("Date");
if(Date==null) Date="";
String Year=request.getParameter("Year");
if(Year==null) Year="";
String Post=request.getParameter("Post");
if(Post==null) Post="";

String EndExam=request.getParameter("EndExam");
if(EndExam==null) EndExam="";
String strSQL="SELECT * FROM 信息工程系 WHERE ";
strSQL=strSQL+"Id LIKE '%"+Id+"%'AND ";
strSQL=strSQL+"Name LIKE '%"+Name+"%'AND ";
strSQL=strSQL+"Date LIKE '%"+Date+"%'AND ";
strSQL=strSQL+"Year LIKE '%"+Year+"%'AND ";
strSQL=strSQL+"Post LIKE '%"+Post+"%'AND ";

strSQL=strSQL+"EndExam LIKE'%"+EndExam+"%'";
strSQL=strSQL+"order by Id ASC";
ResultSet rs=stm.executeQuery(strSQL);
%>
<center><h2>报考人数</h2></center>
<table border="1"align="center"border="0"align="center"cellpadding="0"cellspacing="1"bgcolor="#00CCCC">
<tr heght="30">
<th></th>
<th>准考证号</th>
<th>姓 名</th>
<th>入学时间</th>
<th>报考年份</th>
<th>是否申报学位</th>
<th>是否通过毕业考试</th>
<tr height="30" bgcolor="#00CCCC" align="center">
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
</tr>
<%}

<% rs.close();
stm.close();
conn.close();
}
catch(ClassNotFoundException e)
{
out.println("a"+e.getMessage());
}
catch(SQLException e)
{
out.println(e.getMessage());
}
%>

Answer 1

“只进结果集不支持请求的操作”———这个是什么问题？

得到的rs， 要判断是否有记录
if(rs.next()){
%>
<center><h2>报考人数</h2></center>
<table border="1" align="center"border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#00CCCC">
<tr heght="30">
<th></th>
<th>准考证号</th>
<th>姓 名</th>
<th>入学时间</th>
<th>报考年份</th>
<th>是否申报学位</th>
<th>是否通过毕业考试</th>
</tr>
<tr height="30" bgcolor="#00CCCC" align="center">
<td><%=rs.getString(1)%></td>
<td><%=rs.getString(2)%></td>
<td><%=rs.getString(3)%></td>
<td><%=rs.getString(4)%></td>
<td><%=rs.getString(5)%></td>
<td><%=rs.getString(6)%></td>
</tr>
<%

}else{ <%
没有记录

<%
}