main.jsp~85~

一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.bwm.core.*" %>
<%@ page import="com.bwm.model.*" %>
<%@ page import="java.util.*" %>
<link href="../css/admin.css" rel="stylesheet" type="text/css">
<table width="100%"  border="0" cellspacing="0" cellpadding="0">
<% if (Crazyadept.UserIsOK(session,FinalConstants.STATUS_ADMIN)){%>
  <tr>
    <td height="60" class="bottomline"><img src="../images/pass4.gif"><a href="../admin/index.jsp" class="delink">进入管理员控制台</a></td>
  </tr>
<%}%>
  <tr>
    <td height="60"><img src="../images/pass0.gif">论谈公告</td>
  </tr>
<% BasetableFactory bf=BasetableFactory.getInstance();
        Collection coll=bf.ListFsort("WHERE state="+FinalConstants.STATE_AFFICKHE);
        if(coll==null||coll.size()<=0||coll.isEmpty()){
%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td>『无』</td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10>暂无公告版块</td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%
        }else{
        Iterator it=coll.iterator();
        while(it.hasNext()){
            Fsort f=(Fsort)it.next();

%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td><a href="theme.jsp?action=affiche">『<%=f.getName()%>』</a></td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10><%=f.getResume()%></td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%}}%>
  <tr>
    <td height="60" class="topline"><img src="../images/pass1.gif">技术版块</td>
  </tr>
<%
        Collection coll1=bf.ListFsort("WHERE state="+FinalConstants.STATE_TECHNIC);
        if(coll1==null||coll1.size()<=0||coll1.isEmpty()){
%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td>『无』</td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10>暂无技术版块</td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%
        }else{
        Iterator it=coll1.iterator();
        while(it.hasNext()){
            Fsort f=(Fsort)it.next();

%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td><a href="theme.jsp?action=technic">『<%=f.getName()%>』</a></td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10><%=f.getResume()%></td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%}}%>
  <tr>
    <td height="60" class="topline"><img src="../images/pass3.gif">非技术版块</td>
  </tr>
<%
        Collection coll2=bf.ListFsort("WHERE state="+FinalConstants.STATE_NOTECHNIC);
        if(coll2==null||coll2.size()<=0||coll2.isEmpty()){
%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td>『无』</td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10>暂无非技术版块</td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%
        }else{
        Iterator it=coll2.iterator();
        while(it.hasNext()){
            Fsort f=(Fsort)it.next();

%>
  <tr>
    <td><table width="100%"  border="1" cellpadding="0" cellspacing="0" bordercolor="efefef" bgcolor="f9f9f9" >
        <tr>
          <td width="60" rowspan="3" align="center"><IMG src="../images/off.gif" width=32></td>
          <td><a href="theme.jsp?action=technic">『<%=f.getName()%>』</td>
        </tr>
        <tr>
          <td><IMG height=10 src="../images/forum_readme.gif" width=10><%=f.getResume()%></td>
        </tr>
        <tr>
          <td><TABLE align=left border=0 cellPadding=0 cellSpacing=0 width=176>
              <TR align="center">
                <TD width=40><IMG src="../images/forum_today.gif"></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                <TD>0</TD>
                <TD width=40><IMG src="../images/forum_post.gif" ></TD>
                <TD>0</TD>
              </TR>
            </TABLE></td>
        </tr>
      </table></td>
  </tr>
<%}}%>
  <tr>
    <TD height="60" class="topline" ><IMG src="../images/pass2.gif">名单图例：</TD>
  </tr>
  <tr>
    <TD height="100">　<IMG height=11
                  src="../images/vip.gif" width=12> 管理员　‖　<IMG height=16
                  src="../images/ao3.gif" width=16>　注册用户　‖　<IMG height=16
                  src="../images/ao5.gif" width=16>　游客 　
    <P>　<img height=16
                  src="../images/on.gif" width=16>　有新贴的论坛　‖　<IMG height=16
                  src="../images/off.gif" width=16>　 没有新贴的论坛 　‖<img height=16
                  src="../images/Lock.gif" width=16>　 被锁定的论坛 </TD>
  </tr>
  <tr>
    <td>&nbsp;</td>
  </tr>
</table>