<%
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
……
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
……
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();%>