{"id":4857,"date":"2018-03-30T10:04:55","date_gmt":"2018-03-30T02:04:55","guid":{"rendered":"http:\/\/blog.qdac.cc\/?p=4857"},"modified":"2018-03-30T10:05:50","modified_gmt":"2018-03-30T02:05:50","slug":"qdbtqhttpprovider-%e9%80%9a%e8%ae%af%e5%8d%8f%e8%ae%ae%e8%af%b4%e6%98%8e","status":"publish","type":"post","link":"https:\/\/blog.qdac.cc\/?p=4857","title":{"rendered":"[QDB]TQHttpProvider \u901a\u8baf\u534f\u8bae\u8bf4\u660e"},"content":{"rendered":"<p>TQHttpProvider \u670d\u52a1\u5668\u7aef\u4f7f\u7528\u4efb\u4f55\u8bed\u8a00\u7f16\u5199\u90fd\u53ef\u4ee5\uff0c\u4f46\u9700\u8981\u5176\u652f\u6301 HTTP\/HTTPS \u534f\u8bae\u3002<\/p>\n<p>\u8981\u4f7f\u7528 TQHttpProvider\uff0c\u60a8\u9700\u8981\u8bbe\u7f6e TQHttpProvider \u7684\u4ee5\u4e0b\u5c5e\u6027\uff1a<\/p>\n<ol>\n<li>ServiceUrl\uff1a\u8be5 URL \u4f1a\u88ab\u7528\u505a\u5bf9\u670d\u52a1\u5668\u7aef\u8bf7\u6c42\u7684\u57fa\u51c6\u5730\u5740\u6765\u4f7f\u7528\uff0c\u4e0b\u9762\u662f\u5bf9\u5e94\u7684\u5b50URL\uff1a<br \/>\n\uff081\uff09\u3001Open\uff1a\u8be5\u547d\u4ee4\u7528\u4e8e\u6253\u5f00\u4e00\u4e2a\u6570\u636e\u5e93\u8fde\u63a5<br \/>\n\uff082\uff09\u3001Close\uff1a\u5173\u95ed\u5f53\u524d\u6253\u5f00\u7684\u6570\u636e\u5e93\u8fde\u63a5<br \/>\n\uff083\uff09\u3001OpenDataSet\uff1a\u6253\u5f00\u4e00\u4e2a\u6570\u636e\u96c6\u5bf9\u8c61<br \/>\n\uff084\uff09\u3001ExecSQL\uff1a\u6267\u884c\u4e00\u4e2a\u4e0d\u8fd4\u56de\u7ed3\u679c\u96c6\u7684 SQL \u811a\u672c<br \/>\n\uff085\uff09\u3001RefreshToken\uff1a\u7528\u4e8e\u5237\u65b0\u5f53\u524d\u4ee4\u724c\uff0c\u907f\u514d\u4ee4\u724c\u8fc7\u671f<\/li>\n<li>AppId\uff1a\u5ba2\u6237\u7aef\u5e94\u7528\u7684\u552f\u4e00\u7f16\u7801\uff0c\u7528\u6765\u552f\u4e00\u6807\u8bb0\u4e00\u4e2a\u5e94\u7528\u3002\u670d\u52a1\u5668\u7aef\u5e94\u6839\u636e\u8fd9\u4e2a appid\uff0c\u53bb\u67e5\u627e\u5bf9\u5e94\u7684 \u00a0MD5 \u00a0\u7b7e\u540d\u65f6\u4f7f\u7528\u7684\u76d0\u503c\uff0c\u4ee5\u4fbf\u9a8c\u8bc1\u53c2\u6570\u662f\u5426\u662f\u6709\u6548\u7684\u53c2\u6570\uff0c\u4ee5\u907f\u514d\u88ab\u5916\u90e8\u8c03\u7528\u3002<\/li>\n<li>AppSalt\uff1aAppId \u5bf9\u5e94\u7684\u7528\u4e8e\u8ba1\u7b97 MD5 \u54c8\u5e0c\u503c\u7684\u76d0\u503c\uff0c\u7528\u4e8e\u6df7\u6dc6\u7b7e\u540d\u5185\u5bb9\u3002<\/li>\n<\/ol>\n<p>\u4f7f\u7528\u4ee5\u4e0a\u4ee3\u7801\u4ee5\u540e\uff0c\u60a8\u5c31\u53ef\u4ee5\u6309\u7167 QDB \u7684\u6b63\u5e38\u89c4\u5219\u4f7f\u7528 TQHttpProvider \u8bbf\u95ee\u670d\u52a1\u5668\u7aef\u7684\u6570\u636e\u5e93\u4e86\u3002\u90a3\u4e48\uff0c\u63a5\u4e0b\u6765\u7684\u95ee\u9898\u5c31\u662f\u5ba2\u6237\u7aef\u4e0e\u670d\u52a1\u5668\u7aef\u901a\u8baf\u7684\u534f\u8bae\u5177\u4f53\u7ea6\u5b9a\u4e86\uff1a<\/p>\n<p>1\u3001\u5efa\u7acb\u8fde\u63a5<\/p>\n<p>\u547d\u4ee4\u4ee3\u7801\uff1a\/Open<\/p>\n<p>\u547d\u4ee4\u53c2\u6570\uff1a<\/p>\n<ul>\n<li>appid \uff1a\u5bf9\u5e94\u4e8e TQHttpProvider.AppId \u5c5e\u6027<\/li>\n<li>timestamp\uff1a\u5f53\u524d\u8ba1\u7b97\u673a\u7684\u65f6\u95f4\u6233\uff0c\u540e\u7eed\u670d\u52a1\u5668\u7aef\u53ef\u4ee5\u6839\u636e\u8be5\u503c\u4e0e\u670d\u52a1\u5668\u65f6\u95f4\u7684\u5dee\u503c\uff0c\u6765\u786e\u5b9a\u662f\u5426\u6765\u81ea\u5e94\u7528\u7684\u8bbf\u95ee\uff0c\u4ece\u800c\u907f\u514d\u5916\u90e8\u653b\u51fb<\/li>\n<li>database\uff1a\u8981\u8fde\u63a5\u7684\u6570\u636e\u5e93\u7684\u8fde\u63a5\u5b57\u7b26\u4e32\uff0c\u4e00\u822c\u6765\u8bf4\uff0c\u4e3a\u4e86\u907f\u514d\u4f20\u9012\u654f\u611f\u4fe1\u606f\uff0c\u5e94\u5728\u670d\u52a1\u5668\u7aef\u5b9a\u4e49\u522b\u540d\uff0c\u8fd9\u91cc\u76f4\u63a5\u4f20\u8fde\u63a5\u7684\u522b\u540d\uff0c\u7531\u670d\u52a1\u5668\u7aef\u8fdb\u884c\u89e3\u6790\uff0c\u83b7\u53d6\u5b9e\u9645\u7684\u8fde\u63a5\u53c2\u6570\u3002<\/li>\n<li>sign\uff1a\u53c2\u6570\u7b7e\u540d\uff0c\u5176\u5177\u4f53\u7b97\u6cd5\u662f\u6309\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u7684\u53c2\u6570\u540d\u79f0\u6392\u5e8f\uff0c\u4e5f\u5c31\u662f\u8bf4 AppId \u548c appid \u8ba1\u7b97\u6392\u5e8f\u5217\u7684\u4f4d\u7f6e\u5e94\u8be5\u662f\u4e00\u6837\u7684\uff0c\u7136\u540e\u5c06\u5404\u4e2a\u53c2\u6570\u62fc\u63a5\u6210\u672a\u8fdb\u884c URL \u7f16\u7801\u7684\u5b57\u7b26\u4e32\uff0c\u53c2\u6570\u540d\u4e0e\u503c\u4e4b\u524d\u4f7f\u7528\u7b49\u53f7\u8fde\u63a5\uff0c\u53c2\u6570\u4e0e\u53c2\u6570\u4e4b\u95f4\u4f7f\u7528 \u201c&amp;\u201d \u8fde\u63a5\u3002\u62fc\u63a5\u540e\u7684\u53c2\u6570\u5b57\u7b26\u4e32 + TQHttpProvider.AppSalt \u7684\u503c\u8ba1\u7b97 MD5 \u54c8\u5e0c\u503c\u5e76\u4ee5\u5c0f\u5199\u65b9\u5f0f\u8d4b\u503c\u7ed9 sign\u3002<\/li>\n<\/ul>\n<p>\u8fd4\u56de\u503c\uff1a<\/p>\n<p style=\"padding-left: 30px;\">\u670d\u52a1\u5668\u7aef\u5e94\u8fd4\u56de\u4e00\u4e2a\u7b26\u5408\u4e0b\u9762\u683c\u5f0f\u8981\u6c42\u7684 JSON \u5bf9\u8c61\uff1a<\/p>\n<pre class=\"lang:js decode:true\">{\r\n\"code\":0,\/\/\u6574\u6570\u9519\u8bef\u4ee3\u7801\uff0c0 \u4ee3\u8868\u6210\u529f\uff0c\u5176\u5b83\u503c\u610f\u5473\u7740\u5931\u8d25\uff0c\u5177\u4f53\u542b\u4e49\u5b9a\u4e49\u7531\u670d\u52a1\u5668\u7aef\u5b9e\u73b0\u786e\u5b9a\r\n\"hint\":\"\",\/\/\u9519\u8bef\u63d0\u793a\u6d88\u606f\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u64cd\u4f5c\u6210\u529f\uff0c\u8be5\u9879\u88ab\u5ffd\u7565\uff0c\u4e5f\u5c31\u662f\u53ef\u4ee5\u4e0d\u8fd4\u56de\uff0c\u4e00\u822c\u7528\u4e8e\u63d0\u793a\u7528\u6237\r\n\"help\":\"\",\/\/\u63d0\u4f9b\u7ed9\u5f00\u53d1\u8005\u7684\u51fa\u9519\u5e2e\u52a9\u4fe1\u606f\uff0c\u53ef\u80fd\u4f1a\u5305\u542b\u654f\u611f\u4fe1\u606f\uff0c\u4e0d\u9002\u5b9c\u63d0\u4f9b\u7ed9\u7528\u6237\u5448\u73b0\r\n\"result\":{\r\n  \"access_token\":\"\",\/\/\u4f1a\u8bdd\u4ee4\u724c\uff0c\u540e\u7eed\u64cd\u4f5c\u90fd\u9700\u8981\u63d0\u4f9b\u8be5\u4ee4\u724c\u4ee5\u786e\u5b9a\u60a8\u7684\u4fe1\u606f\r\n  \"access_expire\":7200,\/\/\u4f1a\u8bdd\u6709\u6548\u671f\uff0c\u8d85\u8fc7\u6709\u6548\u671f\uff0c\u4f1a\u8bdd\u9700\u8981\u5237\u65b0\u4ee4\u724c\u6216\u8005\u91cd\u65b0\u6253\u5f00\u8fde\u63a5\r\n  \"refresh_token\":\"\",\/\/\u5237\u65b0\u4ee4\u724c\uff0c\u8be5\u4ee4\u724c\u7528\u4e8e\u7ed9\u5f53\u524d\u4f1a\u8bdd\u201c\u7eed\u547d\u201d\uff0c\u8c03\u7528 \/RefreshToken \u65f6\u9700\u8981\u4f20\u9012\u8be5\u53c2\u6570\r\n  \"refresh_expire\":2592000\/\/\u5237\u65b0\u4ee4\u724c\u6709\u6548\u671f\uff0c\u5e94\u5927\u4e8e\u4f1a\u8bdd\u7684\u6709\u6548\u671f\r\n  }\r\n}<\/pre>\n<p style=\"padding-left: 30px;\">\u60a8\u4e5f\u53ef\u4ee5\u901a\u8fc7\u670d\u52a1\u5668\u5728 result \u91cc\u8fd4\u56de\u989d\u5916\u7684\u53c2\u6570\u7ed9\u5ba2\u6237\u7aef\uff0c\u6574\u4e2a result \u7684\u5185\u5bb9\u4f1a\u88ab\u8bb0\u5f55\u5230 ServerExtParams \u5c5e\u6027\u4e2d\u3002<\/p>\n<p>\u793a\u4f8b URL\uff1a<\/p>\n<p style=\"padding-left: 30px;\">https:\/\/blog.qdac.cc\/qdb\/qdb_httppov.php\/Open?timestamp=1522357751&#038;sign=b67d447f3cc86b8c1e69368ddb355671&#038;appid=Demos.HttpProvider&#038;database=PgSQLDemo<\/p>\n<p>\u989d\u5916\u5efa\u8bae\uff1a<\/p>\n<p style=\"padding-left: 30px;\">\u5bf9\u4e8e\u6709\u7279\u6b8a\u9700\u8981\u7684\u5ba2\u6237\uff0c\u7aef\u53c2\u6570\u7b7e\u540d\u7b97\u6cd5\u53ef\u4ee5\u81ea\u5b9a\u4e49\uff0c\u53ef\u4ee5\u4fee\u6539 TQHttpProvider.Rest \u51fd\u6570\u6765\u5b8c\u6210\u8fd9\u4e00\u5de5\u4f5c\u3002<\/p>\n<p>2\u3001\u5173\u95ed\u8fde\u63a5<\/p>\n<p>\u547d\u4ee4\u4ee3\u7801\uff1a\/Close<\/p>\n<p>\u547d\u4ee4\u53c2\u6570\uff1a<\/p>\n<ul>\n<li>token\uff1a\u5efa\u7acb\u8fde\u63a5\u65f6\u5f97\u5230\u7684\u4f1a\u8bdd\u4ee4\u724c\uff08 access_token \uff09<\/li>\n<li>timestamp\uff1a\u5f53\u524d\u8ba1\u7b97\u673a\u7684\u65f6\u95f4\u6233<\/li>\n<li>sign\uff1a\u53c2\u6570\u7b7e\u540d\uff0c\u53c2\u8003 \/Open \u547d\u4ee4<\/li>\n<\/ul>\n<p>\u8fd4\u56de\u503c\uff1a<\/p>\n<p style=\"padding-left: 30px;\">\u670d\u52a1\u5668\u7aef\u5e94\u8fd4\u56de\u4e00\u4e2a\u7b26\u5408\u4e0b\u9762\u683c\u5f0f\u8981\u6c42\u7684 JSON \u5bf9\u8c61\uff1a<\/p>\n<pre class=\"lang:js decode:true\">{\r\n\"code\":0,\/\/\u6574\u6570\u9519\u8bef\u4ee3\u7801\uff0c0 \u4ee3\u8868\u6210\u529f\uff0c\u5176\u5b83\u503c\u610f\u5473\u7740\u5931\u8d25\uff0c\u5177\u4f53\u542b\u4e49\u5b9a\u4e49\u7531\u670d\u52a1\u5668\u7aef\u5b9e\u73b0\u786e\u5b9a\r\n\"hint\":\"\",\/\/\u9519\u8bef\u63d0\u793a\u6d88\u606f\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u64cd\u4f5c\u6210\u529f\uff0c\u8be5\u9879\u88ab\u5ffd\u7565\uff0c\u4e5f\u5c31\u662f\u53ef\u4ee5\u4e0d\u8fd4\u56de\uff0c\u4e00\u822c\u7528\u4e8e\u63d0\u793a\u7528\u6237\r\n\"help\":\"\"\/\/\u63d0\u4f9b\u7ed9\u5f00\u53d1\u8005\u7684\u51fa\u9519\u5e2e\u52a9\u4fe1\u606f\uff0c\u53ef\u80fd\u4f1a\u5305\u542b\u654f\u611f\u4fe1\u606f\uff0c\u4e0d\u9002\u5b9c\u63d0\u4f9b\u7ed9\u7528\u6237\u5448\u73b0\r\n}<\/pre>\n<p>\u5907\u6ce8\uff1a<\/p>\n<p style=\"padding-left: 30px;\">\u65e0\u8bba\u670d\u52a1\u5668\u8fd4\u56de\u9519\u8bef\u4ee3\u7801\u662f\u4f55\u503c\uff0c\u90fd\u4e0d\u4f1a\u5f71\u54cd\u8fde\u63a5\u5173\u95ed\u3002<\/p>\n<p>\u793a\u4f8b URL\uff1a<\/p>\n<p style=\"padding-left: 30px;\">https:\/\/blog.qdac.cc\/qdb\/qdb_httppov.php\/Close?token=se3hKEXp0vsqsZgNcSXUqRzcvb6IGBuj&#038;sign=8e9ea60b0cfac8c1b5032fecc71afa98&#038;timestamp=1522357651<\/p>\n<p>3\u3001\u6253\u5f00\u6570\u636e\u96c6<\/p>\n<p>\u547d\u4ee4\u4ee3\u7801\uff1a\/OpenDataSet<\/p>\n<p>\u547d\u4ee4\u53c2\u6570\uff1a<\/p>\n<ul>\n<li>token\uff1a\u5efa\u7acb\u8fde\u63a5\u65f6\u5f97\u5230\u7684\u4f1a\u8bdd\u4ee4\u724c\uff08 access_token \uff09<\/li>\n<li>timestamp\uff1a\u5f53\u524d\u8ba1\u7b97\u673a\u7684\u65f6\u95f4\u6233<\/li>\n<li>sign\uff1a\u53c2\u6570\u7b7e\u540d\uff0c\u53c2\u8003 \/Open \u547d\u4ee4<\/li>\n<li>sql\uff1a\u8981\u67e5\u8be2\u7684 SQL \u811a\u672c\u3002\u5982\u679c\u4f7f\u7528 POST \u65b9\u5f0f\u6295\u9012\uff0c\u90a3\u4e48\u5b83\u5c06\u505a\u4e3a\u4e00\u4e2a Json \u5bf9\u8c61\u7684\u5b50\u7ed3\u70b9\u5b58\u5728\uff0c\u5426\u5219\u5f53\u505a\u666e\u901a\u53c2\u6570\u53c2\u4e0e\u7b7e\u540d\u8ba1\u7b97\u3002<\/li>\n<li>transaction\uff1a\u662f\u5426\u9700\u8981\u5f00\u542f\u4e8b\u52a1\uff0c\u5e03\u5c14\u503c\u3002\u5982\u679c\u4f7f\u7528 POST \u65b9\u5f0f\u6295\u9012\uff0c\u90a3\u4e48\u5b83\u5c06\u505a\u4e3a\u4e00\u4e2a Json \u5bf9\u8c61\u7684\u5b50\u7ed3\u70b9\u5b58\u5728\uff0c\u5426\u5219\u5f53\u505a\u666e\u901a\u53c2\u6570\u53c2\u4e0e\u7b7e\u540d\u8ba1\u7b97\u3002<\/li>\n<li>params\uff1aSQL \u53c2\u6570\u4e0e\u503c\u5bf9\u5217\u8868\uff0c\u4ec5 POST \u00a0\u65b9\u5f0f\u4e0b\u9700\u8981\u3002GET \u65b9\u5f0f\u4e0b\uff0c\u53c2\u6570\u88ab\u76f4\u63a5\u901a\u8fc7 URL \u4f20\u9012\u3002<\/li>\n<\/ul>\n<p>\u8fd4\u56de\u503c\uff1a<\/p>\n<pre class=\"lang:delphi decode:true\">{\r\n\"code\":0,\/\/\u6574\u6570\u9519\u8bef\u4ee3\u7801\uff0c0 \u4ee3\u8868\u6210\u529f\uff0c\u5176\u5b83\u503c\u610f\u5473\u7740\u5931\u8d25\uff0c\u5177\u4f53\u542b\u4e49\u5b9a\u4e49\u7531\u670d\u52a1\u5668\u7aef\u5b9e\u73b0\u786e\u5b9a\r\n\"hint\":\"\",\/\/\u9519\u8bef\u63d0\u793a\u6d88\u606f\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u64cd\u4f5c\u6210\u529f\uff0c\u8be5\u9879\u88ab\u5ffd\u7565\uff0c\u4e5f\u5c31\u662f\u53ef\u4ee5\u4e0d\u8fd4\u56de\uff0c\u4e00\u822c\u7528\u4e8e\u63d0\u793a\u7528\u6237\r\n\"help\":\"\",\/\/\u63d0\u4f9b\u7ed9\u5f00\u53d1\u8005\u7684\u51fa\u9519\u5e2e\u52a9\u4fe1\u606f\uff0c\u53ef\u80fd\u4f1a\u5305\u542b\u654f\u611f\u4fe1\u606f\uff0c\u4e0d\u9002\u5b9c\u63d0\u4f9b\u7ed9\u7528\u6237\u5448\u73b0\r\n\"result\":{\r\n  \"Fields\":[\/\/\u5b57\u6bb5\u5b9a\u4e49\u5217\u8868\r\n     {\r\n     \"name\":\"\",\/\/\u5b57\u6bb5\u540d\r\n     \"table\":\"\",\/\/\u5b57\u6bb5\u6240\u5c5e\u8868\u540d\uff0c\u975e\u5fc5\u9700\r\n     \"schema\":\"\",\/\/\u8868\u6240\u6709\u8005\uff0c\u975e\u5fc5\u9700\r\n     \"category\":\"\",\/\/\u6570\u636e\u5e93\uff0c\u975e\u5fc5\u9700\r\n     \"base_name\":\"\",\/\/\u6570\u636e\u5e93\u539f\u59cb\u5b57\u6bb5\u540d\uff0c\u975e\u5fc5\u9700\r\n     \"delphi_type\":\"\",\/\/\u5bf9\u5e94\u7684 Delphi \u5b57\u6bb5\u7c7b\u578b\uff0c\u503c\u53c2\u8003 FieldTypeNames \u5b9a\u4e49\uff0c\u5fc5\u9700\r\n     \"len\":0,\/\/\u5bf9\u5e94\u7684\u5217\u957f\u5ea6\uff0c\u975e\u5fc5\u9700\r\n     \"precision\":0,\/\/\u7cbe\u5ea6\uff0c\u975e\u5fc5\u9700\r\n     \"scale\":0,\/\/\u5c0f\u6570\u70b9\u540e\u4f4d\u6570\uff0c\u975e\u5fc5\u9700\r\n     \"flags\":[not_null,primary_key,multiple_key,unique_key,blob]\/\/\u975e\u5fc5\u9700\r\n     }...\r\n     ]\r\n  \"Records\":[\/\/\u8bb0\u5f55\u5217\u8868\r\n     []\/\/\u503c\u5217\u8868\u6570\u7ec4\r\n     ,...\r\n     ]\r\n  }\r\n}<\/pre>\n<p>\u5907\u6ce8\uff1a<\/p>\n<p style=\"padding-left: 30px;\">1\u3001\u4f7f\u7528 POST \u4f20\u9012 SQL \u547d\u4ee4\u65f6\uff0cJSON \u53c2\u6570\u683c\u5f0f\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n<pre class=\"lang:delphi decode:true\">{\r\n\"sql\":\"select * from information_schema.columns where table_name=:tablename\",\r\n\"transaction\":false,\r\n\"params\":{\r\n   \"tablename\":\"pg_indexes\"\r\n   }\r\n}<\/pre>\n<p style=\"padding-left: 30px;\">2\u3001\u51fa\u4e8e\u5b89\u5168\u8003\u8651\uff0c\u4e00\u822c\u4e0d\u63a8\u8350\u5728\u5ba2\u6237\u7aef\u76f4\u63a5\u4f20\u9012 SQL \u811a\u672c\u5230\u670d\u52a1\u5668\u7aef\u6267\u884c\u3002\u53ef\u4ee5\u4f7f\u7528\u9884\u5b9a\u4e49SQL\u811a\u672c\uff0c\u7136\u540e\u4f20\u522b\u540d\u53ca\u53c2\u6570\u7684\u65b9\u5f0f\uff0c\u6267\u884c\u76f8\u5e94\u7684\u7ed3\u679c\u96c6\uff0c\u5177\u4f53\u53c2\u8003 qdb_httpprov.php \u5b9e\u73b0\u3002<\/p>\n<p>\u53c2\u8003 URL\uff1a<\/p>\n<p style=\"padding-left: 30px;\">https:\/\/blog.qdac.cc\/qdb\/qdb_httppov.php\/OpenDataSet?token=QWPRU15npVEzTlvR7kdU9sF7BRsbKQdl&#038;timestamp=1522357912&#038;sign=af03500cb0fd5892a302611deffeabf9<\/p>\n<p>4\u3001\u6267\u884cSQL\u811a\u672c<\/p>\n<p>\u547d\u4ee4\u4ee3\u7801\uff1a\/ExecSQL<\/p>\n<p>\u53c2\u6570\uff1a<\/p>\n<ul>\n<li>token\uff1a\u5efa\u7acb\u8fde\u63a5\u65f6\u5f97\u5230\u7684\u4f1a\u8bdd\u4ee4\u724c\uff08 access_token \uff09<\/li>\n<li>timestamp\uff1a\u5f53\u524d\u8ba1\u7b97\u673a\u7684\u65f6\u95f4\u6233<\/li>\n<li>sign\uff1a\u53c2\u6570\u7b7e\u540d\uff0c\u53c2\u8003 \/Open \u547d\u4ee4<\/li>\n<li>sql\uff1a\u8981\u67e5\u8be2\u7684 SQL \u811a\u672c\u3002\u5982\u679c\u4f7f\u7528 POST \u65b9\u5f0f\u6295\u9012\uff0c\u90a3\u4e48\u5b83\u5c06\u505a\u4e3a\u4e00\u4e2a Json \u5bf9\u8c61\u7684\u5b50\u7ed3\u70b9\u5b58\u5728\uff0c\u5426\u5219\u5f53\u505a\u666e\u901a\u53c2\u6570\u53c2\u4e0e\u7b7e\u540d\u8ba1\u7b97\u3002<\/li>\n<li>transaction\uff1a\u662f\u5426\u9700\u8981\u5f00\u542f\u4e8b\u52a1\uff0c\u5e03\u5c14\u503c\u3002\u5982\u679c\u4f7f\u7528 POST \u65b9\u5f0f\u6295\u9012\uff0c\u90a3\u4e48\u5b83\u5c06\u505a\u4e3a\u4e00\u4e2a Json \u5bf9\u8c61\u7684\u5b50\u7ed3\u70b9\u5b58\u5728\uff0c\u5426\u5219\u5f53\u505a\u666e\u901a\u53c2\u6570\u53c2\u4e0e\u7b7e\u540d\u8ba1\u7b97\u3002<\/li>\n<li>params\uff1aSQL \u53c2\u6570\u4e0e\u503c\u5bf9\u5217\u8868\uff0c\u4ec5 POST \u00a0\u65b9\u5f0f\u4e0b\u9700\u8981\u3002GET \u65b9\u5f0f\u4e0b\uff0c\u53c2\u6570\u88ab\u76f4\u63a5\u901a\u8fc7 URL \u4f20\u9012\u3002<\/li>\n<\/ul>\n<p>\u8fd4\u56de\u503c\uff1a<\/p>\n<pre class=\"lang:delphi decode:true \">{\r\n\"code\":0,\/\/\u6574\u6570\u9519\u8bef\u4ee3\u7801\uff0c0 \u4ee3\u8868\u6210\u529f\uff0c\u5176\u5b83\u503c\u610f\u5473\u7740\u5931\u8d25\uff0c\u5177\u4f53\u542b\u4e49\u5b9a\u4e49\u7531\u670d\u52a1\u5668\u7aef\u5b9e\u73b0\u786e\u5b9a\r\n\"hint\":\"\",\/\/\u9519\u8bef\u63d0\u793a\u6d88\u606f\u5b57\u7b26\u4e32\uff0c\u5982\u679c\u64cd\u4f5c\u6210\u529f\uff0c\u8be5\u9879\u88ab\u5ffd\u7565\uff0c\u4e5f\u5c31\u662f\u53ef\u4ee5\u4e0d\u8fd4\u56de\uff0c\u4e00\u822c\u7528\u4e8e\u63d0\u793a\u7528\u6237\r\n\"help\":\"\",\/\/\u63d0\u4f9b\u7ed9\u5f00\u53d1\u8005\u7684\u51fa\u9519\u5e2e\u52a9\u4fe1\u606f\uff0c\u53ef\u80fd\u4f1a\u5305\u542b\u654f\u611f\u4fe1\u606f\uff0c\u4e0d\u9002\u5b9c\u63d0\u4f9b\u7ed9\u7528\u6237\u5448\u73b0\r\n\"result\":0\/\/\u6700\u540e\u7684SQL\u8bed\u53e5\u5f71\u54cd\u7684\u884c\u6570\r\n}<\/pre>\n<p>\u5907\u6ce8\uff1a<\/p>\n<p style=\"padding-left: 30px;\">1\u3001\u4f7f\u7528 POST \u4f20\u9012 SQL \u547d\u4ee4\u65f6\uff0cJSON \u53c2\u6570\u683c\u5f0f\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n<pre class=\"lang:delphi decode:true\">{\r\n\"sql\":\"select * from information_schema.columns where table_name=:tablename\",\r\n\"transaction\":false,\r\n\"params\":{\r\n   \"tablename\":\"pg_indexes\"\r\n   }\r\n}<\/pre>\n<p style=\"padding-left: 30px;\">2\u3001\u51fa\u4e8e\u5b89\u5168\u8003\u8651\uff0c\u4e00\u822c\u4e0d\u63a8\u8350\u5728\u5ba2\u6237\u7aef\u76f4\u63a5\u4f20\u9012 SQL \u811a\u672c\u5230\u670d\u52a1\u5668\u7aef\u6267\u884c\u3002\u53ef\u4ee5\u4f7f\u7528\u9884\u5b9a\u4e49SQL\u811a\u672c\uff0c\u7136\u540e\u4f20\u522b\u540d\u53ca\u53c2\u6570\u7684\u65b9\u5f0f\uff0c\u6267\u884c\u76f8\u5e94\u7684\u7ed3\u679c\u96c6\uff0c\u5177\u4f53\u53c2\u8003 qdb_httpprov.php \u5b9e\u73b0\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>TQHttpProvider \u670d\u52a1\u5668\u7aef\u4f7f [&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":[8],"tags":[],"class_list":["post-4857","post","type-post","status-publish","format-standard","hentry","category-delphi"],"views":9937,"_links":{"self":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/4857","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=4857"}],"version-history":[{"count":2,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/4857\/revisions"}],"predecessor-version":[{"id":4859,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=\/wp\/v2\/posts\/4857\/revisions\/4859"}],"wp:attachment":[{"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.qdac.cc\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}