ASP 調用dll及封裝dll執行個體

開啟VB6，建立ActiveX DLL
2、在工程引用中加入Microsoft Active Server Pages Object Library選擇
3、填加代碼如下： 複製代碼 代碼如下:'Code Start
'聲明部分
Private MyScriptingContext As ScriptingContext
Private MyApplication As Application
Private MyRequest As Request
Private MyResponse As Response
Private MyServer As Server
Private MySession As Session
'下面定義公用函數（在VB中訪問ASP對象，即在VB中可以用MyApplication等同於ASP中的Application、MyRequest等同於ASP中的Request、 MyResponse等同於ASP中的Response、 MyServer等同於ASP中的Server、 MySession等同於ASP中的Session 使用）
Public Sub OnStartPage(PassedScriptingContext As ScriptingContext)
Set MyScriptingContext = PassedScriptingContext
Set MyApplication = MyScriptingContext.Application
Set MyRequest = MyScriptingContext.Request
Set MyResponse = MyScriptingContext.Response
Set MyServer = MyScriptingContext.Server
Set MySession = MyScriptingContext.Session
End Sub
Public Sub OnEndPage()
Set MyScriptingContext = Nothing
Set MyApplication = Nothing
Set MyRequest = Nothing
Set MyResponse = Nothing
Set MyServer = Nothing
Set MySession = Nothing
End Sub
'建立自訂函數SayHello
Public Sub SayHello()
MyResponse.Write ("Hello World")
End Sub
'Code End

4、將類名改為：HelloWorld 將工程名改為：TestVBCode
5、產生TestVBCode.DLL檔案，並使用Windows運行註冊組件命令Regsvr32 路徑\TestVBCode.DLL註冊後即可使用。（卸載組件命令為Regsvr32 /u 路徑\TestVBCode.DLL）
6、建立Test.asp檔案，代碼如下 複製代碼 代碼如下:<%
'VB自建函數調用格式
'Set 對象名=Server.CreateObject("工程名.類名")
'對象名.自建函數名
Set MyTestObj = Server.CreateObject("TestVBCode.HelloWorld")
MyTestObj.SayHello
%>

7、運行Test.asp檔案結果顯示如下：
Hello World
===========================================================
對於更複雜的運用,大家可以通過這個執行個體向外擴充就可以了.
如: 複製代碼 代碼如下:Public Sub connstr2()
Set conn = MyServer.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & MyServer.MapPath("codata.mdb")
Set rs = conn.Execute("select * from news")
Do While Not rs.EOF
MyResponse.Write (rs("news_title") & "<br>")
rs.MoveNext
Loop
rs.Close
Set conn = Nothing
End Sub

這個是用資料庫連接的代碼封裝,當然這裡要添加ADO引用的.