8_8.asp
来自「《asp网页设计》作者沈才梁源代码,共十章」· ASP 代码 · 共 29 行
ASP
29 行
<HTML><HEAD>
<TITLE>8_8.asp记录指针的移动取得姓名字段值</TITLE>
</HEAD>
<BODY>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.open "txl"
Set Rs = Server.CreateObject("ADODB.Recordset")
SQL = "Select * from userlist Order by ID"
Rs.Open SQL,Conn,1,1
If Not Rs.Eof Then
Rs.MoveFirst
Response.write "第一条记录:" & Rs("姓名") & "<br>"
Rs.MoveNext
Response.write "第二条记录:" & Rs("姓名") & "<br>"
Rs.MoveLast
Response.write "最后一条记录:" & Rs("姓名") & "<br>"
Rs.MovePrevious
Response.write "倒数第二条记录:" & Rs("姓名") & "<br>"
End If
Rs.Close
Set Rs = Nothing
Conn.Close
Set Conn = Nothing
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?