ASP ÏÞÖÆ·¢Ìûʱ¼ä ºÍ µÇ½ÏÞÖÆ
н¨Á¢Ò»¸öASPÎļþ °Ñ ÒÔÏ´úÂë¸´ÖÆ½øÈ¥
<%
ip=request.ServerVariables("REMOTE_ADDR") '»ñÈ¡À´·ÃµÄIPµØÖ·
dim conn
set conn=server.CreateObject("ADODB.connection")
conn.open "Dbq="&server.MapPath("yb/dat/data.mdb")&";Driver={Microsoft Access Driver (*.mdb)}" '½¨Á¢Êý¾Ý¿âÁ¬½Ó ÕâÀïÄã¿ÉÒÔ×Ô¼º¸Ä
sql="select * from ip_user where ipµØÖ·='"&ip&"'"
set rs=server.CreateObject("ADODB.recordset")
rs.open sql,conn,3,3
if rs.eof then
call ip_fir("thenew")
else
vistime=rs("·ÃÎÊʱ¼ä")
if DateDiff("h",vistime,now)>=12 then
call ip_fir("theup")
else
call ip_notfir
end if
end if
%>
<%'--------------ΪÁË·½±ãд³ÉÁ˹ý³ÌÐÎʽ£º
Sub Ip_fir(action)'---------------------µÚÒ»´Î·ÃÎʵĹý³Ì
response.write "12СʱÄÚ£¬ÄãÊǵÚÒ»´Î·ÃÎʱ¾Õ¾£¬ÕâÀïÌùÉϼÓÁ÷Á¿´úÂë"
if action="theup" then
rs("·ÃÎÊʱ¼ä")=now()
rs.update
elseif action="thenew" then
sql1="insert into ip_user(ipµØÖ·) values ('"&request.ServerVariables("REMOTE_ADDR")&"')"
conn.execute(sql1)
end if
End Sub
Sub ip_notfir()''---------------------12СʱÄÚ·ÃÎʹýµÄ¹ý³Ì
'---------------------ÕâÀï¸Ä³ÉÄãÆÚ´ýµÄ´¦Àí·½Ê½
response.write "ÄãÔÚ×î½ü12СʱÄÚ·ÃÎʹý±¾Õ¾"
End Sub
%>
check_inTimeÊÇʱ¼äTime(±ÈÈç8:30:00)
tuihour=hour(rs("check_inTime"))
tuiMinute=Minute(rs("check_inTime"))
chaotime=TimeSerial(tuihour,tuiMinute+10,0)'ÓÃÕâ¸öʱ¼äº¯Êý·µ»ØÒ»¸öʱ¼ä£¡¾ÍÊÇÍùºó¼Ó10·ÖÖÓ¡£Èç¹ûÊÇcheck_inTimeÊÇ8:30:00£¬ÄÇô·µ»ØÊ±¼äΪ£º8:40:00 ¡£
if chaotime>time then
Response.Redirect("cuo.asp?id=3")'´íÎó´¦ÀíÒ³Ãæ£¡¿ÉÒÔÔÚÕⶨÒå˵ʮ·ÖÖÓºó²ÅÄܹ»×¢²á£¡
end if
µÇ½´íÎó5´ÎËø¶¨30·Ö
If LoginType = "Ò»°ã¹ÜÀíÔ±" Then
sql = " Select * from ÆóÒµÖ®ÐǹÜÀíÔ±×ÊÁϱí Where ¹ÜÀíÔ±µÇ¼ID = '" & User & "' "
DBRs.Open sql,DBConn,1,3
If DBRs.EOF Then
DBRs.Close
Set DBRs = Nothing
DBConn.Close
Set DBConn = Nothing
Response.Write "<script>alert('Óû§Ãû»òÕßÃÜÂë´íÎó£¬ÇëÖØÐÂÊäÈë');history.back();</script><br><p>"
Response.End
Else
'=======
Ïà¹ØÎĵµ£º
°²×°¹ý³Ì˳³©£¬ASPÒ³ÃæÔÚÆäËü»·¾³ÏÂÄÜÕý³£µ÷ÊÔ£¬Îļþ·¾¶ÅäÖÃÕýÈ·Çé¿öÏ£¬²»Äܵ÷ÊÔASP Ò³Ãæ£¬²Î¿¼Ò»ÏÂÄÚÈÝ
µÚÒ»
Ð޸Ķ˿ÚÅäÖà һЩÓÅ»¯ºÍ·À»¤Èí¼þ¶Ô¶Ë¿ÚÓÐÌØÊâµÄ“Õչ˔
µÚ¶þ
³£¼ûµÄ“500ÄÚ²¿·þÎñÆ÷´íÎó”Íò½ðÓÍ£º
1¡¢Ð¶ÔØ“internetÐÅÏ¢·þÎñ(IIS)”£¬
2¡¢¿´¿´Ê¼þ²é¿´Æ÷ÀïÓÐû ......
ÒÔÏÂÊÇ·¢ÔÚ÷×ÓÂÛ̳µÄÌù×Ó£¬×ª·¢¹ýÀ´£¬Ï£Íû¸øÓõÃ×ŵĺüÓѲο¼¡£
ÎҵijÌÐòÒÔǰһֱÊÇÓû¨Éú¿Ç°ó¶¨IPʵÏÖµÄÔ¶³Ì£¬ÓÉÓÚ¿Í»§·þÎñÆ÷ºÍ¿Í»§¶Ë¶¼ÊÇͨ¹ý¿í´øÉÏÍø£¬Ò»°ãµÄ²Ù×÷£¨¿ª½ø»õµ¥¡¢ÏúÊÛµ¥µÈ£©ËÙ¶ÈÒ²»¹²»´í£¬µ«ÊÇÔÚÔ¶³Ì¿Í»§¶ËÐÞ¸ÄÉÌÆ·×ÊÁÏ£¨10000¶àÌõ¼Ç¼£©¡¢²éѯһ¶ÎʱÆÚµÄ½øÏú´æÁ÷Ë®£¨Ò»ÖÜ5000ÌõÒÔÉÏ£©µÈÉæ¼°µ½È¡¼Ç¼Á¿´óµ ......
eofÊÇaspÖÐrecordset¶ÔÏóÖ¸ÕëµÄÒ»ÖÖ¡£
rs.eof ·µ»Ø¼Ç¼ָÕëÊÇ·ñ³¬³öÊý¾Ý±íÄ©¶Ë£¬true±íʾÊÇ£¬falseΪ·ñ
rs¼Ç¼¼¯ÊÇÎÒÃǾ³£»áÅöµ½µÄ,ÏÂÃæ¶ÔËüÖî¶àµÄÒÆ¶¯Ö¸Õë½øÐлã×Ü,ÈçÏÂ:
rs.movenext ½«¼Ç¼ָÕë´Óµ±Ç°µÄλÖÃÏòÏÂÒÆÒ»ÐÐ
rs.moveprevious ½«¼Ç¼ָÕë´Óµ±Ç°µÄλÖÃÏòÉÏÒÆÒ»ÐÐ
rs.movefirst ½«¼Ç¼ָÕëÒÆµ½Êý¾Ý±íµÚÒ»ÐÐ
......
½ÌѧÄÚÈÝ
ASP¶¯Ì¬ÍøÒ³Éè¼Æ¼¼ÊõÌåϵ½á¹¹
ASPÖ÷Òª¹¹³ÉÔªËØµÄ¹¦Äܼ°Ó÷¨
ASP¶¯Ì¬ÍøÒ³Éè¼ÆÊµÀý
ÖØµãºÍÄѵã
asp¶¯Ì¬ÍøÒ³Éè¼Æ¼¼ÊõÌåϵ½á¹¹
asp¶¯Ì¬ÍøÒ³Éè¼ÆµÄ·½·¨
ǰµ¼ÖªÊ¶
½Å±¾ÓïÑÔ——vbscript»òjavascript
Êý¾Ý¿â֪ʶ——SQL
²ÎÔÄ×ÊÁÏ
HTTP://WWW.w3schools.com
ÍÆ¼öÈí¼þ£ºAdobe Dreamweaver ......
ASPµÄDES¼ÓÃܽâÃÜ
2007-05-18 09:49
ÔÎÄ£ºhttp://hi.baidu.com/myfav/blog/item/3ebc58828edd79a30cf4d290.html
ǰÁ½Ììѧµ½¶Ô³ÆÃÜÂëDESËã·¨£¬È»ºó¾Í×Ô¼ºÇ×ÊÖдÁ˸öʵÏÖ³ÌÐò³öÀ´£¬ºÃ¶àµØ·½ÓõÃ×ÅÄÅ¡£ÕâÀïÊÇÓÃASPʵÏÖ£¬µ±È»Ò²¾ÍÊÇ¿ÉÒÔÒÆµ½VBÀ²¡£¶®µÃÔõÑùдºóд³ÉʲôÓïÑÔ¶¼ÐÐÀ²£¬Ö»Òª¶®µÃÄÇÃÅÓïÑÔ¡£Èç¹ûÓÐÅóÓÑÏëÖªµÀ¾ßÌåD ......