上一篇：图解MySQL数据库的安装和操作

一些ASP初学者常用的代码

1.获得系统时间:
<%=now()%>
2.取得来访用的ip:
<%=request.servervariables("remote_host")%>

3.获得系统,浏览器版本:
<script>
window.document.write("版本："+navigator.appname+navigator.appversion+" browser.")
</script>

4.去除ie滚动条:
<body scroll="no">
<body style="overflow-y:hidden">

5.进入网站,跳出广告:
<script language="javascript">

window.open(http://www.xxxxxx.com',,height=200,width=300,top=0,left=30);
// -->
</script>

6.随机数:
<%randomize%>
<%=(int(rnd()*n)+1)%>
n为可改变数

7.向上混动代码:
<marquee direction="up" scrolldelay="200" style="font-size: 9pt; color: #ff0000;
line-height: 150%; font-style:italic; font-weight:bold" scrollamount="2" width="206"
height="207" bgcolor="#ffff00">hhhhhhhhhhhhhhhhhhh</marquee>

8.自动关闭网页:
<script language="javascript">

</script>
<p align="center">本页10秒后自动关闭,请注意刷新页面</p>

9.随机背景音乐:
<%randomize%>
<bgsound src="mids/<%=(int(rnd()*60)+1)%>.mid" loop="-1">　

可以修改数字，限制调用个数，我这里是６０个．

10.自动刷新本页面:
<script>

</script>

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 ***></object></div> ＃前面
<div z-index:1><object ***></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="clsid27cdb6e-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>

16.使用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

17.使用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

18.使用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经典问答收藏之一

↓相关文章：