¦h¼h¦¡¬[ºc¬O¤@ºØ¶}µo§Þ³N¡A§ó¬O¤@ºØ¨t²Î¬[ºcªºÅé¨t³]­p·§©À
¥¦¬OÀHµÛ·~°È¤£Â_ÂX®iªº»Ý¨D©M¤¬°Ê¦¡ªº´¶¤Î¦Ó²£¥Íªº

¬[ºcªºµo®i¾úµ{ ....
   
¡@¡@¡@¡@¡@¡U2. LAN ªºOne-Tier¡U¡U3. DataBase ServerªºTwo-Tier¡U4. Application ServerªºThree-Tier¡U

1. ¶Ç²Îªº One-Tier
¡@¡@¥H«e DBF ¨t²Î´N¬O±N¸ê®Æ®w©ñ©ó Local¡]³æ¾÷¤W¡^¡A¦p§Ú­Ì¥Î DBASE ©Î CLIPPER ³z¹L Use / Append / Replace / Delete / Seek ¡Kµ¥«ü¥O¥h¦s¨ú DBF ÀɮסA§A¼gªºµ{¦¡ PRG ¬O¦b Local ¤W°õ¦æ¡A¨Ã©I¥s Local ¤Wªº DBASE ©Î CLIPPER LIB¡]©Î DLL¡^¥h¦s¨ú³o¨Ç DBF ªºÀɮסA¾ã­Ó¹Lµ{³£¦b¦P¤@­ÓLocal PC ¤W°õ¦æ¡A§Ú­Ì¥i¥H¥s¥¦ One-Tier¡F¦p¹Ï¤@©Ò¥Ü¡A¦b PC ¤W§Ú­Ì¨Ï¥Î¤F DBASE ªºµ{¦¡¨Ó¦s¨ú¦P¤@³¡ PC ¤Wªº DBF ÀÉ¡A©Ò¦³¥\¯à³£¦b¦P¤@³¡PC ¤W°õ¦æ¡C

2. LAN ªº One-Tier
¡@¡@NOVELL ¤Î WINDOWS ¥i¥H±N DBF ¸m©ó File Server ¤W¡A©Ò¥H¶i¤J¤F Multi-User ®É¥N¡A¦¹®É¡ADBF Åý¦h­Ó PC ¥i¥H¦@¨ÉÀɮס]¥iŪ¥i¼g¡^¡A½T¹ê±a¨Ó«K§Q©Ê¡A¦ý¦b DBASE ©Î CLIPPER ªº PRG ÁÙ¬O¦b PC ºÝ°õ¦æ¡]µ{¦¡¥i¥H©ñ¦b File Server ¤W¡A¦ý Run ¬O¦b PC ¤W¡^¡A©Ò¥H PC ºÝ¥u¬O¥hºô¸ô Open DBF ÀɮסAŪ¼g³£¬O¦b PC ºÝ¥h§¹¦¨ªº¡A³o­Ó¬[ºc¥u¬O DBF ªº¦@¨É¡AFile Server ¨Ã¨S¦³¥ô¦ó¨Æ±¡°µ¡A©Ò¥HÁÙ¬O¦b One-Tier ¤W§@·~¡CVD20 ªº BDE ¤¤ Local DBF ÁöµM¥i¥H«ü©w©ñ¦bºô¸ôºÏºÐ¾÷¤W¡A¦ý¤]¬O One-Tier¡C¦p¹Ï¤G¡A¦UPC ¤u§@¯¸³z¹L File Server ¦@¨É¸ê®Æ®w¡]DBF ÀÉ¡^¡A¦ý©Ò¦³¸ê®Æ¦s¨ú¬O¥Ñ¦U PC ¦Û¤v¥h°õ¦æ»P§¹¦¨ªº¡C



3. DataBase Server ªº Two-Tier
¡@¡@Two-Tier ´N¬O Client/Server ªº¬[ºc¡AClient ´N¬O PC ©Î²×ºÝ¾÷¡AServer ´N¬O Database Server¡A¬ù¤Q¤­¦~«e¡AIBM µo®i DB2 ¬° Client/Server ¶}±Ò¤F¤jªù¡A¦¹«á¦p«B«á¬Kµ«¡AInformix / Sybase / Oracle ±¸°_¡A©ó1990¦~¥N¤j¸v¬y¦æ¡A95 ¦~°_¡AMS-SQL °Ý¥@¡A§óÅý¸ê®Æ®w¥«³õ¶i¤J¾Ô°ê®É¥N¡A´N¬O¦]¬° RDBMS¡]Relation DataBase Management System¡^½T¹ê±a¨Ó¸ê®Æ®wªº®ÄÀ³»P¼Ð·Ç¡C

¡@¡@©Ò¿× DataBase Server¡A´N¬O±Mªù³B²z¸ê®Æ®wªº¥D¾÷¡A³B²z¸ê®Æ®wªº¤èªk¬O±Ä¥Î¤@ºØ¤j®a¼Ð·Çªº»y¨¥¡ÐSQL¡A³oºØ»y¨¥¤w¸g¦¨¬°µo®i¸ê®Æ®wªº¦@¦P¼Ð·Ç¡]¦p ANSI-92 ¼Ð·Ç¡^¡A´N¬OµL½×§A¨Ï¥Î­þºØ¸ê®Æ®w¡A§A³£¥i¥H¨Ï¥Î¬Û¦Pªº SQL »y¨¥§Y¥i¥H¦s¨ú¸ê®Æ®w¡]¨ä¹ê¦U®a¸ê®Æ®w¼t°ÓÁÙ¬O¦³·L¤pªº¯S®í®t²§©Ê¡A¤£¤@©w§¹¥þ¦@³q¡^¡C©Ò¦³ªº PC ©Î Client ³£¥²¶·¥H SQL ¨Ó¤U¹Fµ¹ DataBase Server¡A¨Ã¥Ñ DataBase Server ¥þÅv³B²z¡AClient ¥²¶·µ¥«Ý Server ªº°õ¦æµ²ªG¡A¦p Insert / Update / Delete ´N¬O«ü´§­n¹ï DataBase Server ¶i¦æ¬Y Table¡]¸ê®Æªí¡^ªº·s¼W / §ó§ï / §R°£ªº°Ê§@¡A¦p Select ´N¬O­n«ü´§ Server ¥h¬d¸ß¬ÛÃöªº¸ê®Æ¤U¨Ó¡AServer ¬O¥H Cursor ªº¤è¦¡±N¸ê®Æ¦^¶Çµ¹ Client¡A¤]¬O»¡ Client ¤U¹F Select ªº SQL ¥H«á·|±o¨ì¤@­Ó Cursor¡]¸ê®Æ¶°¦X¡^¡A©Ò¥H Client/Server ¬O¤@ºØ¤À¤uªº¼Ò¦¡¡A¥Ñ Client ¨Ó´£¥X¥Ó½Ð¡A¥Ñ Server ¨Ó§¹¦¨¸ê®Æ¦s¨úªº¥Øªº¡A¦p¦¹§Y¥i¥H±N¸ê®Æ¦w¥þ¶°¤¤©ó DataBase Server ¤W¡A¤£¥²¹³ DBF ¤À´²¨ìPC ¤W¦s¨ú¡A®e©ö¶Ã±¼»P·l·´¡]¤×¨ä¬O Index ¤å¥ó¡^¡A¸ê®ÆªºÃ­©w«×¬Û¹ï´£°ª¡A³B²z¤j¶q¸ê®Æªº³t«×¤]¬Û¹ï´£¤É¡]DBF ¸ê®Æ¤@¤j¡A³t«×´N¬OºC¡^¡AC/S ¬[ºc½T¹ê´£¤É¤£¤Ö³t«×»P«~½è¡C

¡@¡@¦p¹Ï¤T¡A¦b LAN ¤W·|¦³¤@­Ó DataBase ªº¥D¾÷¡A¥Ñ¥¦­t³d¨ÓªA°È¦U¤u§@¯¸ªº¸ê®Æ¦s¨ú¤u§@¡A¨C­Ó¤u§@¯¸³£¬O¥H SQL »yªk¨Ó¦V DataBase ¥D¾÷¤U¹F½Ð¨D©R¥O¡A¨Ã¥Ñ DataBase ¥D¾÷¨Ì¤u§@¯¸©R¥O¥N¬°¨ú¸ê®Æ®w¡C


4.Application ServerªºThree-Tier

¡@¡@¨ä¹ê Two-Tier ¤w¸g¸Ñ¨M¤F¤£¤Ö¸ê®Æ®wªº°ÝÃD¡A¦ý­±Á{¤j«¬¨t²Î¡AC/S ·|¦]¬° Connection ¼Æ¶q¡]¨Ï¥ÎªÌªº³s½u¼Æ¡^ªº¼É¼W¦Ó³y¦¨ Database Server µLªk­t²ü¡A³q±`¤@­Ó Application Connection ¥u­n¨ì¹F 30 ¨ì 50 ­ÓUser´N·|³y¦¨ DB Server ¯h©ó©b©R¡A³t«×»P®Ä¯à±N¦³ÅãµÛªº§ïÅÜ¡F¥t¤@­Ó°ÝÃD´N¬O·í¸ê®Æ®wªº¸ê®Æ«Ü¤j®É¡AClient/Server ³q±`·|¨Ì SQL ©R¥O±N¤j¶q¸ê®Æ¶Ç¦^ Client¡A©¹©¹³y¦¨ºô¸ô»P Server ªº²~ÀV¡F¦AªÌ´N¬OºûÅ@ªº°ÝÃD¡A¤j«¬ªº¨t²Î¦³«Ü¦h«Ü¤jªº Client µ{¦¡¡A¤À´²¨ì¦U­Ó Client ¤W¡A¨C·í¦³µ{¦¡ª©¥»²§°Ê®É¡A³£¥²¶·¤j¶O©P³¹ªº±N Client µ{¦¡´«±¼¡A¦A¥[¤W¥Ø«e¾ã­Ó A/P ªº¥þ²yµo®iÁͶմN¬O Thin-Client¡]½G¤pªº Client¡^¡A3-Tier ªº¬[ºc»P¬ÛÃö§Þ³N¤]´N¦]¹B¦Ó¥Í¤F¡C
¡@¡@©Ò¿× 3-Tier ´N¬O Client / Application Server / DataBase Serverªº·N«ä¡A»P 2-Tier ¤£¤@¼Ë¡A´N¬O±N­ì¥» Fat Client¡]ªÎ­Dªº Client ºÝ¡^©î¦¨ Thin Client »P Application Server¡C»¡©ú¦p¤U¹Ï¡G

¡@¡@

(1) Client¡G¡]¤SºÙ¥Î¤á¼h¡B¤¶­±¼h¡^
¡@¡@²³æªº Client µ{¦¡¡A¤]¥i¥H¨Ï¥Î Web ¨Ó³]­p¡]VD30 ¼È®É¤£´£¨Ñ Web Client ªº³s±µ¤è¦¡¡^¡A¨äµ{¦¡¤£·|ª½±µ¸IIJ¸ê®Æ®w¡A¤]´N¬O¨S¦³¥ô¦ó SQL »yªk»P¸ê®Æ®w¦s¨úµ{¦¡¡A§ó¤£¯à¦³¸ê®Æ®wªº¹BºâÅÞ¿è¡AClient Åܦ¨¥u¯à¥Î¨Ó¿é¤J»PÅã¥Ü¸ê®Æ¡A¦n¹³¬O·í¦~ªº Terminal¡AClient Åܪº«Ü²³æ¡A³»¦h¤]¥u¯à°µÂI¸ê®ÆªºÀËÅç»P Column ¶¡ªº¹w³]­È¤Î²©ö¹Bºâ¦Ó¤w¡A»P Web ªº HTML »P PHP ªº«eºÝ³]­p«Ü¹³¡A¸T¤î¥h°õ¦æ«áºÝ Database ªº°Ê§@¡A¥u¬O´£¨Ñµ¹¥Î¤á¤@­ÓµøÄ±¤Wªº¤¶­±¡C
(2) Application Server¡G¡]ÅÞ¿è¼h¡^
¡@¡@´N¬O±µ¨ü Client ªº½Ð¨D¥D¾÷¡AClient ·|»P Application Server ­n¸ê®Æ¤Î­n¨D¦s¤J¸ê®Æ¡A©Ò¥H A/P Server ¬O Client ªº¦@¦P¥N²z¤H¡A¥N²z¦U Client ªº¸ê®Æ¦s¨úªA°È»Pµ{¦¡ªA°È¡A¤]´N¬O»¡¡AA/P Server ¥H SQL »yªk»P DB¡]DataBase¡^Server ¸IIJ¡C¦ý Client «h¤£¦æ¡A¶·¸g¥Ñ A/P Server ¥N²z¡A·í A/P Server ¥Ñ DB Server ¨ú±o¸ê®Æ«á¡A¦A¥H MIDAS ±N Cursor ¶Ç°e¨ì Client ¤W¡C¬Û¹ïªº¡A¦pªG Client ­n¦s¤J¸ê®Æ¡A«h­n©I¥s A/P Server ºÝªº¦sÀɵ{¦¡¡A¦¹®É Client ·|±N¸ê®Æ¥´¥]¶Ç°e¨ì A/P Server ¤W¡A¦A¥Ñ A/P Server ¨Ó¥H SQL »yªk¹ï DB Server ¦sÀÉ¡C
(3) DataBase Server¡G¡]¸ê®Æ¼h¡^
¡@¡@»P­ì¨Ó Client/Server ¬[ºcªº Database Server ¤@¼Ë¡AºûÅ@¸ê®Æªº§¹¾ã©Ê¡B¦w¥þ©Ê¡A¤Î¦^À³ Application Server¡]ÅÞ¿è¼h¡^ªº½Ð¨D¡A§êºt Database ¦s¨úªºªA°È¡C

¡@¡@°T¥ú¦­¤w¦b 3 ¦~«e´N¥H MIDAS¡]Borland µo®iªº³q°T¨ó©w¡^¬ãµo 3-Tier ªº§Þ³N¡A¸g¹L¤F2¦~ªº¤j«¬±M®×¹ê°È¾ú½m¡A³y´N¤F EEP ªºµo®i¥­¥x¡]Electronic Enterprise Platform¡^¡C¬°¤F¯à±N·sªº¬ãµo¦¨ªG¥i¥HÅý DBTOOLS «È¤á¸s¤À¨É¡AVD3.0 «h¦P¼Ë±Ä¥Î EEP ªº A/P Server ¥­¥x¡AÅý VD30 ª½±µÅD¤É¬°³Ì·sªº 3-Tier ¬[ºc¡A¨Ó¸Ñ¨M 2-Tier µLªkº¡¨¬ªº»Ý¨D¡C
¡@¡@¦]¬° VD3.0 ªº A/P Server¡A¬O±Ä¥Î¤F°T¥ú¦Û¦æ¬ãµoªº EEP A/P Server¡A©Ò¥H¨ã¦³¦p¤U´X­Ó¯S©Ê¡G

1.
Ãþ¦ü Web ªº§¹¥þµLª¬ºAªº³s½u¤è¦¡¡C¤]´N¬O Client »P DataBase ÀH®É«O«ù¤£³s½uª¬ºA¡A¤@ª½¨ì»Ý¨Dµo¥Í¤~¥h³s½u¡A¦p¦¹±N«O«ù¸û¨Îªº³s±µª¬ºA¡C¥t¥~¡AA/P Server »P Client ¤]¬OµLª¬ºAªº¡A¤]´N¬O Client »P Server ¨âºÝÀH®É¥i¥HÂ_½u¡A¥u­n³s½u¤@«ì´_¡A¨t²Î±N¦Û°Ê¦A³s½u¡]User µ¥«Ý¶È 2~3 ¬í¶¡¡A¬OµL·Pıªº¡^¡C³o¼Ë°£¤FÅý A/P SERVER
¯à©Ó¨ü§ó¤jªº­t¸ü¥~¡AÁÙ¥i¥H¤j´T«×¦a´£¤É¨t²ÎªºÃ­©w«×¡C
2.
¤ä´© Name Server ªº¬[ºc¡C¥i¥H¨Ï¥Î Load Balance ªº¥\¯à¨Ó½Õ¸`·í User ¼É¼W®É¦h¥x A/P Server ¶¡ªºLoading¡CName Server ¤]¥i¥H¬°µLª¬ºA¼Ò¦¡¡A¤]´N¬O»¡«e¤@¤ÀÄÁ¥Ñ¬Y­Ó A/P Server ¨ÓªA°È¡A¦ý¤U¤@¤ÀÄÁ¤£¤@©w¬O¥Ñ¦P¤@¥x¨ÓªA°È¡C
3.
¤ä´© Server Method¡C´N¬O¥Ñ Client ¨Ó©I¥s¡A¦ý¬O¦b Server ¤W°õ¦æ¡A³o³¡¥÷«Ü¹³ Store Procedule¡A¥u¦b A/P Server ºÝ°õ¦æªºµ{¦¡¡A¦b EEP ¬O¥H Delphi ¨Ó³]­p Server Method¡A¦b VD3.0 «h¥i¥H¦b Server Form ³]­p¤@¬qµ{¦¡¡A¨Ã¥Ñ Client ¨Ó©I¥s¡C
4.
«D¦P¨Bªº IServer Method¡C«e­±ªº Server Method ªº Client ·|¤@ª½µ¥¡Aµ¥¨ì Server °õ¦æ§¹²¦«á Client ¤~·|¦A°õ¦æ¡C«D¦P¨Bªº lServer Method ¤]¤@¼Ë¡A®t§Oªº¬O Client ºÝ´N¤£¥²¥hµ¥«Ý¡A¥i¥Hª½±µ¥h°µ§Oªº¨Æ¡A«Ý A/P Server °õ¦æ§¹²¦«á¡AServer ¥²¶·¥H MessageID ªº¤è¦¡¨Ó³qª¾ User¡C«D¦P¨Bªº lServer Method ¨C¤@­Ó Method ³£¦b Server ºÝ¤@­Ó¿W¥ßªº Thread ¤¤°õ¦æ¡A¬°¤FºÞ¨î Resource¡A·|­­¨î Method ªº°õ¦æ¼Æ¶q¡A·í¶W¹L³W©w¼Æ¶qªº´N­n¥H Queue ¨Ó Hold ¦í¡A¦A¨Ì¦¸®ø¤Æ Method ªº°õ¦æ¡C
5.
A/P Server ºÝ¤Wªº¤¸¥ó¤£¦h¡C¥Ø«eª¾¹Dªº¦³ SQuery / SDataSource / SUpdateComp / SAutoNumber¡]¦Û°Ê½s¸¹¡^¡K¡A°ò¥»¤WÁÙ¬O¸ê®Æ®wªº¤¸¥ó¸û¦h¡CÁÙ¦³¤@¨Ç¦pÂà´«¸ê®Æªí¦Ü Work / Excel / TXT / HTMLªº¤¸¥ó¡C
6.
¸ê®Æ¦P¨BªA°È¡CVD3.0 ´£¨Ñ¤@­Ó Cache Table ªº¾÷¨î¡A¤]´N¬O»¡±N³¡¥÷±`¥Î¥B¸ê®Æ¸û¤pªº Table Cache ¨ìClient ¨Ó¡A¨ä Client ªº°ÆÀɦW¬° .CAC¡A¦¹®É Client ¦b¨Ï¥Î LookUpList ®É¥i¥Hª½±µ½Õ¥Î Client ªº Cache¡A¤£¥²¦A¨ì Server ¤W§ì¨ú¸ê®Æ¡A¦p¦¹¤@¨Ó¦b Internet ®Ä²v¤W·|´£¤É¤£¤p¡A°ß¤@¯ÊÂI´N¬O¸ê®Æ¦P¨Bªº°ÝÃD¡A©Ò¥HA/P Server ¥²¶·­t³d³o¨Ç Client ªº CAC ¦P¨B¥\¯à¡]¥u¯à±N Server ªº³Ì·s¸ê®Æ¹ï¦U­Ó Client §ó·s¡^¡C
7.
¥i¥H¥Î ADO ³s±µ¸ê®Æ®w¡C¥Ø«e A/P Server ÁÙ¬O¥Î BDE ¨Ó³s±µ Database¡A¥¼¨Óªº EEP A/P Server ±N¥i¥H¨Ï¥Î ADO ¨Ó³s±µ¸ê®Æ®w¡C

¡@¡@±q¶}µo¨¤«×©MÀ³¥Î¨¤«×¨Ó¬Ý¡A¤T¼h¦¡¬[ºc¤ñ¨â¼h©Î³æ¼hµ²ºc³£¦³§ó¤jªºÀu¶Õ¡C¤T¼h¦¡µ²ºc¾A¦X¸sÅé¶}µo¡A¨C¤H¥i¥H¦³¤£¦Pªº¤À¤u¡A¨ó¦P¤u§@¨Ï®Ä²v­¿¼W¡C¶}µoÂù¼h©Î³æ¼hÀ³¥Î®É¡A¨C­Ó¶}µo¤H­û³£À³¹ï¨t²Î¦³¸û²`ªº²z¸Ñ¡A¯à¤O­n¨D«Ü°ª¡A¶}µo¤T¼hÀ³¥Î®É¡A«h¥i¥Hµ²¦X¦h¤è­±ªº¤H¤~¡A¥u»Ý¤Ö¼Æ¤H¹ï¨t²Î¥þ­±ÁA¸Ñ¡A±q¤@©wµ{«×¤u­°§C¤F¶}µoªºÃø«×¡C

¡@¡@¤T¼h¬[ºcÄÝ©ó½G«È¤áªº¼Ò¦¡¡A¥Î¤áºÝ¥u»Ý¤@­Ó¸û¤pªºµwºÐ¡B¸û¤pªº°O¾ÐÅé¡B¸ûºCªº CPU ´N¥i¥HÀò±o¤£¿ùªº©Ê¯à¡C¬Û¸û¤§¤U¡A³æ¼h©Î­D«È¤á¹ï¾÷¾¹ªº­n¨D¤Ó°ª¡C¸Õ·Q¦pªG¤µ«áÁÙ¬O¥H³æ¼h©ÎÂù¼h¬[ºc¬°¥D¬yªº¸Ü¡AµwÅ骺§ó·s¶O¥Î±N·|¦³¦h¤j¡A¾¨ºÞ²{¦b¹q¸£»ù®æ¤U­°«Ü¦h¡A¹ï­Ó¤H¥Î¤á¤w¥i¥H©Ó¨ü¡A¦ý¹ï©ó¥ø·~¦Ó¨¥¡AÀWÁcªºÂ¾÷¾¹²^¨O¡A´«·s¾÷¾¹¡A³o¬O¤@µ§¦h»ò¤jªº¶O¥Î¡C¥i¨£¡A¤T¼h¬[ºcªº¹ê²{±aµ¹§Ú­Ìªº¤£¶È¶È¬OºØ²z©À¡A§ó¦hªº¬O¸ê·½»P®Ä²v¡C

VD ªº³]­p²z½× ....
   
¡@¡@¡@¡U1. Clien tData Set -- «eºÝ¸ê®Æªí¡U2. Server Form -- ¦øªA¾¹ªí³æ¡U3. Server Method -- ¦øªA¾¹µ{¦¡¡U

¡@¡@¥Ñ©ó±Ä¥Î 3-Tier ªº¬[ºc¡A©Ò¥H«eºÝ´N¤£¤¹³\»P¸ê®Æ®w¦³ª½±µ±µÄ²¡A¤×¨ä¬O¦bªí³æ³]­p¤W¡A¤£¯à¨Ï¥Î Table »P SQL ³o¨â­Ó¤¸¥ó¥h³]­p¡C¦]¬°³o¨â­Ó¤¸¥ó³£·|¨Ï¥Î¨ì B.D.E¡A·|»P Database ¦³ª½±µªº³s±µÃö«Y¡A³o¬O¹H¤Ï 3-Tier ªº³]­p­ì«h¡C¦]¦¹¦b¤T¼h¬[ºc¤W³]­pªí³æ©M³øªí®É°£¤F»Ý­n±q A/P Server ¤W¨ú±o¸ê®Æ¥~¡AÁÙ­n¦Ò¼{¹ï¸ê®Æªí§@·s¼W§ó§ï§R°£ªº°Ê§@³B²z¡C¨º»ò»P¶Ç²Îªº³æ¼h³]­p¬Û¤ñ¤S¸Ó¦p¦ó¥h°µ©O¡H½Ð¬Ý VD ´£¨Ñªº¥H¤U´X­Ó·s¤¸¥ó¡G

1¡BClientDataSet («eºÝ¸ê®Æªí)
¡@¡@¬°¤F¯à¥R¤À³e¹ý 3-Tier ºë¯«¡A§Ú­Ì¦b«eºÝ¤S¦h²K¥[¤F¨â­Ó¸ê®Æ¤¸¥ó¡C¤@­Ó¬° Client Dataset¡A¥t¤@­Ó¬° Cache DataSet¡C¦]¬°­ì¨Óªº Table »P SQL ³£¬O¥Ñ Client ºÝ¤U SQL ©Î¥H Table ¤¸¥ó±N¸ê®Æ¶Ç¿é¨ì Client ¨ÓºûÅ@¡A©Ò¥HClient ¥²¶·­n¦w¸Ë BDE ¤~¯à¹B§@¡C¦Ó Client Dataset «h·|¥D°Ê¨ì«ü©wªº A/P Server ¤W§ì¨ú¸ê®Æ¡A¨t²Î·|¥H Provider Name 1. ¥h§ì¨ú A/P Server ªº¨º¤@­Óªº¸ê®Æ®w¡]Data Module¡^¡A¤]´N¬O»¡¡A¤£¬O¥Ñ Client ¨Ó¤U¹F SQL »yªk§ì¸ê®Æ¤U¨Ó¡A¦Ó¬O¥Ñ A/P Server ¨Ó¤U¹F SQL ¦V¸ê®Æ®w¨ú±o¸ê®Æ¦A¶Ç°e¨ì Client ¤W¡A¤~¯à§¹¦¨¸ê®Æ¦s¨úªºªA°È¡C(·íµM A/P Server ºÝ¤W¥²¶·­n¦³¬Û¹ïªº¸ê®Æ®w Data Module )


¡@¡@¸ÑÄÀ»¡©ú»¡1.¡GProvider Name ¤SºÙ¸ê®Æ¨ÑÀ³ªÌ¡A¬O Client Dataset ªº­«­nÄݩʤ§¤@¡CA/P Server ¤W¥i¥H¸ü¤J¦h­Ó¥H Delphi ³]­pªº BPL¡A¨C¤@­Ó BPL ³£¥i¯à¦³¦h­Ó Provider¡A¤@­Ó Provider ¤@¯ë¬O¥Nªí¤@­Ó A/P Server ºÝ¤Wªº SQuery¡A¥¦¤@Ãä³s±µ¨ì Database Server ¤W¡A¤@Ãä«h­n·Ç³ÆÅý User ³s±µ¡A¥H´£¨Ñ Client ªº¸ê®Æ¦s¨úªA°È¡C¦pªG¬ODelphi ªº BPL¡A«h Provider ªº®æ¦¡¬° BPLName.QueryName¡A«eªÌ«ü BPLName¡A«áªÌ¬° Server ºÝ QueryName¡F¤Ï¤§¦p³s±µ VD3.0 ªº¸ê®Æ¤¸¥óªÌ¡AProvider ªº®æ¦¡¬°¡GSVD30. ServerForm. SQueryName¡A«eªÌ©T©w¬° SVD30¡]¦]¬° VD3.0 ¥H¤@­Ó SVD30.BPL ¨Ó°ÊºA²£¥ÍµêÀÀ¦h­Ó BPL¡^¡A¤¤¶¡¬° Server ªº Form Name¡A«ü VD3.0 Server ºÝ VDS ©Ò¦s¤Uªº Server Form¡C«áªÌ¬° SQuery Name¡C


2. ServerForm (¦øªA¾¹ªí³æ)
¡@¡@VD2.0 ªº VDS ¤@¯ë¥u¦³ Client ºÝªº VDS¡A¦ý VD30 ¤¤ªº VDS ¦³¨âºØ¡C¤@ºØ»P­ì VD2.0 ªº VDS ¤@¼Ë³£¬OClient ºÝªº VDS¡A¬O¸m©ó Client ºÝ¤Wªº¡CVD3.0 ¥Î³o­Ó VDS ¨Ó±Ò°Ê Client ºÝªº Form ©Î Report¡F¥t¤@ºØ VDS ¬O¦s¦bEEP A/P Server ºÝªº VDS¡A¬O¥Ñ EEP A/P Server ªº VD30.BPL ¨Ó¶}±Ò¡A¤]´N¬O»¡ VD30.BPL ·|¦b VD30_Server ªº¥Ø¿ý¤W§ä¤@­Ó¦W¦r¬° Default.VDS¡]A/P Server ºÝªº¹w³] VDS¡^¡A¦¹ Server ªº VDS ·|¦s¥t¤@ºØ From¡A§Y¬O©Ò¿×ªºServer Form¡C³oºØ Server Form¥i¥H¦b VD3.0ªº«á¥x Designner ¤¤·s¼W»P³]­p¡C·íµM¡A¬°¤F²¤Æ³]­pµ{¦¡¡A§A¥i¥H±N VD3.0 ªº Client »P Server ³£¦X¨Ö¦b¦P¤@­Ó VDS ¤¤¡A¤£¥²¤À Client »P Server¡A­n¤À­n¦X¹ï VD3.0 ¨Ó»¡³£¬O¥i¥H¦Û¥Ñ³]©wªº¡A¦pªG¦X¦b¤@°_ªº¸Ü¡A¨º»P VD2.0 ¤@¼Ë¡C

¡@¡@3.0 ª©ªº Client ºÝ Form ¦³¤­ºØ¡G¤@¬° Form / ¤G¬° Report / ¤T¬° Global Form / ¥|¬° Template Form¡A¤­´N¬OVD30 ·s¼Wªº Server Form¡C¥¦¬O¥Î¨Ó³]­p»P Client Dataset ³s±µ¥Îªº Data Module¡C¤]´N¬O»¡¡AClient ¤£¯àª½±µ¨Ï¥Î Table »PQuery¡A¥u¯à¨Ï¥Î Client Dataset ³z¹L Server Form ªº Data Module ¨Ó¦s¨ú¸ê®Æ¡C¨º»ò¦p¦ó³]­p¤@­Ó Data Modual ©O¡A¤@¯ë¨ÓÁ¿¡A§Ú­Ì­n¦b Server Form ¶K¤J¤T­Ó¤¸¥ó¡C¤@­Ó¬O SQuery ¤¸¥ó¡A¤@­Ó¬O SUpdateComp ¤¸¥ó¡A³Ì«á¤@­Ó¬O SDataSource¤¸¥ó¡A¤À§OÁ¿­z¦p¤U¡G

(1)
SQuery¡G»P¤§«e TVDSQL ©Î Delphi ªº Query ¤¸¥ó¤@¼Ë¡A¥Î¨Ó¤U¹F SQL »yªk¨Ï¥Î¡A¦¹¤¸¥óªº§@¥Î¬O¤U¹F©R¥Oµ¹ DataBase Server¡A¨Ã±N¸ê®Æ¶Ç°eµ¹ Client ºÝ¡C
(2)
SUpdateComp¡G¥»¤¸¥óªº§@¥Î¬O¦Û°Ê¤Æ³B²z Client ºÝ©Ò­n¨Dªº Insert / Update / Delete µ¥»Ý¨D¡AA/P Server ·|¥H¦¹¤¸¥ó¨Ó¤U¹F¹ïÀ³ªº Insert / Update / Delete µ¥ SQL ©R¥O¡C·íµM¡A¥»¤¸¥ó¥²¶·»P SQuery ¤¸¥ó¬Û°t¹ï¡A¤£¥i³æ¿W¨Ï¥Î¡C
(3)
DataSource¡G¦Ó¥»¤¸¥ó¬O¥Î¨Ó¥]¸Ë Master / Detail¡]¤@¹ï¦hÃö³s¡^ªº¸ê®Æµ¹¬Y¤@­Ó SQuery ¨Ï¥Î¡A¤]´N¬O»¡±N¤@­Ó Detail ªº¬ÛÃö¸ê®Æ¥]¸Ëµ¹¤@­Ó Master ·í§@¨ä Mater ªº¬Y¤@­Ó Column¡C¦¹±Mªù¥Î¦b Master / Detail ªº±¡ªp¡A¨Ã¬°¤FÅý Master / Detail ¯à¦P®É¦sÀɩҥ]¸Ëªº¤¸¥ó¡C¦p¹Ï©Ò¥Ü

3. Sever Method¡]¦øªA¾¹µ{¦¡¡^
¡@¡@¥H«e¦b One-Tier ªº®É¥NùØ¡Aµ{¦¡³£¬O¦b³æ¥x¾÷¾¹¤W°õ¦æ¨Ã§¹¦¨¡A¦Û±q Microsoft »P¦U¼t°Ó¦b Windows ¤W¶}¥ßDCOM 1.¡]Distributed Component Object Model¡^ªº³W®æ«á¡A­Ó¤H¹q¸£´N¶i¤J¦h¥x¨ó¦P¤u§@ªº®É¥N¡A²¦³º­Ó¤H¹q¸£ªº³t«×¦h§Ö¡A¶i¨B¦h¯«³t¡A¤]¥u¬O¤@³¡ PC¡A¦p¦óÅý¦U PC ¯à¨ó¦P¤u§@¡A¨º¤@©w¬O¤@­ÓÅå¤Hªº¥@¬É¡A©ó¬Oªñ¦~¨Ó¬y¦æ 3-Tier »P N-Tier ´N¬O³o¼Ë¨Óªº¡A§Q¥Î¦U¦Û¤À¤uªº·§©À¡AÅý¤u§@¯¸©M¦øªA¾¹¦U¥q©Òªø¡A¶i¦ÓÅý PC ¯àµo´§¥X·¥­­ªº®Ä¯à¡C¦b VD30 ¤¤¡A§A¥i¥H¦b Client ¤W©I¥s Server ºÝªºµ{¦¡¡A©I¥sªº¤èªk»P¤@¯ë©I¥s Client ºÝªº PRG ¤£¤@¼Ë¡A§A¥²¶·¦b Client µ{¦¡¤¤¥H"_"¶}ÀY¥Nªí¬O Server ¤Wªº Form¡C»yªk®æ¦¡¦p¤U¡G

_ServerForm.MethodName¡]Parameters..¡^
¡½ ServerForm¡G¥Nªí¬O A/P Server ¤W¬Y­Ó Server Form¡]¤]¥i¥H»¡¬O Server ¤Wªº DataBase Module¡^¡C
¡½ MethodName¡G¦b¤@­Ó Server Form ¤W¥i¥H«Ø¥ß¦h­Ó PRG¡A³o­Ó³¡¥÷»P¦b Client ¤W¥i¥H«Ø¥ß¦h­Ó PRG ¬O¤@¼Ëªº¡C
¡½ Parameters¡G©I¥s Server Method ©Ò­n¶Ç»¼ªº°Ñ¼Æ¡A¦¹®É Client ·|±N«ü©wªº°Ñ¼Æ¤º®e¶Ç»¼µ¹ Server ºÝ¡A¨Ã¥Ñ Server ¨Ó°õ¦æ¨Ã¶Ç¦^­Èµ¹ Client¡A³o³¡¥÷´N¦n¶H¬O¦P¤@¥x Client ¤W°õ¦æ°Æµ{¦¡¤@¼Ë¡C

¡@¡@¦b 3-Tier ªº¬[ºc¤W¡AClient ºÝªº CDS ¤¸¥ó¬O¤£¯à¥h¤U¹F Insert / Delete / Update «ü¥Oªº¡A¥u¯à³z¹L SUpdateComp ¨Ó¥N²z¡A¦p­n§ó§ïªº¸ê®Æ«Ü¦h¡A©Î®Ú¥»»P Client ªº CDS µLÃö¡A´N¥²¶·¥H Server Method ¨Ó¥N²z°õ¦æ¡A³oºØ Server Method ´N¦n¹³ 2-Tier ¦b DataBase ¤W°õ¦æªº Stored Procedure ¬Û¦ü¡A¦]¬°ºô¸ô¶Ç¿é¤ñ¸û¦³ÀW¼eªº°ÝÃD¡A¦pªG¯àÅý¬Y¨Çµ{¦¡ª½±µ¦b DataBase Server ¤W°õ¦æ¡A·íµM¨ä®Ä²v·|¼W¥[¤£¤Ö¡A©Ò¥H VD3.0 ªº Server Method ¤]¬O¬°¤F¦¹¥Øªº¡A¤]´N¬O»¡¦pªG§â¤@¨Ç¾ã²z¸ê®Æ©Î»Ý­n³t«×ªºµ{¦¡¸m©ó A/P Server ¤W¨Ó°õ¦æªº¸Ü¡A·|Åý Client ºÝ¤£¶·­n¨Ì¿à¤Ó°ªªººô¸ôÀW¼e¡C

¡@¡@¸ÑÄÀ»¡©ú1.¡GDCOM ªº«e¨­´N¬O COM(Common Object Model)¡A¬O Microsoft ¦b Windows ¤W©Ò¶}¥ßªºµ{¦¡®w¤¸¥ó¤Æªº³W®æ¡A¹³¤@­Ó¤j«¬ªº³nÅé¨t²Î¬OµLªk¥Ñ¤@­Ó¤jªº°õ¦æÀɩҲզ¨¡A¥H«e¬O¥H DLL ¨Ó¨ú¥N¦@¥Îªºµ{¦¡®w¡A²{¦b¬O¥H COM ¨Ó°µ¬°¦@¦Pªºµ{¦¡®w¡A¨Ã§âµ{¦¡®w¥Hª«¥ó¾É¦Vªº¤è¦¡¥]¸Ë¦¨¤¸¥ó¡A¥H§Qµ{¦¡ªº¿W¥ß©Ê»P¦A¥Î©Ê¡F¦Ó DCOM¡]Distributed¡^´N¬O¥i¥HÅý³o¨Ç PC ¤W COM ¤¸¥ó¥i¥HÅý¨ä¥L PC ¨Ó¨Ï¥Î¡C²³æªº»¡¡A´N¬OÅý¤£¦P¹q¸£ªºµ{¦¡¥i¥H³Q¬Û¤¬¥s¥Î¡A§A¥i¯àÁÙ°O±o DLL §a¡A´N¬O§A¥i¥H¥h¸ü¤J¤@­Óµ{¦¡®w¡A¨Ã¥h©I¥s¨äµ{¦¡®wªº¤@­Ó¤lµ{¦¡¡A©Ò¥H DLL ´N¬O³æ¥x PC ªºµ{¦¡®w¡A¦Ó DCOM ¤£¦ý¥i¥H¨ú¥N DLL¡A¦Ó¥B¥¦¬Æ¦Ü¥i¥HÅý¤£¦Pªº¹q¸£¶¡¥i¥H¬Û¤¬©I¥s¡A¤]´N¬O»¡ A ªº PC ¥i¥H©I¥s B ªº PC ªº¬Y¤@­Óµ{¦¡¥h°õ¦æ¡C

Á`µ² ....
   
¡@¡@VD30 ¤¤¦b Client ºÝ§êºt 3-Tier ªº­«­n¥ô°È´N¬O CDS ¤¸¥ó(Client Dataset)¡A¦Ó Server ºÝ«h¬O SQuery »PSUpdateComp ¨â­Ó¤¸¥ó³Ì¬°­«­n¡A¦pªG§A¥»¨Ó´N·| VD ¨t¦Cªº²£«~¡A¥u­n±N³o¤T­Ó¤¸¥ó§ËÀ´¡A¨º§A¥ß§Y¥i¦¨¬° 3Tier °ª¤â¤F¡C






¥x¥_¥«¤j¦P°Ï 103 ¥Á¥Í¦è¸ô 290 ¸¹ 8 ¼Ó¡@¹q¸Ü¡G02-2556-6159¡@¶Ç¯u¡G02-2556-9425
ª©Åv©Ò¦³¡@°T¥ú¬ì§Þ¨t²ÎªÑ¥÷¦³­­¤½¥q
(c) Copyright 2000 InfoLight System Corp. Ltd.