萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 網路程式設計 >> ASP.NET 程式設計

ASP 分頁產生靜態 HTML 頁面完整程式碼

需求

將動態分頁列表一次性產生為靜態 HTML 檔案 (如 `list_1.html`, `list_2.html`...) 以降低資料庫負載、提升瀏覽速度。

完整程式碼 (generate.asp)

<!--#include file="conn.asp"-->
<html><head><title>靜態頁產生器</title></head><body>
<%
' 1. 取得總頁數
Dim sql, rs, totalPage, pageSize
sql = "SELECT * FROM News"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open sql, conn, 1, 1 ' adOpenKeyset, adLockReadOnly
pageSize = 20
rs.PageSize = pageSize
totalPage = rs.PageCount
rs.Close : Set rs = Nothing

' 2. 迴圈產生每一頁
Dim fso, file, strHead, strBody, strFoot, j, whichPage, howManyRecs
Set fso = Server.CreateObject("Scripting.FileSystemObject")
strHead = "新聞列表"
strFoot = ""

For j = 1 To totalPage
    whichPage = j
    sql = "SELECT * FROM News"
    Set rs = Server.CreateObject("ADODB.Recordset")
    rs.Open sql, conn, 1, 1
    rs.PageSize = pageSize
    rs.AbsolutePage = whichPage
    howManyRecs = 0

    strBody = ""
    Do While Not rs.EOF And howManyRecs < rs.PageSize
        strBody = strBody & ""
        strBody = strBody & "" ' ID
        strBody = strBody & "" ' 標題
        strBody = strBody & "" ' 日期
        strBody = strBody & "" ' 分類
        strBody = strBody & ""
        rs.MoveNext
        howManyRecs = howManyRecs + 1
    Loop
    strBody = strBody & "
" & rs(0) & "" & rs(1) & "" & rs(2) & "" & rs(3) & "
" ' 產生分頁導覽列 Dim navHtml navHtml = "
" If whichPage > 1 Then navHtml = navHtml & "上一頁 " navHtml = navHtml & "首頁 " End If navHtml = navHtml & " 第 " & whichPage & " 頁 / 共 " & totalPage & " 頁 " If whichPage < totalPage Then navHtml = navHtml & "下一頁 " navHtml = navHtml & "尾頁 " End If navHtml = navHtml & "
" ' 寫入檔案 Dim fileName : fileName = Server.MapPath("list_" & j & ".html") Set file = fso.CreateTextFile(fileName, True) ' True=覆蓋 file.Write strHead & strBody & navHtml & strFoot file.Close rs.Close : Set rs = Nothing Response.Write "已產生 list_" & j & ".html <br>" Next Set fso = Nothing Response.Write "
所有靜態頁面產生完畢!" %> </body></html>

關鍵技術點

  1. Scripting.FileSystemObject:伺服器端檔案系統操作 (建立、寫入、刪除)。
  2. 字串拼接:在迴圈中組裝完整 HTML 字串,最後一次寫入,減少 I/O。
  3. AbsolutePage:Recordset 內建分頁屬性,直接定位頁首記錄。
  4. 導覽列靜態化:連結指向 `.html` 而非 `.asp`,實現純靜態站點。

部署建議

  • 排程器 (Windows Task / SQL Agent Job) 定時執行 `generate.asp` (可加密碼參數防誤觸發)。
  • 搭配 IIS **輸出快取** 或 **靜態內容壓縮** (gzip) 進一步提升效能。
  • 內容更新時 (發布新聞、修改標題) 觸發重新產生,或每日固定時段批次更新。

遷移至 ASP.NET (參考)

// C# 靜態化範例
public void GenerateStaticPages()
{
    var template = File.ReadAllText(Server.MapPath("~/Templates/ListTemplate.html"));
    int pageSize = 20, total = GetTotalCount();
    int totalPages = (int)Math.Ceiling((double)total / pageSize);

    for (int p = 1; p <= totalPages; p++)
    {
        var data = GetPageData(p, pageSize);
        string html = RenderTemplate(template, data, p, totalPages);
        File.WriteAllText(Server.MapPath($"~/Static/list_{p}.html"), html, Encoding.UTF8);
    }
}
copyright © 萬盛學電腦網 all rights reserved