<!--#include file="setup.asp"-->
<!--#include file="check.asp"-->
<HTML>
<HEAD>
<title>后台管理</title>
<META content=zh-cn http-equiv=Content-Language>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<LINK href="Images/Style.css" type=text/css rel=stylesheet>
</HEAD>
<BODY leftMargin=0 topMargin=0>

<table width=98% align="center" border="0" cellspacing="1" cellpadding="2" class="tableBorder">
<tr>
<th width="20%">名称</th>
<th width="7%">类别</th>
<th width="65%">地址</th>
<th width="8%" colspan="2">管理</th>
</tr>
<%
dim page,pagesize,j,bg1,totalrecord,pgnum
page=request("page")
pagesize = 20
j=0
set rs=Server.CreateObject("ADODB.RecordSet")
sql="select * from Playerlist order by id desc"
rs.open sql,conn,1,1
if rs.eof then
%>
<tr bgcolor="#FFFFFF"><td align=center colspan="5" height=60>没找到相应的记录！</td></tr>
<%
end if
rs.PageSize = PageSize
totalrecord=rs.recordcount
pgnum=rs.Pagecount
if page="" or clng(page)<1 then page=1
if clng(page) > pgnum then page=pgnum
if pgnum>0 then rs.AbsolutePage=page
do while not rs.eof
j=j+1
if j mod 2 = 0 then
bg1="#EFEFEF"
else
bg1="#FFFFFF"
end if
%>
<tr bgcolor="<%=bg1%>" height="24" align="center">
<td align="left">&nbsp;<%=rs("musicname")%></td>
<td><%=rs("classname")%></td>
<td><%=rs("url")%></td>
<td><a href="Player_Edit.asp?id=<%=rs("id")%>"><font color="#004400">编辑</font></a></td>
<td><a href="Player_Save.asp?action=del&id=<%=rs("id")%>" onClick="javascript:return confirm('删除后不能恢复！\n\n确认删除？')"><font color="#440000">删除</font></a></td>
</tr>
<%
if j>=PageSize then exit do
rs.movenext
loop
rs.close
set rs=nothing
%>
<tr><td colspan="5" height="30" bgcolor="#EEEEEE" align="center">
共<%=totalrecord%>个 
<a href="?page=1"><font color="#202020">首页</font></a><font color="#202020"> 
                              | </font> <a href="?page=<%=page-1%>"><font color="#202020">上一页</font></a><font color="#202020"> 
                              | </font> <a href="?page=<%=page+1%>"><font color="#202020">下一页</font></a><font color="#202020"> 
                              | </font> <a href="?page=<%=pgnum%>"><font color="#202020">最后一页</font></a><font color="#202020">&nbsp;(<%=page%>/<%=pgnum%>) 
                              </font>
</td></tr>
</table>
</body>
</html>
<%closeconn%>
