×¢Òâ¡°+¡±ºÍ¡°&¡±µÄÇø±ð¡£µ±Á½¸ö±»Á¬½ÓµÄÊý¾Ý¶¼ÊÇ×Ö·ûÐÍʱ£¬ËüÃǵÄ×÷ÓÃÏàͬ¡£µ±Êý×ÖÐͺÍ×Ö·ûÐÍÁ¬½Óʱ£¬¡°&¡±°ÑÊý¾Ý¶¼×ª»¯³É×Ö·ûÐÍÈ»ºóÁ¬½Ó£»¡°+¡±°ÑÊý¾Ý¶¼×ª»¯³ÉÊý×ÖÐÍÈ»ºóÁ¬½Ó¡£
Àý£º
\ÆäֵΪ\¡£
\ÐÕÃû£º\ÕÅÈý\ÆäֵΪ£º\ÐÕÃû£ºÕÅÈý\¡£ 23 & \ÆäֵΪ£º\¡£ 23+\ÆäֵΪ£º30¡£
¶ø23+\Ôò»á³öÏÖÀàÐͲ»Æ¥ÅäµÄ´íÎó¡£
3¡¢¹ØÏµ±í´ïʽ¼°ÔËËã·û
¹ØÏµ±í´ïʽÓÃÀ´±È½ÏÁ½¸öÊýÖµ»ò×Ö·û´®£¬·µ»ØÖµÊÇÂß¼ÖµTrue»òFalse¡£¼ûÏÂ±í¡£
ÔËËã·û = <> > < >= <= Like is ˵Ã÷ ÏàµÈÔËËã·û ²»µÈÔËËã·û ´óÓÚÔËËã·û СÓÚÔËËã·û ´óÓÚ»òµÈÓÚÔËËã·û СÓÚ»òµÈÓÚÔËËã·û ×Ö·û´®Ä£Ê½Æ¥ÅäÔËËã·û ¶ÔÏóÒ»Ö±ȽÏÔËËã·û 4¡¢ÈÕÆÚ±í´ïʽ¼°ÔËËã·û
ÈÕÆÚ±í´ïʽÓÉËãÊõÔËËã·û¡°+¡¢-¡±¡¢ËãÊõ±í´ïʽ¡¢ÈÕÆÚÐͳ£Á¿¡¢ÈÕÆÚÐͱäÁ¿ºÍº¯Êý×é³É¡£ËûÃÇÖ®¼äÖ»ÄܽøÐмӡ°+¡±¡¢¼õ¡°-¡±ÔËËã¡£ÓÐ3ÖÖÇé¿ö£º
? Á½¸öÈÕÆÚÐÍÊý¾Ý¿ÉÒÔÏà¼õ£¬½á¹ûÊÇÒ»¸öÊýÖµÐÍÊý¾Ý
? Ò»¸ö±íʾÌìÊýµÄÊýÖµÐÍÊý¾Ý¿ÉÒÔ¼Óµ½ÈÕÆÚÐÍÊý¾ÝÖУ¬Æä½á¹ûÈÔȻΪһÈÕÆÚÐÍÊý¾Ý ? Ò»¸ö±íʾÌìÊýµÄÊýÖµÐÍÊý¾Ý¿É´ÓÈÕÆÚÐÍÊý¾ÝÖмõµôËü£¬Æä½á¹ûÈÔȻΪһÈÕÆÚÐÍÊý
¾Ý¡£
5¡¢Âß¼ÔËËã·û
Âß¼ÔËËã·û¶ÔÂß¼Á¿½øÐÐÂß¼ÔËË㣬³ýNotÍâ¶¼ÊǶÔÁ½¸öÂß¼Á¿ÔËËã¡£½á¹ûΪÂß¼ÖµTrue»òFalse¡£ ÔËËã·û Not And Or Xor Eqv Imp
˵Ã÷ È¡·´ÔËËã·û£¨ÔËËãÊýΪ¼Ùʱ£¬½á¹ûÎªÕæ£¬·´Ö®½á¹ûΪ¼Ù£© ÓëÔËËã·û£¨ÔËËãÊý¾ùÎªÕæÊ±£¬½á¹û²ÅÎªÕæ£© »òÔËËã·û£¨ÔËËãÊýÖÐÓÐÒ»¸öÎªÕæÊ±£¬½á¹ûÎªÕæ£© Òì»òÔËËã·û£¨ÔËËãÊýÏ෴ʱ£¬½á¹û²ÅÎªÕæ£© µÈ¼ÛÔËËã·û£¨ÔËËãÊýÏàͬʱ²ÅÎªÕæ£¬ÆäÓà½á¹û¾ùΪ¼Ù£© Ô̺¬ÔËËã·û£¨µÚÒ»¸öÔËËãÊýÎªÕæ£¬µÚ¶þ¸öÔËËãÊýΪ¼Ùʱ£¬½á¹û²ÅÎªÕæ£¬ÆäÓà½á¹û¾ùΪ¼Ù£© 6¡¢ÔËËã·ûÓÅÏÈ˳Ðò
ÔÚÒ»¸ö±í´ïʽÖнøÐÐÈô¸É²Ù×÷ʱ£¬Ã¿Ò»²¿·Ö¶¼»á°´Ô¤ÏÈÈ·¶¨µÄ˳Ðò½øÐмÆËãÇó½â£¬³ÆÕâ¸ö˳ÐòΪÔËËã·ûµÄÓÅÏÈ˳Ðò¡£
ÔÚ±í´ïʽÖУ¬µ±ÔËËã·û²»Ö¹Ò»ÖÖʱ£¬ÒªÏÈ´¦ÀíËãÊõÔËËã·û£¬½Ó×Å´¦Àí±È½ÏÔËËã·û£¬È»ºóÔÙ´¦ÀíÂß¼ÔËËã·û¡£ËùÓбȽÏÔËËã·ûµÄÓÅÏÈ˳Ðò¶¼Ïàͬ£»Ò²¾ÍÊÇ˵£¬Òª°´ËüÃdzöÏÖµÄ˳Ðò´Ó×óµ½ÓÒ½øÐд¦Àí¡£¶øËãÊõÔËËã·ûºÍÂß¼ÔËËã·ûÔò±ØÐë°´ÏÂÁÐÓÅÏÈ˳Ðò½øÐд¦Àí£º
ËãÊõ Ö¸ÊýÔËËã (^) ¸ºÊý (¨C) ³Ë·¨ºÍ³ý·¨ (*¡¢ /) ÕûÊý³ý·¨ (\\) ÇóÄ£ÔËËã (Mod) ¼Ó·¨ºÍ¼õ·¨ (+¡¢ ¨C) ×Ö·û´®Á¬½Ó (&) ±È½Ï ÏàµÈ (=) ²»µÈ (<>) СÓÚ (<) ´óÓÚ (>) СÓÚ»òÏàµÈ (<=) ´óÓÚ»òÏàµÈ (>=) Like Is Âß¼ Not And Or Xor Eqv Imp
µ±³Ë·¨ºÍ³ý·¨Í¬Ê±³öÏÖÔÚ±í´ïʽÖÐʱ£¬Ã¿¸öÔËËã¶¼°´ÕÕËüÃÇ´Ó×óµ½ÓÒ³öÏÖµÄ˳Ðò½øÐмÆËã¡£µ±³Ë·¨ºÍ³ý·¨Í¬Ê±³öÏÖÔÚ±í´ïʽÖÐʱ£¬Ã¿¸öÔËËãÒ²¶¼°´ÕÕËüÃÇ´Ó×óµ½ÓÒ³öÏÖµÄ˳Ðò½øÐмÆËã¡£¿ÉÒÔÓÃÀ¨ºÅ¸Ä±äÓÅÏÈ˳Ðò£¬Ç¿Áî±í´ïʽµÄijЩ²¿·ÖÓÅÏÈÔËÐС£À¨ºÅÄÚµÄÔËËã×ÜÊÇÓÅÏÈÓÚÀ¨ºÅÍâµÄÔËËã¡£µ«ÊÇ£¬ÔÚÀ¨ºÅÖ®ÄÚ£¬ÔËËã·ûµÄÓÅÏÈ˳Ðò²»±ä¡£
×Ö·û´®Á¬½ÓÔËËã·û (&) ²»ÊÇËãÊõÔËËã·û£¬µ«ÊÇ£¬¾ÍÆäÓÅÏÈ˳Ðò¶øÑÔ£¬ËüÔÚËùÓÐËãÊõÔËËã·ûÖ®ºó£¬¶øÔÚËùÓбȽÏÔËËã·û֮ǰ¡£
Like µÄÓÅÏÈ˳ÐòÓëËùÓбȽÏÔËËã·û¶¼Ïàͬ£¬Êµ¼ÊÉÏÊÇģʽƥÅäÔËËã·û¡£
Is ÔËËã·ûÊǶÔÏóÒýÓõıȽÏÔËËã·û¡£Ëü²¢²»½«¶ÔÏó»ò¶ÔÏóµÄÖµ½øÐбȽϣ¬¶øÖ»È·¶¨Á½¸ö¶ÔÏóÒýÓÃÊÇ·ñ²ÎÕÕÁËÏàͬµÄ¶ÔÏó¡£
2.4.6 ¿ØÖƽṹ
¿ØÖƽṹÓÃÓÚ¿ØÖƳÌÐòÖ´ÐеÄÁ÷³Ì¡£Èç¹ûδʹÓÿØÖÆÁ÷Óï¾ä£¬³ÌÐò±ã´Ó×óÖÁÓÒ¡¢×Ô¶¥ÏòϵعᴩÕâЩÓï¾ä¡£ÓÐЩ¼òµ¥³ÌÐò¿ÉÒÔÖ»Óõ¥ÏòÁ÷³ÌÀ´±àд£¬ÓÐЩÁ÷³Ì¿ÉÒÔÒÀ¿¿ÔËËã·ûµÄÓÅÏȼ¶À´¿ØÖÆ£¬µ«ÊÇÒª³ä·Ö·¢»ÓVBµÄÇ¿´ó¹¦ÄÜ£¬ÊµÏÖ¸´ÔÓµÄЧ¹û£¬Ôò±ØÐèÕÆÎÕÆä¿ØÖÆ½á¹¹¡£
1¡¢Ñ¡Ôñ½á¹¹
Ñ¡Ôñ½á¹¹Òà³ÆÅж¨½á¹¹»òÅжϽṹ£¬±íʾ¸ù¾Ý²»Í¬µÄÇé¿ö¶Ôij¸öÌõ¼þ×ö³öÅжϣ¬¸ù¾ÝÕâ¸öÌõ¼þµÄ¾ßÌåȡֵÇé¿ö×ö³ö²»Í¬µÄÑ¡Ôñ£¬Ö´Ðв»Í¬µÄ²Ù×÷¡£
Visual BasicÖ§³ÖµÄÑ¡Ôñ½á¹¹ÓÐIfÓï¾äºÍSelect CaseÓï¾ä¡£ £¨1£©If...Then ½á¹¹
ÓÃIf...Then ½á¹¹ÓÐÌõ¼þµØÖ´ÐÐÒ»¸ö»ò¶à¸öÓï¾ä¡£µ¥ÐÐÓï·¨ºÍ¶àÐпéÓï·¨¶¼¿ÉÒÔʹÓ㺠If condition Then statement If condition Then
statements End If
Condition´ú±íÐèÒªÅжϵÄÌõ¼þ£¬Í¨³£ÊDZȽÏʽ£¬µ«Ëü¿ÉÒÔÊÇÈκμÆËãÊýÖµµÄ±í´ïʽ¡£Visual Basic½«Õâ¸öÖµ½âÊÍΪTrue»òFalse£ºÒ»¸öΪÁãµÄÊýֵΪ False£¬¶øÈκηÇÁãÊýÖµ¶¼±»¿´
×÷True¡£ÈôconditionΪ True£¬ÔòVisual BasicÖ´ÐÐ Then ¹Ø¼ü×ÖºóÃæµÄËùÓÐstatements¡£¿ÉÒÔʹÓõ¥Ðлò¶àÐÐÓï·¨ÓÐÌõ¼þµØÖ´ÐÐÒ»¸öÓï¾ä£¨ÏÂÃæÁ½¸öÀý×ӵȼۣ©£º
If anyDate < Now Then anyDate = Now If anyDate < Now Then anyDate = Now End If
×¢Ò⣺If...Then µÄµ¥Ðиñʽ²»ÓÃEnd IfÓï¾ä¡£Èç¹ûconditionΪ TrueʱҪִÐжàÐдúÂ룬Ôò±ØÐëʹÓöàÐпé If...Then...End If Óï·¨¡£
If anyDate < Now Then anyDate = Now
commandbutton1.Enabled = False ' commandbutton1¿ØÖÆÊ§Ð§¡£ End If
£¨2£©If...Then...Else ½á¹¹ ´ËÖÖ¸ñʽµÄ¾ßÌåд·¨ÈçÏ£º
If condition Then
[statementblock-1] Else
[statementblock-2] End If
ÕâÖÖ¸ñʽ´ú±íµÄº¬ÒåÊÇ£ºµ±Ìõ¼þ³ÉÁ¢Ê±£¬Ö´ÐÐThenºóÃæµÄÓï¾äÌå1ÖеÄÈ«²¿Óï¾ä£¬Ö´ÐÐÍêºóÌø³öÕû¸öIfÓï¾äÌ壬ִÐÐIfÓï¾äÌåºóµÄÓï¾ä£»µ±Ìõ¼þ²»³ÉÁ¢Ê±£¬ÔòÖ´ÐÐElseºóµÄÓï¾äÌå2ÖеÄÈ«²¿Óï¾ä£¬ÔÙÖ´ÐÐÕû¸öIfÓï¾äÌåºóµÄÓï¾ä¡£
If...Then...Else ½á¹¹Ò²¿ÉÒÔ½øÐÐǶÌ×Åжϣ¬¸ñʽÈçÏ£º If condition1 Then [statementblock-1] ElseIf condition2 Then [statementblock-2] [ElseIf condition3 Then [statementblock-3]] ¡¡ [Else
[statementblock-n]] End If
´ËÖÖ¸ñʽֻÔÚÌõ¼þ²»³ÉÁ¢Ê±ÔÙ½øÐÐеÄÅжϣ¬¿ÉÒÔʹÓüòµ¥µÄElseIf¸ñʽ¡£¶øÇÒElseIf²¿·Ö¿ÉÒÔǶÌ×¶à²ã£¬¸ù¾Ý¾ßÌåÇé¿ö¾ö¶¨¡£Ö»ÒªÊ¹ÓÃʱ½á¹¹ºÏÀí£¬¿ÉÒÔʹÓÃÈÎÒâ²ãǶÌס£
ÀýÈç¶Ô³É¼¨µÈ¼¶µÄÅжϣº
If x>=90 Then Level1 = \ÓÅ\ ElseIf x>=80 Then Level1 = \Á¼\ ElseIf x>=70 Then Level1 = \ÖÐ\ ElseIf x>=60 Then Level1 = \¼°¸ñ\
Else
Level1 = \²»¼°¸ñ\
End If
£¨3£©Select Case½á¹¹
Visual Basic Ìṩ Select Case ½á¹¹Ìæ´ú If...Then...Else£¬´Ó¶ø¿ÉÔÚ¶à¸öÓï¾ä¿éÖÐÓÐÑ¡ÔñµØÖ´ÐÐÆäÖÐÒ»¸ö¡£Select Case Óï¾äµÄÄÜÁ¦Óë If...Then...Else Óï¾äÀàËÆ£¬µ«¶Ô¶àÖØÑ¡ÔñµÄÇé¿ö£¬Select Case Óï¾äʹ´úÂë¸ü¼ÓÒ×¶Á¡£
Select Case ÔڽṹµÄÉÏ·½´¦ÀíÒ»¸ö²âÊÔ±í´ïʽ²¢Ö»¼ÆËãÒ»´Î¡£È»ºó£¬Visual Basic ½«±í´ïʽµÄÖµÓë½á¹¹ÖеÄÿ¸ö Case µÄÖµ½øÐбȽϡ£Èç¹ûÏàµÈ£¬¾ÍÖ´ÐÐÓë¸Ã Case Ïà¹ØÁªµÄÓï¾ä¿é¡£
Select CaseÓï¾äµÄÒ»°ã¸ñʽΪ£º
Select Case testexpression
[Case expressionlist1
[statementblock-1]] [Case expressionlist2 [statementblock-2]] ?
[Case Else
[statementblock-n]]
End Select
ÿһ¸öexpressionlistÊÇÒ»¸ö»ò¼¸¸öÖµµÄÁÐ±í¡£Èç¹ûÔÚÒ»¸öÁбíÖÐÓжà¸öÖµ£¬¾ÍÓöººÅ°ÑÖµ¸ô¿ª¡£Ã¿Ò»¸östatementblock Öк¬ÓÐÁã¸ö»ò¶à¸öÓï¾ä¡£Èç¹û²»Ö¹Ò»¸öCaseÓë²âÊÔ±í´ïʽÏàÆ¥Å䣬ÔòÖ»¶ÔµÚÒ»¸öÆ¥ÅäµÄCaseÖ´ÐÐÓëÖ®Ïà¹ØÁªµÄÓï¾ä¿é¡£Èç¹ûÔÚ±í´ïʽÁбíÖÐûÓÐÒ»¸öÖµÓë²âÊÔ±í´ïʽÏàÆ¥Å䣬ÔòVisual BasicÖ´ÐÐCase Else×Ӿ䣨´ËÏîÊÇ¿ÉÑ¡µÄ£©ÖеÄÓï¾ä¡£
ÀýÈç¶Ô³É¼¨µÈ¼¶µÄÅжÏÒ²¿ÉÒÔÓÃSelect Case½á¹¹£º
Select Case x Case Is>=90 Level2 = \ÓÅ\ Case Is>=80 Level2 = \Á¼\ Case Is>=70 Level2 = \ÖÐ\ Case Is>=60 Level2 = \¼°¸ñ\ Case Else
Level2 = \²»¼°¸ñ\ End Select
2¡¢Ñ»·½á¹¹
Ñ»·½á¹¹ÔÊÐíÖØ¸´Ö´ÐÐÒ»ÐлòÊýÐдúÂë¡£Visual Basic Ö§³ÖµÄÑ»·½á¹¹ÓУº ? Do...LoopÑ»· ? ForÑ»· £¨1£©Do...Loop
ÓÃDoÑ»·Öظ´Ö´ÐÐÒ»Óï¾ä¿é£¬ÇÒÖØ¸´´ÎÊý²»¶¨¡£Do...Loop Óï¾äÓм¸ÖÖÑݱäÐÎʽ£¬µ«Ã¿