📄 sponsorlist.asp
字号:
<%@ LANGUAGE = VBScript %>
<!--#include file="conn.asp"-->
<!--#include file="checklogin.asp"-->
<%
rs.Open "Select * From sponsor order by ID",Conn
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link REL="StyleSheet" HREF="../tjscripts.css" TYPE="text/css" MEDIA="screen">
<title><%= SiteTitle %>后台管理系统</title>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<table border="1" cellspacing="1" width="760" bordercolor="#0033CC">
<tr>
<td width="100%" height="31" bgcolor="#FFCC00"><b>查看首页广告</b></td>
</tr>
<tr>
<td width="100%">
<div align="center">
<table border="1" cellspacing="1" width="99%" bordercolor="#A50F18">
<tr>
<td width="10%" height="30" align="center">广告编号</td>
<td width="15%" height="30" align="center">广告名称</td>
<td width="15%" height="30" align="center">广告类型</td>
<td width="15%" height="30" align="center">广告开始日期</td>
<td width="15%" height="30" align="center">广告结束日期</td>
<td width="15%" height="30" align="center">广告所有者</td>
<td width="15%" height="30" align="center">广告有效性</td>
</tr>
<%
While Not rs.EOF
SponsorID = rs ("ID")
SponsorName = rs ("SponsorName")
SponsorType = rs ("SponsorType")
SponsorBeginDate = rs ("SponsorBeginDate")
SponsorEndDate = rs ("SponsorEndDate")
SponsorOwner = rs ("SponsorOwner")
SponsorValid = rs ("SponsorValid")
%>
<tr>
<td width="10%" height="30" align="center"><%= SponsorID %></td>
<td width="15%" height="30" align="center"><%= Right (SponsorName, Len (SponsorName) - 8) %></td>
<td width="15%" height="30" align="center"><%= SponsorType %></td>
<td width="15%" height="30" align="center"><%= SponsorBeginDate %></td>
<td width="15%" height="30" align="center"><%= SponsorEndDate %></td>
<td width="15%" height="30" align="center"><%= SponsorOwner %></td>
<td width="15%" height="30" align="center"><%= SponsorValid %></td>
</tr>
<%
rs.MoveNext
Wend
rs.Close
Set rs = nothing
Conn.Close
Set Conn = nothing
%>
</table>
</div>
</td>
</tr>
<tr>
<td width="100%" align="center"><a href="javascript:history.back();"><b>返回</b></a></td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -