gonggao.asp

信息管理系统 管理页面:admin/index.asp 用户和密码都是admin

<!--#include file=conn.asp-->
<script language="JavaScript">
function closewindow()
{ 
  window.close();
}
</script>
<link rel="stylesheet" type="text/css" href="1.css">
    <% 
    dim id,rs,sql
    id=trim(request("id"))
    if id="" then
    call list()
	response.end
	end if
    set rs=server.createobject("adodb.recordset")
    sql="select * from [gonggao] where id="&cstr(id)
    rs.open sql,conn,1,1
    if rs.eof and rs.bof then
	response.write "没有新闻"
	response.end
   	end if
   	function HTMLEncode(fString)
    fString = replace(fString, ">", "&gt;")
    fString = replace(fString, "<", "&lt;")
    fString = Replace(fString, CHR(13), "")
    fString = Replace(fString, CHR(10) & CHR(10), "</P><P>")
    fString = Replace(fString, CHR(10), "<BR>")
    HTMLEncode = fString
    end function
   	%>
   	<title><%=rs("biaoti")%></title>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9933" width="100%">
  <tr>
    <td width="100%">
    <div align="center">
      <center>
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="96%">
      <tr>
        <td width="100%" colspan="3">
        <p align="right">
        <br>
        <font size="2"><font color="#808080">[</font><a href="news.asp"><font color="#808080">返回</font></a><font color="#808080">]</font><span style="font-weight: 700"> </span>
        </font>
        <font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
        <span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
        <a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none; font-weight:700">
        <font color="#808080">关闭窗口</font></a></span></font></td>
      </tr>
      <tr>
        <td width="100%" colspan="3"><img border="0" src="img/logo.gif"><br>
　</td>
      </tr>
      <tr>
        <td width="100%" colspan="3">
        <p align="center"><span style="font-size: 14pt; font-weight: 700"><%=rs("biaoti")%></span></td>
      </tr>
      <tr>
        <td width="34%" height="18">
        </td>
        <td width="33%" height="18">
        </td>
        <td width="33%" height="18">
        <font color="#C0C0C0" size="2"><%=rs("data")%></font></td>
      </tr>
      <tr>
        <td width="100%" colspan="3"><font size="2">&nbsp;&nbsp;&nbsp; <%=HTMLEncode(rs("neirong"))%></font></td>
      </tr>
      <tr>
        <td width="100%" colspan="3">
        <p align="right">
        <b>
        <font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
        <span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
        <a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none">
        <font color="#808080">关闭窗口</font></a></span></font><font size="2" color="#808080"><br>
　</font></b></td>
      </tr>
    </table>
      </center>
    </div>
    </td>
  </tr>
</table>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
<%sub list()
dim k
set rs=server.createobject("adodb.recordset")
sql="select * from [gonggao] order by id desc"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "没有新闻"
response.end
end if
k=0
%>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#FF9933" width="100%" height="13">
  <tr>
    <td width="100%" height="13">
    <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="98%">
      <tr>
        <td width="8%" colspan="2">　</td>
        <td width="64%">　</td>
        <td width="28%">　</td>
      </tr>
      <tr>
        <td width="2%">　</td>
        <td width="6%" height="20">
        <p align="center"><font size="2">编号</font></td>
        <td width="64%" height="20"><font size="2">标题</font></td>
        <td width="28%" height="20"><font size="2">发布时间</font></td>
      </tr>
      <%do while not rs.eof%><span style="font-size: 9pt">
      <tr>
        <td width="2%">　</td>
        <td width="6%" height="20"> </span>
        <p align="center">
        <font size="2"><%=k+1%></font></td>
        <td width="64%" height="20"><a href="javascript:win=open('news.asp?id=<%=rs("id")%>','offer','width=560,height=450,status=no,menubar=yes,scrollbars=yes,top=0,left=0'); win.focus()">
        <font size="2"><%=rs("biaoti")%></font></a></td>
        <td width="28%" height="20"><font size="2" color="#C0C0C0"><%=rs("data")%></font></td>
      </tr>
      <span style="font-size: 9pt">
      <%
      rs.movenext
      k=k+1
      loop
      %> </span>
      <tr>
        <td width="100%" colspan="4">
        <p align="right">
        <b>
        <font style="FONT-SIZE: 15px; COLOR: #000066; FONT-FAMILY: 宋体">
        <span style="FONT-SIZE: 10pt; FONT-FAMILY: 宋体">
        <a class="yellow" href="javascript:closewindow();" target="_self" style="text-decoration: none">
        <font color="#808080">关闭窗口</font></a></span></font></b></td>
      </tr>
      <tr>
        <td width="100%" colspan="4">　</td>
      </tr>
    </table>
    </td>
  </tr>
</table>
<%end sub%>