家庭/个人应用

开发平台：
ASP/ASPX

special_list.asp：源码内容
							
<!--#include file="articleconn.asp"-->
<!--#include file="security.asp"-->
<!--#include file="../checkpost.asp"-->
<!--#include file="inc/function.asp"-->
<%if session("flag")>1 then
    response.write "<script>alert('您的操作权限不够！');history.back();</script>"
    response.end
end if
%>
<%'分页
set rs=server.createobject("adodb.recordset")
sql="select * from special"
rs.open sql,conn,1,1
  page=Request("page")
  if page=0 then
     page=1
  end if
  RecordCount = 0 
  do while not rs.Eof
    RecordCount = RecordCount +1
    rs.MoveNext 
  loop
  if not RecordCount=0 then
     rs.MoveFirst
  end if
  pageCount=RecordCount/10
  pageCount=int(pageCount)
  if (RecordCount mod 10)>0 then
     PageCount=PageCount +1
  end if 
rs.close
set rs=nothing
  %>
<html>
<head>
<title>修改/删除专辑</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="inc/Admin_STYLE.css">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div align="center"> 
  <p>&nbsp; </p>
  <center>
        
    <table width="95%" border="0" cellpadding="2" cellspacing="1" class="border">
      <tr> 
        <td width="250" class="tdbg" style="letter-spacing: 1">共有专辑<font color="#FF0000"><%=RecordCount%></font>个，目前<font color="#ff0000"><%=page%>/<%=pageCount%></font>页</td>
        <td width="50" align="center" class="tdbg" style="letter-spacing: 1"> 
          <%if page=1 then
            %>
          首页 
          <%else%>
          <a href="special_list.asp">首页</a> 
        <%end if%>        </td>
        <td width="75" align="center" class="tdbg" style="letter-spacing: 1"> 
          <%if page=1 then
            %>
          上一页 
          <%else%>
          <a href="special_list.asp?page=<%=page-1%>">上一页</a> 
        <%end if%>        </td>
        <td width="75" align="center" class="tdbg" style="letter-spacing: 1"> 
          <%if pagecount-page=0 then
            %>
          下一页 
          <%else%>
          <a href="special_list.asp?page=<%=page+1%>">下一页</a> 
        <%end if%>        </td>
		<td width="50" align="center" class="tdbg"> 
          <%if pagecount-page=0 then%>
          尾页 
          <%else%>
          <a href="special_list.asp?page=<%=pagecount%>">尾页</a> 
        <%end if%>        </td>
      </tr>
    </table>
  </center>
      <%
	 set rs=server.createobject("adodb.recordset")
	 sql="select * from special order by id desc"
	 rs.open sql,conn,1,1
	 if rs.eof and rs.bof then
	  response.redirect "error1.asp?err_on=5"
	 else
      %>
  <table width="95%" border="0" cellpadding="2" cellspacing="1" class="border">
<%do while pos<(page-1)*10                                 
pos=pos+1                                 
rs.moveNext                                 
loop%>                                 
<%x=0%>                                
<%do while x<10 and not rs.eof%>
    <tr class="tdbg"> 
      <td width="50"><div align="center"><%=rs("id")%></div></td>
      <td width="350"><%=rs("special")%></td>
      <td width="50"><a href=special_edit.asp?id=<%=rs("id")%>><div align="center">修改</div></a></td>
      <td width="50"><a href=special_del.asp?id=<%=rs("id")%>><div align="center">删除</div></a></td>
    </tr>
<% 
x=x+1                                
rs.movenext                                
loop
rs.close
set rs=nothing
end if
conn.close
set conn=nothing
%>
  </table>
  <p>&nbsp;</p>
</div>
</body>
</html>

						