announcementview.jsp

jsp bbs源代码

<%
/*##################################################################**
**#  LyBBS ver 1.2.b2 (1.2.beta-2版) / 凌云论坛 ver 1.2.b2         #**
**#                                                                #**
**#  版权所有: 凌云工作室 (原流星电脑工作室)                       #**
**#                                                                #**
**#  制作人  : 星语凌 『teddy (Yongshan Ye)』                      #**
**#                                                                #**
**#  主页地址: http://www.unix-now.com/lybbs   凌云论坛主页        #**
**#            http://www.ierp.info/lybbs      凌云论坛镜像站      #**
**#            http://[e-mail]/        凌云论坛支持信箱    #**
**#                                                                #**
**##################################################################*/
%>
<table cellpadding=0 cellspacing=0 border=0 width=<%=tablewidth%> bgcolor=<%=tablebordercolor%> align=center>
 <tr>
  <td>
   <table cellpadding=3 cellspacing=1 border=0 width=100% style="TABLE-LAYOUT: fixed">
<%
number=connect.getRowNum("announcement where db="+db);
if(number!=0) {
  rs=connect.executeQuery("select id,author,title,content,date_format(postat,'%Y年%m月%d日 %H:%i') as postat from announcement where db="+db+" order by postat desc,id");
  while(rs.next()) {
    announceid=rs.getInt(1);
    announceauthor=rs.getString(2);
    announcetitle=rs.getString(3);
    announcecontent=rs.getString(4);
    announcepostat=rs.getString(5);
    i++;
    if(i%2==0)
      announcebgcolor=postcolorone;
    else
      announcebgcolor=postcolortwo;
%>
    <tr>
     <td bgcolor=<%=titlecolor%> align=center valign=top>
       <font face="宋体" color=<%=titlefontcolor%>><b>&gt;&gt; <%=announcetitle%> &lt;&lt;</b></font>
     </td>
    </tr>
<%
if(isadmin>0) {
%>
    <tr>
     <td bgcolor=<%=announcebgcolor%> align=left>
      <a href="announcement.jsp?action=delete&announceid=<%=announceid%>&db=<%=db%>"><img src="images/a_delete.gif" border=0"></a>
      <a href="announcement.jsp?action=edit&announceid=<%=announceid%>&db=<%=db%>"><img src="images/a_edit.gif" border=0"></a> 
      <a href="announcement.jsp?action=add&db=<%=db%>"><img src="images/a_add.gif" border=0"></a>
     </td>
    </tr>
<%
}
%>
    <tr>
     <td bgcolor="<%=announcebgcolor%>" valign=top style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word">
      <font face="宋体" color=<%=postfontcolortwo%>>
       <p><blockquote><%=announcecontent%></blockquote><p>
      </font>
     </td>
    </tr>
    <tr>
     <td bgcolor="<%=announcebgcolor%>" valign=middle>
      <table width=100% border="0" cellpadding="0" cellspacing="0">
       <tr>
        <td align=left>
          &nbsp;&nbsp;&nbsp;
          <font face="宋体" color=<%=postfontcolortwo%>><b>发布人</b>： <%=announceauthor%></font>
        </td>
        <td align=right>
          <font face="宋体" color=<%=postfontcolortwo%>><b>发布时间</b>： <%=announcepostat%></font>
          &nbsp;&nbsp;&nbsp;
       </tr>
      </table>
     </td>
    </tr>
<%
  }
}
else {
%>
    <tr>
     <td bgcolor=<%=titlecolor%> align=center valign=top>
       <font face="宋体" color=<%=titlefontcolor%>><b>&gt;&gt; 当前没有任何公告 &lt;&lt;</b></font>
     </td>
    </tr>
<%
if(isadmin>0) {
%>
    <tr>
     <td bgcolor=<%=announcebgcolor%> align=left>
      <a href="announcement.jsp?action=delete&announceid=<%=announceid%>&db=<%=db%>"><img src="images/a_delete.gif" border=0"></a>
      <a href="announcement.jsp?action=edit&announceid=<%=announceid%>&db=<%=db%>"><img src="images/a_edit.gif" border=0"></a> 
      <a href="announcement.jsp?action=add&db=<%=db%>"><img src="images/a_add.gif" border=0"></a>
     </td>
    </tr>
<%
}
%>
    <tr>
     <td bgcolor="<%=announcebgcolor%>" valign=top style="LEFT: 0px; WIDTH: 100%; WORD-WRAP: break-word">
      <font face="宋体" color=<%=postfontcolortwo%>>
       <p><blockquote>请点击添加图标来发布一个公告(必须是管理员)。<br>当你发布一次公告后，本公告就会自动消失，无需你手动删除！ </blockquote><p>
      </font>
     </td>
    </tr>
    <tr>
     <td bgcolor="<%=announcebgcolor%>" valign=middle>
      <table width=100% border="0" cellpadding="0" cellspacing="0">
       <tr>
        <td align=left>
          &nbsp;&nbsp;&nbsp;
          <font face="宋体" color=<%=postfontcolortwo%>><b>发布人</b>： 本站的默认公告</font>
        </td>
        <td align=right>
          <font face="宋体" color=<%=postfontcolortwo%>><b>发布时间</b>： <%=now_time%></font>
          &nbsp;&nbsp;&nbsp;
       </tr>
      </table>
     </td>
    </tr>
<%
}
%>
   </table>
  </td>
 </tr>
</table>