📄 readmessage.asp

📁 集合了学习asp的100个实例

💻 ASP

字号:

<%

response.buffer=true

response.clear

response.expires=0

%>

<html>

<head>

</head>

<body bgcolor=#c1f7d8>

<p align=center><font size=5>查看留言</font></p>

<%

if not request.querystring("id")="" then

   strdsn="dsn=bbs;uid=feng;pwd=feng"

   strdeletesql="delete from message where id=" &request.querystring("id")

   set rsdelete=server.createoject("adodb.recordset")

   rsdelete.open strdeletesql,strdsn,1,3

   set rsdelete=nothing

   response.redirect "readmessage.asp"

end if

%>

<%

dim strsql,strdsn

strsql="select * from message where messagetoname='" & session("name") & "'"

strdsn="dsn=bbs;uid=feng;pwd=feng"

set rs=server.createobject("adodb.recordset")

rs.open strsql,strdsn,1,3

response.write "<center> 你共有" & rs.recordcount & "条留言"

%>

<%

dim i

response.write "<table border=1 width=100%/><tr>"

for i=1 to rs.recordcount

    response.write "<td width=27%/>" & rs("messagedate") & " " & rs("messagetime") & "</td>"

    response.write "<td width=18%/>" & rs("messagename") & "</td>"

    response.write "<td width=20%/>" & rs("messageemail") & "</td>"

    response.write "<td width=20%/>" & rs("messagehomepage") & "</td>"

response.write "<td width=15%/><a href=return.asp?toname=" & rs("messagename")

response.write ">回复</a>"

response.write "<a href=readmessage.asp?id=" & rs("id") & ">删除</a></td></tr>"

response.write "<tr><td colspan=5>" & rs("messagecontent") & "</td></tr>"

rs.movenext

next 

response.write "</table>"

rs.close

set rs=nothing

%>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -