我要评论asp是active server page的缩写，意为“动态服务器页面”。asp是微软公司开发的代替cgi脚本程序的一种应用，它可以与数据库和其它程序进行交互，是一种简单、方便的编程工具。
11.access数据库连接：
<%
option explicit
dim startime,endtime,conn,connstr,db
startime=timer()
'更改数据库名字
db="data/dvbbs5.mdb"
set conn = server.createobject("adodb.connection")
connstr="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath(db)
'如果你的服务器采用较老版本access驱动，请用下面连接方法
'connstr="driver={microsoft access driver (*.mdb)};dbq=" & server.mappath(db)
conn.open connstr
function closedatabase
conn.close
set conn = nothing
end function
%>
12.sql数据库连接：
<%
option explicit
dim startime,endtime,conn,connstr,db
startime=timer()
connstr="driver={sql server};server=hudenq-n11t33nb;uid=sa;pwd=xsfeihu;database=dvbbs"
set conn = server.createobject("adodb.connection")
conn.open connstr
function closedatabase
conn.close
set conn = nothing
end function
%>
13.用键盘打开网页代码：
<script language="javascript">
function ctlent(eventobject)
{
if((event.ctrlkey && window.event.keycode==13)||(event.altkey && window.event.keycode==83))
{
window.open('网址','','')
}
}
</script>
这里是ctrl+enter和alt+s的代码 自己查下键盘的ascii码再换就行
14.让层不被控件复盖代码：
<div z-index:2><object xxx></object></div> ＃ 前面 <div z-index:1><object xxx></object></div> ＃ 后面 <div id="layer2" style="position:absolute; top:40;width:400px; height:95px;z-index:2"> <table height=100% width=100% bgcolor="#ff0000"><tr> <td height=100% width=100%></td></tr></table><iframe width=0 height=0></iframe></div> <div id="layer1" style="position:absolute; top:50;width:200px; height:115px;z-index:1"> <iframe height=100% width=100%></iframe></div>
15.动网flash广告代码：
<object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase=http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0 width="468" height="60"> <param name=movie value="images/yj16d.swf"> <param name=quality value=high> <embed src="images/dvbanner.swf" quality=high pluginspage=http://www.macromedia.com/shockwave/download/index.cgi?p1_prod_version=shockwaveflash; ;;;;;;;;;;; type="application/x-shockwave-flash" width="468" height="60"></embed></object>
16.vbs弹出窗口小代码:
<script language=vbscript> msgbox"你还没有注册或登陆论坛","0","精品论坛" location.href = "login.asp" </script>
17.使用fso修改文件特定内容的函数：
function fsochange(filename,target,string)
dim objfso,objcountfile,filetempdata
set objfso = server.createobject("scripting.filesystemobject")
set objcountfile = objfso.opentextfile(server.mappath(filename),1,true)
filetempdata = objcountfile.readall
objcountfile.close
filetempdata=replace(filetempdata,target,string)
set objcountfile=objfso.createtextfile(server.mappath(filename),true)
objcountfile.write filetempdata
objcountfile.close
set objcountfile=nothing
set objfso = nothing
end function
18.使用fso读取文件内容的函数：
function fsofileread(filename)
dim objfso,objcountfile,filetempdata
set objfso = server.createobject("scripting.filesystemobject")
set objcountfile = objfso.opentextfile(server.mappath(filename),1,true)
fsofileread = objcountfile.readall
objcountfile.close
set objcountfile=nothing
set objfso = nothing
end function
19.使用fso读取文件某一行的函数：
function fsolinedit(filename,linenum)
if linenum < 1 then exit function
dim fso,f,temparray,tempcnt
set fso = server.createobject("scripting.filesystemobject")
if not fso.fileexists(server.mappath(filename)) then exit function
set f = fso.opentextfile(server.mappath(filename),1)
if not f.atendofstream then
tempcnt = f.readall
f.close
set f = nothing
temparray = split(tempcnt,chr(13)&chr(10))
if linenum>ubound(temparray)+1 then
exit function
else
fsolinedit = temparray(linenum-1)
end if
end if
end function
20.使用fso修改文件特定内容的函数：
function fsochange(filename,target,string)
dim objfso,objcountfile,filetempdata
set objfso = server.createobject("scripting.filesystemobject")
set objcountfile = objfso.opentextfile(server.mappath(filename),1,true)
filetempdata = objcountfile.readall
objcountfile.close
filetempdata=replace(filetempdata,target,string)
set objcountfile=objfso.createtextfile(server.mappath(filename),true)
objcountfile.write filetempdata
objcountfile.close
set objcountfile=nothing
set objfso = nothing
end function
21.使用fso读取文件内容的函数：
function fsofileread(filename)
dim objfso,objcountfile,filetempdata
set objfso = server.createobject("scripting.filesystemobject")
set objcountfile = objfso.opentextfile(server.mappath(filename),1,true)
fsofileread = objcountfile.readall
objcountfile.close
set objcountfile=nothing
set objfso = nothing
end function
22.使用fso读取文件某一行的函数：
function fsolinedit(filename,linenum)
if linenum < 1 then exit function
dim fso,f,temparray,tempcnt
set fso = server.createobject("scripting.filesystemobject")
if not fso.fileexists(server.mappath(filename)) then exit function
set f = fso.opentextfile(server.mappath(filename),1)
if not f.atendofstream then
tempcnt = f.readall
f.close
set f = nothing
temparray = split(tempcnt,chr(13)&chr(10))
if linenum>ubound(temparray)+1 then
exit function
else
fsolinedit = temparray(linenum-1)
end if
end if
end function
到此，关于asp常用代码的总结篇，就为大家介绍完了，希望对大家有帮助。
发表评论