資料|資料庫|資料庫連接 前一段發現很多閃友發貼求助flash與資料庫連接，所以我研究了了一下，決定給大家寫下關於ASP\php\JSp的資料庫連接的方法，今天給大家的flash與資料庫連接(ASP篇)，以後我會陸續為大家奉上，希望大家經常來我的部落格做客！一共需要建立三個檔案（如圖二）。首先寫asp檔案，起名為save.asp．具體代碼如下： <%
u_name=Request.Form("Name")
u_company=Request.Form("Company")
u_relation=Request.Form("Relation")
u_url=Request.Form("Url")
u_msg=Request.Form("Msg")
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("Msg.mdb")
sql="Insert into data (Name,Company,Relation,Url,Msg) values (’"&U_name&"’,’"&u_company&"’,’"&u_relation&"’,’"&u_url&"’,’"&u_msg&"’)"
conn.Execute(sql)
conn.close
Set conn=Nothing
Response.Write "&temp=ok"
%>下面我們做access檔案，起名為Msg.mdb！建立表，起名為data表．建立欄位名稱： id; Name; Company; Relation; Url; Msg; Time. 資料類型依次設定為：自動編號；文本；文本；文本；文本；備忘；日期／時間． 儲存關閉．最後我們做flash，檔案名稱我起個conn吧！在工作區，照圖一去做，每個元件一層！建立最頂層在最後一貞加上如下代碼：
System.useCodepage = true;
Name = "";
Company = "";
Relation = "";
Url = "";
Msg = "";
function SendData() {
if (Name != "" && Company != "" && Relation != "" && Msg != "") {
var MyVar = new LoadVars();
MyVar.Name = Name;
MyVar.Company = Company;
MyVar.Relation = Relation;
MyVar.Url = Url;
MyVar.Msg = Msg;
MyVar.sendAndLoad("http://localhost/6/save.asp", MyVar, "POST");
temp = "提交中,請稍侯...";
MyVar.onLoad = function(success) {
if (success) {
temp = "呵呵!成功咯喲！來!再來一條...";
Name = "";
Company = "";
Relation = "";
Url = "";
Msg = "";
} else {
temp = "失敗了！可能網絡有問題！";
}
};
} else {
temp = "請輸入完整！";
}
}
sendBTU.onRelease = function() {
SendData();
};
clearBTU.onRelease = function() {
temp = "歡迎你給我發留言！";
Name = "";
Company = "";
Relation = "";
Url = "";
Msg = "";
};
stop();然後把相應的輸入文本筐的變數起相應的名字！如姓名後面的輸入文本筐的變數起名為：Name. 如有什麼問題請在下面留言，我會儘快幫你解決！
附件:
圖一
