|
·ÖÀർº½ |
 |
|
|
|
ÌìÍøÖÇÄܲéѯÉè¼ÆÆ÷²úÆ·ÊÖ²á |
|
×ÊÔ´´óС£º654.21 KB |
×ÊÔ´ÀàÐÍ£ºÎĵµ |
ÏÂÔØ»ý·Ö£º 1 |
|
|
|
×ÊÔ´½éÉÜ |
|
Ŀ¼
Ò»¡¢ ²úÆ·¸ÅÊö............................................................................................................ 4
1.1²úÆ·¹¦Äܼò½é ...................................................................................................... 4
1.2²úÆ·¹¦ÄÜÌØµã ...................................................................................................... 4
¶þ¡¢ Ö÷Òª¹¦ÄÜÃèÊö..................................................................................................... 5
2.1»ù±¾¶ÔÏó¼°Ê¹Ó÷½·¨ ............................................................................................ 5
2.2´´½¨²éѯ ........................................................................................................... 10
2.2.1½¨Á¢Êý¾Ý¼¯ ............................................................................................ 10
2.2.2²éѯ½çÃæÉè¼Æ ......................................................................................... 14
Èý¡¢²¿·ÖµäÐͰ¸Àý½â¾ö·½°¸............................................................................................ 16
ËÄ¡¢ÁªÏµÎÒÃÇ................................................................................................................. 18
ÌìÍøÖÇÄܲéѯÉè¼ÆÆ÷²úÆ·ÊÖ²á
°æÈ¨ËùÓЩ 2009 ÌìÍøÈí¼þ - 4 -
Ò»¡¢ ²úÆ·¸ÅÊö
1.1²úÆ·¹¦Äܼò½é
ÖÇÄܲéѯÉè¼ÆÆ÷ÊÇÎÒÃÇÌṩ¸øÓû§µÄÒ»¸ö×Ô¶¨ÒåµÄ²éѯ¹¤¾ß£¬Ëü¿ÉÒÔ¸ù¾ÝÓû§µÄÐèÇó£¬ÒÀÍÐHISÊý¾Ý¿â£¬Í¨¹ý¼òµ¥µÄ½çÃæÉè¼Æ£¬À´Íê³É²éѯ£¬¹¦ÄÜÇ¿´ó£¬Éè¼ÆÁé»î
1.2²úÆ·¹¦ÄÜÌØµã
1¡¢²éѯ½á¹ûÖ§³ÖÆÁÄ»´òÓ¡£¬¿ØÖÆ·½·¨¶àÑù
2¡¢Ö§³Ö×îÖÕÓû§Éè¼Æ¡¢Ð޸IJéѯ£¬Ö»ÐèÁ¬½ÓÏà¹ØµÄÊý¾ÝÔ´£¬È·¶¨Ïà¹ØµÄ±í£¬¾Í¿ÉÒÔ¿ìËÙÉú³É²éѯ
3¡¢Éú³ÉºóµÄ²éѯ֧³ÖÐ޸쬰üÀ¨×ÖÌåµÄÉèÖ㬱߿òµÄÉèÖã¬Êý¾Ý±íµÄµ÷ÕûµÈ¡£
4¡¢ÍêÈ«×Ô¶¨Òå²éѯ½çÃæ£¬²¢Ö§³Öº¯Êý£¬×ܺϼƵȹ¦ÄÜ£¬¶Ô·Ö×éºÏ¼Æ£¬×ܼÆ,ÏÔʾ¸ñʽµÈÖ»Ðè¼òµ¥µØÉèÖÃÊôÐÔ¼´¿É¡£
5¡¢²éѯ½á¹û×ֶοÉÒÔ×Ô¶¨Òåµ÷ÕûÏÔʾ˳Ðò£¬¸ù¾Ý½çÃæ¹ØÁªÌõ¼þ×Ô¶¯Éú³ÉSQL½Å±¾£¬·½±ã²éÕÒÎÊÌâ
ÌìÍøÖÇÄܲéѯÉè¼ÆÆ÷²úÆ·ÊÖ²á
°æÈ¨ËùÓЩ 2009 ÌìÍøÈí¼þ - 5 -
¶þ¡¢ Ö÷Òª¹¦ÄÜÃèÊö
Ë«»÷QuerySolution.exe£¬½øÈëÖÇÄܲéѯÉè¼ÆÆ÷½çÃæ£¬Ê×ÏÈÎÒÃǵ¥»÷ÐÂÔö°´Å¥£¬µ¯³ö²éѯ·½°¸×ÜÌåά»¤½çÃæ£¬ÔÚÕâÀィÁ¢²éѯ·½°¸µÄ»ù±¾ÐÅÏ¢£¬°üÀ¨·½°¸Ãû³Æ£¬ÖÐÎÄÃèÊö¼°±¸×¢£¬ÊäÈëÍêÏàÓ¦µÄÐÅÏ¢µã»÷È·¶¨°´Å¥£¬½øÈë²éѯÉè¼Æ»ù±¾½çÃæ¡£
ͼ1 ½¨Á¢²éѯ·½°¸µÄ»ù±¾ÐÅÏ¢
2.1»ù±¾¶ÔÏó¼°Ê¹Ó÷½·¨
ÖÇÄܲéѯÉè¼ÆÆ÷°üº¬×Ô¼ºµÄ¶ÔÏóºÍ¿Ø¼þ£¬ÈÃÓ¦ÓóÌÐòºÍ×îÖÕÓû§Äܹ»¸üÈÝÒ׵ظıä²éѯ£¬ÔÚÖ÷½çÃæÉÏ£¬ÎÒÃÇ¿ÉÒÔ¿´µ½²¢µ÷ÓÃÕâЩ¶ÔÏó¿Ø¼þ¡£
1¡¢ ÉÏ·½ÊÇ»ù±¾¹¤¾ßÇø
2¡¢ ×ó±ßÊǿؼþÇø
3¡¢ ÖмäÊDzéѯÉè¼ÆÇø
4¡¢ |
|
ÏÂÔØµØÖ· |
|
|
|
|
|