本文分享一個以 Ajax 搭配 ASP 的綜合範例:讀取 Access 資料庫的內容,用表格呈現,而且連翻頁都靠 Ajax 完成,不必重整頁面。程式寫得偏入門、還有優化空間,適合正在學 Ajax 的朋友參考,也歡迎大家一起來把它改得更好。
作者也坦言目前還留著一個小毛病:翻到最後一頁、若只剩一列資料時,會冒出空白與 undefined。這個問題試過不少方法仍不算圓滿,若有人有解特別歡迎指教。另外提醒一個易踩的坑——文中有些地方看起來像笑臉表情的,其實是大寫的 d。
這支 ASP 負責連線資料庫、分頁並輸出以逗號分隔的字串。開頭先放一個刻意用來模擬延遲的 Sub,方便觀察 Ajax 的 loading 狀態:
<%
Sub TimeDelaySeconds(DelaySeconds)
SecCount = 0
Sec2 = 0
While SecCount < DelaySeconds + 1
Sec1 = Second(Time())
If Sec1 <> Sec2 Then
Sec2 = Second(Time())
SecCount = SecCount + 1
End If
Wend
End Sub
TimeDelaySeconds(0)
%>
接著關閉快取、指定 GB2312 編碼,並建立 ADODB 連線到 Database.mdb:
<%
Response.Expires = -9999
Response.AddHeader "Pragma","no-cache"
Response.AddHeader "cache-control","no-cache"
Response.Charset = "GB2312"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("Database.mdb")
conn.Open connstr
%>
然後用 Recordset 查詢 UserData 表、設定每頁筆數,並對傳入的 page 參數做上下界判斷,最後把「總頁數、當前頁、各列欄位」以逗號串接輸出:
<%
set rs = server.createobject("adodb.recordset")
Sqlstr = "select * from UserData order by id"
rs.open Sqlstr,conn,1,1
rs.PageSize = 3
AllPage = rs.PageCount
Page = request.QueryString ("page")
if cint(page) =< 1 then
Page = 1
elseif cint(page) >= rs.PageCount then
Page = rs.PageCount
end if
rs.AbsolutePage=page
Response.write AllPage&","&rs.AbsolutePage&","
for i = 1 to rs.PageSize
if rs.EOF or rs.BOF then exit for
Response.write rs(0)&","&rs(1)&","&rs(2)&","&rs(3)&","
rs.movenext
next
rs.close
Set rs = nothing
%>
先建立跨瀏覽器的 XMLHttpRequest 物件——用一連串 try/catch 依序嘗試 Mozilla 原生、新版 IE 的 Msxml2.XMLHTTP、舊版 IE 的 Microsoft.XMLHTTP,全失敗就報錯:
var request = false;
try {
request = new XMLHttpRequest();
} catch (trymicrosoft) {
try {
request = new ActiveXObject("Msxml2.XMLHTTP");
} catch (othermicrosoft) {
try {
request = new ActiveXObject("Microsoft.XMLHTTP");
} catch (failed) {
request = false;
alert("Object Error!");
}
}
}
defaultPages() 負責載入第一頁;selectPages() 則依 Previous/Next 計算目標頁碼、先清掉舊的表格列再重新請求:
function defaultPages() {
var url = "Demo.asp";
request.open("GET", url, true);
request.onreadystatechange = updatePage;
request.send(null);
}
function selectPages(Method,Pages) {
for(i=0;i<3;i++)
document.getElementById("MyTable").deleteRow();
if (Method == "Previous"){
var PageTemp = document.getElementById("PageNow").value;
var PageNow = parseInt(PageTemp)-1;
var url = "Demo.asp?Page="+PageNow;
request.open("GET", url, true);
request.onreadystatechange = updatePage;
request.send(null);
}
else if (Method == "Next"){
var PageTemp = document.getElementById("PageNow").value;
var PageNow = parseInt(PageTemp)+1;
var url = "Demo.asp?Page="+PageNow;
request.open("GET", url, true);
request.onreadystatechange = updatePage;
request.send(null);
}
}
updatePage() 依 readyState 顯示 loading 或完成狀態,並在 HTTP 200 時呼叫 requestAllright() 處理資料:
function updatePage() {
if (request.readyState <= 3){
document.getElementById("Status").innerHTML = "Loading...";
document.getElementById("Pages").innerHTML = "Previous│Next";
}
if (request.readyState == 4){
if (request.status == 200) {
requestAllright();
}else{
document.getElementById("Status").innerHTML = "Error:" + request.status;
document.getElementById("Pages").innerHTML = "Previous│Next";
}
}
}
requestAllright() 把逗號字串 split 成陣列,前三個值當作總頁數與當前頁,其餘每四個一組組成三列資料,再動態 insertRow/insertCell 塞進表格,最後依當前頁決定上一頁/下一頁連結能不能點:
function requestAllright() {
var getStr = request.responseText;
var getValue = getStr.split(",");
var PageCount = getValue[0];
var PageNow = getValue[1];
var Contact = [
[getValue[2],getValue[3],getValue[4],getValue[5]],
[getValue[6],getValue[7],getValue[8],getValue[9]],
[getValue[10],getValue[11],getValue[12],getValue[13]]
];
for (var List=0;List<Contact.length;List++){
var MyTr = MyTable.insertRow();
for (var Cell=0;Cell<Contact[List].length;Cell++){
var MyTd = MyTr.insertCell();
MyTd.innerHTML = Contact[List][Cell];
}
}
if (PageNow == PageCount){
document.getElementById("Pages").innerHTML = "<a href=Javascript:selectPages('Previous','0'); class=pagesTag>Previous</a>│Next";
}
else if (PageNow == 1){
document.getElementById("Pages").innerHTML = "Previous│<a href=Javascript:selectPages('Next','0'); class=pagesTag>Next</a>";
}
else {
document.getElementById("Pages").innerHTML = "<a href=Javascript:selectPages('Previous','0'); class=pagesTag>Previous</a>│<a href=Javascript:selectPages('Next','0'); class=pagesTag>Next</a>";
}
document.getElementById("PageCount").value = PageCount;
document.getElementById("PageNow").value = PageNow;
document.getElementById("Status").innerHTML = "Done with!";
}
頁面放一個 id 為 MyTable 的表格作為資料區(含 Id、Name、Sex、Age 四欄標題),下方是狀態列與翻頁區,並用兩個隱藏欄位 PageCount、PageNow 保存分頁狀態:
<script language="Javascript" type="text/javascript" src="AJax.js"></script>
<table id="MyTable">
<tr>
<td class="MyTableTag">Id</td>
<td class="MyTableTag">Name</td>
<td class="MyTableTag">Sex</td>
<td class="MyTableTag">Age</td>
</tr>
</table>
<input type="hidden" name="PageCount" id="PageCount"/>
<input type="hidden" name="PageNow" id="PageNow"/>
<td id="Status">Loading...</td>
<td id="Pages">Previous│Next</td>
資料庫使用 Access(database.mdb),資料表名為 UserData,欄位為 Id、Name、Sex、Age,其中 Id 是編號、其餘皆為字串。性別欄位這裡用一般文字,若要改成 yes/no 之類,自行調整即可。整個範例把「資料查詢(ASP)」「非同步請求與 DOM 操作(JS)」「呈現結構(HTML)」三者串起,是理解 Ajax 分頁表格相當實用的一份入門素材。