3HAC036811-003

¼Æ¾Ú®wªº³X°Ý¤èªk¦³«Ü¦h,¨ä¤¤Ado¬O°ò©óOLE DB±µ¤f¤W¹ê²{ªºCOM¹ï¶H,¥¦ªº¥D­nÀuÂI¬O©ö©ó¨Ï¥Î¡B³t«×§Ö¡B¤º¦s¤ä¥X¤Ö©MºÏ½L¿ò¸ñ¤Ö¡CAdo¦bÃöÁ䪺À³¥Î¤è®×¤¤¨Ï¥Î¤Öªººôµ¸¬y¶q,¨Ã¥B¦b«e¬q©M¼Æ¾Ú·½¤§¶¡¨Ï¥Î¤Öªº¼h¼Æ,¥»¤å¤¤±NAdo³X°Ý¼Ò¶ô«Ê¸Ë¦¨¤@­ÓADOConnÃþ,¦b½s¼g¼Æ¾Ú®wŪ¼gµ{§Ç®É¥u»Ý½Õ¥Î³o­ÓAdoÃþ§Y¥i[3],Ado«Ê¸ËÃþµ{§Ç¥]¬A¥|­Ó¨ç¼Æ:

//¼Æ¾Ú®w³s±µ¨ç¼Æ

¦b½s¼g¼Æ¾Ú®w¼Æ¾Ú´¡¤J»P³X°Ýµ{§Çªº®É­Ô,³q¹LVC½Õ¥ÎSQL»y¥y§Y¥i,¥»¤å¤¤¥D­n³q¹LSQL»y¥y¤¤ªºSelect¡BInsert¡BUpdate©MDeleteµ¥¶i¦æ¾Þ§@,¥HÄñ¶¤uÃÀ¤å¥ó¤U¸ü¬°¨Ò,Äñ¶¤uÃÀ¤å¥ó¤U¸ü®É,­º¥ý³s±µ¼Æ¾Ú®w,³q¹LSELECT»y¥y¬d¸ß¼Æ¾Ú®w¤¤ªº¤uÃÀ«ü©wªí,§ä¨ì«ü©wµ¹¥»¥Í²£½uªº¤uÃÀ¸¹,³q¹L¤uÃÀ¸¹½Õ¥ÎSELECT»y¥y¬d¸ß¼Æ¾Ú®wªºÄñ¶¤uÃÀªí,¤U¸ü¬ÛÃö¤uÃÀ,Äñ¶¤uÃÀVC¤U¸ü¬É­±¦p¹Ï2©Ò¥Ü,©T¤Æ¤uÃÀ¤U¸ü¬É­±¦p¹Ï3©Ò¥Ü¡CFRP(Fiber Reinforced Plastics)¤SºÙ°ªÀ£¬Á¼þ¿ûºÞ¹D,¦b¥Í²£¹Lµ{¤¤¥Ñ©ó¤u¤H¾Þ§@²¨©¿¡B¾÷±ñ«Y²Î¬G»Ù¡B¥Í²£¤uÃÀ¤å¥ó©ö¥á¥¢¦Ó³y¦¨¥Í²£¥XªººÞ¹D½è¶q¤£¦X®æ,¬O§xÂZ¦U¬Á¼þ¿ûºÞ¹D¥Í²£¼t®aªº¤@­ÓÃöÁä°ÝÃD¡CÀHµÛ«H®§¤Æªº°ª³tµo®i,¥ø·~ªººÞ²z§Þ³N¤é·s¤ë²§,¥ø·~ªººÞ²z¶Vµo¬ì¾Ç¤Æ¡B³W½d¤Æ¡C¦]¦¹,´£¥X¤F¹ï²{¦³¥Í²£½u¶i¦æÁpºô¤É¯Å§ï³yªº­n¨D¡C

¥»¤å¦b§ïÅܭ즳¬Á¼þ¿ûºÞ¹D¥Í²£½u©T¤Æ«Y²Î±±¨î¤èªk[1]ªº«e´£¤U,¦bÄñ¶»P©T¤Æªº¥Í²£½uºÝVCµ{§Ç¤¤¥[¤J¼Æ¾Ú®w¾Þ§@¥N½X,¼Æ¾Ú®w³X°Ý§Þ³N±Ä¥Î«Ê¸ËAdo¤èªk,±Ä¥ÎSQL server 2000§@¬°ºôµ¸¼Æ¾Ú®w,¿ì¤½«ÇºÝ±Ä¥ÎC#»y¨¥½s¼g¡C¦b­ì¦³¥Í²£½u¥\¯à¤W¹ïí©w©Ê¡B©Êµ¥¦U¤è­±´£¥X¤F¡B°ª­n¨D,¥H¾AÀ³¤½¥q´£°ª²£«~½è¶q¡B¥[±j¥Í²£¡B²`¤Æ¦¨¥»±±¨î¡B´£°ª¤u§@®Ä²vµ¥¤u§@¤è¦V¡C

2  «Y²Îªº¾ãÅé¬[ºc³]­p

¹Ï1¬°¸Ó«Y²ÎªºC/S+B/S¤T¼hµ²ºc,¥¦ªº¹B¦æÀô¹Ò¤À«È¤áºÝ¡B¥Í²£½uºÝ©M¼Æ¾Ú®wªA°È¾¹ºÝ¤T³¡¤À,¼Ò¶ô¤Æ½sµ{,¨ãÅé¥\¯à¬°¤£¦P¼Ò¶ô°ï¬ä¡C¥Í²£½uºÝ¬°C/Sµ²ºc,³q¹LVC«Ê¸ËAdoÃþ®w³X°Ýºôµ¸¼Æ¾Ú®w,¨ã¦³¥Í²£¼Æ¾Ú¡B³øĵ¼Æ¾Ú¼g¤J¼Æ¾Ú®w©M¥Í²£¤uÃÀ¤U¸üµ¥¥\¯à;¿ì¤½«È¤áºÝ¬°B/Sµ²ºc[2],¥ÑC#»y¨¥½s¼g,¥D­n¦³Åv­­³]©w¡B³]³ÆºÞ²z¡BÄñ¶ºÞ²z¡B©T¤ÆºÞ²zµ¥¼Ò¶ô¡C±Ä¥Î¥H¤Óºô²Õ«Ø§½°ìºô,¥Ñ©ó¥Í²£½uµ{»P¿ì¤½«Ç¬Û¹j¸û»·,ºô½u±Ä¥Î»·µ{³q«H¹qÆl,¸ô¥Ñ±Ä¥Î±aµL½uµo®g¥\¯àªºTP-LINK¸ô¥Ñ¾¹¡C

3  ¼Æ¾Ú®w³]­p

SQL server 2000¬O¤@ºØ¨ã¦³Â×´I¶}µoÀô¹ÒªºÃö«Y«¬¼Æ¾Ú®w«Y²Î,¨ä¹B¦æ³t«×§Ö,¯à¨³³tÅTÀ³«Y²Î­n¨D,¤£¶È´£°ª¤Fºôµ¸¥Î¤áªº¾Þ§@³t«×,ÁÙ¯à°÷´£¨Ñ¦h¹ï¦hªº¤u§@¯¸»Ý¨D,¸Ñ¨M¤F¦h¥Î¤á¾Þ§@¼Æ¾Ú·lÃa©M¥á¥¢µ¥°ÝÃD¡C

®Ú¾Ú«Y²Î©M¥Î¤á­n¨D,SQL server 2000¼Æ¾Ú®w¤¤¹ï¨C¤@±ø¥Í²£½u»Ý«Ø¥ßºÞ¹D_Äñ¶_©T¤Æ_°O¿ý¡BÄñ¶¤uÃÀªí¡B©T¤Æ¤uÃÀªí¡B¤uÃÀ«ü©wªí¡B³øĵ«H®§ªí¡B³]³Æ«H®§ªíµ¥¡C ´ú¸Õ­I´º

­p¶q³¡ªù»Ý­t³d¹ï¥»³æ¦ì©Ò¦³»ö¾¹¶i¦æ©P´Á®Õ·Ç¥H¤ÎÅ禬µ¥¤u§@¡A«Ý­p¶q»ö¾¹¤À¬°¿W¥ß»ö¾¹¥H¤Î¼Ò¶ô¤Æ»ö¾¹¨â¤jÃþ¡C¼Ò¶ô¤Æ»ö¾¹¬Û¹ï¶Ç²Î»ö¾¹¦Ó¨¥¯Ê¤Ö¥Î¤á¡§­±ªO¡¨¡A»Ý­n¨Ï¥Î³n¥ó­±ªO¥H¤Î¬ÛÀ³ªºµ{§Ç¹ïªO¥d¶i¦æ±±¨î¡Aª¬ºA¿é¥Xµ¥¡C¾Þ§@¬Û¹ï´_Âø¡C¦]¦¹¼Ò¶ô¤Æ»ö¾¹ªº­p¶q¦Û°Ê¤Æµ{«×«Ü§C¡A¹ï³æ¤@¼Ò¶ô¤Æ»ö¾¹­p¶qªº®É¶¡¸ûªø¡A®Ä²v§C¡C¬°¤F§ïµ½³oºØ±¡ªp¡A­p¶q³¡ªù»Ý­n¤@®M°w¹ï¼Ò¶ô¤Æ»ö¾¹ªº¦Û°Ê¤Æ®Õ·Ç«Y²Î¡C

²¤Æ¼Ò¶ô¤Æ³]³Æªº®Õ·Ç¡A¦Û°Ê¤Æ¡I

VXI¡BPXIÁ`½u´ú¶q³]³Æ®Õ·Ç«Y²Î

«Y²Î´y­z

VXI¡BPXIÁ`½u´ú¶q³]³Æ®Õ·Ç«Y²Î¯à°÷¦b²Î¤@¥­»O¤W¹ï¤£¦P³]³Æ¹ê²{¹ï¼Ð·Ç»ö¾¹¥H¤Î³Q®Õ·Ç»ö¾¹ªº±±¨î©M®Õ·Ç¾Þ§@¡A«Y²Î³]­p¥]¬A«Y²Î¥­»O³]­p¥H¤Î³n¥ó³]­p¡C

«Y²Î¯SÂI

¡¹¯à¤ä«ù¨âºØ±`¨£Á`½uÃþ«¬¼Ò¶ô¤Æ»ö¾¹¡GPXI¥H¤ÎVXI¡F

¡¹°w¹ïPXI¡BVXIÁ`½uÃþ«¬¼Ò¶ô¤Æ»ö¾¹¡A¤ä«ù¤TºØ±`¨£¥\¯àªºªO¥dDA¡BAD¡A¼Æ¦r¸U¥Îªí¡F

¡¹¯à°÷¹ê²{¦h³q¹Dªº¦Û°Ê¤Á´«¡A­n¨D­p¶q¹Lµ{¤¤ºÉ¥i¯à´î¤Ö¤H¤uªº³s½u¡A¬d½u¤¤Â_¾Þ§@¡F

¡¹¨Ï¥ÎNI¶}µoªÌ®M¥ó¶}µoPXI¥H¤ÎVXI¼Ò¶ô¤Æ»ö¾¹®Õ·Ç³n¥ó¡F

¡¹¸Ó®Õ·Ç«Y²Î¨Ï¥Î²Î¤@ªºµw¥ó¥­»O¡A¨Ï¥Î¤£¦Pªº³n¥ó¼Ò¶ô¥i¥H¤À§O¹ê²{°w¹ïPXI©ÎªÌVXI¼Ò¶ô¤Æµw¥óªO¥dªº®Õ·Ç¡F

¡¹¯à°÷ÆF¬¡¦a¦Û©w¸q³]­p³øªí®æ¦¡¡C  ¦b¥]¸Ë¾÷±ñ³]³Æ¬G»Ù¤¤¡A¿i·l¬O¥D­nªº¡C¦Ó¥]¸Ë¾÷±ñ¦U²Õ¦¨¹s¥óªºÅܧΡA±`±`·|¥[¤j¹s¥ó¿i·l¡A¾É­P³]³Æ¬G»Ù¡C

¥]¸Ë¾÷±ñ¦b§@·~¹Lµ{¤¤¡A¥Ñ©ó¨ü¤Oªº§@¥Î¨Ï¹s¥óªº¤Ø¤o©Î§Îª¬²£¥Í§ïÅܪº²{¶H¥s°µÅܧΡC¥]¸Ë¾÷±ñ¹s¥ó¡A¯S§O¬O°ò¦¹s¥ó©Î¹BÂೡ¦ìªº¹s¥óªºÅܧΡA±NÄY­«¼vÅT¥]¸Ë¾÷±ñ³]³Æªº¤u§@½è¶q©M¹Ø©R¡C

ª÷Äݹs¥óªºÅܧξ÷²z

ª÷Äݹs¥óÅܧΪº¹Lµ{¥i¤À¬°¼u©ÊÅܧ楬q©M¶ì©ÊÅܧ楬q¡C¹ê½îÃÒ©ú¡A¦b¨âºØÅܧΤ¤¡A¶ì©ÊÅܧιï¹s¥óªº©Ê¯à©M¹Ø©R¦³¸û¤j¼vÅT¡C

ª÷Äݧ÷®Æ¼u©ÊÅܧΪº¾÷²z¬O¡Gª÷ÄÝ­ì¤l¶¡¦s¦bµÛ¬Û¤¬¥­¿Åªº¤O¡X¡X§l¤O©MÀ£¤O¡C§l¤O¨Ï­ì¤l©¼¦¹±K¦X¨ì¤@°_¡F¦ÓÀ£¤O«h¨Ï­ì¤l¶¡¤£­n±µªñ±o¤Óºò±K¡C¦b©ó±`±¡ªp¤U¡A­ì¤l¦û¾Úªº¬O³o¨âºØ¤O«O«ù¥­¿Åªº¦ì¸m¡C·í¬I¥[¥~¤O¨Ï­ì¤l¶¡¶Z¾aªñ©Î©Ô»·®É¡A³£¥²µM²£¥Í¬ÛÀ³ªº¬Û¥¸§Ü¤O©Î¬Û§lªº§Ü¤O¡A¨Ã»P¤§«Ø¥ß·sªº¥­¿Å¡C·í¥~¤O¥h°£«á¡A¤S¥X²{·sªº¤£¥­¿Å¡A­ì¤l­«·s¦^¨ì­ì¨Ó¬Û¤¬¥­¿Åªº¦ì¸m¡C³o¤]´N¬O¼u©ÊÅܧΪº¾÷²z¡A§Y¬O»¡¼u©ÊÅܧΤD¬O¥Ñ©ó¥~¤O§@¥Î©Ò¤Þ°_ªº¡A­ì¤l¶¡¶ZÂ÷µo¥Í¥i°f©ÊÅܤƪºµ²ªG¡C

MOTOROLA MVME SBC VME CARD

Motorola XR867KC-V3 MVME

Motorola MVME147-022 MVME 147-022 Module PN: 01-W3964B

Motorola MVME162-523 MVME 162-523

Motorola MVME337-1 MVME 337-1

Motorola MVME374-1 MVME 374-1

Motorola MVME328-1 MVME 328-1

Motorola MVME332XTP MVME 332XTP

MOTOROLA MVME BOARD 01-W3580F W / 01-W3040F

Motorola MVME181-1 MVME 181-1 VME Module

Motorola MVME167-34B MVME 167-34B NEW

Motorola MVME187 MVME 187 VME Module

Motorola EMI-1

CSI 5133A 512k

MOTOROLA MVME 705A MODULE

Motorola Type MC1XXX

Motorola VMEBUS System Controller-VME Board-MVMe 050

MOTOROLA MVME 712A/AM

KLA Motorola MVME PN: 01-W3066F & 01-W3180F

Motorola MVME 333S-2 MVME333-2

Motorola MVME 332XT MVME332XT

MVME VME 337-1 Motorola 01-W3440B 13F

MOTOROLA BOARD MVME 332XTS

Motorola MVME 147S-1 MVME147S-1 VME

Motorola VMEBUS System Controller-VME Board-MVME 332

MOTOROLA MVME 712-102

MOTOROLA MVME 1301

Motorola MVME 337-1

Augat MVME 12-Port

MOTOROLA MVME 712M

Motorola MVME332XTS MVME-332XTS 8-CH