{"id":10224,"date":"2019-10-05T21:55:16","date_gmt":"2019-10-05T13:55:16","guid":{"rendered":"https:\/\/mnya.tw\/cc\/?p=10224"},"modified":"2021-10-20T21:13:34","modified_gmt":"2021-10-20T13:13:34","slug":"1480","status":"publish","type":"post","link":"https:\/\/mnya.tw\/cc\/word\/1480.html","title":{"rendered":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599"},"content":{"rendered":"<p>\u4eca\u5929\u662f\u6211\u9019\u6bb5\u6642\u9593\u5fc3\u60c5\u6700\u5dee\u7684\u4e00\u5929\uff0c\u4f46\u4e5f\u56e0\u70ba\u4e0d\u65b7\u7684\u5931\u6557\uff0c\u665a\u9593\u7d42\u65bc\u7814\u7a76\u51fa\u4f86\u9019\u7bc7\u6587\u7ae0\u7684\u6210\u679c\uff0c\u7db2\u4e0a\u95dc\u65bc <strong>Android APP<\/strong> \u8981\u4f7f\u7528<a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/j\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong> JDBC<\/strong> <\/a>\u76f4\u63a5\u9023\u63a5<strong> MySQL \u8cc7\u6599\u5eab<\/strong>\u4e26\u53d6\u51fa\u8cc7\u6599\u7684\u5b8c\u6574\u6027\u6587\u7ae0\u4e26\u4e0d\u5b58\u5728\uff0c\u5927\u591a\u6587\u7ae0\u90fd\u662f\u4e00\u500b\u90e8\u5206\u800c\u5df2\uff0c\u5b83\u6703\u7528\u5230\u975e\u5e38\u591a\u89c0\u5ff5\uff0c\u8907\u96dc\u5ea6\u9817\u9ad8\uff0c\u4f46\u505a\u51fa\u4f86\u7684\u6771\u897f\u537b\u5f88\u7c21\u55ae\uff0c\u6211\u5e0c\u671b\u9019\u6b21\u7528\u55ae\u7bc7\u6587\u7ae0\u5c31\u80fd\u4e00\u6b21\u628a\u6240\u6709\u6b65\u9a5f\u5217\u51fa\uff0c\u8b93\u5927\u5bb6\u53ef\u4ee5\u5728\u6700\u77ed\u7684\u6642\u9593\u70ba\u81ea\u5df1\u958b\u767c\u7684 APP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599\uff0c\u9019\u6a23\u5f8c\u7e8c\u8981\u505a\u5176\u4ed6\u8cc7\u6599\u5eab\u7684\u61c9\u7528\u5c31\u76f8\u5c0d\u7c21\u55ae\u975e\u5e38\u591a\uff01\u9019\u662f\u958b\u982d\uff0c\u975e\u5e38\u95dc\u9375\u7684\u4e00\u500b\u74f6\u9838\u9ede\uff0c\u76f8\u4fe1\u4e0d\u5c11\u4eba\u5361\u95dc\u65bc\u6b64\uff0c\u5e0c\u671b\u840c\u82bd\u7db2\u9801\u53ef\u4ee5\u5e6b\u52a9\u5230\u66f4\u591a\u4eba\u3002\u6211\u63a1\u7528 <a href=\"https:\/\/mnya.tw\/cc\/word\/tag\/android-studio\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Android Studio<\/strong><\/a> \u4f5c\u70ba\u958b\u767c\u8005\u5de5\u5177\u3002<\/p>\n<p>\u9019\u908a\u7a0d\u5fae\u89e3\u91cb\u4e00\u4e0b\uff0c\u56e0\u70ba APP \u4e3b\u8981\u662f\u96e2\u7dda\u529f\u80fd\u70ba\u4e3b\uff0c\u6240\u4ee5\u4e00\u65e6\u8981\u9023\u4e0a\u7db2\u8def\u4e26\u986f\u793a\u8cc7\u8a0a\uff0c\u5c31\u8981\u52d5\u7528\u5230\u6240\u8b02\u7684<strong>\u57f7\u884c\u7dd2\uff08Thread\uff09<\/strong>\uff0c\u907f\u514d APP \u70ba\u4e86\u7b49\u5f85\u7db2\u8def\u8cc7\u6e90\u5c0e\u81f4\u6574\u9ad4\u5ef6\u9072\u3002\u9700\u8981\u7528\u5230\u7db2\u8def\u7684\u57f7\u884c\u7dd2\u4e00\u822c\u7a31\u70ba\u300c\u5de5\u4f5c\u8005\u57f7\u884c\u7dd2\u300d\uff0c\u6211\u5011\u6703\u5728\u5167\u9023\u63a5\u8cc7\u6599\u5eab\u4e26\u53d6\u5f97\u9700\u8981\u7684\u8cc7\u6599\uff0c\u4f46\u662f\u82e5\u8981\u5c07\u9019\u4e9b\u8cc7\u6599\u986f\u793a\u5728 APP \u4e0a\uff0c\u9019\u5c31\u6703\u7528\u5230\u6240\u8b02\u7684\u300cUI \u57f7\u884c\u7dd2\u300d\uff0c\u4f46\u662f\u300c\u5de5\u4f5c\u8005\u57f7\u884c\u7dd2\u300d\u662f\u4e0d\u53ef\u4ee5\u76f4\u63a5\u57f7\u884c\u300cUI \u57f7\u884c\u7dd2\u300d\u6240\u57f7\u884c\u7684 UI \u5de5\u4f5c\uff0c\u9700\u8981\u900f\u904e <code>View.post(Runnable)<\/code> \u7684\u65b9\u6cd5\u4f86\u628a\u300c\u5de5\u4f5c\u8005\u57f7\u884c\u7dd2\u300d\u5167\u9700\u8981\u52d5\u5230 UI \u7684\u90e8\u5206\u5305\u8d77\u4f86\uff0c\u800c\u9019\u6bb5\u5305\u8d77\u4f86\u7684\u7a0b\u5f0f\u5247\u7531 UI \u57f7\u884c\u7dd2\u64cd\u7e31\uff0c\u9019\u6a23\u5c31\u4e0d\u6703\u5d29\u6f70\uff08Crash\uff09\u4e86\uff01\u5be6\u969b\u4e0a\u57f7\u884c\u8d77\u4f86\u5c31\u6703\u662f\u5148\u986f\u793a\u9810\u8a2d\u7684\u6587\u5b57\uff0c\u53ef\u80fd\u662f\u300c\u9023\u7dda\u4e2d\u300d\u5427\uff1f\u7136\u5f8c\u7b49\u5230\u8cc7\u6599\u5f9e\u7db2\u8def\u53d6\u5f97\u5f8c\u624d\u986f\u793a\u51fa\u4f86\u3002\u9019\u908a\u5c31\u8ddf\u7db2\u9801\u524d\u7aef\u5f88\u4e0d\u4e00\u6a23\uff0c\u7ad9\u9577\u5b78\u5230\u4e0d\u5c11\u3002<\/p>\n<p>\u4e8b\u5148\u8acb\u5148\u5efa\u7acb\u4e00\u500b APP \u8981\u9023\u7dda\u7684 MySQL \u8cc7\u6599\u5eab\uff0c\u9019\u908a\u63a8\u85a6\u4e00\u500b\u7dda\u4e0a\u6e2c\u8a66\u7528\u7684 MySQL \u8cc7\u6599\u5eab<a href=\"https:\/\/www.db4free.net\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u300cdb4free\u300d<\/a>\uff0c\u514d\u8cbb\u8a3b\u518a\u99ac\u4e0a\u555f\u7528\uff01\u8cc7\u6599\u5eab\u5167\u8981\u6709\u4e00\u500b\u8cc7\u6599\u8868\u540d\u70ba\u300ctest\u300d\uff0c\u7136\u5f8c\u6709\u5169\u500b\u6b04\u4f4d\uff0c\u5206\u5225\u662f\u300cid\u300d\u8207\u300cname\u300d\uff0c\u7136\u5f8c\u5b58\u653e\u591a\u7b46\u8cc7\u6599\u9032\u53bb\uff0c\u5230\u6642\u5019\u5c31\u53ef\u4ee5\u53d6\u51fa\u9019\u4e9b\u8cc7\u6599\u5566\uff01\u5982\u679c\u4e0d\u60f3\u8981\u624b\u52d5\u5efa\u7acb\uff0c\u9019\u908a\u4e5f\u8cbc\u5fc3\u63d0\u4f9b SQL \u78bc\u7d66\u5404\u4f4d\u5feb\u901f\u751f\u6210\u8cc7\u6599\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-sql\">SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";\r\nSET AUTOCOMMIT = 0;\r\nSTART TRANSACTION;\r\nSET time_zone = \"+00:00\";\r\n\r\nDROP TABLE IF EXISTS `test`;\r\nCREATE TABLE `test` (\r\n  `id` int(11) NOT NULL,\r\n  `name` text NOT NULL\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;\r\n\r\nINSERT INTO `test` (`id`, `name`) VALUES\r\n(1, 'XXX'),\r\n(2, 'OOO');\r\nCOMMIT;<\/code><\/pre>\n<blockquote>\n<h1><span style=\"color: #800000;\"><a id=\"index\"><\/a>\ud83d\udc4b \u6240\u6709\u6b65\u9a5f\uff1a<\/span><\/h1>\n<p>\ud83d\udc49 <a href=\"#ch1\">\u7b2c\u4e00\u6b65\uff1a\u5275\u5efa\u4e00\u500b\u5168\u65b0\u7684\u7a7a\u5c08\u6848<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch2\">\u7b2c\u4e8c\u6b65\uff1aXML\uff08UI\uff09\u7684\u78ba\u8a8d<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch3\">\u7b2c\u4e09\u6b65\uff1alibs \u76ee\u9304\u4e2d\u5b89\u88dd JDBC \u9a45\u52d5<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch4\">\u7b2c\u56db\u6b65\uff1a\u4f7f APP \u53d6\u5f97\u9023\u63a5\u7db2\u8def\u7684\u6b0a\u9650<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch5\">\u7b2c\u4e94\u6b65\uff1a\u5efa\u7acb\u300cMysqlCon.java\u300d\uff0c\u64b0\u5beb\u6709\u95dc\u8cc7\u6599\u5eab\u9023\u7dda\u7684\u7a0b\u5f0f<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch6\">\u7b2c\u516d\u6b65\uff1a\u805a\u7126\u300cMainActivity.java\u300d\uff0c\u57f7\u884c\u7dd2\u8207 UI \u986f\u793a\u8cc7\u8a0a<\/a><br \/>\n\ud83d\udc49 <a href=\"#ch7\">\u7b2c\u4e03\u6b65\uff1a\u6a21\u64ec\u5668\u6e2c\u8a66\u3001\u5be6\u9ad4\u624b\u6a5f\u6e2c\u8a66<\/a><\/p><\/blockquote>\n<h1><span style=\"color: #000080;\"><a id=\"ch1\"><\/a>\ud83d\udc49 \u7b2c\u4e00\u6b65\uff1a\u5275\u5efa\u4e00\u500b\u5168\u65b0\u7684\u7a7a\u5c08\u6848<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p>\u6211\u5011\u4f7f\u7528 JAVA \u4f5c\u70ba\u9810\u8a2d\u64b0\u5beb APP \u7684\u7a0b\u5f0f\u8a9e\u8a00\uff0c\u5efa\u7acb\u6642\u9078\u64c7<strong>\u300c\u7a7a\u6d3b\u52d5\uff08Empty Activity\uff09\u300d<\/strong>\u6a21\u677f\uff0c\u53ef\u4ee5\u53c3\u8003<a href=\"https:\/\/mnya.tw\/cc\/word\/1455.html\" target=\"_blank\" rel=\"noopener noreferrer\">\u300aAndroid Studio\uff1a\u4e0b\u8f09\u3001\u5b89\u88dd\u8207\u5275\u5efa\u4e00\u500b\u57fa\u65bc Kotlin \u8a9e\u8a00\u7684 APP \u5c08\u6848\u300b<\/a>\u6587\u7ae0\u7684\u8aaa\u660e\u5275\u5efa\u5c08\u6848\uff0c\u4e0d\u904e\u8acb\u81ea\u884c\u628a Kotlin \u8f49 JAVA\uff08\u61f6\u5f97\u518d\u5beb\u4e00\u7bc7 \ud83d\ude1b\uff09\u3002<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch2\"><\/a>\ud83d\udc49 \u7b2c\u4e8c\u6b65\uff1aXML\uff08UI\uff09\u7684\u78ba\u8a8d<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-1.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u57fa\u672c\u4e0a\u5275\u5efa\u597d\u7684\u7a7a\u5c08\u6848\u6703\u6709\u500b TextView \u5143\u4ef6\u5728\u756b\u9762\u6b63\u4e2d\u592e\uff0c\u4e0a\u982d\u6709\u300cHello World!\u300d\u7684\u5b57\u6a23\uff0c\u8acb\u78ba\u8a8d\u5b83\u6709 ID\uff0c\u6c92\u6709\u7684\u8a71\u5e6b\u5b83\u8a2d\u4e00\u500b ID\uff0c\u6211\u662f\u8a2d\u7f6e\u6210 <code>android:id=\"@+id\/text_view\"<\/code>\uff0c\u56e0\u70ba\u63a5\u4e0b\u4f86\u6211\u5011\u5f9e MySQL \u8cc7\u6599\u5eab\u53d6\u51fa\u7684\u8cc7\u6599\u8868\u8cc7\u6599\u5c31\u6703\u986f\u793a\u5728\u9019\u500b UI \u5143\u4ef6\u4e0a\u3002<\/p>\n<p>\u6574\u9ad4\u4e0a UI \u90fd\u662f\u7528\u73fe\u6210\u7684\uff0c\u56e0\u70ba\u9019\u7bc7\u6587\u7ae0\u7684\u76ee\u6a19\u4e5f\u53ea\u662f\u6293\u8cc7\u6599\u800c\u5df2\uff0cUI \u6839\u672c\u4e0d\u9700\u8981\u53bb\u6539\u5b83\u3002<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch3\"><\/a>\ud83d\udc49 \u7b2c\u4e09\u6b65\uff1alibs \u76ee\u9304\u4e2d\u5b89\u88dd JDBC \u9a45\u52d5<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-2.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u56e0\u70ba\u662f JAVA \u7a0b\u5f0f\u8981\u9023\u63a5 MySQL \u8cc7\u6599\u5eab\uff0c\u6240\u4ee5 JDBC \u9a45\u52d5\u662f\u5fc5\u8981\u7684\uff0c\u8acb\u81f3<a href=\"https:\/\/dev.mysql.com\/downloads\/connector\/j\/\" target=\"_blank\" rel=\"noopener noreferrer\">\u5b98\u65b9\u7db2\u7ad9<\/a>\u4e0b\u8f09\uff0c\u5efa\u8b70\u4f7f\u7528\u820a\u7248\u6bd4\u8f03\u4e0d\u6703\u932f\uff0c\u4e0b\u8f09\u5f8c\u662f\u500b\u58d3\u7e2e\u6a94\uff0c\u89e3\u58d3\u7e2e\u5f8c\u627e\u6839\u76ee\u9304\u5167\u7684\u300c\ud83d\udcc4 mysql-connector-java-x.x.xx-bin.jar\u300d\uff0c\u300cx.x.xx\u300d\u662f\u7248\u672c\u865f\u78bc\uff0c\u8209\u4f8b\u4f86\u8aaa\u6211\u5c31\u662f\u62ff\u300c\ud83d\udcc4 mysql-connector-java-5.1.48-bin.jar\u300d\u4f86\u7528\uff0c\u8acb\u5c07\u9019\u500b\u6a94\u6848\u653e\u5165\u300c\ud83d\udcc1 \u5c08\u6848\u76ee\u9304\/app\/libs\u300d\u4e2d\uff0c\u9019\u6a23\u5c31\u53ef\u4ee5\u4f7f\u7528\u9a45\u52d5\u4e86\uff01\u81f3\u65bc\u70ba\u4ec0\u9ebc\u662f\u653e\u5728 \ud83d\udcc1 libs \u76ee\u9304\u4e2d\uff0c\u5927\u5bb6\u53ef\u4ee5\u5230 APP \u7684 build.gradle \u4e2d\u770b\u5230\u4ee5\u4e0b\u8a2d\u5b9a\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-markup\">implementation fileTree(dir: 'libs', include: ['*.jar'])<\/code><\/pre>\n<p>\u9019\u662f\u9810\u8a2d\u7684\u8def\u5f91\uff0c\u56e0\u6b64\u9a45\u52d5\u90fd\u653e\u5728 \ud83d\udcc1 libs \u76ee\u9304\u4e2d\u3002<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch4\"><\/a>\ud83d\udc49 \u7b2c\u56db\u6b65\uff1a\u4f7f APP \u53d6\u5f97\u9023\u63a5\u7db2\u8def\u7684\u6b0a\u9650<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-3.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u70ba\u4e86\u8b93 APP \u53d6\u5f97\u7db2\u8def\u9023\u7dda\u7684\u6b0a\u9650\uff0c\u8acb\u6253\u958b\u300cAndroidManifest.xml\u300d\uff08\u5728 \ud83d\udcc1 manifest \u76ee\u9304\u4e2d\uff09\uff0c\u4e26\u5728 &lt;manifest&gt; \u5230 &lt;\/manifest&gt; \u4e2d\u52a0\u5165\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-markup\">&lt;uses-permission android:name=\"android.permission.INTERNET\"&gt;&lt;\/uses-permission&gt;<\/code><\/pre>\n<p>\u9019\u6a23\u5c31\u53ef\u4ee5\u81ea\u52d5\u53d6\u5f97\u7db2\u8def\u9023\u7dda\u7684\u6b0a\u9650\u56c9\uff01<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch5\"><\/a>\ud83d\udc49 \u7b2c\u4e94\u6b65\uff1a\u5efa\u7acb\u300cMysqlCon.java\u300d\uff0c\u64b0\u5beb\u6709\u95dc\u8cc7\u6599\u5eab\u9023\u7dda\u7684\u7a0b\u5f0f<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-4.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u5efa\u7acb\u4e00\u500b\u300cMysqlCon.java\u300d\uff0c\u88e1\u9762\u64b0\u5beb\u6709\u95dc\u8cc7\u6599\u5eab\u9023\u7dda\u8207\u8b80\u53d6\u8cc7\u6599\u76f8\u7576\u7684 JAVA \u7a0b\u5f0f\uff0c\u6700\u5f8c\u6703\u5728\u300c\u7b2c\u516d\u6b65\u300d\u4f7f\u7528\u57f7\u884c\u7dd2\u4f86\u8dd1\u9019\u88e1\u7684\u7a0b\u5f0f\u78bc\uff0c\u9019\u6a23\u5c31\u53ef\u4ee5\u9023\u63a5\u6307\u5b9a MySQL \u8cc7\u6599\u5eab\uff0c\u4e26\u4e14\u5f9e\u4e2d\u53d6\u5f97\u6307\u4ee4\u8cc7\u6599\u8868\u5167\u6240\u6709\u7b46\u8cc7\u6599\u3002<\/p><div class=\"3a456c955cc9861673f62d33beb7714e\" data-index=\"2\" style=\"float: none; margin:0px;\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-2683739050533486\"\r\n     crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle\"\r\n     style=\"display:block; text-align:center;\"\r\n     data-ad-layout=\"in-article\"\r\n     data-ad-format=\"fluid\"\r\n     data-ad-client=\"ca-pub-2683739050533486\"\r\n     data-ad-slot=\"3270345536\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n\n<p>\u203b \u8acb\u5c07\u300cMysqlCon.java\u300d\u5efa\u7acb\u5728\u300c\ud83d\udcc1 java\/\u5c08\u6848\u540d\u7a31\u300d\u4e0b\uff0c\u4e5f\u5c31\u662f \ud83d\udcc4 MainActivity.java \u65c1\u3002<\/p>\n<p>\u63a5\u4e0b\u4f86\u5c31\u76f4\u63a5\u79c0\u51fa\u6240\u6709\u7684 JAVA \u7a0b\u5f0f\u78bc\uff0c\u7a0d\u5f8c\u518d\u7c21\u77ed\u6558\u8ff0\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-java\">package com.example.mysql_connect;\r\n\r\nimport android.util.Log;\r\n\r\nimport java.sql.Connection;\r\nimport java.sql.DriverManager;\r\nimport java.sql.ResultSet;\r\nimport java.sql.SQLException;\r\nimport java.sql.Statement;\r\n\r\npublic class MysqlCon {\r\n\r\n    \/\/ \u8cc7\u6599\u5eab\u5b9a\u7fa9\r\n    String mysql_ip = \"\u8cc7\u6599\u5eabIP\";\r\n    int mysql_port = 3306; \/\/ Port \u9810\u8a2d\u70ba 3306\r\n    String db_name = \"\u8cc7\u6599\u5eab\u540d\u7a31\";\r\n    String url = \"jdbc:mysql:\/\/\"+mysql_ip+\":\"+mysql_port+\"\/\"+db_name;\r\n    String db_user = \"\u4f7f\u7528\u8005\u540d\u7a31\";\r\n    String db_password = \"\u4f7f\u7528\u8005\u5bc6\u78bc\";\r\n\r\n    public void run() {\r\n        try {\r\n            Class.forName(\"com.mysql.jdbc.Driver\");\r\n            Log.v(\"DB\",\"\u52a0\u8f09\u9a45\u52d5\u6210\u529f\");\r\n        }catch( ClassNotFoundException e) {\r\n            Log.e(\"DB\",\"\u52a0\u8f09\u9a45\u52d5\u5931\u6557\");\r\n            return;\r\n        }\r\n\r\n        \/\/ \u9023\u63a5\u8cc7\u6599\u5eab\r\n        try {\r\n            Connection con = DriverManager.getConnection(url,db_user,db_password);\r\n            Log.v(\"DB\",\"\u9060\u7aef\u9023\u63a5\u6210\u529f\");\r\n            }catch(SQLException e) {\r\n            Log.e(\"DB\",\"\u9060\u7aef\u9023\u63a5\u5931\u6557\");\r\n            Log.e(\"DB\", e.toString());\r\n        }\r\n    }\r\n\r\n    public String getData() {\r\n        String data = \"\";\r\n        try {\r\n            Connection con = DriverManager.getConnection(url, db_user, db_password);\r\n            String sql = \"SELECT * FROM test\";\r\n            Statement st = con.createStatement();\r\n            ResultSet rs = st.executeQuery(sql);\r\n\r\n            while (rs.next())\r\n            {\r\n            String id = rs.getString(\"id\");\r\n            String name = rs.getString(\"name\");\r\n            data += id + \", \" + name + \"\\n\";\r\n            }\r\n            st.close();\r\n        } catch (SQLException e) {\r\n            e.printStackTrace();\r\n        }\r\n        return data;\r\n    }\r\n\r\n\r\n}<\/code><\/pre>\n<p>\u6700\u524d\u9762\u7684 package \u8207 import \u5176\u5be6\u4e0d\u7528\u81ea\u5df1\u5148\u6253\uff08\u8907\u88fd\uff09\u9032\u53bb\u7a0b\u5f0f\u6a94\u5167\uff0c\u56e0\u70ba\u63a5\u4e0b\u4f86\u7684\u7a0b\u5f0f IDE\uff08Android Studio\uff09 \u6703\u81ea\u52d5\u5075\u6e2c\u7f3a\u5c11\u5957\u4ef6\uff0c\u5c31\u6703\u53eb\u4f60\u7528\u9375\u76e4<strong> Alt + Enter<\/strong> \u81ea\u52d5\u5f15\u5165\uff0c\u975e\u5e38\u65b9\u4fbf\uff01<\/p>\n<p>\u8cc7\u6599\u5eab\u5b9a\u7fa9\u90e8\u5206\u8981\u5148\u628a\u8cc7\u6599\u5eab IP\u3001\u8cc7\u6599\u5eab Port\u3001\u8cc7\u6599\u5eab\u540d\u7a31\u3001\u8cc7\u6599\u5eab Url\u3001\u4f7f\u7528\u8005\u540d\u7a31\u8207\u5bc6\u78bc\u5b9a\u7fa9\u597d\uff0c\u63a5\u8457\u5728 <code>run()<\/code> \u65b9\u6cd5\u4e2d\u6e2c\u8a66 JDBC \u9a45\u52d5\u662f\u5426\u904b\u4f5c\u3001MySQL \u8cc7\u6599\u5eab\u662f\u5426\u6b63\u5e38\u9023\u7dda\u3002\u9019\u908a\u90fd\u6703\u7528 Log \u4f86 Debug\uff0c\u5728 Android Studio \u4e2d\u53ef\u4ee5\u5728\u4e0b\u65b9 Logcat \u4e2d\u67e5\u770b\u3002<\/p>\n<p><code>getData()<\/code> \u65b9\u6cd5\u662f\u8981\u53d6\u5f97 test \u8cc7\u6599\u8868\u4e2d\u7684\u6bcf\u7b46\u8cc7\u6599\uff0c\u56e0\u6b64 JAVA \u4e2d\u5c31\u6709\u6558\u8ff0\u6b04\u4f4d\u7684\u53d6\u51fa\u8207\u532f\u51fa\u683c\u5f0f\uff0c\u6700\u5f8c\u4ee5 <code>String data<\/code> \u56de\u50b3\u3002<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch6\"><\/a>\ud83d\udc49 \u7b2c\u516d\u6b65\uff1a\u805a\u7126\u300cMainActivity.java\u300d\uff0c\u57f7\u884c\u7dd2\u8207 UI \u986f\u793a\u8cc7\u8a0a<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-5.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u63a5\u4e0b\u4f86\u8981\u4f86\u5beb\u4e3b\u7a0b\u5f0f\u5566\uff01\u805a\u7126\u300cMainActivity.java\u300d\uff0c\u6211\u5011\u8981\u7528\u57f7\u884c\u7dd2\u4f86\u57f7\u884c\u525b\u525b\u5beb\u597d\u7684\u300cMysqlCon.java\u300d\uff0c\u4e26\u7528\u524d\u6587\u6240\u63d0\u5230\u7684\u65b9\u5f0f\u4f86\u64cd\u4f5c UI\uff0c\u8b93 UI \u53ef\u4ee5\u986f\u793a\u4f86\u81ea\u7db2\u8def\u7684\u8cc7\u8a0a\uff0c\u9996\u5148\u5148\u544a\u8a34\u5404\u4f4d\u63a5\u4e0b\u4f86\u8981\u5beb\u7a0b\u5f0f\u7684\u5340\u584a\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-java\">protected void onCreate(Bundle savedInstanceState) {\r\n    super.onCreate(savedInstanceState);\r\n    setContentView(R.layout.activity_main);\r\n    \/\/ \u5beb\u5728\u9019\u88e1\r\n}<\/code><\/pre>\n<p>\u63a5\u4e0b\u4f86\u5c31\u662f\u5b8c\u6574\u7684\u57f7\u884c\u7dd2 JAVA \u7a0b\u5f0f\u78bc\uff1a<\/p>\n<pre class=\"line-numbers\"><code class=\"language-java\">final TextView text_view = (TextView) findViewById(R.id.text_view);\r\n\r\n        new Thread(new Runnable(){\r\n            @Override\r\n            public void run(){\r\n                MysqlCon con = new MysqlCon();\r\n                con.run();\r\n                final String data = con.getData();\r\n                Log.v(\"OK\",data);\r\n                text_view.post(new Runnable() {\r\n                    public void run() {\r\n                        text_view.setText(data);\r\n                    }\r\n                });\r\n\r\n            }\r\n        }).start();<\/code><\/pre>\n<p>\u7b2c\u4e00\u884c\u8981\u5148\u5efa\u7acb text_view \u5143\u4ef6\uff0c\u63a5\u4e0b\u4f86\u624d\u80fd\u64cd\u4f5c\u5b83\u4f86\u986f\u793a\u8cc7\u6599\u3002<\/p>\n<p><code>con.run();<\/code> \u5c31\u662f\u57f7\u884c\u300cMysqlCon.java\u300d\u4e2d\u7684 <code>run()<\/code> \u65b9\u6cd5\uff1b<code>con.getData();<\/code> \u5c31\u662f\u57f7\u884c\u300cMysqlCon.java\u300d\u4e2d\u7684<code> getData()<\/code> \u65b9\u6cd5\u3002<code>Log.v(\"OK\",data)<\/code>; \u53ef\u5728 Android Studio \u4e2d\u4e0b\u65b9 Logcat \u4e2d\u67e5\u770b\u53d6\u51fa\u7684\u8cc7\u6599\u3002<code>text_view.post(new Runnable() { ... }<\/code> \u90e8\u5206\u5c31\u662f\u524d\u6587\u63d0\u5230\u7684 <code>View.post(Runnable)<\/code> \uff0c\u4e5f\u5c31\u662f\u628a\u300c\u5de5\u4f5c\u8005\u57f7\u884c\u7dd2\u300d\u5167\u9700\u8981\u52d5\u5230 UI \u7684\u90e8\u5206\u5305\u8d77\u4f86\uff0c\u800c\u9019\u6bb5\u5305\u8d77\u4f86\u7684\u7a0b\u5f0f\u5247\u7531 UI \u57f7\u884c\u7dd2\u64cd\u7e31\uff0c\u4e5f\u5c31\u662f\u7a0b\u5f0f\u78bc\u4e2d\u7684 <code>text_view.setText(data);<\/code>\uff0c\u9019\u5c31\u53ef\u4ee5\u66ff\u63db\u6389\u539f\u4f86\u300cHello World!\u300d\u7684\u5b57\u6a23\u3002<\/p>\n<h1><span style=\"color: #000080;\"><a id=\"ch7\"><\/a>\ud83d\udc49 \u7b2c\u4e03\u6b65\uff1a\u6a21\u64ec\u5668\u6e2c\u8a66\u3001\u5be6\u9ad4\u624b\u6a5f\u6e2c\u8a66<\/span> <a href=\"#index\">\u23cf\ufe0f<\/a><\/h1>\n<p>\u9019\u908a\u53ef\u4ee5\u53c3\u8003\u9019\u5169\u7bc7\u6587\u7ae0\uff1a<\/p>\n<p><a href=\"https:\/\/mnya.tw\/cc\/word\/1456.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>\ud83d\udcdd Android Studio\uff1a\u5efa\u7acb\u865b\u64ec\u8a2d\u5099\uff08\u6a21\u64ec\u5668\uff09\u3001\u904b\u884c\u958b\u767c\u4e2d\u7684 APP \u5728\u6a21\u64ec\u5668\u4e0a<\/strong><\/a><br \/>\n<a href=\"https:\/\/mnya.tw\/cc\/word\/1458.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>\ud83d\udcdd Android Studio\uff1a\u5c07\u958b\u767c\u4e2d\u7684 APP \u5b89\u88dd\u5230\u624b\u6a5f\u4e0a\u6559\u5b78\uff08USB \u5075\u932f\u6a21\u5f0f\uff09<\/strong><\/a><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-6.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u6a21\u64ec\u5668\u8dd1\u525b\u525b\u5beb\u597d\u7684 APP\uff0c\u6253\u958b\u5f8c\u6703\u5148\u986f\u793a\u9810\u8a2d\u7684\u300cHello World!\u300d\u5b57\u6a23\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg\" width=\"1024\" height=\"768\" \/><br \/>\n\u25b2 \u63a5\u8457\u4e0b\u65b9 Logcat \u4e2d\u51fa\u73fe\u9023\u63a5\u6210\u529f\u8207\u8cc7\u6599\uff0c\u6a21\u64ec\u5668\u4e2d\u7684 APP \u4e5f\u6703\u8ddf\u8457\u986f\u793a\u5f9e MySQL \u8cc7\u6599\u5eab\u4e2d\u53d6\u51fa\u7684\u8cc7\u6599\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-8.jpg\" width=\"864\" height=\"768\" \/><br \/>\n\u25b2 \u5be6\u969b\u624b\u6a5f\u4e0a\u57f7\u884c APP \u4e5f\u662f\u4e00\u6a23\uff0c\u5148\u986f\u793a\u9810\u8a2d\u6587\u5b57\uff0c\u7b49\u6293\u5230\u8cc7\u6599\u518d\u628a\u9810\u8a2d\u6587\u5b57\u66ff\u63db\u6389\u3002<\/p>\n<p>\u6b64\u7bc7\u6587\u7ae0\u70ba\u7b46\u8a18\u6587\uff0c\u53ef\u80fd\u6709\u4e0d\u5c11\u932f\u8aa4\uff0c\u9700\u8981\u7279\u5225\u6ce8\u610f\uff01\u4f46\u9084\u662f\u6b61\u8fce\u5927\u5bb6\u53c3\u8003 \ud83d\ude0a\u3002<\/p>\n<p><a href=\"https:\/\/mnya.tw\/cc\/word\/1481.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>\u300a\u5ef6\u4f38\u7bc7\uff1aAndroid Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u5beb\u5165\u8cc7\u6599\u5f8c\u66f4\u65b0\u756b\u9762\u300b<\/strong><\/a><\/p>\n<div id=\"gtx-trans\" style=\"position: absolute; left: -67px; top: 10677.8px;\">\n<div class=\"gtx-trans-icon\"><\/div>\n<\/div>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>\u4eca\u5929\u662f\u6211\u9019\u6bb5\u6642\u9593\u5fc3\u60c5\u6700\u5dee\u7684\u4e00\u5929\uff0c\u4f46\u4e5f\u56e0\u70ba\u4e0d\u65b7\u7684\u5931\u6557\uff0c\u665a\u9593\u7d42\u65bc\u7814\u7a76\u51fa\u4f86\u9019\u7bc7\u6587\u7ae0\u7684\u6210\u679c\uff0c\u7db2\u4e0a\u95dc\u65bc Android APP \u8981\u4f7f\u7528 JDBC \u76f4\u63a5\u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u53d6\u51fa\u8cc7\u6599\u7684\u5b8c\u6574\u6027\u6587\u7ae0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10232,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16,481,14,503,38,498,518],"tags":[519],"class_list":["post-10224","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software-application","category-mobile-os","category-code","category-database","category-android","category-java","category-app-development","tag-android-studio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mnya.tw\/cc\/word\/1480.html\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801\" \/>\n<meta property=\"og:description\" content=\"\u4eca\u5929\u662f\u6211\u9019\u6bb5\u6642\u9593\u5fc3\u60c5\u6700\u5dee\u7684\u4e00\u5929\uff0c\u4f46\u4e5f\u56e0\u70ba\u4e0d\u65b7\u7684\u5931\u6557\uff0c\u665a\u9593\u7d42\u65bc\u7814\u7a76\u51fa\u4f86\u9019\u7bc7\u6587\u7ae0\u7684\u6210\u679c\uff0c\u7db2\u4e0a\u95dc\u65bc Android APP \u8981\u4f7f\u7528 JDBC \u76f4\u63a5\u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u53d6\u51fa\u8cc7\u6599\u7684\u5b8c\u6574\u6027\u6587\u7ae0 [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mnya.tw\/cc\/word\/1480.html\" \/>\n<meta property=\"og:site_name\" content=\"\u840c\u82bd\u7d9c\u5408\u5929\u5730\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-05T13:55:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-20T13:13:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"768\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"\u840c\u82bd\u7ad9\u9577\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/x.com\/qwe987299\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005:\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u840c\u82bd\u7ad9\u9577\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9810\u4f30\u95b1\u8b80\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html\"},\"author\":{\"name\":\"\u840c\u82bd\u7ad9\u9577\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\"},\"headline\":\"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599\",\"datePublished\":\"2019-10-05T13:55:16+00:00\",\"dateModified\":\"2021-10-20T13:13:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html\"},\"wordCount\":170,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1480-7.jpg\",\"keywords\":[\"Android Studio\"],\"articleSection\":[\"\u8edf\u9ad4\u61c9\u7528\",\"\u884c\u52d5\u5e73\u53f0\",\"\u7a0b\u5f0f\u8a2d\u8a08\",\"\u8cc7\u6599\u5eab\",\"Android\",\"JAVA\",\"APP\u958b\u767c\"],\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html\",\"name\":\"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1480-7.jpg\",\"datePublished\":\"2019-10-05T13:55:16+00:00\",\"dateModified\":\"2021-10-20T13:13:34+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#primaryimage\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1480-7.jpg\",\"contentUrl\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/wp-content\\\/uploads\\\/2019\\\/1480-7.jpg\",\"width\":1024,\"height\":768},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/1480.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\\\/\\\/mnya.tw\\\/cc\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#website\",\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/\",\"name\":\"\u840c\u82bd\u7d9c\u5408\u5929\u5730\",\"description\":\"\u751f\u6d3b\u4f11\u9592\u2502\u96fb\u5b50\u8cc7\u8a0a\u2502\u5b78\u8853\u77e5\u8b58\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/#\\\/schema\\\/person\\\/28e9ae25bc418b8ec216b7aa2c848faa\",\"name\":\"\u840c\u82bd\u7ad9\u9577\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g\",\"caption\":\"\u840c\u82bd\u7ad9\u9577\"},\"description\":\"\u60a8\u597d\uff0c\u6211\u662f\u840c\u82bd\u7cfb\u5217\u7db2\u7ad9\uff08Mnya Series Website\uff09\u7684\u7ad9\u9577&amp;\u5275\u59cb\u4eba\uff0c\u53ef\u4ee5\u7a31\u547c\u6211\u300c\u840c\u82bd\u7ad9\u9577\u300d\u3002\u6211\u7684\u8208\u8da3\u8207\u5c08\u9577\u6709\u767b\u5c71\u3001\u89c0\u5bdf\u5730\u5f62\u3001\u651d\u5f71\u3001\u65c5\u904a\u3001\u7db2\u9801\u8a2d\u8a08\uff06\u67b6\u8a2d\uff06\u7d93\u71df\u3001\u52d5\u756b\u88fd\u4f5c\u3001\u5716\u7247\u8655\u7406\u3001\u8cc7\u6599\u5f59\u6574\u7b49\u3002\u6709\u4efb\u4f55\u554f\u984c\u6216\u5efa\u8b70\u8acb\u81f3\u840c\u82bd\u8ad6\u58c7\u767c\u8868\u3002\u7db2\u7ad9\u696d\u52d9\u3001\u5546\u696d\u5408\u4f5c\u7684\u806f\u7d61\u65b9\u5f0f\u5728\u300c\u95dc\u65bc\u672c\u7ad9 \u2192 \u5718\u968a\u4ecb\u7d39 \u2192 \u7ad9\u9577\u4ecb\u7d39\u300d\uff0c\u5f88\u9ad8\u8208\u8a8d\u8b58\u60a8\uff01\u8acb\u591a\u6307\u6559\uff01\",\"sameAs\":[\"https:\\\/\\\/mnya.tw\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/x.com\\\/qwe987299\"],\"url\":\"https:\\\/\\\/mnya.tw\\\/cc\\\/word\\\/author\\\/qwe987299\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mnya.tw\/cc\/word\/1480.html","og_locale":"zh_TW","og_type":"article","og_title":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","og_description":"\u4eca\u5929\u662f\u6211\u9019\u6bb5\u6642\u9593\u5fc3\u60c5\u6700\u5dee\u7684\u4e00\u5929\uff0c\u4f46\u4e5f\u56e0\u70ba\u4e0d\u65b7\u7684\u5931\u6557\uff0c\u665a\u9593\u7d42\u65bc\u7814\u7a76\u51fa\u4f86\u9019\u7bc7\u6587\u7ae0\u7684\u6210\u679c\uff0c\u7db2\u4e0a\u95dc\u65bc Android APP \u8981\u4f7f\u7528 JDBC \u76f4\u63a5\u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u53d6\u51fa\u8cc7\u6599\u7684\u5b8c\u6574\u6027\u6587\u7ae0 [&hellip;]","og_url":"https:\/\/mnya.tw\/cc\/word\/1480.html","og_site_name":"\u840c\u82bd\u7d9c\u5408\u5929\u5730","article_published_time":"2019-10-05T13:55:16+00:00","article_modified_time":"2021-10-20T13:13:34+00:00","og_image":[{"width":1024,"height":768,"url":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg","type":"image\/jpeg"}],"author":"\u840c\u82bd\u7ad9\u9577","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/x.com\/qwe987299","twitter_misc":{"\u4f5c\u8005:":"\u840c\u82bd\u7ad9\u9577","\u9810\u4f30\u95b1\u8b80\u6642\u9593":"2 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#article","isPartOf":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html"},"author":{"name":"\u840c\u82bd\u7ad9\u9577","@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa"},"headline":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599","datePublished":"2019-10-05T13:55:16+00:00","dateModified":"2021-10-20T13:13:34+00:00","mainEntityOfPage":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html"},"wordCount":170,"commentCount":0,"image":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#primaryimage"},"thumbnailUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg","keywords":["Android Studio"],"articleSection":["\u8edf\u9ad4\u61c9\u7528","\u884c\u52d5\u5e73\u53f0","\u7a0b\u5f0f\u8a2d\u8a08","\u8cc7\u6599\u5eab","Android","JAVA","APP\u958b\u767c"],"inLanguage":"zh-TW","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mnya.tw\/cc\/word\/1480.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mnya.tw\/cc\/word\/1480.html","url":"https:\/\/mnya.tw\/cc\/word\/1480.html","name":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599 - \u840c\u82bd\u7d9c\u5408\u5929\u5730 - \u840c\u82bd\u7db2\u9801","isPartOf":{"@id":"https:\/\/mnya.tw\/cc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#primaryimage"},"image":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#primaryimage"},"thumbnailUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg","datePublished":"2019-10-05T13:55:16+00:00","dateModified":"2021-10-20T13:13:34+00:00","author":{"@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa"},"breadcrumb":{"@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mnya.tw\/cc\/word\/1480.html"]}]},{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#primaryimage","url":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg","contentUrl":"https:\/\/mnya.tw\/cc\/wp-content\/uploads\/2019\/1480-7.jpg","width":1024,"height":768},{"@type":"BreadcrumbList","@id":"https:\/\/mnya.tw\/cc\/word\/1480.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/mnya.tw\/cc"},{"@type":"ListItem","position":2,"name":"Android Studio\uff1aAPP \u4f7f\u7528 JDBC \u9023\u63a5 MySQL \u8cc7\u6599\u5eab\u4e26\u8b80\u53d6\u6307\u5b9a\u8cc7\u6599\u8868\u4e2d\u6240\u6709\u8cc7\u6599"}]},{"@type":"WebSite","@id":"https:\/\/mnya.tw\/cc\/#website","url":"https:\/\/mnya.tw\/cc\/","name":"\u840c\u82bd\u7d9c\u5408\u5929\u5730","description":"\u751f\u6d3b\u4f11\u9592\u2502\u96fb\u5b50\u8cc7\u8a0a\u2502\u5b78\u8853\u77e5\u8b58","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mnya.tw\/cc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"zh-TW"},{"@type":"Person","@id":"https:\/\/mnya.tw\/cc\/#\/schema\/person\/28e9ae25bc418b8ec216b7aa2c848faa","name":"\u840c\u82bd\u7ad9\u9577","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63875472a671bb4fd1e3a1012e8ef8bb9672b41d7810b61f508a42ad15ef16a?s=96&d=mm&r=g","caption":"\u840c\u82bd\u7ad9\u9577"},"description":"\u60a8\u597d\uff0c\u6211\u662f\u840c\u82bd\u7cfb\u5217\u7db2\u7ad9\uff08Mnya Series Website\uff09\u7684\u7ad9\u9577&amp;\u5275\u59cb\u4eba\uff0c\u53ef\u4ee5\u7a31\u547c\u6211\u300c\u840c\u82bd\u7ad9\u9577\u300d\u3002\u6211\u7684\u8208\u8da3\u8207\u5c08\u9577\u6709\u767b\u5c71\u3001\u89c0\u5bdf\u5730\u5f62\u3001\u651d\u5f71\u3001\u65c5\u904a\u3001\u7db2\u9801\u8a2d\u8a08\uff06\u67b6\u8a2d\uff06\u7d93\u71df\u3001\u52d5\u756b\u88fd\u4f5c\u3001\u5716\u7247\u8655\u7406\u3001\u8cc7\u6599\u5f59\u6574\u7b49\u3002\u6709\u4efb\u4f55\u554f\u984c\u6216\u5efa\u8b70\u8acb\u81f3\u840c\u82bd\u8ad6\u58c7\u767c\u8868\u3002\u7db2\u7ad9\u696d\u52d9\u3001\u5546\u696d\u5408\u4f5c\u7684\u806f\u7d61\u65b9\u5f0f\u5728\u300c\u95dc\u65bc\u672c\u7ad9 \u2192 \u5718\u968a\u4ecb\u7d39 \u2192 \u7ad9\u9577\u4ecb\u7d39\u300d\uff0c\u5f88\u9ad8\u8208\u8a8d\u8b58\u60a8\uff01\u8acb\u591a\u6307\u6559\uff01","sameAs":["https:\/\/mnya.tw\/","https:\/\/x.com\/https:\/\/x.com\/qwe987299"],"url":"https:\/\/mnya.tw\/cc\/word\/author\/qwe987299"}]}},"_links":{"self":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts\/10224","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/comments?post=10224"}],"version-history":[{"count":0,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/posts\/10224\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/media\/10232"}],"wp:attachment":[{"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/media?parent=10224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/categories?post=10224"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mnya.tw\/cc\/wp-json\/wp\/v2\/tags?post=10224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}