📄 newslist.asp
字号:
<!--#include file="../conndb.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新闻管理</title>
<link href="../style.css" rel="stylesheet">
<script language="javascript">
function news90(url) {
var oth="toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,left=200,top=200";
oth = oth+",width=400,height=300";
var news90=window.open(url,"news90",oth);
news90.focus();
return false;
}
function SelectChk()
{
var s=false;
var deptid,n=0;
var strid,strurl;
var nn = self.document.all.item("news")
for (j=0;j<nn.length;j++)
{
if (self.document.all.item("news",j).checked)
{
n = n + 1;
s=true;
deptid = self.document.all.item("news",j).id+"";
if(n==1)
{
strid = deptid;
}
else
{
strid = strid + "," + deptid;
}
}
}
strurl = "NewsDelt.asp?id=" + strid;
if(!s) {
alert("请选择要删除的新闻!");
return false;
}
if ( confirm("你确定要删除这些新闻吗？")) {
form1.action=strurl;
form1.submit();
}
}
function sltAll()
{
var nn = self.document.all.item("news");
for(j=0;j<nn.length;j++)
{
self.document.all.item("news",j).checked = true;
}
}
function sltNull()
{
var nn = self.document.all.item("news");
for(j=0;j<nn.length;j++)
{
self.document.all.item("news",j).checked = false;
}
}
</script>
</head>
<body link="#000080" vlink="#080080">
<form id="form1" name="form1" method="POST">
<%
Dim rs
Set rs = Server.CreateObject("ADODB.RecordSet")
'按发布时间降序读取新闻
sql = "SELECT * FROM News ORDER BY PostTime DESC"
rs.Open sql, Conn, 1, 1
If rs.EOF Then
Response.Write "<tr><td colspan=5 align=center>目前还没有新闻。</td></tr></table>"
Else
%>
<p align=center><font color="#000080" style="font-size: 12pt"><b>新 闻 管 理</b></font></p>
<table align=center border="1" cellspacing="0" width="100%" bordercolor="#5A8FF0">
<tr>
<td width="56%" align="center" bgcolor="#5A8FF0"><strong>题目</strong></td>
<td width="24%" align="center" bgcolor="#5A8FF0"><strong>时间</strong></td>
<td width="10%" align="center" bgcolor="#5A8FF0"><strong>修改</strong></td>
<td width="10%" align="center" bgcolor="#5A8FF0"><strong>选择</strong></td>
</tr>
<%
'设置每页显示记录
rs.PageSize = 15
'读取当前页码
iPage = Request("Page")
If iPage <=0 Then
iPage = 1
End If
If iPage > rs.PageCount Then
iPage = rs.PageCount
End If
rs.AbsolutePage = iPage
'循环显示当前页的记录
For i = 1 To rs.PageSize
%>
<tr>
<td><a href="../NewsView.asp?id=<%=rs("Id")%>" onClick="return news90(this.href)"><%=rs("Title")%></a></td>
<td align="center"><%=rs("PostTime")%></td>
<td align="center"><a href="NewsEdit.asp?id=<%=rs("id")%>" onClick="return news90(this.href)">修改</a></td>
<td align="center"><input type="checkbox" name="news" id="<%=rs("id")%>"></td>
</tr>
<%
rs.MoveNext()
If rs.EOF Then
Exit For
End If
Next
%>
</table>
<%
'显示页码链接
If rs.PageCount>1 Then
Response.Write "<table border='0'>"
Response.Write "<tr>"
Response.Write "<td><b>分页：</b></td>"
For i=1 to rs.PageCount
Response.Write "<td><a href='NewsList.asp?page=" & i & "'>"
Response.Write "[<b>" & i & "</b>]</a>"
Response.Write "</td>"
Next
Response.Write "</tr></table>"
End if
End If
%>
<p align="center">
<input type="button" value="添加新闻" onclick="news90('NewsAdd.asp')" name=add>
<input type="button" value="全 选" onclick="sltAll()" name=button1>
<input type="button" value="清 空" onclick="sltNull()" name=button2>
<input type="submit" value="删 除" name="tijiao" onclick="SelectChk()">
<br><br>
<input type=hidden name="news">
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -