{"id":2031,"date":"2023-06-21T23:26:56","date_gmt":"2023-06-21T15:26:56","guid":{"rendered":"http:\/\/viplao.com\/?p=2031"},"modified":"2023-06-21T23:32:34","modified_gmt":"2023-06-21T15:32:34","slug":"flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink","status":"publish","type":"post","link":"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/","title":{"rendered":"FLINK SQL \u5b9e\u8df5 &#8211; \uff08\u5341\u4e94\uff09\uff1aflink sql \u5f00\u53d1\u4f01\u4e1a\u7ea7\u5229\u5668\u4e4b Dlink"},"content":{"rendered":"\n<p>\u53d1\u73b0\u6709\u4e24\u6b3e\u975e\u5e38\u4f18\u79c0\u7684\u5229\u5668\uff1a<\/p>\n\n\n\n<ul>\n<li>Apache Zeppelin<\/li>\n\n\n\n<li>Dlink<\/li>\n<\/ul>\n\n\n\n<p>\u4e3a\u5565\u5148\u4ecb\u7ecd Dlink \u5462\uff1f<\/p>\n\n\n\n<p>\u56e0\u4e3a\u535a\u4e3b\u548c\u5176\u5f00\u53d1\u4eba\u5458\u6df7\u7684\u5f88\u719f\u4e86\uff0c\u6240\u4ee5\u5c31\u5148\u62ff Dlink \u6765\u5c1d\u8bd5\u5c1d\u8bd5\u3002<\/p>\n\n\n\n<p>\u5e9f\u8bdd\u4e0d\u591a\u8bf4\uff0c\u5927\u5bb6\u90fd\u60f3\u5148\u770b\u6548\u679c\u518d\u770b\u600e\u4e48\u90e8\u7f72\u3002\u5148\u770b\u770b\u6700\u7ec8\u6548\u679c\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_71 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u6587\u7ae0\u76ee\u5f55<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#2Dlink_%E5%B9%B3%E5%8F%B0%E6%95%88%E6%9E%9C\" title=\"2.Dlink \u5e73\u53f0\u6548\u679c\">2.Dlink \u5e73\u53f0\u6548\u679c<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#21%E7%99%BB%E5%BD%95\" title=\"2.1.\u767b\u5f55\">2.1.\u767b\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#22flink_sql_%E5%BC%80%E5%8F%91%E7%95%8C%E9%9D%A2\" title=\"2.2.flink sql \u5f00\u53d1\u754c\u9762\">2.2.flink sql \u5f00\u53d1\u754c\u9762<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#3%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2%E7%AF%87\" title=\"3.\u5b89\u88c5\u90e8\u7f72\u7bc7\">3.\u5b89\u88c5\u90e8\u7f72\u7bc7<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#31Dlink_%E7%9A%84_github\" title=\"3.1.Dlink \u7684 github\">3.1.Dlink \u7684 github<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#32%E9%83%A8%E7%BD%B2%E7%8E%AF%E5%A2%83%E5%87%86%E5%A4%87\" title=\"3.2.\u90e8\u7f72\u73af\u5883\u51c6\u5907\">3.2.\u90e8\u7f72\u73af\u5883\u51c6\u5907<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#33%E4%B8%8B%E8%BD%BD%E8%A7%A3%E5%8E%8B_Dlink_%E5%AE%89%E8%A3%85%E5%8C%85\" title=\"3.3.\u4e0b\u8f7d\u89e3\u538b Dlink \u5b89\u88c5\u5305\">3.3.\u4e0b\u8f7d\u89e3\u538b Dlink \u5b89\u88c5\u5305<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#34%E9%85%8D%E7%BD%AE_Dlink_MySQL\" title=\"3.4.\u914d\u7f6e Dlink MySQL\">3.4.\u914d\u7f6e Dlink MySQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#35%E5%90%AF%E5%8A%A8_web_%E5%90%8E%E7%AB%AF\" title=\"3.5.\u542f\u52a8 web \u540e\u7aef\">3.5.\u542f\u52a8 web \u540e\u7aef<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#36%E9%85%8D%E7%BD%AE_web_%E5%89%8D%E7%AB%AF\" title=\"3.6.\u914d\u7f6e web \u524d\u7aef\">3.6.\u914d\u7f6e web \u524d\u7aef<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/#4%E6%80%BB%E7%BB%93%E5%8F%8A%E5%B1%95%E6%9C%9B\" title=\"4.\u603b\u7ed3\u53ca\u5c55\u671b\">4.\u603b\u7ed3\u53ca\u5c55\u671b<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"2Dlink_%E5%B9%B3%E5%8F%B0%E6%95%88%E6%9E%9C\"><\/span>2.Dlink \u5e73\u53f0\u6548\u679c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"21%E7%99%BB%E5%BD%95\"><\/span>2.1.\u767b\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-0a69dc04616095e5655162cb62512dbd_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>\u767b\u5f55<\/p>\n\n\n\n<p>\u767b\u5f55\u8d26\u53f7\u548c\u5bc6\u7801\u9ed8\u8ba4\u4e3a admin\/admin\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"22flink_sql_%E5%BC%80%E5%8F%91%E7%95%8C%E9%9D%A2\"><\/span>2.2.flink sql \u5f00\u53d1\u754c\u9762<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5177\u4f53\u529f\u80fd\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-6db46ca87d42e500bcaaf90d2707c9a0_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>sql \u5f00\u53d1<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>\u6ce8\u610f\uff1a<br>\u9884\u8dd1\u5c31\u662f\u7528\u4e8e\u5feb\u901f\u9a8c\u8bc1 sql \u662f\u5426\u662f\u6b63\u786e\u7684\uff0c\u53ef\u4ee5\u5feb\u901f\u4ee5 standalone \u6a21\u5f0f\u8dd1\u51fa\u6765\u4e00\u4e2a\u7ed3\u679c\u3002\u80a5\u80a0\u5730\u597d\u7528\u3002\u60f3\u770b\u5230\u9884\u8dd1\u7684\u7ed3\u679c\uff0c\u5728 sql \u4e2d\u4e0d\u80fd\u5199 insert into xxx \u8fd9\u6bb5\u3002<\/p>\n<\/blockquote>\n\n\n\n<p>\u53ef\u4ee5\u770b\u5230\u662f\u4e00\u4e2a\u529f\u80fd\u5f88\u9f50\u5168\u7684 web IDE\u3002<\/p>\n\n\n\n<p>\u63a5\u4e0b\u6765\u6211\u4eec\u770b\u770b\u600e\u4e48\u5b89\u88c5\u90e8\u7f72 Dlink 0.4.0\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"3%E5%AE%89%E8%A3%85%E9%83%A8%E7%BD%B2%E7%AF%87\"><\/span>3.\u5b89\u88c5\u90e8\u7f72\u7bc7<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"31Dlink_%E7%9A%84_github\"><\/span>3.1.Dlink \u7684 github<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6e90\u7801\u76f4\u63a5\u53bb github \u4e0a\u770b\uff0c\u5df2\u7ecf\u5f00\u6e90\u4e86\uff0c\u94fe\u63a5\u5982\u4e0b\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DataLinkDC\/dlink\">https:\/\/github.com\/DataLinkDC\/dlink<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"32%E9%83%A8%E7%BD%B2%E7%8E%AF%E5%A2%83%E5%87%86%E5%A4%87\"><\/span>3.2.\u90e8\u7f72\u73af\u5883\u51c6\u5907<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6b64\u90e8\u7f72\u793a\u4f8b\u662f\u5728 Mac OS \u4e0a\u8fdb\u884c\uff0c\u5176\u4ed6\u73af\u5883\u672a\u6d4b\u8bd5\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"33%E4%B8%8B%E8%BD%BD%E8%A7%A3%E5%8E%8B_Dlink_%E5%AE%89%E8%A3%85%E5%8C%85\"><\/span>3.3.\u4e0b\u8f7d\u89e3\u538b Dlink \u5b89\u88c5\u5305<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u535a\u4e3b\u662f\u57fa\u4e8e Dlink 0.4.0 \u7248\u672c\u90e8\u7f72\u5b89\u88c5\u7684\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e00\u6b65\uff1a\u4e0b\u8f7d Dlink 0.4.0 \u5b89\u88c5\u5305\u3002<\/p>\n\n\n\n<p>\u6211\u4eec\u6253\u5f00 Dlink 0.4.0 release Notes \u770b\u770b\uff0c\u94fe\u63a5\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p><a href=\"https:\/\/github.com\/DataLinkDC\/dlink\/releases\/tag\/0.4.0\">https:\/\/github.com\/DataLinkDC\/dlink\/releases\/tag\/0.4.0<\/a><\/p>\n\n\n\n<p>\u6253\u5f00\u4e0a\u8ff0 0.4.0 release Notes \u94fe\u63a5\u540e\uff0c\u70b9\u51fb\u4e0b\u56fe\u4e2d\u7684&nbsp;<code>dlink-release-0.4.0.tar.gz<\/code>&nbsp;\u4e0b\u8f7d Dlink 0.4.0 \u7684\u5b89\u88c5\u5305\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-c01f14ab1ad745ecc27f9065f325e0ff_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>Dlink \u4e0b\u8f7d<\/p>\n\n\n\n<p>\u7b2c\u4e8c\u6b65\uff1a\u89e3\u538b Dlink 0.4.0 \u5b89\u88c5\u5305\u770b\u770b\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-247758e3e51b23b5695cc5146019815c_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>Dlink<\/p>\n\n\n\n<p>\u89e3\u538b\u540e\u5f97\u5230\u7684&nbsp;<code>dlink-release-0.4.0<\/code>&nbsp;\u76ee\u5f55\u7ed3\u6784\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u6ce8\u610f\u8fd9\u91cc\u53ea\u662f Dlink \u76f8\u5173\u7684\u5305\u548c\u6587\u4ef6\uff0cflink \u4efb\u52a1\u7684\u6267\u884c\u5fc5\u7136\u8fd8\u4f1a\u4f9d\u8d56\u5230 flink \u76f8\u5173\u7684\u5305\uff0c\u8fd9\u5c31\u9700\u8981\u4f60\u5728&nbsp;<code>dlink-release-0.4.0<\/code>&nbsp;\u76ee\u5f55\u4e0b\u81ea\u5df1\u521b\u5efa\u4e00\u4e2a&nbsp;<code>plugins<\/code>&nbsp;\u6587\u4ef6\u5939\u3002\u5e76\u4e14\u5c06 flink \u76f8\u5173\u7684 jar \u653e\u5728&nbsp;<code>plugins<\/code>&nbsp;\u6587\u4ef6\u5939\u4e0b\u3002\u5373\u4ece&nbsp;<a href=\"https:\/\/link.zhihu.com\/?target=https%3A\/\/archive.apache.org\/dist\/flink\/flink-1.13.2\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/archive.apache.org\/dist\/flink\/flink-1.13.2\/<\/a>&nbsp;\u4e0b\u8f7d\u5bf9\u5e94\u7684 flink tar.gz \u5230\u672c\u5730\u540e\uff0c\u5c06\u89e3\u538b\u540e\u7684 flink jar \u5168\u90e8 copy \u5230&nbsp;<code>plugins<\/code>&nbsp;\u6587\u4ef6\u5939\u4e0b\u5373\u53ef\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>config\/ -- \u914d\u7f6e\u6587\u4ef6\n|- application.yml\nlib\/ -- \u5916\u90e8\u4f9d\u8d56\u53caConnector\n|- dlink-client-1.13-0.4.0.jar\n|- dlink-connector-jdbc-1.13-0.4.0.jar\n|- dlink-function-0.4.0.jar\n|- dlink-metadata-clickhouse-0.4.0.jar\n|- dlink-metadata-mysql-0.4.0.jar\n|- dlink-metadata-oracle-0.4.0.jar\n|- dlink-metadata-postgresql-0.4.0.jar\nsql\/\n|- dlink.sql -- Mysql\u521d\u59cb\u5316\u811a\u672c\nauto.sh -- \u542f\u52a8\u505c\u6b62\u811a\u672c\ndlink-admin-0.4.0.jar -- \u7a0b\u5e8f\u5305\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"34%E9%85%8D%E7%BD%AE_Dlink_MySQL\"><\/span>3.4.\u914d\u7f6e Dlink MySQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u65e2\u7136\u662f\u4e00\u4e2a web IDE\uff0c\u5fc5\u7136\u4f1a\u5b58\u50a8\u4e00\u4e9b web \u5e94\u7528\u76f8\u5173\u7684\u4fe1\u606f\u3002\u8fd9\u4e9b\u4fe1\u606f\u5c31\u662f\u5b58\u50a8\u5728 MySQL \u4e2d\u7684\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e00\u6b65\uff1a\u521b\u5efa MySQL&nbsp;<code>dlink<\/code>&nbsp;\u5e93\u3002<\/p>\n\n\n\n<p>\u4f7f\u7528 MySQL-cli \u8fde\u63a5 MySQL \u521b\u5efa\u5e93\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; mysql -u\u7528\u6237\u540d -p\u5bc6\u7801\n\nmysql&gt; create database dlink;\nmysql&gt; show databases;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic4.zhimg.com\/80\/v2-797c579868ec05853f675735c46129a7_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>Dlink MySQL<\/p>\n\n\n\n<p>\u7b2c\u4e8c\u6b65\uff1a\u4f7f\u7528 Dlink \u7684 sql \u811a\u672c\uff08<code>dlink \u76ee\u5f55\\sql \u76ee\u5f55\\dlink.sql<\/code>\uff09\u521d\u59cb\u5316 Dlink \u6570\u636e\u5e93\u8868\u4fe1\u606f\uff0c\u5177\u4f53\u521d\u59cb\u5316\u547d\u4ee4\u884c\u5982\u4e0b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&gt; mysql -h localhost -u\u7528\u6237\u540d -p\u5bc6\u7801 -Ddlink &lt; dlink.sql\n&gt; mysql -u\u7528\u6237\u540d -p\u5bc6\u7801\nmysql&gt; use dlink;\nmysql&gt; show tables;\n<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic3.zhimg.com\/80\/v2-9d27ba98135c7e71b813d82250e23c12_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>Dlink MySQL Table<\/p>\n\n\n\n<p>\u7b2c\u4e09\u6b65\uff1aDlink \u4e5f\u662f\u4e2a web \u9879\u76ee\uff0c\u7528\u7684\u662f SpringBoot \u90a3\u4e00\u5957\u4e1c\u897f\uff0c\u6240\u4ee5\u8fde\u63a5 MySQL \u5f97\u9700\u8981\u8fdb\u884c Spring \u76f8\u5173\u7684\u914d\u7f6e\u3002<\/p>\n\n\n\n<p>\u6240\u4ee5\u9700\u8981\u53bb&nbsp;<code>dlink \u76ee\u5f55\\config \u76ee\u5f55\\application.yml<\/code>&nbsp;\u4e2d\u4fee\u6539 MySQL \u76f8\u5173\u7684\u914d\u7f6e\u3002\u7531\u4e8e\u535a\u4e3b\u662f\u5728\u672c\u5730\u90e8\u7f72\u3002\u6240\u4ee5\u6d89\u53ca\u5230\u6539\u52a8\u7684\u53ea\u6709\u7528\u6237\u540d\u548c\u5bc6\u7801\uff0c\u6539\u5b8c\u4e4b\u540e\u4fdd\u5b58\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic1.zhimg.com\/80\/v2-6aee2d2058f4d3d708595ed25496e790_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>application.yml<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"35%E5%90%AF%E5%8A%A8_web_%E5%90%8E%E7%AB%AF\"><\/span>3.5.\u542f\u52a8 web \u540e\u7aef<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Dlink \u662f\u524d\u540e\u7aef\u5206\u79bb\u7684\uff0c\u521a\u521a\u6211\u4eec\u914d\u7f6e\u4e86 MySQL \u76f8\u5173\u7684\u73af\u5883\uff0c\u5219\u53ef\u4ee5\u76f4\u63a5\u542f\u52a8\u540e\u7aef\u4e86\uff0c\u540e\u7aef\u5360\u7528\u7684\u7aef\u53e3\u662f 8888\uff0c\u542f\u52a8\u547d\u4ee4\u5982\u4e0b\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sh auto.sh start\n<\/code><\/pre>\n\n\n\n<p>\u5728 Mac OS \u4e0b\u542f\u52a8\u53ef\u80fd\u4f1a\u9047\u5230\u4e0b\u9762\u7684\u95ee\u9898\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/pic2.zhimg.com\/80\/v2-6b51cd477a86ec3d3a601f22df5655f1_720w.webp\" alt=\"\"\/><\/figure>\n\n\n\n<p>bash error<\/p>\n\n\n\n<p>\u8fd9\u4e2a\u9519\u8bef\u7684\u539f\u56e0\u5982\u4e0b\u94fe\u63a5\uff1a<\/p>\n\n\n\n<p><a href=\"https:\/\/jingyan.baidu.com\/article\/9f63fb91d014b8c8410f0e7a.html\">https:\/\/jingyan.baidu.com\/article\/9f63fb91d014b8c8410f0e7a.html<\/a><\/p>\n\n\n\n<p>\u89e3\u51b3\u65b9\u6848\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u76f4\u63a5\u628a&nbsp;<code>auto.sh<\/code>&nbsp;\u5728\u5176\u4ed6\u7f16\u8f91\u5668\u4e2d\u91cd\u65b0\u590d\u5236\u51fa\u6765\u4e00\u4e2a&nbsp;<code>auto1.sh<\/code>&nbsp;\u542f\u52a8\u5c31\u53ef\u4ee5\u3002<\/p>\n\n\n\n<p>\u5176\u4ed6\u547d\u4ee4\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># \u505c\u6b62\nsh auto.sh stop\n# \u91cd\u542f\nsh auto.sh restart\n# \u72b6\u6001\nsh auto.sh status\n<\/code><\/pre>\n\n\n\n<p>\u8fd0\u884c\u65e5\u5fd7\uff1a<\/p>\n\n\n\n<p>\u63a7\u5236\u53f0\u8f93\u51fa\uff1a\u9879\u76ee\u6839\u76ee\u5f55\u4e0b\u7684 dlink.log \u6587\u4ef6\u3002<\/p>\n\n\n\n<p>\u65e5\u5fd7\u5f52\u6863\u8f93\u51fa\uff1a\u9879\u76ee\u6839\u76ee\u5f55\u4e0b\u7684 logs \u76ee\u5f55\u4e0b\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"36%E9%85%8D%E7%BD%AE_web_%E5%89%8D%E7%AB%AF\"><\/span>3.6.\u914d\u7f6e web \u524d\u7aef<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u524d\u7aef\u90fd\u662f\u4e00\u4e9b\u9759\u6001\u6587\u4ef6\uff0cDlink \u4f7f\u7528 Nginx \u4f5c\u4e3a\u8bbf\u95ee\u524d\u7aef\u9759\u6001\u6587\u4ef6\u7684\u670d\u52a1\u5668\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e00\u6b65\uff1aNginx \u5728 Mac OS \u7684\u5b89\u88c5\uff0c\u5982\u4e0b\u94fe\u63a5\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-embed\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/www.jianshu.com\/p\/4f433d219ab7\n<\/div><\/figure>\n\n\n\n<p>\u7b2c\u4e8c\u6b65\uff1a\u5728 nginx.conf \u6587\u4ef6\u4e2d\u914d\u7f6e Dlink \u7684 server \u4fe1\u606f\u3002<\/p>\n\n\n\n<p>\u672c\u5730\u5b89\u88c5\u7684\u8bdd\uff0c\u76f4\u63a5\u628a\u4e0b\u9762\u8fd9\u6bb5 copy \u5230 nginx.conf \u4e2d\u5bf9\u5e94\u7684 server \u914d\u7f6e\u4e0b\u5c31\u884c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>server {\n    listen       9999;\n    server_name localhost;\n    \n    # gzip config\n    gzip on;\n    gzip_min_length 1k;\n    gzip_comp_level 9;\n    gzip_types text\/plain application\/javascript application\/x-javascript text\/css application\/xml text\/javascript application\/x-httpd-php image\/jpeg image\/gif image\/png;\n    gzip_vary on;\n    gzip_disable \"MSIE &#91;1-6]\\.\";\n    \n    #charset koi8-r;\n    \n    #access_log logs\/host.access.log main;\n    \n    location \/ {\n        root   html;\n        index index.html index.htm;\n        try_files $uri $uri\/ \/index.html;\n    }\n    \n    #error_page 404             \/404.html;\n    \n    # redirect server error pages to the static page \/50x.html\n    #\n    error_page   500 502 503 504 \/50x.html;\n    location = \/50x.html {\n        root   html;\n    }\n    \n    location ^~ \/api {\n        proxy_pass http:\/\/127.0.0.1:8888;\n        proxy_set_header   X-Forwarded-Proto $scheme;\n        proxy_set_header   X-Real-IP         $remote_addr;\n    }\n}\n<\/code><\/pre>\n\n\n\n<p>\u7b2c\u4e09\u6b65\uff1a\u6ce8\u610f\uff0c\u91cd\u70b9\u3002<code>\u4e00\u5b9a\u8981\u5c06 \u3010dlink \u76ee\u5f55\\html \u76ee\u5f55\\\u6240\u6709\u6587\u4ef6\u3011\u4e0a\u4f20\u81f3 Nginx \u7684 [html \u76ee\u5f55]\u4e0b\u3002<\/code>\u4e0d\u7136\u8bbf\u95ee&nbsp;<a href=\"https:\/\/link.zhihu.com\/?target=http%3A\/\/127.0.0.1%3A9999\" target=\"_blank\" rel=\"noreferrer noopener\">http:\/\/127.0.0.1:9999<\/a>&nbsp;\u5565\u90fd\u770b\u4e0d\u5230\u3002<\/p>\n\n\n\n<p>\u7b2c\u56db\u6b65\uff1areload Nginx \u914d\u7f6e\u4fe1\u606f\u3002<\/p>\n\n\n\n<p>\u7b2c\u4e94\u6b65\uff1a\u7136\u540e\u6211\u4eec\u5c31\u53ef\u4ee5 happy \u7684\u4f7f\u7528 Dlink \u4e86\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"4%E6%80%BB%E7%BB%93%E5%8F%8A%E5%B1%95%E6%9C%9B\"><\/span>4.\u603b\u7ed3\u53ca\u5c55\u671b<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5176\u4ed6\u529f\u80fd\u535a\u4e3b\u8fd8\u5728\u6d4b\u8bd5\u4e2d\u3002<\/p>\n\n\n\n<p>\u5f15\u7528 Dlink \u5b98\u7f51\u7684\u4ecb\u7ecd\uff0cDlink \u5c06\u7d27\u8ddf Flink \u5b98\u65b9\u793e\u533a\u53d1\u5c55\uff0c\u4e3a\u63a8\u5e7f\u53ca\u53d1\u5c55 Flink \u7684\u5e94\u7528\u800c\u594b\u6597\uff0c\u6253\u9020 FlinkSQL \u7684\u6700\u4f73\u642d\u6863\u7684\u5f62\u8c61\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u53d1\u73b0\u6709\u4e24\u6b3e\u975e\u5e38\u4f18\u79c0\u7684\u5229\u5668\uff1a \u4e3a\u5565\u5148\u4ecb\u7ecd Dlink \u5462\uff1f \u56e0\u4e3a\u535a\u4e3b\u548c\u5176\u5f00\u53d1\u4eba\u5458\u6df7\u7684\u5f88\u719f\u4e86\uff0c\u6240\u4ee5\u5c31\u5148\u62ff&hellip; <a href=\"http:\/\/viplao.com\/index.php\/2023\/06\/21\/flink-sql-%e5%ae%9e%e8%b7%b5-%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89%ef%bc%9aflink-sql-%e5%bc%80%e5%8f%91%e4%bc%81%e4%b8%9a%e7%ba%a7%e5%88%a9%e5%99%a8%e4%b9%8b-dlink\/\" class=\"more-link read-more\" rel=\"bookmark\">\u7ee7\u7eed\u9605\u8bfb <span class=\"screen-reader-text\">FLINK SQL \u5b9e\u8df5 &#8211; \uff08\u5341\u4e94\uff09\uff1aflink sql \u5f00\u53d1\u4f01\u4e1a\u7ea7\u5229\u5668\u4e4b Dlink<\/span><i class=\"fa fa-arrow-right\"><\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[25],"views":391,"_links":{"self":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2031"}],"collection":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/comments?post=2031"}],"version-history":[{"count":2,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2031\/revisions"}],"predecessor-version":[{"id":2038,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/posts\/2031\/revisions\/2038"}],"wp:attachment":[{"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/media?parent=2031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/categories?post=2031"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/viplao.com\/index.php\/wp-json\/wp\/v2\/tags?post=2031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}