<% 
ResultSet rs=bean_rsgl.getrs(); out.print("<table border=1 align=center borderColorLight='#000000' cellspacing='0'>");
while(rs.next()){
out.print("<tr>");
String name=rs.getString("user_name");
String age=rs.getString("user_age");
String sex=rs.getString("user_sex");
out.print("<td>"+name+"</td>"+"<td>"+age+"</td>"+"<td>"+sex+"</td>");
out.print("</tr>"); }
out.print("</table>");
rs.close();%> 
判断一下,rs是否为空;
if(rs == null) out.println("error!!!!");
else
    ……

解决方案 »

  1.   

    <% 
    ResultSet rs=bean_rsgl.getrs();
    rs.next();
    out.print("<table border=1 align=center borderColorLight='#000000' cellspacing='0'>");
    if(rs.getRow()==0)
    {}else{
    rs.absolute(1);
    while(!rs.isAfterLast()){
    out.print("<tr>");
    String name=rs.getString("user_name");
    String age=rs.getString("user_age");
    String sex=rs.getString("user_sex");
    out.print("<td>"+name+"</td>"+"<td>"+age+"</td>"+"<td>"+sex+"</td>");
    out.print("</tr>");
    if(!rs.next())
    break;
    }
    }
    out.print("</table>");
    rs.close();%>