Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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×Ö·û´®º¯Êý´óÈ«

º¯Êý Óï·¨ ¹¦ÄÜ
Len Len(string|varname) ·µ»Ø×Ö·û´®ÄÚ×Ö·ûµÄÊýÄ¿£¬»òÊÇ´æ´¢Ò»±äÁ¿ËùÐèµÄ×Ö½ÚÊý¡£
Trim Trim(string) ½«×Ö·û´®Ç°ºóµÄ¿Õ¸ñÈ¥µô
Ltrim Ltrim(string) ½«×Ö·û´®Ç°ÃæµÄ¿Õ¸ñÈ¥µô
Rtrim Rtrim(string) ½«×Ö·û´®ºóÃæµÄ¿Õ¸ñÈ¥µô
Mid Mid(string,start,length) ´Óstring×Ö·û´®µÄstart×Ö·û¿ªÊ¼È¡µÃlength³¤¶ ......

ASPÓëÊý¾Ý¿âÓ¦ÓÃ(¸ø³õѧÕß)

ASPÓëÊý¾Ý¿âÓ¦ÓÃ(¸ø³õѧÕß)
--------------------
¼û×î½üÐí¶àÍøÓÑѯÎÊһЩ¹ØÓÚÊý¾Ý¿â²Ù×÷µÄ»ù´¡ÎÊÌ⣬ÏÖ°ÑÎÒÒÔǰдµÄһƪ¼òµ¥½Ì³ÌÌùÉÏÀ´£¬ºÃÈÃһЩ³õѧÕß×î¿ìµÄÈëÃÅ£º
ASPÓëÊý¾Ý¿âÓ¦Ó㨸ø³õѧÕߣ©
Ò»°ãÀ´Ëµ£¬Ò»¸öÕæÕýµÄ¡¢ÍêÕûµÄÕ¾µãÊÇÀë²»¿ªÊý¾Ý¿âµÄ£¬ÒòΪʵ¼ÊÓ¦ÓÃÖУ¬ÐèÒª±£´æµÄÊý¾ÝºÜ¶à£¬¶øÇÒÕâЩÊý¾ÝÖ®¼äÍùÍù»¹ ......

´î½¨¼òÒ×µÄasp·þÎñÆ÷ ÓÃÓÚÊÖ»ú°²×°²âÊÔ³ÌÐò

À¶ÑÀ»µµôÁË£¬ÕâÑùÒ»À´ ÊÖ»ú°²×°³ÌÐò±äµÃºÜ²»·½±ãÁË¡£Ò»¿ªÊ¼ÊÇÏȰÑÒª°²×°µÄ³ÌÐòÒÔ¸½¼þµÄÐÎʽ·¢µ½ÓÊÏä ÔÙÔÚÊÖ»úÉÏÅäÖÃÓÊÏä ÈúóÏÂÔØ¸½¼þ°²×°£¬ÕâÑùËäÈ»½â¾öÁËÎÊÌâ  µ«ÊÇ»¹ÊÇÓкܶ಻·½±ãµÄµØ·½¡£ ÓÚÊÇ  ×Ô¼ºÏë´î½¨Ò»¸ö·þÎñÆ÷ Ö±½ÓʵÏÖÔÚÏß°²×°¡£Ç°ÌáÊÇÊÖ»úÖ§³Öwifi£¬¾ÍÊÇ˵ÐèÒªÊÖ»ú·ÃÎÊÄÚÍøµØÖ·£¬·ñÔòµÃ»° ¾Í±È½Ï ......

Oracle´óÎı¾ÔÚASPÖдæÈ¡ÎÊÌâµÄ½â¾ö


ÔÚÎÒ¿ª·¢BS½á¹¹³ÌÐòÖУ¬ÓÉÓÚ¾­³£ÐèÒªÔÚORACLEÖд¦ÀíһЩÈÝÁ¿½Ï´óµÄÎı¾Êý¾Ý£¬ËùÒÔ¾­¹ý·´¸´²âÊÔÖÕÓÚÓÃASP³É¹¦½â
¾öÁË´óÎı¾Êý¾ÝÔÚORACLEÏ´æÈ¡ÎÊÌâ¡£
¡¡¡¡
¡¡¡¡Ò»¡¢ÔËÐл·¾³£º
¡¡¡¡1¡¢Microsoft Windows 2000 Server + IIS 5.0
2¡¢Oracle8iÖÐÎıê×¼°æ
¡¡¡¡
¡¡¡¡¶þ¡¢½¨Á¢Êý¾Ý±í£º
¡¡¡¡CREATE TABLE SYSTEM.TEST(
B ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ