<%
ResultSet rs1;
String sql1="select * from XSCJB";
rs1=xs.executeQuery(sql1);
String id1=rs1.getString("XH");
String id2=rs1.getString("XQM");
id1=request.getParameter("XN");
id2=request.getParameter("XQM");
ResultSet rs;
String sql="select * from XSCJB where XN="+id1+" and XQM="+id2+"";
rs=xs.executeQuery(sql);
while(rs.next())
{
%>
<P align="center">学号:<%=rs.getString("XH")%> 学年:<%=rs.getString("XN")%> 考试成绩:<%=rs.getString("FSLKSCJ")%>
</P>
<%
}
%>
请大虾不吝赐教
greatripple(迎接挑战) 你也太厉害了吧,自作主张就把我写的那句移后了
<%
ResultSet rs1;
String sql1="select * from XSCJB";
rs1=xs.executeQuery(sql1);
//////////////一定要在这里
rs1.next();
String id1=rs1.getString("XN");
String id2=rs1.getString("XQM");
///////rs1.next();
id1=request.getParameter("XN");
id2=request.getParameter("XQM");
ResultSet rs;