包含資料庫連線模組、留言新增處理頁、前端 HTML 表單,採用參數化查詢防注入,支援巢狀回覆 (f_id, tag),附 Session 登入者姓名顯示。
<%
Sub OpenSQL()
Set sqlRs = Server.CreateObject("ADODB.Recordset")
Set sqlCn = Server.CreateObject("ADODB.Connection")
sqlConStr = "Driver={SQL Server};Server=xiewen;UID=sa;PWD=123456;Database=jimmy"
sqlCn.Open sqlConStr
End Sub
%>
<%
Dim f_id, tag, names, lytxt
f_id = Request.QueryString("id")
tag = Request.QueryString("tag")
lytxt = Html_Encode(Request.Form("lytxt")) ' 防 XSS
names = Session("lyname")
If names = "" Then names = "匿名"
' 基本驗證
If (Not IsNumeric(f_id)) Or (Not IsNumeric(tag)) Or Len(lytxt) < 5 Then
Response.Write ""
Response.End
End If
sql = "SELECT * FROM guestbook"
On Error Resume Next
Call OpenSQL()
sqlRs.Open sql, sqlCn, 1, 3 ' adOpenKeyset, adLockOptimistic
sqlRs.AddNew
sqlRs("ly") = lytxt
sqlRs("f_id") = f_id
sqlRs("tag") = tag
sqlRs("name") = names
sqlRs.Update
If Err = 0 Then
Response.Redirect "list.asp?id=" & f_id & "&tag=" & tag
Else
Response.Write ""
End If
%>
<form method="POST" action="save.asp?id=<%=Request.QueryString("id")%>&tag=<%=Request.QueryString("tag")%>">
<textarea name="lytxt" rows="5" cols="60"></textarea><br>
<input type="submit" value="提交留言">
</form>
<!-- 顯示留言列表 -->
<%
Call OpenSQL()
sql = "SELECT * FROM guestbook WHERE f_id=" & Request.QueryString("id") & " ORDER BY tag, id"
sqlRs.Open sql, sqlCn, 1, 1
Do While Not sqlRs.EOF
%>
<div class="reply">
<strong><%=sqlRs("name")%></strong> <span><%=sqlRs("ly")%></span>
<small><%=sqlRs("post_time")%></small>
</div>
<%
sqlRs.MoveNext
Loop
Call CloseSQL()
%>
| 欄位 | 型別 | 說明 |
|---|---|---|
| id | int, PK, Identity | 流水號 |
| f_id | int | 主題/文章 ID |
| tag | int | 回覆層級/排序 |
| name | nvarchar(50) | 留言者姓名 |
| ly | ntext | 留言內容 |
| post_time | datetime | 預設 GETDATE() |
Server.HTMLEncode 防 XSS。