ACCESSʱ¼ä²éѯ£¬ÅжÏÎÊÌ⣬ÔÚÏßµÈ
Çë½Ì£º
±íA½á¹¹ÈçÏ£ºID StartTime EndTime
1 2010/4/2 9:00:00 2010/4/2 11:00:00
2 2010/4/2 12:00:00 2010/4/2 14:00:00
. ... ...
ÏÖÎÒÓµÓÐÁ½¸öʱ¼ä±äÁ¿a,b£¬ÔõÑù²éѯ¿ÉÒÔµÃÖªa,bËù×é³ÉµÄʱ¼ä¶ÎºÍ±íÖÐStartTime£¬EndTime¹¹³ÉµÄʱ¼ä¶Î²»³åÍ»£¿
ÎÒÏëµ½µÄÊÇÕâÑù£º
1.ÌÈÈôaСÓÚStartTimeÖÐ×îС£¬ÄÇôbÒ²Ó¦¸ÃСÓÚStartTimeÖÐ×îСµÄ¼Ç¼£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
2.ÌÈÈôa´óÓÚEndTimeÖÐ×î´ó£¬ÄÇôbÒ²Ó¦¸Ã´óÓÚEndTimeÖÐ×î´ó£¬Í¬Ê±bÓ¦¸Ã´óÓÚa£»
3.ÌÈÈôa²»±ÈStartTimeÖÐ×îСµÄС£¬Ò²²»±ÈEndTimeÖÐ×î´óµÄ´ó£¬ÄÇôa²»Ó¦¸Ã´¦ÓÚÓÉStartTimeºÍEndTimeËù×é³ÉµÄÈÎÒâʱ¼ä¶ÎÄÚ£¨Õâ¸öÎÒ¿ÉÒÔͨ¹ýbetweenÅжϣ©£¬ÕâÖÖÇé¿öÏÂÎÒÓ¦¸ÃÔõÑù¶Ôb×öÅжÏÄØ£¿ÎÒµÄ˼·ÊDzé³öÀëa×î½üµÄStartTime£¬È»ºóbÓ¦¸ÃСÓÚ´ËStartTime£¬µ«¿É±¯µÄÊÇÎÒ²»ÖªµÀÔõÑùµÃµ½Àëa×î½üµÄStartTime£¨ÎÒ²»ÄÜÿ¸ö¶¼Ïë¼õÈ¡×îСֵ°É£¿£©£¬²»ÖªµÀACCESSÓÐûÌṩʲôʱ¼ä·½ÃæµÄº¯Êý¿É¹©µ÷Óã¬Çë¸øÓè°ïÖú¡£
¼ÅįµÄSF
û¿´¶®£¬½¨ÒéÄÜÓÃʵ¼ÊÀý×Ó˵Ã÷¡£
½¨ÒéÄãÁгöÄãµÄ±í½á¹¹£¬²¢Ìṩ²âÊÔÊý¾ÝÒÔ¼°»ùÓÚÕâЩ²âÊÔÊý¾ÝµÄËù¶ÔÓ¦ÕýÈ·½á¹û¡£
²Î¿¼Ò»ÏÂÕâ¸öÌù×ÓµÄÌáÎÊ·½Ê½http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html
¾ÍÊǶ©»áÒéÊÒ£¬¿ªÊ¼Ê±¼äºÍ½áÊøʱ¼ä²»ÄܺÍÒÑ´æÔÚµÄʱ¼ä¶Î³åÍ»£¬Ó¦¸ÃÔõôÅжϷ½±ã
ÈýÂ¥ÒѾ¸ø³ö´ð°¸ÁË¡£
òËÆÕâÑù²»ÐаÉ<
Ïà¹ØÎÊ´ð£º
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤?
ÄãÊÇÔõÑù¸³ÖµµÄ£¿
²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û
ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÒÏë±£Áô±íÖÐ×îеÄ30¸öÊý¾Ý£¨ÓмǼʱ¼äµÄ×Ö¶Îaddtime£©£¬ÆäÓàµÄɾ³ý£¬ÇëÎÊsqlÓï¾äÔõÑùдÄØ£¿Ð»Ð»¡£
End_rbody_64466527//-->
¸Ã»Ø¸´ÓÚ2010-04-27 08:37:30±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[ ......