{"id":2253,"date":"2016-02-02T14:44:25","date_gmt":"2016-02-02T06:44:25","guid":{"rendered":"http:\/\/blog2.tibame.com\/?p=2253"},"modified":"2022-04-08T18:28:02","modified_gmt":"2022-04-08T10:28:02","slug":"r%e8%88%87mysql%e9%80%a3%e7%b7%9a-jdbc","status":"publish","type":"post","link":"https:\/\/blog.tibame.com\/?p=2253","title":{"rendered":"R\u8207MySQL\u9023\u7dda\u2014JDBC"},"content":{"rendered":"<p><strong>\u9700\u5b89\u88dd\u5b8c\u6210\u6a94\u6848\uff1a<\/strong><br \/>\n1.R-Studio \u5b89\u88dd\u65b9\u5f0f\u53c3\u8003\u9023\u7d50\uff1a<a href=\"https:\/\/blog.wiedu.tw\/?p=2208\">https:\/\/blog.wiedu.tw\/?p=2208<\/a><br \/>\n2.R\u5b89\u88dd\u65b9\u5f0f\u53c3\u8003\u9023\u7d50\uff1a<a href=\"https:\/\/blog.wiedu.tw\/?p=1794\">https:\/\/blog.wiedu.tw\/?p=1794<\/a><br \/>\n3.MySQL<br \/>\n4.JDK\u5b89\u88dd\u65b9\u5f0f\u53c3\u8003\u9023\u7d50\uff1a<a href=\"https:\/\/blog.wiedu.tw\/?p=2068\">https:\/\/blog.wiedu.tw\/?p=2068<\/a><\/p>\n<p><strong>\u5b89\u88ddDownload Connector\/J<\/strong><\/p>\n<div class=\"pcrstb-wrap\"><table>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u4e00\uff1a\u641c\u5c0b\u201d Download Connector\/J\u201d\u6216\u662f\u53c3\u8003\u9023\u7d50(<a href=\"https:\/\/goo.gl\/A7SZXY\">https:\/\/goo.gl\/A7SZXY<\/a>)\uff0c\u9ede\u9078\u201dDownload\u201d<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<p><!--more--><br \/>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql1.png\" alt=\"mysql1\" width=\"1625\" height=\"725\" class=\"aligncenter size-full wp-image-2245\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql1.png 1625w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql1-300x134.png 300w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql1-768x343.png 768w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql1-1024x457.png 1024w\" sizes=\"(max-width: 1625px) 100vw, 1625px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u4e8c\uff1a\u9ede\u9078\u201d No thanks, just start my download.\u201d\uff0c\u4e0b\u8f09\u6a94\u6848<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u4e09\uff1a\u5c07\u4e0b\u8f09\u4e0b\u4f86\u6a94\u6848\u89e3\u58d3\u7e2e\u81f3\u60a8\u8981\u7684\u76ee\u9304\u4e4b\u4e0b\uff0c\u4e26\u5c07\u76ee\u9304\u8907\u88fd\u4e0b\u4f86<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql3.png\" alt=\"mysql3\" width=\"1017\" height=\"656\" class=\"aligncenter size-full wp-image-2247\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql3.png 1017w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql3-300x194.png 300w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql3-768x495.png 768w\" sizes=\"(max-width: 1017px) 100vw, 1017px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u56db\uff1a\u6253\u958bR-Studio install \u9023\u63a5MySQL\u6240\u9700\u7684 package<br \/>\n1. RJDBC<br \/>\n2. DBI<br \/>\n3. rJava<br \/>\n\u4e00\u4e00\u5c07\u5957\u4ef6\u540d\u7a31\u8f38\u5165\uff0c\u4e26\u9ede\u9078install \u5b89\u88ddpackage<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql4.png\" alt=\"mysql4\" width=\"856\" height=\"430\" class=\"aligncenter size-full wp-image-2248\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql4.png 856w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql4-300x151.png 300w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql4-768x386.png 768w\" sizes=\"(max-width: 856px) 100vw, 856px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u4e94\uff1a\u900f\u904elibrary\u5c07\u5957\u4ef6\u4e00\u4e00\u532f\u5165R-Studio\u4e2d\uff0clibrary(RJDBC)\u3001library(DBI)\u3001library(rJava)\uff0c\u6216\u662f\u900f\u904e\u4ecb\u9762\u64cd\u4f5c\u5957\u4ef6\u4e00\u4e00\u532f\u5165<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql5.png\" alt=\"mysql5\" width=\"702\" height=\"538\" class=\"aligncenter size-full wp-image-2249\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql5.png 702w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql5-300x230.png 300w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u516d\uff1a\u9023\u7ddaMySQL\u8cc7\u6599\u5eab<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql6.png\" alt=\"mysql6\" width=\"2027\" height=\"206\" class=\"aligncenter size-full wp-image-2250\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql6.png 2027w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql6-300x30.png 300w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql6-768x78.png 768w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql6-1024x104.png 1024w\" sizes=\"(max-width: 2027px) 100vw, 2027px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color:#FDF5E6\">\n<img decoding=\"async\" src=\"https:\/\/blog.wiedu.tw\/wp-content\/uploads\/2016\/02\/mysql7.png\" alt=\"mysql7\" width=\"1538\" height=\"224\" class=\"aligncenter size-full wp-image-2251\" srcset=\"https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql7.png 1538w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql7-300x44.png 300w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql7-768x112.png 768w, https:\/\/blog.tibame.com\/wp-content\/uploads\/2016\/02\/mysql7-1024x149.png 1024w\" sizes=\"(max-width: 1538px) 100vw, 1538px\" \/>\n<\/td>\n<\/tr>\n<tr>\n<td style=\"background-color: #CD2990; font-size: 16px;color: white;\">\n\u6b65\u9a5f\u4e03\uff1a\u57f7\u884c\u4e0a\u5169\u884c\u7a0b\u5f0f\u78bc\u5373\u53ef\u9023\u7ddaMySQL\u8cc7\u6599\u5eab<br \/>\n(\u76f8\u95dc\u8ab2\u7a0b:<a href=\"http:\/\/goo.gl\/kDqAqT\">TibaMe\u5b78\u7fd2\u7db2\u2013DataBase<\/a>)\n<\/td>\n<\/tr>\n<\/table><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u9700\u5b89\u88dd\u5b8c\u6210\u6a94\u6848\uff1a 1.R-Studio \u5b89\u88dd\u65b9\u5f0f&hellip;<\/p>\n","protected":false},"author":19,"featured_media":2254,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_lmt_disableupdate":"","_lmt_disable":"","footnotes":""},"categories":[480,173,1543],"tags":[621,622],"class_list":["post-2253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology","category-173","category-1543","tag-jdbc","tag-mysql"],"aioseo_notices":[],"views":3548,"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/posts\/2253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2253"}],"version-history":[{"count":4,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/posts\/2253\/revisions"}],"predecessor-version":[{"id":2258,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/posts\/2253\/revisions\/2258"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=\/wp\/v2\/media\/2254"}],"wp:attachment":[{"href":"https:\/\/blog.tibame.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.tibame.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}