index.jsp

这是一个用JAVA语言编写的BBS论坛程序

<%
/*
 * Copyright:  Copyright (c) 2004 
 * @author http://hi.baidu.com/lael80*/
%>
<%@ page contentType="text/html; charset=gb2312" errorPage=""%>
<%@ include file="head.jsp"%>
<br>
<%=tabletop%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
      <!--DWLayoutTable-->
      <tr valign="middle">
        <td height="25" colspan="2" class="b1"><!--DWLayoutEmptyCell-->&nbsp;</td>
      </tr>
      <tr valign="middle">
        <td width="40"><%if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=1")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=1")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
		}
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=1&pageid=1" class="style1">≡ 网页设计 ≡</a><br>
&nbsp;网页设计(asp/jsp/php/xml...),工具使用</td>
                <td width="90"><img src="images/forum1.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=1&topic=<%=workDB.queryBBS(1,0)%>&pageid=1&id=1"><%=workDB.queryBBS(1,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(1,1)%>"><%=workDB.queryBBS(1,1)%></a><br>
              日期：<%=workDB.queryBBS(1,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(1)%>"><%=workDB.queryAdmin(1)%></a></td>
                <td width="90">今天:<%=workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=1")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=1")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=1")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=1")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=1")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr valign="middle">
        <td width="40" valign="middle">
          <%
            if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=2")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=2")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
            }
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=2&pageid=1" class="style1">≡ 平面设计 ≡</a><br>
&nbsp;平面设计，创意设计</td>
                <td width="90"><img src="images/forum4.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=2&topic=<%=workDB.queryBBS(2,0)%>&pageid=1&id=1"><%=workDB.queryBBS(2,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(2,1)%>"><%=workDB.queryBBS(2,1)%></a><br>
              日期：<%=workDB.queryBBS(2,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(2)%>"><%=workDB.queryAdmin(2)%></a></td>
                <td width="90">今天:<%=workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=2")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=2")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=2")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=2")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=2")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr>
        <td width="40" valign="middle"><%if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=3")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=3")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
		}
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=3&pageid=1" class="style1">≡ 动漫前沿 ≡</a><br>
&nbsp;flash动画，设计，欣赏，交流</td>
                <td width="90"><img src="images/forum9.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=3&topic=<%=workDB.queryBBS(3,0)%>&pageid=1&id=1"><%=workDB.queryBBS(3,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(3,1)%>"><%=workDB.queryBBS(3,1)%></a><br>
              日期：<%=workDB.queryBBS(3,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(3)%>"><%=workDB.queryAdmin(3)%></a></td>
                <td width="90">今天:<%=workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=3")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=3")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=3")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=3")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=3")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr>
        <td width="40" valign="middle"><%if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=4")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=4")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
		}
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=4&pageid=1" class="style1">≡ 编程开发 ≡</a><br>
&nbsp;程序开发技术交流，问题解决</td>
                <td width="90"><img src="images/forum8.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=4&topic=<%=workDB.queryBBS(4,0)%>&pageid=1&id=1"><%=workDB.queryBBS(4,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(4,1)%>"><%=workDB.queryBBS(4,1)%></a><br>
              日期：<%=workDB.queryBBS(4,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(4)%>"><%=workDB.queryAdmin(4)%></a></td>
                <td width="90">今天:<%=workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=4")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=4")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=4")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=4")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=4")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr>
        <td width="40" valign="middle"><%if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=5")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=5")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
		}
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=5&pageid=1" class="style1">≡ 电脑网络 ≡</a><br>
&nbsp;IT前沿，电脑技术，网络安全</td>
                <td width="90"><img src="images/forum3.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=5&topic=<%=workDB.queryBBS(5,0)%>&pageid=1&id=1"><%=workDB.queryBBS(5,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(5,1)%>"><%=workDB.queryBBS(5,1)%></a><br>
              日期：<%=workDB.queryBBS(5,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(5)%>"><%=workDB.queryAdmin(5)%></a></td>
                <td width="90">今天:<%=workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=5")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=5")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=5")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=5")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=5")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr>
        <td width="40" valign="middle"><%if(workDB.queryCount("select count(topic_id) from user_topic where TO_DAYS(topic_date)=TO_DAYS(now()) and topic_forum=6")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=6")==0){
	      out.println("<img src='images/btype3.gif'>");
		}else{
		  out.println("<img src='images/btype1.gif'>");
		}
	  %></td>
        <td width="100%" valign="middle"><div align="left">
            <table width="100%" border="0" cellpadding="2" cellspacing="0">
              <tr>
                <td width="336">&nbsp;<a href="topic.jsp?forum=6&pageid=1" class="style1">≡ 灌水乐园 ≡</a><br>
&nbsp;热门话题，时尚潮流</td>
                <td width="90"><img src="images/forum2.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=6&topic=<%=workDB.queryBBS(6,0)%>&pageid=1&id=1"><%=workDB.queryBBS(6,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(6,1)%>"><%=workDB.queryBBS(6,1)%></a><br>
              日期：<%=workDB.queryBBS(6,3)%></td>
              </tr>
          </table>
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr class="style4">
                <td width="336">&nbsp;<img src="images/ren.gif">版主：<a href="userinfo.jsp?name=<%=workDB.queryAdmin(6)%>"><%=workDB.queryAdmin(6)%></a></td>