這是傳統 **Classic ASP (VBScript/JScript)** 時代的伺服器端腳本,透過 `ADODB.Recordset` 讀取 CSV 檔並逐筆寫入資料庫。現代專案請改用 ASP.NET Core / Node.js / Python 等技術,本文僅供維護舊系統參考。
<%@ LANGUAGE='JAVASCRIPT' %>
<!-- #include file="../adojvs.inc" -->
<!-- #include file="../conn.inc" --> <!-- 定義 conn 連線物件 -->
<%
// 執行 SQL 通用函式
function RunSQL(sql) {
var rs = Server.CreateObject("ADODB.Recordset");
rs.CursorType = 1; // adOpenKeyset
rs.LockType = 3; // adLockBatchOptimistic
try {
rs.Open(sql, conn);
} catch (ex) {
var err = "Error: " + ex + "
" + sql;
var o = conn.Errors;
for (var i=0; i " + o.Item(i).Description;
Response.Write(err);
return false;
}
rs.Close();
return true;
}
// TABLE 類別:封裝 Insert/Update/Delete/Replace
var TABLE = function(tableName) {
this.TabName = tableName;
this.Fields = [];
this.values = [];
this.flag = 0; // 1=Replace, 2=Insert, 3=Update, 4=Delete
this.MySQL = "";
};
TABLE.prototype.F = function(fieldsCsv) { // 設定欄位名 (第一欄為 key)
this.Fields = fieldsCsv.split(",").slice(1);
};
TABLE.prototype.V = function(valuesCsv) { // 設定值並決定動作
var a = valuesCsv.split(",");
this.flag = parseInt(a[0]);
this.values = a.slice(1);
switch (this.flag) {
case 1: this.Replace(); break;
case 2: this.Insert(); break;
case 3: this.Update(); break;
case 4: this.Delete(); break;
}
return this.MySQL;
};
TABLE.prototype.Insert = function() {
var fs = [], vs = [];
for (var i=0; i " + sql);
RunSQL(sql);
}
ts.Close();
} else {
Response.Write("檔案不存在: " + filePath);
}
%>
flag,Key欄位,欄位2,欄位3... 2,新Key,值2,值3... → INSERT 3,既有Key,新值2,新值3... → UPDATE 1,Key,值2,值3... → REPLACE (Key=0 視為新增) 4,Key,,值3... → DELETE (空值略過條件)