area_1.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 INT_ID,STR_TITLE,STR_AUTHOR FROM DATA WHERE INT_COOL=1 ORDER BY STR_DATE DESC");
//(------取数据，画表格------------

int intRowcount =0;
String strId,strS1,strS2,cool_sign;
String strAll;

cool_sign="<strong><small><font face='Comic Sans MS'></font><font color=#ff0000>C</font><font color=#e68000>o</font><font color=#00c000>o</font><font color=#0099ff>l</font><font color=#9900ff>!</font></font></small></strong>&nbsp;";
strAll="<table cellspacing='0' cellpadding='0' width='100%' bgcolor='#ebebeb'>";

while(rs.next()&&intRowcount<10){
strId=rs.getString("INT_ID");
strS1=rs.getString("STR_TITLE");
strS2=rs.getString("STR_AUTHOR");
strAll=strAll+"<tr ><td colspan='2' class='p9'>"+cool_sign+"<a href='readtxt.jsp?idget="+strId+"'>"+strS1+"</a></td><td align='left' nowrap><a href='intramail.jsp?receiver="+strS2+"'>"+strS2+"</a></td></tr>";
intRowcount++;
}
strAll=strAll+"</table>";
out.print(strAll);
rs.close();
%>