{"id":1552,"date":"2014-12-23T09:50:59","date_gmt":"2014-12-23T01:50:59","guid":{"rendered":"http:\/\/blog.qdac.cc\/?p=1552"},"modified":"2014-12-23T13:33:52","modified_gmt":"2014-12-23T05:33:52","slug":"tqdbprovider%e6%8e%a5%e5%8f%a3%e8%ae%be%e8%ae%a1","status":"publish","type":"post","link":"https:\/\/blog.qdac.cc\/?p=1552","title":{"rendered":"QDB.TQDBProvider\u63a5\u53e3\u8bbe\u8ba1"},"content":{"rendered":"<p>\u4e0b\u56fe\u662fQDB\u4e2d\u4e0e\u8d1f\u8d23\u4e0e\u6570\u636e\u5e93\u8fde\u63a5\u7684\u6570\u636e\u63d0\u4f9b\u8005\u5bf9\u8c61\u7684\u63a5\u53e3\u5b9a\u4e49\uff0cUML \u6587\u4ef6\u4e3a StartUML \u7684\u683c\u5f0f\uff0c\u5982\u6709\u9700\u8981\uff0c\u8bf7\u5728 QQ\u7fa4 \u8054\u7cfb\u3002<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/blog.qdac.cc\/wp-content\/uploads\/2014\/12\/TQDBProvider2.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1560\" src=\"https:\/\/blog.qdac.cc\/wp-content\/uploads\/2014\/12\/TQDBProvider2.png\" alt=\"TQDBProvider\" width=\"779\" height=\"990\" srcset=\"https:\/\/blog.qdac.cc\/wp-content\/uploads\/2014\/12\/TQDBProvider2.png 779w, https:\/\/blog.qdac.cc\/wp-content\/uploads\/2014\/12\/TQDBProvider2-236x300.png 236w\" sizes=\"auto, (max-width: 779px) 100vw, 779px\" \/><\/a><\/p>\n<p>\u3010\u7b80\u4ecb\u3011<\/p>\n<p>TQDBProvider\u7528\u4e8e\u5efa\u7acb\u6570\u636e\u96c6\u548c\u6570\u636e\u5e93\u4e4b\u95f4\u7684\u6865\u6881\u53ca\u8f85\u52a9\u529f\u80fd\u3002TQDBProvider\u63d0\u4f9b\u7684\u63a5\u53e3\u7c7b\u522b\u4e3b\u8981\u6709\uff1a<\/p>\n<p>1\u3001\u5c5e\u6027<\/p>\n<p>ProviderName &#8211; \u63d0\u4f9b\u8005\u540d\u79f0\uff0c\u5728\u6574\u4e2a\u7cfb\u7edf\u4e2d\u5fc5\u9700\u552f\u4e00\u6807\u8bb0\uff0c\u53ea\u8bfb\u3002<\/p>\n<p>ConnectionString &#8211; \u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u7b49\u4ef7\u4e8e\u5206\u522b\u8bbe\u7f6e\u5404\u4e2a\u5c5e\u6027\u7684\u7ed3\u679c\u3002<\/p>\n<p>Connected &#8211; \u662f\u5426\u5df2\u8fde\u63a5\u5c5e\u6027\uff0c\u8bbe\u7f6e\u5b83\u5c06\u6253\u5f00\u8fde\u63a5\u5bf9\u8c61<\/p>\n<p>Database &#8211; \u8fde\u63a5\u7684\u6570\u636e\u5e93\u540d<\/p>\n<p>ServerHost &#8211; \u670d\u52a1\u5668\u5730\u5740<\/p>\n<p>ServerPort &#8211; \u670d\u52a1\u5668IP<\/p>\n<p>UserName &#8211; \u7528\u6237\u540d<\/p>\n<p>Password &#8211; \u5bc6\u7801<\/p>\n<p>LastErrorCode &#8211; \u672b\u6b21\u9519\u8bef\u4ee3\u7801<\/p>\n<p>LastErrorMsg &#8211; \u672b\u6b21\u9519\u8bef\u6d88\u606f\u5185\u5bb9<\/p>\n<p>TransactionLevel &#8211; \u4e8b\u52a1\u5d4c\u5957\u7ea7\u522b\uff08\u5982\u679c\u652f\u6301\uff09<\/p>\n<p>Handle &#8211; \u5185\u90e8\u5b9e\u9645\u4f7f\u7528\u7684\u8fde\u63a5\u53e5\u67c4\uff0c\u5176\u542b\u4e49\u7531\u66f4\u4e0b\u5c42\u7684\u5b9e\u73b0\u89e3\u91ca<\/p>\n<p>ConnectParams &#8211; \u8fde\u63a5\u53c2\u6570\uff0c\u6700\u7ec8\u901a\u8fc7\u5b83\u6784\u5efa\u6210ConnectionString\uff0c\u800cConnectionString\u7684\u4fee\u6539\u4e5f\u4f1a\u53cd\u9988\u7ed9\u5b83<\/p>\n<p>CommandTimeout &#8211; \u6267\u884c\u811a\u672c\u7684\u8d85\u65f6\u65f6\u95f4\u8bbe\u7f6e<\/p>\n<p>ConnectTimeout &#8211; \u8fde\u63a5\u5230\u6570\u636e\u5e93\u7684\u8d85\u65f6\u65f6\u95f4\u8bbe\u7f6e<\/p>\n<p>KeepAlive &#8211; \u662f\u5426\u4fdd\u6301\u6570\u636e\u5e93\u8fde\u63a5<\/p>\n<p>PeekInterval &#8211; \u7528\u4e8e\u4fdd\u6301\u6570\u636e\u5e93\u8fde\u63a5\u6d3b\u52a8\u7684\u4fdd\u6301\u547d\u4ee4\u53d1\u9001\u95f4\u9694<\/p>\n<p>AutoReconnect &#8211; \u5f53\u8fde\u63a5\u4e22\u5931\u65f6\uff0c\u5982\u679c\u6709\u65b0\u7684\u811a\u672c\u9700\u8981\u6267\u884c\u65f6\uff0c\u662f\u5426\u81ea\u52a8\u91cd\u65b0\u8fde\u63a5<\/p>\n<p>IsolationLevel &#8211; \u4e8b\u52a1\u9694\u79bb\u7ea7\u522b<\/p>\n<p>2\u3001\u4e8b\u4ef6<\/p>\n<p>2.1\u3001\u8fde\u63a5\u4e8b\u4ef6<\/p>\n<p>BeforeConnect \u00a0&#8211; \u8fde\u63a5\u524d\u89e6\u53d1\uff0c\u7ed9\u4e88\u6700\u540e\u4e00\u6b21\u4fee\u6539\u8fde\u63a5\u53c2\u6570\u7684\u673a\u4f1a<\/p>\n<p>AfterConnected \u00a0&#8211; \u8fde\u63a5\u6210\u529f\u540e\u89e6\u53d1<\/p>\n<p>BeforeDisconnect \u00a0&#8211; \u4e3b\u52a8\u65ad\u5f00\u8fde\u63a5\u524d\u89e6\u53d1\uff0c\u5982\u679c\u662f\u88ab\u52a8\u65ad\u5f00\u8fde\u63a5\u5219\u4e0d\u4f1a\u89e6\u53d1<\/p>\n<p>AfterDisconnected &#8211; \u65ad\u5f00\u8fde\u63a5\u540e\u89e6\u53d1\uff0c\u5982\u679c\u662f\u7531\u4e8e\u7f51\u7edc\u539f\u56e0\u65ad\u5f00\u8fde\u63a5\uff0c\u53ef\u80fd\u4e0d\u4f1a\u53ca\u65f6\u89e6\u53d1<\/p>\n<p>BeforeExecute \u00a0&#8211; \u5728\u6267\u884c\u811a\u672c\u524d\u89e6\u53d1<\/p>\n<p>AfterExecute &#8211; \u5728\u6267\u884c\u811a\u672c\u5b8c\u6210\u540e\u89e6\u53d1\uff0c\u4e0d\u8bba\u662f\u5426\u6267\u884c\u6210\u529f\uff0c\u53ef\u4ee5\u7ed3\u5408QLog\u7b49\u65e5\u5fd7\u8bb0\u5f55\u5de5\u5177\u6765\u8bb0\u5f55\u65e5\u5fd7<\/p>\n<p>OnExecuteError \u00a0&#8211; \u5728\u6267\u884c\u811a\u672c\u5931\u8d25\u65f6\u89e6\u53d1<\/p>\n<p>OnExecuted &#8211; \u5728\u6267\u884c\u811a\u672c\u6210\u529f\u65f6\u89e6\u53d1<\/p>\n<p>2\u3001\u51fd\u6570<\/p>\n<p>\u6784\u9020\u548c\u6790\u6784\u51fd\u6570\u7565\u3002<\/p>\n<p>Open &#8211; \u6253\u5f00\u8fde\u63a5\uff0c\u5982\u679c\u6210\u529f\uff0c\u8fd4\u56deTrue\uff0c\u5931\u8d25\u8fd4\u56deFalse<\/p>\n<p>Close &#8211; \u5173\u95ed\u5f53\u524d\u5df2\u6253\u5f00\u7684\u8fde\u63a5<\/p>\n<p>OpenDataStream &#8211; \u6267\u884c\u6307\u5b9a\u7684\u811a\u672c\u5e76\u4fdd\u5b58\u8fd4\u56de\u7ed3\u679c\u5230\u4e00\u4e2a\u6570\u636e\u6d41\uff0c\u6570\u636e\u6d41\u7684\u683c\u5f0f\u7531AFormat\u53c2\u6570\u6307\u5b9a\u3002\u5982\u679c\u811a\u672c\u8fd4\u56de\u591a\u4e2a\u7ed3\u679c\u96c6\uff0c\u5219\u8fd4\u56de\u4e00\u4e2a\u5305\u542b\u8fd9\u591a\u4e2a\u7ed3\u679c\u96c6\u7684\u590d\u5408\u6570\u636e\u6d41\u3002\u5206\u540c\u6b65\u548c\u5f02\u6b65\u4e24\u79cd\u6a21\u5f0f\uff0c\u5f02\u6b65\u6a21\u5f0f\u8fd4\u56de\u7684\u53e5\u67c4\u53ef\u4ee5\u8c03\u7528Cancel\u51fd\u6570\u53d6\u6d88\u811a\u672c\u7684\u540e\u53f0\u6267\u884c\u3002<\/p>\n<p>OpenDataSet &#8211; \u6267\u884c\u6307\u5b9a\u7684\u811a\u672c\u5e76\u5c06\u7ed3\u679c\u8fd4\u56de\u5230\u4e00\u4e2a\u6570\u636e\u96c6\uff0c\u5982\u679c\u6307\u5b9a\u7684\u811a\u672c\u8fd4\u56de\u4e86\u591a\u4e2a\u6570\u636e\u96c6\uff0c\u5219\u8fd4\u56de\u4e00\u4e2a\u5d4c\u5957\u6570\u636e\u96c6\u3002\u5206\u5f02\u6b65\u548c\u540c\u6b65\u4e24\u79cd\u6a21\u5f0f\uff0c\u5f02\u6b65\u6a21\u5f0f\u8fd4\u56de\u7684\u53e5\u67c4\u53ef\u4ee5\u8c03\u7528Cancel\u51fd\u6570\u53d6\u6d88\u811a\u672c\u7684\u540e\u53f0\u6267\u884c\u3002<\/p>\n<p>ExecuteCmd &#8211; \u6267\u884c\u6307\u5b9a\u7684\u811a\u672c\u5e76\u8fd4\u56de\u6700\u540e\u4e00\u53e5\u811a\u672c\u5f71\u54cd\u7684\u603b\u884c\u6570\uff0c\u5982\u679c\u5931\u8d25\uff0c\u5219\u8fd4\u56de-1\u3002\u5206\u5f02\u6b65\u548c\u540c\u6b65\u4e24\u79cd\u6a21\u5f0f\uff0c\u5f02\u6b65\u6a21\u5f0f\u8fd4\u56de\u7684\u53e5\u67c4\u53ef\u4ee5\u8c03\u7528Cancel\u51fd\u6570\u53d6\u6d88\u811a\u672c\u7684\u540e\u53f0\u6267\u884c\u3002<\/p>\n<p>Cancel &#8211; \u53d6\u6d88\u5f02\u6b65\u811a\u672c\u7684\u6267\u884c<\/p>\n<p>BeginTrans\/CommitTrans\/RollbackTrans &#8211; \u5f00\u542f\u3001\u63d0\u4ea4\u3001\u56de\u6eda\u4e8b\u52a1<\/p>\n<p>HasTable\/HasView\/HasProcedure\/HasFunction\/HasTrigger\/HasField &#8211; \u5224\u65ad\u6307\u5b9a\u7684\u8868\u3001\u89c6\u56fe\u3001\u5b58\u8d2e\u8fc7\u7a0b\u3001\u51fd\u6570\u3001\u89e6\u53d1\u5668\u3001\u5b57\u6bb5\u662f\u5426\u5b58\u5728<\/p>\n<p>HasRecords &#8211; \u5224\u65ad\u6307\u5b9a\u7684\u811a\u672c\u662f\u5426\u4f1a\u8fd4\u56de\u8bb0\u5f55\uff0c\u5b83\u4f1a\u5c1d\u8bd5\u5f00\u4e8b\u52a1\u6267\u884c\u76f8\u5e94\u7684\u811a\u672c\uff0c\u7136\u540e\u56de\u6eda\u4e8b\u52a1\u6765\u6d4b\u8bd5\u662f\u5426\u6709\u8bb0\u5f55\u8fd4\u56de<\/p>\n<p>ApplyChanges \u00a0&#8211; \u4ece\u6d41\u6216\u6570\u636e\u96c6\u4e2d\u5c06\u53d8\u66f4\u63d0\u4ea4\u5230\u6570\u636e\u5e93<\/p>\n<p>AcquireDataSet\/ReleaseDataSet &#8211; \u4ece\u6c60\u4e2d\u8bf7\u6c42\u4e00\u4e2a\u6570\u636e\u96c6\u5bf9\u8c61\u53ca\u5c06\u5bf9\u8c61\u8fd4\u56de\u5230\u6c60\u4e2d<\/p>\n<p>EnumTables\/EnumViews\/EnumProcedures\/EnumFunctions\/EnumTriggers\/EnumFields &#8211; \u679a\u4e3e\u6570\u636e\u5e93\u4e2d\u7684\u8868\u3001\u89c6\u56fe\u3001\u5b58\u8d2e\u8fc7\u7a0b\u3001\u51fd\u6570\u3001\u89e6\u53d1\u5668\u3001\u5b57\u6bb5<\/p>\n<p>\u3010\u7b54\u95ee\u3011<\/p>\n<p>1\u3001TQDBProvider\u662f\u5426\u652f\u6301\u670d\u52a1\u5668\u7aef\u6e38\u6807\uff1f<\/p>\n<p>\u4e0d\u652f\u6301\u3002<\/p>\n<p>2\u3001TQDBProvider\u662f\u5426\u652f\u6301\u4e00\u4e2a\u67e5\u8be2\u8fd4\u56de\u591a\u4e2a\u7ed3\u679c\u96c6\uff1f<\/p>\n<p>\u652f\u6301\uff0cOpenDataSet\/OpenDataStream\u90fd\u652f\u6301\u4e00\u6b21\u8fd4\u56de\u591a\u4e2a\uff0c\u5982\u679c\u662fOpenDataSet\uff0c\u5219\u8fd4\u56de\u6210\u4e00\u4e2a\u5d4c\u5957\u6570\u636e\u96c6\uff0c\u5982\u679c\u662fOpenDataStream\u5219\u4f9d\u6b21\u5199\u5165\u5230\u76ee\u6807\u6d41\u3002<\/p>\n<p>3\u3001TQDBProvider\u76f8\u5f53\u4e8e\u73b0\u5728\u7684\u5c42\u6b21\u7684\u4e1c\u897f\uff1f<\/p>\n<p>\u5982\u679c\u975e\u8981\u5bf9\u6bd4\uff0c\u90a3\u4e48\u6211\u4eec\u53ef\u4ee5\u5c06TQDBProvider\u76f8\u8c61\u6210TADOConnection+TADOCommand+TDataProvider\u7684\u4e00\u4e2a\u5408\u4f53\uff0c\u800cTQDataSet\u53ef\u4ee5\u5f53\u6210TADODataSet+TADOQuery\u5427\u3002<\/p>\n<p>4\u3001TQDBProvider \u652f\u6301\u4e09\u5c42\u6a21\u5f0f\u5417\uff1f<\/p>\n<p>\u5f53\u7136\uff0c\u60a8\u770b\u5b83\u7684OpenDataStream\u3001ApplyChanges\u63a5\u53e3\u7684\u8bbe\u8ba1\u5b8c\u5168\u8003\u8651\u4e86\u7f51\u7edc\u4f20\u9001\u6570\u636e\u6d41\u7684\u95ee\u9898\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e0b\u56fe\u662fQDB\u4e2d\u4e0e\u8d1f\u8d23\u4e0e\u6570\u636e\u5e93\u8fde\u63a5\u7684\u6570\u636e\u63d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[69,8,9,66],"tags":[258,245],"class_list":["post-1552","post","type-post","status-publish","format-standard","hentry","category-c-builder","category-delphi","category-qdac","category-qdb","tag-258","tag-245"],"views":3218,"_links":{"self":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/1552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1552"}],"version-history":[{"count":6,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/1552\/revisions"}],"predecessor-version":[{"id":1561,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/1552\/revisions\/1561"}],"wp:attachment":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}