{"id":2609,"date":"2022-05-31T17:19:05","date_gmt":"2022-05-31T09:19:05","guid":{"rendered":"https:\/\/nj.transwarp.cn:8180\/?p=2609"},"modified":"2022-05-31T17:19:15","modified_gmt":"2022-05-31T09:19:15","slug":"tdt-%e8%bf%9e%e6%8e%a5%e7%ae%a1%e7%90%86-jdbc%e8%bf%9e%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/kbwp.transwarp.cn\/?p=2609","title":{"rendered":"TDT-\u8fde\u63a5\u7ba1\u7406-JDBC\u8fde\u63a5"},"content":{"rendered":"<h3>\u6982\u8981\u63cf\u8ff0<\/h3>\n<hr \/>\n<p>\u5728studio\u7248\u672c\u4e2d\uff0ctransporter\u63d0\u4f9b\u7edf\u4e00\u8fde\u63a5\u7ba1\u7406\u529f\u80fd\u3002\u672c\u6587\u8bb2\u8ff0\u8fde\u63a5\u7ba1\u7406-JDBC\u8fde\u63a5\u7684\u6807\u51c6\u64cd\u4f5c\u3002<\/p>\n<h3>\u8be6\u7ec6\u8bf4\u660e<\/h3>\n<hr \/>\n<p>\u8be6\u7ec6\u64cd\u4f5c\u6b65\u9aa4\u5982\u4e0b\uff1a<br \/>\n1\u3001\u5728transporter\u9996\u9875\uff0c\u9009\u62e9\u201c\u7ba1\u7406-\u8fde\u63a5\u7ba1\u7406\u201d\u83dc\u5355\uff0c\u70b9\u51fb\u53f3\u4e0a\u89d2\u201c\u65b0\u5efa\u8fde\u63a5\u201d\uff0c\u9009\u62e9JDBC<br \/>\n<img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2020\/03\/image-1583894132434.png\" alt=\"file\" \/><\/p>\n<p>2\u3001\u586b\u5199\u5404\u9879\u4fe1\u606f<br \/>\n<img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2020\/03\/image-1583895934362.png\" alt=\"file\" \/><br \/>\n\u8fde\u63a5\u540d\u79f0\uff1a\u4efb\u610f\u586b\u5199\u5373\u53ef<br \/>\n\u63cf\u8ff0\uff1a\u4efb\u610f\u586b\u5199\u5373\u53ef<br \/>\n\u96c6\u7fa4\uff1a\u9009\u62e9\u8fde\u63a5\u5230\u7684\u96c6\u7fa4<br \/>\nJDBC\u8fde\u63a5\uff1ajdbc\u8fde\u63a5\u4e32\uff0c\u4f8b\u5982\u6b64\u5904\u4ee5postgresql\u4e3a\u4f8b\uff1ajdbc:postgresql:\/\/{ip_address}\/{db}<br \/>\n\u9a71\u52a8\u7c7b\u540d\uff1ajdbc\u9a71\u52a8\u7c7b\u540d<br \/>\n\u7528\u6237\u540d\u3001\u5bc6\u7801\uff1a\u8bbf\u95ee\u6570\u636e\u5e93\u7684\u7528\u6237\u540d\u53ca\u5176\u5bc6\u7801<br \/>\n\u914d\u7f6e\u6587\u4ef6\uff1a\u70b9\u51fb\u9a71\u52a8\u6587\u4ef6\u4e0a\u4f20JDBC\u9a71\u52a8<\/p>\n<p>3\u3001\u70b9\u51fb\u201c\u6d4b\u8bd5\u8fde\u63a5\u201d\uff0c\u63d0\u793a\u8fde\u63a5\u6210\u529f\u5373\u53ef\u3002<br \/>\n<img decoding=\"async\" src=\"https:\/\/nj.transwarp.cn:8180\/wp-content\/uploads\/2020\/03\/image-1583896187921.png\" alt=\"file\" \/><\/p>\n<p>\u9644\uff1a<br \/>\n\u5404\u79cdjdbc\u8fde\u63a5\u4e32\u683c\u5f0f<\/p>\n<ol>\n<li>MySQL\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:mysql:\/\/{ip_address}:{port}<\/li>\n<li>Oracle\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:oracle:thin:@{ip_address}:{port}:{service}<\/li>\n<li>DB2\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:db2:\/\/{ip_address}:{port}\/{db}<\/li>\n<li>sybase\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:sybase:Tds:{ip_address}:{port}\/{db}<\/li>\n<li>PostgreSQL\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:postgresql:\/\/{ip_address}\/{db}<\/li>\n<li>Sql Server2000\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:microsoft:sqlserver:\/\/{ip_address}:{port};DatabaseName={db}<\/li>\n<li>Sql Server2005\u8fde\u63a5\u4e32\u683c\u5f0f\u5982\u4e0b\uff1a<br \/>\njdbc:sqlserver:\/\/{ip_address}:{port};DatabaseName={db}<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>\u6982\u8981\u63cf\u8ff0 \u5728studio\u7248\u672c\u4e2d\uff0ctransporter\u63d0\u4f9b\u7edf\u4e00\u8fde\u63a5\u7ba1\u7406\u529f\u80fd\u3002\u672c\u6587\u8bb2\u8ff0\u8fde\u63a5\u7ba1\u7406-JDBC\u8fde\u63a5\u7684\u6807 ..<\/p>\n<div class=\"clear-fix\"><\/div>\n<p><a href=\"https:\/\/kbwp.transwarp.cn\/?p=2609\" title=\"read more...\">Read more<\/a><\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2609","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"acf":[],"_links":{"self":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2609"}],"version-history":[{"count":1,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2609\/revisions"}],"predecessor-version":[{"id":3164,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=\/wp\/v2\/posts\/2609\/revisions\/3164"}],"wp:attachment":[{"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kbwp.transwarp.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}