本文再和大家分享一些ASP程序設計中經常用到的源代碼。適合初學者閱讀。希望對你有幫助,一起來看吧!
ASP是Active Server Page的縮寫,意為動態服務器頁面。 ASP是微軟公司開發的代替CGI腳本程序的一種應用,它可以與數據庫和其它程序進行交互,是一種簡單、方便的編程工具。接上篇>> http://www.vevb.com/kaifa/asp/70602.html
11.ACCESS數據庫連接:
- <%
- optionexplicit
- dimstartime,endtime,conn,connstr,db
- startime=timer()
- '更改數據庫名字
- db=data/dvBBS5.mdb
- Setconn=Server.CreateObject(ADODB.Connection)
- connstr=Provider=Microsoft.Jet.OLEDB.4.0;DataSource=&Server.MapPath(db)
- '如果你的服務器採用較老版本Access驅動,請用下面連接方法
- 'connstr=driver={MicrosoftAccessDriver(*.mdb)};dbq=&Server.MapPath(db)
- conn.Openconnstr
- functionCloseDatabase
- Conn.close
- Setconn=Nothing
- EndFunction
- %>
12.SQL數據庫連接:
- <%
- optionexplicit
- dimstartime,endtime,conn,connstr,db
- startime=timer()
- connstr=driver={SQLServer};server=HUDENQ-N11T33NB;uid=sa;pwd=xsfeihu;database=dvbbs
- Setconn=Server.CreateObject(ADODB.Connection)
- conn.Openconnstr
- functionCloseDatabase
- Conn.close
- Setconn=Nothing
- EndFunction
- %>
13.用鍵盤打開網頁代碼:
- <scriptlanguage=javascript>
- functionctlent(eventobject)
- {
- if((event.ctrlKey&&window.event.keyCode==13)||(event.altKey&&window.event.keyCode==83))
- {
- window.open('網址','','')
- }
- }
- </script>
這裡是Ctrl+Enter和Alt+S的代碼自己查下鍵盤的ASCII碼再換就行
14.讓層不被控件复蓋代碼:
- <divz-Index:2><objectxxx></object></div>#前面
- <divz-Index:1><objectxxx></object></div>#後面
- <divid=Layer2style=position:absolute;top:40;width:400px;height:95px;z-index:2>
- <tableheight=100%width=100%bgcolor=#ff0000><tr>
- <tdheight=100%width=100%></td></tr></table><iframewidth=0height=0></iframe></div>
- <divid=Layer1style=position:absolute;top:50;width:200px;height:115px;z-index:1>
- <iframeheight=100%width=100%></iframe></div>
15.動網FLASH廣告代碼:
- <objectclassid=clsid:D27CDB6E-AE6D-11cf-96B8-444553540000
- codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0
- width=468height=60>
- <paramname=movievalue=images/yj16d.swf>
- <paramname=qualityvalue=high>
- <embedsrc=images/dvbanner.swfquality=high
- pluginspage=http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash;
- ;;;;;;;;;;;type=application/x-shockwave-flashwidth=468height=60></embed></object>
16.VBS彈出窗口小代碼:
- <scriptlanguage=vbscript>
- msgbox你還沒有註冊或登陸論壇,0,精品論壇
- location.href=login.asp
- </script>
17.使用FSO修改文件特定內容的函數:
- functionFSOchange(filename,Target,String)
- DimobjFSO,objCountFile,FiletempData
- SetobjFSO=Server.CreateObject(Scripting.FileSystemObject)
- SetobjCountFile=objFSO.OpenTextFile(Server.MapPath(filename),1,True)
- FiletempData=objCountFile.ReadAll
- objCountFile.Close
- FiletempData=Replace(FiletempData,Target,String)
- SetobjCountFile=objFSO.CreateTextFile(Server.MapPath(filename),True)
- objCountFile.WriteFiletempData
- objCountFile.Close
- SetobjCountFile=Nothing
- SetobjFSO=Nothing
- EndFunction
18.使用FSO讀取文件內容的函數:
- functionFSOFileRead(filename)
- DimobjFSO,objCountFile,FiletempData
- SetobjFSO=Server.CreateObject(Scripting.FileSystemObject)
- SetobjCountFile=objFSO.OpenTextFile(Server.MapPath(filename),1,True)
- FSOFileRead=objCountFile.ReadAll
- objCountFile.Close
- SetobjCountFile=Nothing
- SetobjFSO=Nothing
- EndFunction
19.使用FSO讀取文件某一行的函數:
- functionFSOlinedit(filename,lineNum)
- iflinenum<1thenexitfunction
- dimfso,f,temparray,tempcnt
- setfso=server.CreateObject(scripting.filesystemobject)
- ifnotfso.fileExists(server.mappath(filename))thenexitfunction
- setf=fso.opentextfile(server.mappath(filename),1)
- ifnotf.AtEndofStreamthen
- tempcnt=f.readall
- f.close
- setf=nothing
- temparray=split(tempcnt,chr(13)&chr(10))
- iflineNum>ubound(temparray)+1then
- exitfunction
- else
- FSOlinedit=temparray(lineNum-1)
- endif
- endif
- endfunction
20.使用FSO修改文件特定內容的函數:
- functionFSOchange(filename,Target,String)
- DimobjFSO,objCountFile,FiletempData
- SetobjFSO=Server.CreateObject(Scripting.FileSystemObject)
- SetobjCountFile=objFSO.OpenTextFile(Server.MapPath(filename),1,True)
- FiletempData=objCountFile.ReadAll
- objCountFile.Close
- FiletempData=Replace(FiletempData,Target,String)
- SetobjCountFile=objFSO.CreateTextFile(Server.MapPath(filename),True)
- objCountFile.WriteFiletempData
- objCountFile.Close
- SetobjCountFile=Nothing
- SetobjFSO=Nothing
- EndFunction
21.使用FSO讀取文件內容的函數
:
- functionFSOFileRead(filename)
- DimobjFSO,objCountFile,FiletempData
- SetobjFSO=Server.CreateObject(Scripting.FileSystemObject)
- SetobjCountFile=objFSO.OpenTextFile(Server.MapPath(filename),1,True)
- FSOFileRead=objCountFile.ReadAll
- objCountFile.Close
- SetobjCountFile=Nothing
- SetobjFSO=Nothing
- EndFunction
22.使用FSO讀取文件某一行的函數:
- functionFSOlinedit(filename,lineNum)
- iflinenum<1thenexitfunction
- dimfso,f,temparray,tempcnt
- setfso=server.CreateObject(scripting.filesystemobject)
- ifnotfso.fileExists(server.mappath(filename))thenexitfunction
- setf=fso.opentextfile(server.mappath(filename),1)
- ifnotf.AtEndofStreamthen
- tempcnt=f.readall
- f.close
- setf=nothing
- temparray=split(tempcnt,chr(13)&chr(10))
- iflineNum>ubound(temparray)+1then
- exitfunction
- else
- FSOlinedit=temparray(lineNum-1)
- endif
- endif
- endfunction
到此,關於ASP常用代碼的總結篇,就為大家介紹完了,希望對大家有幫助。