index.jsp

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

                <td width="90">今天:<%=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")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=6")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=6")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=6")%></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=7")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=7")==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=7&pageid=1" class="style1">≡ 电视电影 ≡</a><br>
&nbsp;电视电影在线欣赏下载</td>
                <td width="90"><img src="images/forum5.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=7&topic=<%=workDB.queryBBS(7,0)%>&pageid=1&id=1"><%=workDB.queryBBS(7,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(7,1)%>"><%=workDB.queryBBS(7,1)%></a><br>
              日期：<%=workDB.queryBBS(7,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(7)%>"><%=workDB.queryAdmin(7)%></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=7")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=7")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=7")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=7")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=7")%></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=8")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=8")==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=8&pageid=1" class="style1">≡ 贴图专区 ≡</a><br>
&nbsp;美女贴图、时尚MM、性感美女、清纯校花、明星写真</td>
                <td width="90"><img src="images/forum10.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=8&topic=<%=workDB.queryBBS(8,0)%>&pageid=1&id=1"><%=workDB.queryBBS(8,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(8,1)%>"><%=workDB.queryBBS(8,1)%></a><br>
              日期：<%=workDB.queryBBS(8,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(8)%>"><%=workDB.queryAdmin(8)%></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=8")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=8")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=8")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=8")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=8")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
      <tr>
        <td width="40" valign="middle"><img src="images/btype2.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=9&pageid=1" class="style1">≡ 论坛事务 ≡</a><br>
&nbsp;管理层讨论问题的地方</td>
                <td width="90"><img src="images/forum7.gif" width="88"></td>
                <td width="280"> 主题：<a href="display.jsp?forum=9&topic=<%=workDB.queryBBS(9,0)%>&pageid=1&id=1"><%=workDB.queryBBS(9,2)%></a><br>
              作者：<a href="userinfo.jsp?name=<%=workDB.queryBBS(9,1)%>"><%=workDB.queryBBS(9,1)%></a><br>
              日期：<%=workDB.queryBBS(9,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(9)%>"><%=workDB.queryAdmin(9)%></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=9")+workDB.queryCount("select count(reply_id) from user_reply where TO_DAYS(reply_date)=TO_DAYS(now()) and reply_forum=9")%></td>
                <td width="130">主题：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=9")%></td>
                <td width="150"> 帖子：<%=workDB.queryCount("select count(topic_id) from user_topic where topic_forum=9")+workDB.queryCount("select count(reply_id) from user_reply where reply_forum=9")%></td>
              </tr>
            </table>
        </div></td>
      </tr>
    </table>
<%=tablebottom%>
<br>
<%=tabletop%>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
  <tr valign="middle">
    <td height="25" colspan="2" class="b1">&nbsp;</td>
  </tr>
  <tr>
    <td width="40"><div align="center"><img src="images/btype4.gif" width="40"></div></td>
    <td width="100%">您的系统信息:<%=request.getHeader("User-Agent")%><br>您的IP:<%=request.getRemoteAddr()%>&nbsp;:&nbsp;<%=request.getRemotePort()%>
    <%String grade="";
      if(!workFC.cNULL(String.valueOf(session.getAttribute("u_name")))){
        grade="游客";
      }else{
        String usergrade=workDB.queryData("select user_type from user_info where user_name='"+session.getAttribute("u_name")+"'");
        switch (Integer.parseInt(usergrade)){
          case 0  : grade="会员"; break;
          case 1:case 2:case 3:case 4:case 5:case 6:case 7:case 8:case 9: grade="版主"; break;
          case 100: grade="管理员"; break;
          default : grade=""; break;
        }
      }
      out.println("<br>等级:"+grade);
     %>
    </td>
  </tr>
</table>
<%=tablebottom%>
<br>
<%=tabletop%>
<table width="100%" border="0" cellpadding="0" cellspacing="1">
  <tr valign="middle">
    <td height="25" colspan="2" class="b1">&nbsp;</td>
  </tr>
  <tr>
    <td width="40"><div align="center"><img src="images/btype5.gif"></div></td>
    <td width="100%">
<%@ page import="javabean.Listener"%>
<%
Map map=new HashMap();
map=Listener.getOnLineUser();

out.println("<a href='javascript:ShowUserList();'><img id='btn' src='images/add.gif'></a>"+
    "目前论坛总共有 "+(Listener.getOnLineGuest()+map.size())+" 人在线,其中注册用户 "+map.size()+" 人,游客 "+
    Listener.getOnLineGuest()+" 人");

out.println("<div id='list' style='display:none;'><br>");
int i=0;
for(Iterator it=map.keySet().iterator();it.hasNext();){//entrySet()
  Object key=it.next();
  i++;
  out.println("&nbsp;&nbsp;&nbsp;<a href='userinfo.jsp?name="+workFC.UnitoGB((String)map.get(key))+"'>"+
      workFC.UnitoGB((String)map.get(key))+"</a>");
  if(i%10==0)out.println("<br><br>");
}
out.println("<br><br></div>");
%>
    </td>
  </tr>
</table>
<%=tablebottom%>
<br>
<table width="96%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="29%"><div align="right"><img src="images/btype1.gif" width="40" height="30"></div></td>
    <td width="12%">有新贴子</td>
    <td width="5%"><img src="images/btype3.gif" width="40" height="30"></td>
    <td width="14%">无新贴子</td>
    <td width="5%"><img src="images/btype2.gif" width="40" height="30"></td>
    <td width="35%">权限论坛</td>
  </tr>
</table>
<%@ include file="footer.jsp"%>
<script language="javascript">
<!--
function ShowUserList(){
  if(document.getElementById("list").style.display=="none"){
    document.getElementById("list").style.display="";
    document.getElementById("btn").src="images/sub.gif";
  }else{
    document.getElementById("list").style.display="none";
    document.getElementById("btn").src="images/add.gif";
  }
}
//-->
</script>
</body>
</html>