好一段時間沒碰 ASP,這次重新寫一個留言板,反倒覺得比想像中費勁,整整磨了一天才收尾。功能上其實很克制,只保留了「留言」這一件事,其餘花俏的東西一概沒加,架構上則試著套用三層結構——說實話,我對「三層」的定義一直有點模糊,寫完也只能說是形似而已。
整個範例拆成幾個檔案,各司其職:
· index.asp:入口頁,負責依 tCMD 參數分派動作,再把留言列表輸出到畫面。
· BLL_Guest.asp:業務邏輯層,處理新增、刪除、分頁格式化。
· DAL_Guest.asp:資料存取層,所有 SQL 都收在這裡。
· MOD_Guest.asp:資料模型,用來承載一筆留言。
· Common.asp:通用工具類,提供字串格式化與分頁條。
· AccHelper.asp:ADO 封裝,統一管理連線與執行。
· ajax.js:前端非同步請求腳本。
先把共用的類別檔 include 進來,接著依請求參數決定要新增還是刪除,最後一律重新撈一次分頁資料。這樣做的好處是畫面永遠跟資料庫同步,不必在前端拼接 HTML。
<%@ codepage=65001%>
<% option explicit %>
<% Response.Charset="utf-8"
Session.CodePage=65001 %>
<!-- #include file="AccHelper.asp" -->
<!-- #include file="Common.asp" -->
<!-- #include file="DAL_Guest.asp" -->
<!-- #include file="MOD_Guest.asp" -->
<!-- #include file="BLL_Guest.asp" -->
<%
Dim mybll, myList
Set mybll = new BLL_Guest
Select Case Request("tCMD")
Case "SAVE"
mybll.Insert()
Case "DEL"
mybll.Delete()
End Select
myList = mybll.FindByPage()
%>
<h2>客戶留言</h2>
<p>
<form name="subForm" id="subForm">
<textarea id="con" name="con" cols="56" rows="6" wrap="VIRTUAL"></textarea>
<input type="button" name="submit" value="提交留言"
onclick="$('guest/index.asp?tCMD=SAVE&content='+escape(this.form.con.value))" />
</form>
</p>
<%=myList%>
這一層不直接碰資料庫,只負責把請求參數塞進模型物件,再交給 DAL 執行;分頁與 HTML 組裝也集中在這裡。
<%
Class BLL_Guest
Private mycom, mymod, mydal
Private LI, UL
Private DEL
'新增:把表單值放進模型,時間與 IP 由伺服器補上
Public Sub Insert()
mymod.Content = Request("content")
mymod.re = Request("Re")
mymod.Addtime = Now()
mymod.Ip = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
If Len(mymod.Ip) <= 0 Then mymod.Ip = Request.ServerVariables("REMOTE_ADDR")
Call mydal.Insert(mymod)
End Sub
Public Sub Update()
Call mydal.Update(mymod)
End Sub
Public Sub Delete()
mydal.Delete(Request("Id"))
End Sub
'分頁讀取並組出清單 HTML
Public Function FindByPage()
Dim PageSize, CurrentPage, WhereValue, OrderValue, RecordCount
Dim objRS, tmp1, tmp2, tmp3, parms, i, tCMD
tCMD = Request("tCMD")
PageSize = "8"
CurrentPage = Request("PageNo")
If Len(CurrentPage) <= 0 Then CurrentPage = 1
WhereValue = ""
OrderValue = "Id"
Set objRS = mydal.FindByPage(PageSize, CurrentPage - 1, WhereValue, OrderValue)
RecordCount = mydal.Count(WhereValue)
i = 1
Do While Not objRS.EOF
If tCMD = "DEL" Then
DEL = "<a href=""?tCMD=DEL&Id=" & objRS("Id") & """>刪除</a>"
Else
DEL = ""
End If
parms = Array(i, objRS("content"), objRS("ip"), objRS("addtime"), DEL)
tmp1 = tmp1 & mycom.Format(LI, parms)
objRS.MoveNext
i = i + 1
Loop
tmp3 = mycom.Page(PageSize, CurrentPage, RecordCount, "guest/index.asp?tCMD=LIST")
parms = Array(tmp1, tmp3)
tmp2 = tmp2 & mycom.Format(UL, parms)
FindByPage = tmp2
End Function
Private Sub Class_Initialize()
LI = "<li><span>{0}</span> <span>{1}</span><br /><span>作者:{2}</span> <span>{3}</span> <span>{4}</span></li>" & vbCrLf
UL = "<UL>{0}<li>{1}</li></UL>"
Set mycom = new Common
Set mymod = new MOD_Guest
Set mydal = new DAL_Guest
End Sub
Private Sub Class_Terminate()
Set mycom = Nothing
Set mymod = Nothing
Set mydal = Nothing
End Sub
End Class
%>
SQL 全部集中宣告在 Class_Initialize 裡,用自訂的 Format 把參數填進佔位符。分頁靠 Top 搭配 Not In 子查詢完成,這是 SQL Server 上常見的寫法。
<%
Class DAL_Guest
Private SQL_01, SQL_02, SQL_03, SQL_04, SQL_05, SQL_06, SQL_07
Private mycom, myacc, mymod
Public Function GetGuest(Id)
Dim parms, SQL, objRS
parms = Array(Id)
SQL = mycom.Format(SQL_01, parms)
Set objRS = myacc.ExecuteReader(myacc.CONN_STRING, SQL)
If Not objRS.EOF Then
Call mymod.SetVar(objRS("Id"), objRS("Content"), objRS("Re"), objRS("Addtime"), objRS("Ip"))
Set GetGuest = mymod
Else
GetGuest = Null
End If
End Function
Public Sub Insert(vmod)
Dim parms, SQL
parms = Array(vmod.Content, vmod.Re, vmod.Addtime, vmod.Ip)
SQL = mycom.Format(SQL_02, parms)
Call myacc.ExecuteNonQuery(myacc.CONN_STRING, SQL)
End Sub
Public Sub Update(vmod)
Dim parms, SQL
parms = Array(vmod.Id, vmod.Content, vmod.Re, vmod.Addtime, vmod.Ip)
SQL = mycom.Format(SQL_03, parms)
Call myacc.ExecuteNonQuery(myacc.CONN_STRING, SQL)
End Sub
Public Sub Delete(Id)
Dim parms, SQL
parms = Array(Id)
SQL = mycom.Format(SQL_04, parms)
Call myacc.ExecuteNonQuery(myacc.CONN_STRING, SQL)
End Sub
Public Function Count(WhereValue)
Dim parms, SQL, objRS
parms = Array(WhereValue)
SQL = mycom.Format(SQL_07, parms)
Set objRS = myacc.Recordset(myacc.CONN_STRING, SQL)
Count = objRS.RecordCount
End Function
Public Function FindByPage(PageSize, CurrentPage, WhereValue, OrderValue)
Dim parms, SQL, objRS, s1
If CurrentPage = "0" Then
s1 = PageSize & "|" & OrderValue & "|" & WhereValue
parms = Split(s1, "|")
SQL = mycom.Format(SQL_05, parms)
Else
s1 = PageSize & "|" & OrderValue & "|" & WhereValue & "|" & CurrentPage * PageSize
parms = Split(s1, "|")
SQL = mycom.Format(SQL_06, parms)
End If
Set objRS = myacc.ExecuteReader(myacc.CONN_STRING, SQL)
Set FindByPage = objRS
End Function
Private Sub Class_Initialize()
SQL_01 = "Select * From [Guest] Where Id = {0}"
SQL_02 = "Insert into [Guest] ([Content],[Re],[Addtime],[Ip]) values('{0}','{1}','{2}','{3}')"
SQL_03 = "Update [Guest] Set [Content]='{1}',[Re]='{2}',[Addtime]='{3}',[Ip]='{4}' Where Id = {0}"
SQL_04 = "Delete From [Guest] Where Id In ({0})"
SQL_05 = "Select Top {0} * From [Guest] Order By {1} Desc, Id Desc"
SQL_06 = "Select Top {0} * From [Guest] And Id Not IN (Select Top {3} Id From [Guest] Order By {1} Desc, Id Desc) Order By {1} Desc, Id Desc"
SQL_07 = "Select * From [Guest]"
Set mycom = new Common
Set myacc = new AccHelper
Set mymod = new MOD_Guest
End Sub
Private Sub Class_Terminate()
Set mycom = Nothing
Set myacc = Nothing
Set mymod = Nothing
End Sub
End Class
%>
MOD_Guest.asp 只是一個純資料容器,五個公開屬性加上一個 SetVar 就能勝任。
<%
Class MOD_Guest
Public Id, Content, Re, Addtime, Ip
Public Sub SetVar(vId, vContent, vRe, vAddtime, vIp)
Id = vId
Content = vContent
Re = vContent
Addtime = vAddtime
Ip = vIp
End Sub
End Class
%>
Common.asp 提供兩個關鍵函式:Format 用 {0}、{1} 這類佔位符做字串替換;Page 則把總數、首頁、上一頁、下一頁、尾頁、頁次與跳轉框拼成一條分頁列。
Public Function Format(str, arr)
Dim r, i
r = str
For i = 0 To UBound(arr)
r = Replace(r, "{" & i & "}", arr(i))
Next
Format = r
End Function
'Page(PageSize, CurrentPage, RecordCount, PageUrl)
'內部以常puted串(C_RECORDCOUNT、C_FIRSTPAGE1/2、C_PREVPAGE1/2 …)
'搭配 Format 逐段組出,最後串接成 p 回傳。
PageCount = CInt(RecordCount / PageSize + pages) 'pages 為是否需進位的修正值
AccHelper.asp 把 ADO 的三種常用動作包成函式,連線字串寫死在 Class_Initialize 中指向 db.mdb:
Class AccHelper
Public CONN_STRING
Public Function ExecuteNonQuery(connString, cmdText)
Dim objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connString
objConn.Execute cmdText
End Function
Public Function ExecuteReader(connString, cmdText)
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connString
Set objRS = objConn.Execute(cmdText)
Set ExecuteReader = objRS
End Function
Public Function Recordset(connString, cmdText)
Dim objConn, objRS
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open connString
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.Open cmdText, objConn, 1, 3
Set Recordset = objRS
End Function
Private Sub Class_Initialize()
CONN_STRING = "provider = microsoft.jet.oledb.4.0;data source=" & Server.Mappath("db.mdb")
End Sub
End Class
核心只有三件事:建立 XMLHttpRequest 物件、GET 一段網址、把回應塞進指定元素。為兼顧舊版 IE,建立物件時先用 XMLHttpRequest,失敗再退回 Msxml2.XMLHTTP 與 Microsoft.XMLHTTP。
var http_request = false;
function makeRequest(obj, url) {
http_request = false;
if (window.XMLHttpRequest) {
http_request = new XMLHttpRequest();
if (http_request.overrideMimeType) http_request.overrideMimeType('text/xml');
} else if (window.ActiveXObject) {
try {
http_request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (e) {
try { http_request = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) {}
}
}
if (!http_request) {
alert('無法建立 XMLHTTP 物件');
return false;
}
http_request.onreadystatechange = function () {
if (http_request.readyState == 4) {
if (http_request.status == 200) {
updateObj(obj, http_request.responseText);
} else {
updateObj(obj, "");
}
}
};
http_request.open('GET', url, true);
http_request.send(null);
}
function updateObj(obj, data) { obj.innerHTML = data; }
function $(url) {
var obj = document.getElementById("content");
obj.style.display = 'block';
document.getElementById("container").style.margin = "10px auto 0px";
obj.innerHTML = "Loading…";
makeRequest(obj, url);
}
HTML 端的呼叫方式同樣直白,點連結就把對應頁面載入內容區:
<a href="#" onclick="$('news.html')">新聞</a>
<a href="#" onclick="$('product.html')">產品</a>
<a href="#" onclick="$('case.html')">案例</a>
<a href="#" onclick="$('contact.html')">聯繫</a>
這份程式是教學用的骨架,真要上線還有幾件事非做不可:留言內容與查詢條件是直接字串拼接進 SQL 的,等於把注入口全開著,改用參數化查詢並過濾輸出的 HTML 才是安全做法;刪除動作沒有任何權限判斷,誰都能動手;另外 escape 並不適合承載中文,改用 encodeURIComponent 會穩妥得多。觀念釐清之後,把它當成三層分工的入門樣板來讀,還是很值得的。