OraSession:管理連接、數據庫、記錄集,由 CreateObject 創建。OraDatabase:代表數據庫會話,執行 SQL/PL/SQL。OraDynaset:可更新記錄集,支持 Edit、Update、Delete、AddNew、MoveNext、Bookmark 等。MYTABLE1 (ID NUMBER, UserName VARCHAR2, Phone VARCHAR2, Email VARCHAR2)<%
Set OraSession = CreateObject("OracleInProcServer.XOraSession")
Set OraDatabase = OraSession.OpenDatabase("", "user/password", 0)
Set OraDynaset = OraDatabase.DbCreateDynaset("select * from mytable1", 0)
Do While Not OraDynaset.EOF
Response.Write OraDynaset.Fields("ID") & ","
Response.Write OraDynaset.Fields("UserName") & "<br>"
OraDynaset.MoveNext
Loop
Set OraSession = Nothing
%>
Set OraDynaset = OraDatabase.CreateDynaset("select * from MYTABLE1 where ID=" & fID, 0)
Do While Not OraDynaset.EOF
OraDynaset.Edit
OraDynaset.Fields("Phone").Value = fPhone
OraDynaset.Update
OraDynaset.MoveNext
Loop
OraDynaset.AddNew
OraDynaset.Fields("ID").Value = newID
OraDynaset.Fields("UserName").Value = newName
' ...
OraDynaset.Update
OraDynaset.Delete
文中提供了 RetrieveAllRec.asp(查詢顯示表格)與 UpdateRecProc.asp(表單提交更新)完整代碼,包含 HTML 表格輸出、表單處理、錯誤捕獲、資源釋放。
將複雜邏輯封裝在數據庫存儲過程中,ASP 僅調用 EXEC proc_name,提升性能與安全性。創建存儲過程屬 DBA 範疇,此處不贅述。