这是全的,请看一看
<!--#include file="conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body,td,th {
font-size: 13px;
}
.STYLE9 {color: #FF0000}
.STYLE10 {
font-size: 18px;
font-family: "宋体";
font-weight: bold;
}
-->
</style></head>
<body>
<div align="center">
<table width="800" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<th height="25" colspan="3" valign="middle"><div align="center" class="STYLE10" style="font-size=26px">留 言 本</div></th>
</tr>
<tr>
<th height="25" colspan="3" valign="middle"><form name="form1" method="post" action="cxasp.asp">
<label>
<input name="cx" type="text" id="cx">
</label>
<label>
<input type="submit" name="Submit" value="提交">
</label>
</form>
</th>
</tr>
<%
exec="select * from tj order by id desc"
set rs=Server.CreateObject("ADODB.Recordset")
rs.open exec,conn,1,1
rs.pagesize=2
if request.Querystring("page")="" then
page=1
else
page=request.querystring("page")
end if
rs.absolutepage=page
if not rs.eof then
for i=1 to rs.pagesize
if not rs.eof then
%>
<tr bgcolor="#CCCCCC">
<td height="18" colspan="2" align="left" valign="middle" bgcolor="#6699FF"> 标题:
<%=rs("bt")%> </td>
<td height="18" align="left" valign="middle" bgcolor="#6699FF"><!--DWLayoutEmptyCell--> </td>
</tr>
<tr bgcolor="#CCCCCC">
<td height="46" colspan="3" align="left" valign="middle" bgcolor="#FFFFFF"><table width="780" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><%=rs("nr")%></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#CCCCCC">
<td width="13" height="25" align="left" valign="middle"><!--DWLayoutEmptyCell--> </td>
<td width="570" valign="middle"><span class="STYLE9"><a href="xg.asp?id=<%=rs("id")%>">编辑</a> | <a href="scasp.asp?id=<%=rs("id")%>">删除</a></span></td>
<td width="217" align="left" valign="middle">留言时间：<%=left(rs("date"),15)%></td>
</tr>
<%
rs.movenext
end if
next
end if
%>
<tr>
<td height="25" colspan="3" valign="middle"><div align="right"><a href="ly.asp">添加新留言</a></div></td>
</tr>
</table>
<%
if page<>1 then
response.write("<a href='index.asp?page=1'>首页</a> ")
response.write("<a href='index.asp?page="&(page-1)&"'>上一页</a> ")
end if
if page<>rs.pagecount then
response.write("<a href='index.asp?page="&(page+1)&"'>下一页</a> ")
response.write("<a href='index.asp?page="&rs.pagecount&"'>尾页</a>")
end if
%>
</div>
</body>
</html>
