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

📄 notice.asp

📁 我的课程设计
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!-- #include file="conn.asp" -->
<%
	if  (session("username")="") then 	
		response.Redirect("index.asp")
	end if
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改文章</title>
<link rel="stylesheet" href="css/admin.css" type="text/css">
</head>
<%
	Dim ShowPage,strAid,strTitle,strTime,strSQL 
     Dim Page,rs
					
%>
<body>

<br>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
   <tr>
      <td height="28" class="title">你正在查看 <font color="#FFFFFF">[最新消息] 
	  </font>的文章&nbsp;&nbsp; 
	  </td>
  </tr> 
</table>

<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="73"><table  height="12%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
        <tr align="center"> 
          <td width="92" height="30" align="center" >编号</td>
          <td width="232" height="27" align="center">文章标题</td>
		  <td width="153" align="center">添加时间</td>
          <td width="62">编辑</td>
          <td width="64">删除</td>
		  
        </tr> 
	<%
    strSQL="SELECT * FROM notice"
	 set rs=server.createobject("adodb.recordset")
	rs.open strSQL,db,1,1
	if not rs.bof and not rs.eof then
	    Page=request.QueryString("page")
		if page="" then 
		   page=1
		else
		   page=CInt(page)
		end if
		rs.PageSize=20
		rs.AbsolutePage=page
		ShowPage=page
		Dim I
		I=rs.PageSize
		do while not rs.eof and I>0
		      I=I-1
			  strAid=rs("id")
			  strTitle=rs("title")
			  strTime=rs("createtime")
%>
        <tr align="center"> 
          <td  height="30" align="center"><%= strAid %></td>
          <td width="232" height="27" align="center"><a href="editnotice.asp?noticeid=<%= strAid %>"><%= strTitle %></a></td>          
          <td width="153" align="center"><%= strTime %></td>
          <td width="62"><a href="editnotice.asp?noticeid=<%= strAid %>"><img src="images/admin/edit.gif" alt="编辑栏目" height="18" border="0"></a></td>
          <td width="64"><a href="delnotice.asp?noticeid=<%= strAid %>"><img src="images/admin/del.gif" width="16" height="16" border="0"></a></td>
		  
        </tr>
        <%
		rs.movenext
	loop
	if rs.RecordCount<1  then
	%>
        <tr align="center"> 
          <td height="27" colspan="8" class="title">对不起,该栏目还没有文章,请先添加!</td>
        </tr>
        <%
     end if
	%>
      </table></td>
  </tr>
  <%
     if  rs. RecordCount>20 then
  %>
  <tr> 
    <td width="76%" height="29" valign="middle"> 
      <p align="right"><font color="#FFFFFF">  
        第<%= ShowPage %>页&nbsp; 共<%=rs.PageCount%>页&nbsp; <%=rs. RecordCount %>条记录&nbsp;</font> <font color="#FFFFFF"> 
        <%if ShowPage>1then %>
        <a href="article.asp?blockid=<%= strBlockid %>&page=1">首页</a> 
        <%else%>
        首页 
        <% end if %>
        &nbsp; 
        <%if ShowPage>1then %>
        <a href="article.asp?blockid=<%= strBlockid %>&page=<%=ShowPage-1%>">前页</a> 
        <%else%>
        前页 
        <% end if %>
        &nbsp; 
        <% if  ShowPage<rs.PageCount then  %>
        <a href="article.asp?blockid=<%= strBlockid %>&page=<%=ShowPage+1%>">后页</a> 
        <%else%>
        后页 
        <% end if %>
        &nbsp; 
        <%if  ShowPage<rs.PageCount  then %>
        <a href="article.asp?blockid=<%= strBlockid %>&page=<%=rs.PageCount%>">末页</a> 
        <%else%>
        末页 
        <% end if %>
        &nbsp; &nbsp; &nbsp; </font></td>
  </tr>
  <%
        end if
  %>
</table>


<% 
   end if 
%>

<p>&nbsp;</p>
</body>
</html>

⌨️ 快捷键说明

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