area_2.jsp

bbs设计是一个论坛方面的设计 基于jsp的系统设计

<%@ page language="java" import="java.sql.*" %>
<jsp:useBean id="DB" scope="page" class="dbcon.mydb" />
<jsp:useBean id="doit" scope="page" class="dbcon.doit" />

<%  

ResultSet rs=DB.executeQuery("SELECT STR_USER,INT_POSTNUMB FROM LOGIN ORDER BY INT_POSTNUMB DESC");
//(------取数据，画表格------------

int intRowcount =0;
String strUser,strCash,strAll;

strAll="<table cellspacing='0' cellpadding='0' width='100%' bgcolor='#ebebeb'>";
while(rs.next()&&intRowcount<20){
strUser=rs.getString("STR_USER");
strCash=rs.getString("INT_POSTNUMB");
intRowcount++;

strAll=strAll+"<tr ><td>";
strAll=strAll+"<a href='intramail.jsp?receiver="+strUser+"'>"+strUser+"</a></td><td width='50%' align='right'><font color='red'>"+strCash+"</font>";
strAll=strAll+"</td></tr>";
}
strAll=strAll+"</table>";
out.print(strAll);

  // out.print("没有您所要求的记录") '---没有记录--

rs.close();
%>