📄 select.asp
字号:
<!-- #include file="adovbs.inc" -->
<!-- #include file="top.asp" -->
<html>
<head>
</head>
<body>
<h4>同学信息列表</h4>
<%
Set rs=Server.CreateObject("Adodb.recordSet")
Con="Provider=sqloledb;Data Source=(local);Initial Catalog=txl;User ID=sa;Password=;"
'判断用户是否指定了搜索条件
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
rs.Open sql,Con,AdOpenStatic,adlockreadonly,adcmdtext
if rs.eof then
Response.Write"<p>对不起，数据库中没有数据！</p>"
Response.end
end if
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
%>
<form action="select.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"</tr>"
rs.MoveNext
if rs.eof then exit for
next
Response.Write"</table><br>"
'输出首页，上一页，下一页和尾页对应的链接
if NowPage <> 1 then
Response.Write"<a href='select.asp?page=1'>首页</a>"
Response.write" "
Response.Write"<a href='select.asp?page="&NowPage-1&"'>上一页</a>"
end if
if NowPage <> rs.PageCount then
Response.write" "
Response.Write"<a href='select.asp?page="&NowPage+1&"'>下一页</a>"
Response.write" "
Response.Write"<a href='select.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>
<!-- #include file="bottom.asp" -->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -