ASPÈ¡Õûº¯Êý
´ó¼Ò¶¼ÖªµÀÔÚBASICÓïÑÔÖУ¬ÏµÍ³ÎªÎÒÃÇÌṩÁËÐí¶à±ê×¼º¯Êý£¬¶ø“È¡Õûº¯Êý”¾ÍÊÇÆäÖÐÒ»¸ö·Ç³£ÖØÒªµÄº¯Êý¡£
Ò»¡¢ “È¡Õûº¯Êý”µÄ¸ñʽºÍ¹¦ÄÜ¡£
1¡¢¸ñʽ£ºINT£¨X£©
2¡¢¹¦ÄÜ£ºÈ¡²»´óÓÚXµÄ×î´óÕûÊý
3¡¢ËµÃ÷£ºÆäÖÐINTΪº¯ÊýÃû£¬²»ÔÊÐí¸Ä±ä£¬XΪ×Ô±äÁ¿£¬ÆäÐÎʽ¶àÖÖ¶àÑù£¬¿ÉÒÔÊÇÊýÖµ³£Á¿¡¢ÊýÖµ±äÁ¿¡¢ÊýÖµ±í´ïʽ¡£
ÀýÈ磺INT£¨3.1416£©=3
INT£¨3.8752£©=3
INT£¨-3.14£©=-4
INT£¨-3.85£©=-4
´ÓÉÏÃæµÄÌâÄ¿À´¿´£¬ÎÒÃÇ¿ÉÒÔ¿´³ö£¬¶ÔÓÚÓÐСÊý²¿·ÖµÄÕýÊý£¬INT
È¡ÕûÕâºó°ÑСÊý²¿·ÖÉáµô£¬µ«²»½øÐÐËÄÉáÎåÈ룬¶ÔÓÚÓÐСÊýµÄ¸ºÊýÀ´Ëµ£¬INTÈ¡Õûºó²¢²»ÊÇÖ±½ÓÉáµôСÊý£¬¶øÊÇÈ¡±ÈÆäÕû²¿·ÖС1µÄÕûÊý¡£µ±È»ÁË£¬¶ÔÓÚÕæÕýÕûÊýÀ´Ëµ£¬INTÖ®ºóÆäÖµ²»±ä¡£
¶þ¡¢“È¡Õûº¯Êý”µÄÓ¦ÓÃ
1¡¢¶ÔÊýÖµ½øÐÐËÄÉáÎåÈëÔËËã
£¨1£©¶ÔXÖµ±£ÁôÕûÊý²¿·Ö£¬Ð¡Êý²¿·ÖËÄÉáÎåÈë¡£
±í´ïʽΪ£ºINT£¨X*100+0.5£©
ÀýÈç:
INT(3.1416+0.5)=INT(3.6416)=3
INT(3.8572+0.5)=INT(4.3572)=4
INT(-3.14+0.5)=INT(-2.64)=-3
INT(-3.85+0.5)=INT(-3.35)=-4
ͨ¹ý·ÖÎöÉÏÃæµÄÀý×ÓÎÒÃÇ¿ÉÄÜ¿´³ö,ÓÃINTÈ¡Õûº¯Êý´ïµ½ËÄÉáÎåÈëµÄ¹¦ÄÜ,¹Ø¼ü´óÔÚÓÚÕâ¸ö0.5£¬ÔÛÃÇ´ÓÊýÖáÀ´¿´£¬¶ÔÒ»¸öÊý¼ÓÉÏ0.5£¬Ï൱ÓÚ¶ÔÆäÖµÏòÓÒÒÆ¶¯0.5£¬¸ù¾ÝСÊýµãºóµÚһλÊÇСÓÚ5»¹ÊÇ´óÓÚµÈÓÚ5£¬¾ö¶¨ÁË´ËÊýÔÚÏòÓÒÒÆ¶¯¹ý³ÌÖÐÊÇ·ñ¾¹ýÁËÒ»¸öÕûÊý£¬ÒòΪINTº¯ÊýȡֵΪÆä×ó²àµÄ×î´óÕûÊý£¬Èô¾¹ýÁËÒ»¸öÕûÊý£¬Ôò½á¹û¾ÍΪÕâ¸öÕûÊý£¬·ñÔò¾ÍºÍÔÊýÖ±½ÓINTÈ¡Õû½á¹ûÏàͬ¡£ÕâÑù¾Í¿ÉÄÜ´ïµ½ËÄÉáÎåÈëµÄÄ¿µÄÁË¡£
£¨2£©¶ÔXµÄÖµ±£ÁôÁ½Î»Ð¡Êý£¬ ¶ÔµÚÈýλСÊýËÄÉáÎåÈë
±í´ïʽ£ºINT£¨X*100+0.5£©/100
ÀýÈç:
INT(3.1416*100+0.5)/100
=INT(314.16+0.5)/100
=INT(314.66)/100
=314*100
=3.14
INT(3.8572*100+0.5)/100
=INT(385.72+0.5)/100
=INT(386.22)/100
=386/100
=3.86
ÕâÖÖËÄÉáÎåÈë±£ÁôÓëÉÏÃæ1µÄ±£ÁôÖ»Ïà²îÔÚСÊýµãλÖò»Í¬£¬ÎÒÃÇÖ»ÒªÏë°ì·¨¸Ä±äСÊýµãµÄλÖþͿÉÒÔÁË£¬ËùÒÔÎÒÃDzÉÓõķ½·¨ÊÇÏȶÔXÀ©´ó100±¶£¬È»ºóÔÙ°´µÚÒ»ÖÖ·½·¨½øÐÐÈ¡ÉáСÊý£¬×îºóÔÙËõС100±¶£¬ÕâÑù¼È¿ÉÒÔ²»Ó°ÏìÊýµÄ»ù±¾´óС£¬ÓÖ¿ÉÒÔ¶ÔÆä½øÐÐËÄÉáÎåÈë¡£
С½á1
¶ÔXÖµ±£ÁôNλСÊý£¬µÚN+1λСÊýËÄÉáÎåÈëµÄÒ»°ã±í´ïʽΪ£º
INT£¨x*10^N+0.5£©/X*10^N
2¡¢ÅÐÊýÒ»¸öÊýMÄÜ·ñ±»ÊýNÕû³ý
ÀýÈ磺ÅжÏÒ»¸öÊýµÄÆæÅ¼ÐÔ£¬¼´ÊÇ·ñÄܱ»2Õû³ý
M=25 M=24
M/2=12.5 M/2=12
INT(M/2)=12 INT(M/2)
ͨ¹ýÉÏÊö±í´ïʽºÜÈÝÒ׵óö½áÂÛ£º25ÎªÆæÊý£¬25/2<>INT(25/2)£¬24ΪÅ
Ïà¹ØÎĵµ£º
Éý»ªÌṩÖÕÉíÃâ·ÑASP+access PHP+mysqlÐéÄâÖ÷»ú
Ò»£ºÉý»ªÍøÂç¿Æ¼¼ÓÐÏÞ¹«Ë¾,ÓëÉý»ªÍ¬ÔÚÕ¾³¤ÖÕÉíÃâ·Ñ¿Õ¼ä·ö³Ö¼Æ»®.
1¡¢×ð¾´µÄÓû§ÄúºÃ,Ò²ÐíÄú»¹ÔÚΪÿÄêÒ»½»µÄ¿Õ¼ä·ÑÓ÷¢³î,Ò²ÐíÄúÏë»ñµÃÒ»¸ö¸üÓÅÖʵĿռäÈ´²»ÏëͶÈëÌ«¶à,´ÓÏÖÔÚÆð ÕâЩÎÊÌ⽫ÓÈжø½â→Éý»ªÍøÂç←ÓëÉý»ªÍ¬ÔÚÕ¾³¤·ö³Ö¼Æ»®È«ÃæÆô¶¯¡£
2¡¢Ã»ÓÐ×¢²á¹«Ë¾ ......
·½·¨Ò»¡¢¾¡Á¿Ê¹Óø´ÔÓµÄSQLÀ´´úÌæ¼òµ¥µÄÒ»¶Ñ SQL.
ͬÑùµÄÊÂÎñ£¬Ò»¸ö¸´ÔÓµÄSQLÍê³ÉµÄЧÂʸßÓÚÒ»¶Ñ¼òµ¥SQLÍê³ÉµÄЧÂÊ¡£Óжà¸ö²éѯʱ£¬ÒªÉÆÓÚʹÓÃJOIN¡£
oRs=oConn.Execute("SELECT * from Books")
while not oRs.Eof
strSQL = "SELECT * from Authors WHERE AuthorID="&oRs("AuthorID") oRs2=oConn.Execute(strSQ ......
ÏÂÔØµØÖ·£º/download/rar/tot-cms-5.5(sp2).rar
꿅᣼http://www.totcms.com/html/200910-30/20091030001212.htm
¸üÐÂ˵Ã÷£º
1¡¢Ôö¼ÓÁË×Ô¶¨Ò庯Êý¹¦ÄÜ£¬Ö»Òª¹ÜÀíÔ±ÊìϤSQL²éѯ£¬¾Í¿ÉÒÔʹÓÃÆÕͨSQLÓï·¨²éѯÊý¾Ý¿âÉú³Éǰ̨¾²Ì¬HTM¼Ç¼¡£
2¡¢ÎÄÕÂÌí¼Ó²ÉÈ¡Á½¼¶Ä¿Â¼±£´æ£¬²»ÊÇʹÓÃÔÀ´µÄÈý²ãĿ¼·½Ê½¡£
3¡¢½â¾öÐ޸ı ......
´Ë·½·¨¿ÉÒÔ²»ÐèҪרÃÅÖÆ×÷Ä£°åÎļþ£¬Ö»ÐèÕý³£ÔËÐеĶ¯Ì¬Ò³Ãæ¼´¿É£¬¾ßÌå·½·¨ÈçÏ£¬×îÖÕʹÓüû×îºóÒ»¸öº¯Êý£º
Function getHTTPPage(url) ‘Ê×Ò³Éú³É¿ªÊ¼
dim Http
set Http=server.createobject("MSXML2.XMLHTTP")
Http.open "GET",url,false
Http.send()
if Http ......