[ASPÖÐʹÓÃÈý²ã¼Ü¹¹] 9.Óû§µÇ¼֮һ User±íÓëÏà¹ØÀà
½ÓÏÂÀ´¿ªÊ¼½²½âÈçºÎÓÃÈý²ã¼Ü¹¹À´½¨Á¢Óû§µÇ¼¹ý³Ì.
Õâ¸ö¹ý³ÌÓÃÒ»°ãµÄ±à³Ì·½Ê½Ð´ÆðÀ´ºÜ¼òµ¥,´ÓÕâÀïÈëÊÖÀ´½²½âÈý²ã¼Ü¹¹µÄʵÀý,Ïë±Ø´ó¼Ò¶¼»á¸üÈÝÒ×Á˽âÆäÖеÄÂß¼½á¹¹.
Ê×ÏÈÎÒÃÇ×öһЩ׼±¸¹¤×÷,¹¹ÔìÕâ¸öÒµÎñÐèÒªÓõ½µÄ¼¸¸öÀà,ÆäÖаüÀ¨Èý¸ö²¿·Ö:
User²¿·ÖµÄʵÌåÀàMOD_User,µ¥±íÊý¾Ý·ÃÎÊÀàDAL_User
UserLog²¿·ÖµÄµ¥±íÊý¾Ý·ÃÎÊÀàDAL_UserLog
UserÒµÎñÏà¹ØµÄÒµÎñÂß¼ÀàBLL_User,¶à±íÊý¾Ý·ÃÎÊÀàMUL_User
ºÃ,ÎÒÃÇ¿ªÊ¼×¼±¸µÚÒ»²¿·Ö.
[User] ±íµÄ½á¹¹ÈçÏÂ
[UserID] [int] IDENTITY(1,1) NOT NULL,
[UserAccount] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NOT NULL,
[UserPassword] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[UserPower] [int] NOT NULL,
[LogCount] [int] NULL,
[UserDate] [datetime] NULL,
ÒÔ[User]±íÉú³ÉÒ»¸öʵÌåÀàMOD_User,ÎļþÃûΪMOD_User.asp,·ÅÔÚ/Class/MOD/Ŀ¼ÏÂ,ÄÚÈÝÈçÏÂ,Çë´ó¼ÒÊìϤһÏÂpropertyµÄд·¨
class MOD_User
' ******[User] database field
private lngUserID '[int] NOT NULL
private strUserAccount '[ntext] Óû§µÇ¼Ãû
private strUserPassword '[ntext] ÃÜÂë
private strUserName &
Ïà¹ØÎĵµ£º
ÔÚ¶àÏîÑ¡ÔñµÄһЩӦÓÃÖУ¬¿ÉÒÔÓöþ½øÖÆ1´ú±íÑ¡ÖУ¬0´ú±í²»Ñ¡¡£ÀýÈç¸øijÓû§½ÇÉ«·ÖÅäȨÏÞabcdefg£¬Ñ¡ÖÐÇé¿öÊÇ1001101£¬ÄÇô´Ë½ÇÉ«°üº¬ËÄÏîȨÏÞ£¬ÓÃÒ»¸ö±äÁ¿±íʾ£¬ÏàÓ¦µÄÊ®½øÖÆÊýÊÇ77¡£
µ«ÊÇ£¬ÔÚASPÖеĶàÏîÑ¡Ôñ£¬¾Í²»ÊʺÏÕâÖÖÒÔÊýÖµµÄÐÎʽ¼Ç¼ѡÖÐÇé¿ö¡£ÒòΪ£¬µ±ÏîÄ¿ÊýºÜ¶àʱ£¨ÀýÈç6 ......
1.ÊýÖµÐͺ¯Êý£º abs(num): ·µ»Ø¾ø¶ÔÖµ sgn(num): num>0 1; num=0 0; num<0 -1;ÅжÏÊýÖµÕý¸º hex(num): ·µ»ØÊ®Áù½øÖÆÖµ Ö±½Ó±íʾ£º&Hxx ×î´ó8λ oct(num): ·µ»Ø°Ë½øÖÆÖµ Ö±½Ó±íʾ£º&Oxx ×î´ó8λ sqr(num): ·µ»Øƽ·½¸ù num>0 int(num): È¡Õû int(99.8)=99; int(-99.2)=100 fix(num): È¡Õû fix(99.8)=99; fix ......
ºÜ¶àSOHOER¶¼Ï£ÍûÓиö×Ô¼ºµÄÍøÕ¾,¶ø¶ÔÍøÕ¾½¨ÉèÒ»ÎÞËùÖª,»òÕßÒ»Öª°ë½â.½ñÌìÎÒÏȽ²³ÌÐò·½ÃæµÄÇø±ð,ÏàÐźܶàÈËÅöµ½ÁËÓÐЩ¹«Ë¾Ëµphp±ÈAsp,Asp.Net¶¼ÒªºÃ,»òÕßAsp±ÈÆäËûÓïÑÔ¶¼ÒªºÃ¡£Æäʵ,³ÌÐòµÄÓÅÂÔÓëÍøÕ¾¿ª·¢ÈËÔ±µÄ¾Ñé\¼¼ÊõˮƽÏà¹Ø£¬¶øÓïÑÔ±¾Éí²¢Ã»ÓÐʲôÓÅÂÔÖ®·Ö.¾Ñé¶àµÄ³ÌÐòÔ±,²»¹ÜʹÓõÄÄ ......
ÔÚASPÖÐʹÓà Request.ServerVariables("REMOTE_ADDR") À´È¡µÃ¿Í»§¶ËµÄIPµØÖ·£¬µ«Èç¹û¿Í»§¶ËÊÇʹÓôúÀí·þÎñÆ÷À´·ÃÎÊ£¬ÄÇÈ¡µ½µÄ¾ÍÊÇ´úÀí·þÎñÆ÷µÄIPµØÖ·£¬¶ø²»ÊÇÕæÕýµÄ¿Í»§¶ËIPµØÖ·¡£ÒªÏë͸¹ý´úÀí·þÎñÆ÷È¡µÃ¿Í»§¶ËµÄÕæʵIPµØÖ·£¬¾ÍҪʹÓà Request.ServerVariables("HTTP_X_FORWARDED_FOR") À´¶ÁÈ¡¡£²»¹ýҪעÒâµÄÊ£¬²¢²»ÊÇÿ¸ö ......
Éý»ªÌṩÖÕÉíÃâ·ÑASP+access PHP+mysqlÐéÄâÖ÷»ú
Ò»£ºÉý»ªÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾,ÓëÉý»ªÍ¬ÔÚÕ¾³¤ÖÕÉíÃâ·Ñ¿Õ¼ä·ö³Ö¼Æ»®.
1¡¢×ð¾´µÄÓû§ÄúºÃ,Ò²ÐíÄú»¹ÔÚΪÿÄêÒ»½»µÄ¿Õ¼ä·ÑÓ÷¢³î,Ò²ÐíÄúÏë»ñµÃÒ»¸ö¸üÓÅÖʵĿռäÈ´²»ÏëͶÈëÌ«¶à,´ÓÏÖÔÚÆð ÕâЩÎÊÌ⽫ÓÈжø½â→Éý»ªÍøÂç←ÓëÉý»ªÍ¬ÔÚÕ¾³¤·ö³Ö¼Æ»®È«ÃæÆô¶¯¡£
2¡¢Ã»ÓÐ×¢²á¹«Ë¾ ......