⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 index.jsp~228~

📁 一个完整的门户网站,基于JSP环境下开发的,使用SQL数据库.
💻 JSP~228~
字号:
🔍 
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="com.bwm.core.*" %>
<%@ page import="com.bwm.model.*" %>
<%@ page import="java.util.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>明日科技论谈</title>
</head>
<link href="../css/admin.css" rel="stylesheet" type="text/css">
<body>
<table width="750" border="0" align="center" cellpadding="0" cellspacing="0"  class="tableBorder6">
  <tr>
    <td height="180"><jsp:include page="top.jsp"/></td>
  </tr>
  <tr>
    <td align="left" valign="top"><table width="100%"  border="0" cellspacing="0" cellpadding="0">
        <% if (adminflag){%>
        <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">论谈公告&nbsp;<%if(session.getAttribute("user")!=null){String dd="";
        dd=(((User)session.getAttribute("user")).getUid());
        out.print(dd+"&nbsp;<A href='../admin/exit.jsp'>安全退出</A>");
    }%> </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/Lock.gif" ></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>
                  </TR>
                </TABLE></td>
              </tr>
            </table></td>
        </tr><%}else{Iterator it=coll.iterator();
        while(it.hasNext()){Fsort f=(Fsort)it.next();
        String src="../images/off.gif";
        boolean b=false;
                Collection coll1=bf.ListForum("WHERE fsid="+f.getFsid());
                if(coll1!=null&&coll1.size()>0){
                    Iterator it1=coll1.iterator();
                        while(it1.hasNext()){Forum fou=(Forum)it1.next();
                        if(StringUtils.compareNowTime(fou.getFtime())&&fou.getState()!=FinalConstants.STATE_FREEZE){b=true;break;}
                        if(bf.SearchReforum("WHERE fid="+fou.getFid()+" AND state!="+FinalConstants.STATE_FREEZE+" AND rtime >now()-2592000").getRefid()>0) {b=true;break;}}
                }
            if(b){ src="../images/on.gif";}
            if(f.getFree()==FinalConstants.STATE_FREEZE){src="../images/Lock.gif";}%>
        <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=<%=src%> ></td>
                <td><a href="<%=f.getFree()==FinalConstants.STATE_FREEZE?"#":"/forum/forum.jsp?fsid="+f.getFsid()%>" >『<%=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><%=Database.getRow("forum WHERE fsid="+f.getFsid())%></TD>
                    <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                    <TD><%=Database.getRow("reforum WHERE fid IN(SELECT fid FROM forum WHERE fsid="+f.getFsid()+")")%></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/Lock.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>
                  </TR>
                </TABLE></td>
              </tr>
            </table></td>
        </tr><%}else{Iterator it=coll1.iterator();
        while(it.hasNext()){Fsort f=(Fsort)it.next();
        boolean b=false;
String src="../images/off.gif";                Collection coll2=bf.ListForum("WHERE fsid="+f.getFsid());
                if(coll2!=null&&coll2.size()>0){
                    Iterator it1=coll2.iterator();
                        while(it1.hasNext()){Forum fou=(Forum)it1.next();
                        if(StringUtils.compareNowTime(fou.getFtime())&&fou.getState()!=FinalConstants.STATE_FREEZE){b=true;break;}
                        if(bf.SearchReforum("WHERE fid="+fou.getFid()+" AND state!="+FinalConstants.STATE_FREEZE+" AND rtime >now()-2592000").getRefid()>0) {b=true;break;}}
                }
            if(b){ src="../images/on.gif";}
            if(f.getFree()==FinalConstants.STATE_FREEZE){src="../images/Lock.gif";}
                %>
        <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=<%=src%> ></td>
                <td><a href="<%=f.getFree()==FinalConstants.STATE_FREEZE?"#":"/forum/forum.jsp?fsid="+f.getFsid()%>" >『<%=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><%=Database.getRow("forum WHERE fsid="+f.getFsid())%></TD>
                    <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                    <TD><%=Database.getRow("reforum WHERE fid IN(SELECT fid FROM forum WHERE fsid="+f.getFsid()+")")%></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/Lock.gif" ></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>
                  </TR>
                </TABLE></td>
              </tr>
            </table></td>
        </tr>
        <%}else{Iterator it=coll2.iterator();        while(it.hasNext()){
            Fsort f=(Fsort)it.next();
        boolean b=false;
String src="../images/off.gif";                Collection coll3=bf.ListForum("WHERE fsid="+f.getFsid());
                if(coll3!=null&&coll3.size()>0){
                    Iterator it1=coll3.iterator();
                        while(it1.hasNext()){Forum fou=(Forum)it1.next();
                        if(StringUtils.compareNowTime(fou.getFtime())&&fou.getState()!=FinalConstants.STATE_FREEZE){b=true;break;}
                        if(bf.SearchReforum("WHERE fid="+fou.getFid()+" AND state!="+FinalConstants.STATE_FREEZE+" AND rtime >now()-2592000").getRefid()>0) {b=true;break;}}
                }
            if(b){ src="../images/on.gif";}
            if(f.getFree()==FinalConstants.STATE_FREEZE){src="../images/Lock.gif";}
   %>
        <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=<%=src%> ></td>
                <td><a href="<%=f.getFree()==FinalConstants.STATE_FREEZE?"#":"/forum/forum.jsp?fsid="+f.getFsid()%>" >『<%=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><%=Database.getRow("forum WHERE fsid="+f.getFsid())%></TD>
                      <TD width=40><IMG src="../images/forum_topic.gif" ></TD>
                    <TD><%=Database.getRow("reforum WHERE fid IN(SELECT fid FROM forum WHERE fsid="+f.getFsid()+")")%></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 src="../images/forum_today.gif">　主题数量
‖　<IMG src="../images/forum_topic.gif" > 　回复数量
<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></td>
  </tr>
  <tr>
    <td align="center"><jsp:include page="bottom.jsp"/></td>
  </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -