area.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" />
<jsp:include page=cksession.jsp />
<link rel=stylesheet href="style.css" type="text/css">
<center>
<big><big><strong><font color=red>i</font>BBS!</strong></big></big>
<br>
<table width="100%">
<tr><td width="80%" valign="top">
     <table width="100%" border="0" cellPadding="1" cellSpacing="0" bgcolor="#617B5B">
       <tr bgcolor="#617B5B"  >
		<td align="center" >
		  <font color="white">New Elite Posts</font></td>
		</td>
	   </tr>
	   <tr><td  >
		<jsp:include page=area_1.jsp />
		 </td>
	   </tr>
     </table>
	 <center>
     <a href="bbs.jsp?area_id=0&area_name=AllBoards"><font color="red">[All Posts]</font></a><br>
      </center>
<%
ResultSet sqlRst=DB.executeQuery("SELECT * FROM AREA ORDER by STR_AREATYPE DESC");
%>
<table  border="1" borderColorDark="#ffffff" borderColorLight="#000000" bgcolor='#DEDEDE'
cellPadding="5" cellSpacing="5" width="100%">

<script type="" language="JavaScript">
var title;
var rowflag;

title=null;
rowflag=1;
function x(a_id,a_type,a_name,a_master)
{
if (title != a_type) 
{
   if(title !=null)
   {
    document.write("</table>");
	document.write("</td>");
	
	 if(rowflag==3)
     {
     document.write("</tr>");
     rowflag=1;
     }
   }
  
 
title=a_type;

if(rowflag==1)
{
 document.write("<tr>");
 }
document.write("<td valign='top' width='33%' bgcolor='#c0c0c0'>");
document.write("<table border='1' bgcolor='#c0c0c0' width='100%' cellPadding='0' cellSpacing='0' borderColorDark='#ffffff' borderColorLight='#000000'>");
document.write("<tr bgcolor='#617B5B'><td p align='center' colspan='2'>");
document.write("<font color=white>"+title+"<a href='intramail.jsp?receiver=admin'><font color='#00FF00'>[Apply]</font></a></font>"+"</td></tr>");
document.write("<tr><td width='50%'><p align='center'>Board</td>");
document.write("<td width='50%'><p align='center'>Lord</td></tr>"); 
rowflag++;
}

document.write("<tr><td >");
document.write("<img src='images/topic.gif'><a href='bbs.jsp?area_id="+a_id+"&area_name="+a_name+"&area_m="+a_master+"'>"+a_name+"</a>");
document.write("</td><td p align='center'>");
document.write("<a href='intramail.jsp?receiver="+a_master+"'>"+a_master+"</a>");
document.write("</td></tr>");

}

<%
int a_id;
String a_name,a_master,a_type;
while(sqlRst.next())
{ 
	a_id=sqlRst.getInt("INT_AREAID");
	a_type=sqlRst.getString("STR_AREATYPE");
	a_name=sqlRst.getString("STR_AREANAME");  
	a_master=sqlRst.getString("STR_AREAMASTER");
	out.print("x("+ a_id +",'"+ a_type +"','"+ a_name +"','"+ a_master +"');");

}
sqlRst.close();

%>

if(title !=null)
   {
    document.write("</table>");
	document.write("</td>");
	document.write("</tr>");
	   }

</script>
   
 </table>
</td>
<td valign="top" width="20%" bgcolor="#617B5B">
  <table cellPadding="0" cellSpacing="0" width="100%" height="100%">
    <tr >
	    <td align="center"  >
        <font color="white">Active Users</font></td>
     </tr>
   <tr><td >
<jsp:include page=area_2.jsp />
   </td></tr>
   <tr  bgcolor="#617B5B">
   <td  align="center"><font color="white"></font></td>
   </tr>
<tr bgcolor="#ebebeb">
    <td width="100%" height="100%" align="center"  valign="top">
	
    </td>
  </tr>
 </table>

</td>
</tr>
</table>


 <br>
 <br>
 <em><strong><font face="Times New Roman">Copy Right <a href="mailto:[e-mail]"><big>Ji Wang</big></a>
2001/5/20 </font></strong></em></p>
</center>