📄 up.asp
字号:
<!-- #include file="adovbs.inc" -->
<!-- #include file="top.asp" -->
<%
'判断用户是否具有删除数据的权限
if Session("level") < 2 then
Response.write"<br><br><br><br>您没有操作权限或连接已经超时，请重新登录！"
Response.end
end if
Set rs=Server.CreateObject("Adodb.recordSet")
Con="Provider=sqloledb;Data Source=(local);Initial Catalog=txl;User ID=sa;Password=;"
sql="select * from t_student order by d_class,d_no"
'判断用户是否指定了搜索条件
who=Request.Form("who")
if Request.Form("sel")="查找" and who <> "" then
sql="select * from t_student where d_name='"&who&"' order by d_class,d_no"
else
sql="select * from t_student order by d_class,d_no"
end if
'Response.write(sql)
'Response.end
'rs.Open sql,Con,AdOpenStatic,adlockreadonly,adcmdtext
rs.Open sql,Con,1,1
if rs.eof then
Response.write"<p>对不起，数据库中没有数据！</p>"
Response.end
end if
'设置Recordset对象的每一页数据记录条数的大小
rs.PageSize=9
if not isnumeric(request("page")) then
NowPage=1
else
NowPage=Clng(Request("page"))
end if
if NowPage="" then NowPage=1
if NowPage < 1 then NowPage=1
if NowPage > rs.PageCount then NowPage=rs.PageCount
rs.AbsolutePage=NowPage
%>
<html>
<head>
</head>
<body>
<div align="center">
<h4>同学信息列表</h4>
<form action="up.asp" method="post">
<p>请输入学生姓名：<input type="text" name="who" size="12">
<input type="submit" name="sel" value="查找"></p>
<table border="1" width="776" bordercolor="#666699">
<!-- #include file="tabtop.htm" -->
<%
'输出当前页面记录
for j=0 to rs.PageSize-1
Response.Write"<tr align=center valign=middle height=23>"
for i=0 to rs.fields.count-1
Response.write"<td>" & rs.fields(i).value & " </td>"
next
Response.Write"<td><a href='update.asp?class="&trim(rs("d_class"))&""&chr(38)&"no="&trim(rs("d_no"))&"'>修改</a></td>"
'<% Response.Write"<a href='output3.asp?user=普通职员'>普通职员</a>"%
Response.Write"</tr>"
rs.MoveNext
if rs.eof then exit for
Next
Response.Write"</table><br>"
'输出首页，上一页，下一页和尾页对应的链接
if NowPage <> 1 then
Response.Write"<a href='up.asp?page=1'>首页</a>"
Response.write" "
Response.Write"<a href='up.asp?page="&NowPage-1&"'>上一页</a>"
end if
if NowPage <> rs.PageCount then
Response.write" "
Response.Write"<a href='up.asp?page="&NowPage+1&"'>下一页</a>"
Response.write" "
Response.Write"<a href='up.asp?page="&rs.PageCount&"'>尾页</a>"
end if
%>
<p>数据页数 <% =NowPage %>/<% =rs.PageCount %>
请输入页号：<input type="text" name="page" size="4">
<input type="submit" name="go" value="转到">
<input type="reset" value="取消">
</p>
</form>
</div>
<!-- #include file="bottom.asp" -->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -