虛擬主機不允許安裝 COM 上傳元件 (如 ASPUpload、SA-FileUp) 時,可用 **純 ASP + `Request.BinaryRead` + ADO `AppendChunk`** 實現檔案上傳並直接寫入資料庫二進位欄位 (Access `OLE Object` / SQL Server `image`/`varbinary(max)`),完全免元件。
| 方法 | 用途 | 關鍵參數 |
|---|---|---|
Request.BinaryRead(count) | 讀取 Raw HTTP Request Body (二進位) | `count` ≤ `Request.TotalBytes` |
Request.BinaryWrite(data) | 輸出二進位資料到瀏覽器 (顯示圖片用) | `data` 為 Variant (Byte Array) |
Field.AppendChunk(data) | 分塊寫入長二進位/文字欄位 | `data` 為 Variant |
Field.GetChunk(size) | 分塊讀取長二進位/文字欄位 | 傳回 Variant (Byte Array) |
| 資料庫 | 欄位名 | 型別 | 說明 |
|---|---|---|---|
| Access 97/2000 | img | OLE Object | 儲存圖片二進位 |
| SQL Server 7/2000+ | img | image / varbinary(max) | 建議用 varbinary(max) |
主鍵 `id` 設為自動編號/Identity。
<form action="upload_save.asp" method="post" enctype="multipart/form-data">
<input type="file" name="photo" accept="image/*">
<input type="submit" value="上傳">
</form>
<%@ Language=VBScript CodePage=65001 %><%
Option Explicit
Response.Buffer = True
Dim totalBytes, binData, conn, rs, boundary, pos, fileName, contentType, fileData
totalBytes = Request.TotalBytes
If totalBytes = 0 Or totalBytes > 2097152 Then ' 限制 2MB
Response.Write "檔案過大或為空"
Response.End
End If
'--- 讀取完整 Raw Body ---
binData = Request.BinaryRead(totalBytes)
'--- 簡易 Multipart 解析 (教學用,生產環境建議用成熟元件) ---
' 尋找 boundary
boundary = MidB(binData, 1, InStrB(1, binData, ChrB(13)) - 1)
' 尋找 filename="..."
pos = InStrB(1, binData, "filename=""")
If pos > 0 Then
pos = pos + 10
fileName = ""
Do While MidB(binData, pos, 1) <> ChrB(34) ' "
fileName = fileName & Chr(AscB(MidB(binData, pos, 1)))
pos = pos + 1
Loop
End If
' 尋找檔案資料起始 (雙 CRLF 之後)
pos = InStrB(1, binData, ChrB(13)&ChrB(10)&ChrB(13)&ChrB(10))
If pos > 0 Then
pos = pos + 4
' 取得檔案二進位資料 (到下一個 boundary 前)
Dim endPos
endPos = InStrB(pos, binData, boundary)
If endPos = 0 Then endPos = LenB(binData) + 1
fileData = MidB(binData, pos, endPos - pos - 2) ' 扣掉結尾 CRLF
End If
'--- 寫入資料庫 ---
Set conn = Server.CreateObject("ADODB.Connection")
' Access
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("imgdb.mdb")
' SQL Server
' conn.Open "Provider=SQLOLEDB;Data Source=.;Initial Catalog=imgdb;User ID=sa;Password=****;"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "SELECT id, img FROM images WHERE 1=0", conn, 1, 3 ' adOpenKeyset, adLockOptimistic
rs.AddNew
' Access OLE Object / SQL Server image 皆可用 AppendChunk
rs.Fields("img").AppendChunk fileData
rs.Update
Response.Write "上傳成功,ID: " & rs("id")
rs.Close : Set rs = Nothing
conn.Close : Set conn = Nothing
%>
<%@ Language=VBScript %><%
Option Explicit
Dim conn, rs, id, chunk
id = Request("id")
If id = "" Then Response.End
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("imgdb.mdb")
Set rs = conn.Execute("SELECT img FROM images WHERE id = " & CLng(id))
If Not rs.EOF Then
' 分塊輸出,避免大圖記憶體暴增
Response.ContentType = "image/jpeg" ' 實際應根據存檔時記錄的 Content-Type 動態設定
Do
chunk = rs("img").GetChunk(8192) ' 每次 8KB
If IsNull(chunk) Or LenB(chunk) = 0 Then Exit Do
Response.BinaryWrite chunk
Loop
End If
rs.Close : Set rs = Nothing
conn.Close : Set conn = Nothing
%>
前端引用:``
ASPUpload、FreeASPUpload (純 ASP 類別) 或自行完善解析器。最佳實務:純 ASP 免元件上傳適合**教學、極小型專案、無法安裝元件的虛擬主機**。正式商業專案請:
1. 使用成熟上傳元件 (ASPUpload / Dundas / FreeASPUpload)
2. 檔案存檔案系統 / 雲端儲存 (S3/OSS)
3. 資料庫僅存路徑、檔名、大小、MIME、雜湊值
4. 上傳目錄**移除執行權限**,防 WebShell