{"id":2663,"date":"2019-01-06T14:40:43","date_gmt":"2019-01-06T06:40:43","guid":{"rendered":"https:\/\/damogame.cn:15443\/wordpress\/?p=2663"},"modified":"2019-01-06T14:40:43","modified_gmt":"2019-01-06T06:40:43","slug":"go%e8%af%ad%e8%a8%80%e4%bd%bf%e7%94%a8mysql%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/i007.cc\/wordpress\/archives\/2663","title":{"rendered":"Go\u8bed\u8a00\u4f7f\u7528MySQL\u6570\u636e\u5e93"},"content":{"rendered":"<div class=\"author\"><\/div>\n<div class=\"show-content\" data-note-content=\"\">\n<div class=\"show-content-free\">\n<ul>\n<li>\u672c\u6587\u4e3b\u8981\u4ecb\u7ecd\u4f7f\u7528Go\u8bed\u8a00\u4f7f\u7528MySQL\u7684\u642d\u5efa\u5de5\u4f5c\uff0c\u9002\u5408\u79fb\u52a8\u7aef\u540c\u5b66\u81ea\u5df1\u5b66\u4e60Go\u8bed\u8a00\u73a9\u73a9<\/li>\n<li>\u524d\u6bb5\u65f6\u95f4\u64b8\u4e86\u4e00\u4e2a\u7b80\u5355Spring-boot\u7684Demo\uff0c\u6700\u8fd1\u5b66\u4e60\u4e86Go\u8bed\u8a00\u624d\u53d1\u73b0\uff0cGo\u505a\u8d77\u6765\u66f4\u52a0\u7684\u7b80\u5355\uff0c\u6211\u4e0d\u63a8\u5d07\uff0c\u4e0d\u5d07\u62dc\uff0c\u4f46\u662f\u6211\u8fd8\u5f97\u8bf4\u4e00\u53e5\uff0cGo\u8bed\u8a00\u771f\u597d\uff01\uff01\uff01<\/li>\n<\/ul>\n<h4>\u4e00\u3001\u642d\u5efaGo\u8bed\u8a00\u7684\u73af\u5883<\/h4>\n<ul>\n<li>\u5b89\u88c5Go\u7684\u65f6\u5019\u770b\u5230\u9700\u8981\u8bbe\u7f6eGOPATH\u53d8\u91cf\uff0cGo\u4ece1.1\u7248\u672c\u52301.7\u5fc5\u987b\u8bbe\u7f6e\u8fd9\u4e2a\u53d8\u91cf\uff0c\u800c\u4e14\u4e0d\u80fd\u548cGo\u7684\u5b89\u88c5\u76ee\u5f55\u4e00\u6837\uff0c\u8fd9\u4e2a\u76ee\u5f55\u7528\u6765\u5b58\u653eGo\u6e90\u7801\uff0cGo\u7684\u53ef\u8fd0\u884c\u6587\u4ef6\uff0c\u4ee5\u53ca\u76f8\u5e94\u7684\u7f16\u8bd1\u4e4b\u540e\u7684\u5305\u6587\u4ef6\u3002\u6240\u4ee5\u8fd9\u4e2a\u76ee\u5f55\u4e0b\u9762\u6709\u4e09\u4e2a\u5b50\u76ee\u5f55\uff1a<code>src\u3001bin\u3001pkg<\/code><\/li>\n<li>\u4ecego 1.8\u5f00\u59cb\uff0cGOPATH\u73af\u5883\u53d8\u91cf\u73b0\u5728\u6709\u4e00\u4e2a\u9ed8\u8ba4\u503c\uff0c\u5982\u679c\u5b83\u6ca1\u6709\u88ab\u8bbe\u7f6e\u3002\u5728Windows\u4e0a\u9ed8\u8ba4\u4e3a%USERPROFILE%\/go\u3002<\/li>\n<li>\u6211\u81ea\u5df1\u8bbe\u7f6e\u7684\u73af\u5883\u53d8\u91cf\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"551\" data-height=\"401\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-1a32ce15cec746e3.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/551\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-1a32ce15cec746e3.png\" data-original-width=\"551\" data-original-height=\"401\" data-original-format=\"image\/png\" data-original-filesize=\"67263\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">\u6211\u81ea\u5df1\u8bbe\u7f6e\u7684\u73af\u5883\u53d8\u91cf.png<\/div>\n<\/div>\n<\/li>\n<li>\u5b89\u88c5\u5b8c\u6210\u5927\u6982\u662f\u8fd9\u4e2a\u6548\u679c\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"755\" data-height=\"575\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-bf714c06911e1515.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/755\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-bf714c06911e1515.png\" data-original-width=\"755\" data-original-height=\"575\" data-original-format=\"image\/png\" data-original-filesize=\"84038\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<\/li>\n<li>GOPATH \u76ee\u5f55\u7ea6\u5b9a\u6709\u4e09\u4e2a\u5b50\u76ee\u5f55\uff1a\n<ul>\n<li>src \u5b58\u653e\u6e90\u4ee3\u7801\uff08\u6bd4\u5982\uff1a.go .c .h .s\u7b49\uff09<\/li>\n<li>pkg \u7f16\u8bd1\u540e\u751f\u6210\u7684\u6587\u4ef6\uff08\u6bd4\u5982\uff1a.a\uff09<\/li>\n<li>bin \u7f16\u8bd1\u540e\u751f\u6210\u7684\u53ef\u6267\u884c\u6587\u4ef6<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4>\u4e8c\u3001Go\u5f00\u53d1\u5de5\u5177<\/h4>\n<ul>\n<li>\u7531\u4e8eGo\u5f00\u53d1\u7684\u5de5\u5177\u5de8\u591a\uff0c\u4f5c\u4e3a\u4e00\u4e2a\u83dc\u9e1f\uff0c\u76ee\u524d\u4e0d\u77e5\u9053\u5229\u5f0a\uff0c\u5c31\u5f53\u603b\u7ed3\u4e0b\u8d44\u6599\uff0c\u540c\u65f6\u6211\u81ea\u5df1\u4f7f\u7528\u7684\u5de5\u5177\u662f<code>IDEA<\/code>\uff0c\u5f53\u7136\u4e0d\u662f\u514d\u8d39\u7248\uff0c\u53bb\u7f51\u4e0a\u641e\u4e2a\u79d8\u94a5\u76f4\u63a5\u7834\u89e3\uff0c\u56e0\u4e3a<code>IDEA<\/code>\u771f\u7684\u5f88\u5f3a\u5927\uff0c\u8fd9\u5c31\u4e0d\u591a\u63d0\u4e86\uff0c\u5efa\u8bae\u5982\u679c\u8fd8\u5728\u4f7f\u7528\u7684<code>Android Studio<\/code>\u5199\u5b89\u5353\u7a0b\u5e8f\u7684\u5c0f\u4f19\u4f34\uff0c\u53ef\u4ee5\u8bd5\u8bd5\u4f7f\u7528<code>IDEA<\/code>\uff0c\u90fd\u5dee\u4e0d\u591a<\/li>\n<li>1\u3001LiteIDE<br \/>\nLiteIDE\u662f\u4e00\u6b3e\u4e13\u95e8\u4e3aGo\u8bed\u8a00\u5f00\u53d1\u7684\u8de8\u5e73\u53f0\u8f7b\u91cf\u7ea7\u96c6\u6210\u5f00\u53d1\u73af\u5883\uff08IDE\uff09\uff0c\u7531visualfc\u7f16\u5199\u3002<\/p>\n<ul>\n<li>LiteIDE\u5b89\u88c5<\/li>\n<li>\u4e0b\u8f7d\u5730\u5740\u00a0<a href=\"http:\/\/sourceforge.net\/projects\/liteide\/files\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/sourceforge.net\/projects\/liteide\/files<\/a><\/li>\n<li>\u6e90\u7801\u5730\u5740\u00a0<a href=\"https:\/\/github.com\/visualfc\/liteide\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/github.com\/visualfc\/liteide<\/a><\/li>\n<\/ul>\n<\/li>\n<li>2\u3001Sublime Text<br \/>\n\u53c2\u8003\u8fd9\u4e2a\u535a\u5ba2\u5730\u5740\u00a0<a href=\"http:\/\/blog.jobbole.com\/88648\/\" target=\"_blank\" rel=\"nofollow noopener\">http:\/\/blog.jobbole.com\/88648\/<\/a><\/li>\n<li>3\u3001Visual Studio Code<br \/>\nvscode\u662f\u5fae\u8f6f\u57fa\u4e8eElectron\u548cweb\u6280\u672f\u6784\u5efa\u7684\u5f00\u6e90\u7f16\u8f91\u5668, \u662f\u4e00\u6b3e\u5f88\u5f3a\u5927\u7684\u7f16\u8f91\u5668\u3002\u5f00\u6e90\u5730\u5740:<a href=\"https:\/\/github.com\/Microsoft\/vscode\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/github.com\/Microsoft\/vscode<\/a><\/li>\n<li>4\u3001Eclipse<br \/>\nEclipse\uff01\u4f46\u662f\u6211\u597d\u4e45\u90fd\u6ca1\u7528\u4e86\uff0c\u54c8\u54c8\uff01\uff01\uff01<\/li>\n<li>5 \u3001IntelliJ IDEA<br \/>\nidea\u662f\u901a\u8fc7\u4e00\u4e2a\u63d2\u4ef6\u6765\u652f\u6301go\u8bed\u8a00\u7684\u9ad8\u4eae\u8bed\u6cd5,\u4ee3\u7801\u63d0\u793a\u548c\u91cd\u6784\u5b9e\u73b0\u3002\u867d\u7136\u5f00\u53d1Go\u8bed\u8a00\u793e\u533a\u514d\u8d39\u7248\u5c31\u53ef\u4ee5\u4e86\uff0c\u4f46\u662f\u8fd8\u662f\u5efa\u8bae\u641e\u4e2a\u6b63\u5f0f\u7248\uff08\u5177\u4f53\u767e\u5ea6\uff0c\u563f\u563f\uff09\uff0c\u5982\u679c\u4e0d\u884c\u5c31\u4f7f\u7528\u793e\u533a\u514d\u8d39\u7248\uff01\u6211\u81ea\u5df1\u5c31\u662f\u4f7f\u7528\u7684<code>IDEA<\/code><br \/>\n\u5177\u4f53\u7684\u6b65\u9aa4\u5982\u4e0b\uff0c\u5c31\u597d\u50cfinstall\u4e2a\u63d2\u4ef6\uff01<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"1581\" data-height=\"893\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-1f9bd04303496354.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/1000\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-1f9bd04303496354.png\" data-original-width=\"1581\" data-original-height=\"893\" data-original-format=\"image\/png\" data-original-filesize=\"261666\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<\/li>\n<\/ul>\n<h4>\u4e09\u3001\u642d\u5efa\u6570\u636e\u5e93\uff0cmysql + navicat<\/h4>\n<ul>\n<li>1 \u5b89\u88c5MySQL<br \/>\n\u6211\u7684\u5b89\u88c5\u5305\u662f\u516c\u53f8\u7684Java\u5de5\u7a0b\u5e08\u53d1\u7ed9\u6211\u7684\uff0c\u5b98\u7f51\u4e0b\u8f7d\u6bd4\u8f83\u6162\uff0c\u6587\u4ef6\u4e3amysql-5.7.20-windx64.msi<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"338\" data-height=\"166\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-42c90bc4a709bb52.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/338\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-42c90bc4a709bb52.png\" data-original-width=\"338\" data-original-height=\"166\" data-original-format=\"image\/png\" data-original-filesize=\"7574\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<\/li>\n<\/ul>\n<p>\u70b9\u51fb\u76f4\u63a5\u5b89\u88c5\uff0c\u5728\u7b2c\u4e8c\u6b65Choosing a Setup Type\u7684\u65f6\u5019\uff0c\u9009\u62e9Server only<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"703\" data-height=\"601\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-31b6046bd9445715.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/703\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-31b6046bd9445715.png\" data-original-width=\"703\" data-original-height=\"601\" data-original-format=\"image\/png\" data-original-filesize=\"114617\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<p>\u7136\u540e\u4e00\u76f4Next\uff0c\u5728\u8f93\u5165\u6570\u636e\u5e93\u5bc6\u7801\u7684\u65f6\u5019\u8f93\u5165App123\uff0c\u8f93\u5165\u7528\u6237\u540d\u7684\u65f6\u5019\u9700\u8981\u8f93\u5165root\uff0c\u540c\u65f6\u8981\u628a\u8fd9\u4e24\u4e2a\u8bb0\u4e0b\u6765\uff0c\u540e\u9762\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65f6\u5019\u9700\u8981\u7528\u5230<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"703\" data-height=\"673\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-9fd5249356e29445.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/703\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-9fd5249356e29445.png\" data-original-width=\"703\" data-original-height=\"673\" data-original-format=\"image\/png\" data-original-filesize=\"92533\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<ul>\n<li>2\u3001\u7528navicat\u64cd\u4f5c\u6570\u636e\u5e93<br \/>\nnavicat\u662f\u4e2a\u5de5\u5177\uff0c\u53ef\u4ee5\u76f4\u63a5\u5230\u767e\u5ea6\u4e0b\u8f7d\uff0c\u7136\u540e\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u8f93\u5165\u4f60\u7684\u5bc6\u7801\u548c\u7528\u6237\u540d\u5373\u53ef<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"1329\" data-height=\"863\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-8ac63c8168ab91df.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/1000\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-8ac63c8168ab91df.png\" data-original-width=\"1329\" data-original-height=\"863\" data-original-format=\"image\/png\" data-original-filesize=\"283167\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<p>\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93godbdemo\uff0c\u4e3a\u4ec0\u4e48\u53ebgodbdemo\uff0c\u56e0\u4e3a\u5728Go\u91cc\u9762\u7b49\u4e0b\u9700\u8981\u914d\u7f6e\u7684\u6570\u636e\u5e93\u5c31\u53eb\u5b83\u3002<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"267\" data-height=\"143\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-e2a3340262a3a145.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/267\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-e2a3340262a3a145.png\" data-original-width=\"267\" data-original-height=\"143\" data-original-format=\"image\/png\" data-original-filesize=\"11109\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<\/li>\n<li>3\u3001\u521b\u5efa\u8868userinfo<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE TABLE `userinfo` (\r\n    `uid` INT(10) NOT NULL AUTO_INCREMENT,\r\n    `username` VARCHAR(64) NULL DEFAULT NULL,\r\n    `department` VARCHAR(64) NULL DEFAULT NULL,\r\n    `created` DATE NULL DEFAULT NULL,\r\n    PRIMARY KEY (`uid`)\r\n);<\/pre>\n<pre class=\"hljs php\"><\/pre>\n<p>\u4f7f\u7528Navicat Premium \u521b\u5efa\u6570\u636e\u5e93<\/p>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"664\" data-height=\"431\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-365e288d8136449a.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/664\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-365e288d8136449a.png\" data-original-width=\"664\" data-original-height=\"431\" data-original-format=\"image\/png\" data-original-filesize=\"41617\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">\u4f7f\u7528Navicat Premium \u521b\u5efa\u6570\u636e\u5e931.png<\/div>\n<\/div>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"788\" data-height=\"384\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-d8bd1e8c611c3002.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/788\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-d8bd1e8c611c3002.png\" data-original-width=\"788\" data-original-height=\"384\" data-original-format=\"image\/png\" data-original-filesize=\"49227\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">\u4f7f\u7528Navicat Premium \u521b\u5efa\u6570\u636e\u5e932.png<\/div>\n<\/div>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"743\" data-height=\"396\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-0d98a00f4b6f9475.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/743\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-0d98a00f4b6f9475.png\" data-original-width=\"743\" data-original-height=\"396\" data-original-format=\"image\/png\" data-original-filesize=\"50297\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">\u4f7f\u7528Navicat Premium \u521b\u5efa\u6570\u636e\u5e933.png<\/div>\n<\/div>\n<ul>\n<li>ok\uff0c\u51c6\u5907\u5de5\u4f5c\u5dee\u4e0d\u591a\u4e86<\/li>\n<\/ul>\n<h4>\u56db\u3001GitHub\u4f9d\u8d56\u7684\u7ba1\u7406<\/h4>\n<ul>\n<li>\u4e0d\u53ef\u907f\u514d\u7684\u6211\u4eec\u4f1a\u4f7f\u7528\u5916\u90e8\u7684\u4f9d\u8d56\u5305\u5305\u3002go\u5728\u8fd9\u65b9\u9762\u505a\u7684\u975e\u5e38\u98d8\u9038\u3002go\u6ca1\u6709\u50cfjava\u4f7f\u7528maven\u6765\u7ba1\u7406\u4f9d\u8d56\u5305\u3001\u5305\u7248\u672c\uff0c\u800c\u662f\u76f4\u63a5\u4f7f\u7528GOPATH\u6765\u7ba1\u7406\u5916\u90e8\u4f9d\u8d56\u3002<\/li>\n<li>Go\u5b98\u65b9\u6ca1\u6709\u63d0\u4f9b\u6570\u636e\u5e93\u9a71\u52a8\uff0c\u800c\u662f\u4e3a\u5f00\u53d1\u6570\u636e\u5e93\u9a71\u52a8\u5b9a\u4e49\u4e86\u4e00\u4e9b\u6807\u51c6\u63a5\u53e3\uff0c\u5f00\u53d1\u8005\u53ef\u4ee5\u6839\u636e\u5b9a\u4e49\u7684\u63a5\u53e3\u6765\u5f00\u53d1\u76f8\u5e94\u7684\u6570\u636e\u5e93\u9a71\u52a8\uff0c\u8fd9\u6837\u505a\u6709\u4e00\u4e2a\u597d\u5904\uff0c\u53ea\u8981\u662f\u6309\u7167\u6807\u51c6\u63a5\u53e3\u5f00\u53d1\u7684\u4ee3\u7801\uff0c \u4ee5\u540e\u9700\u8981\u8fc1\u79fb\u6570\u636e\u5e93\u65f6\uff0c\u4e0d\u9700\u8981\u4efb\u4f55\u4fee\u6539<\/li>\n<li>1\u3001MySQL\u9a71\u52a8<br \/>\n\u6211\u81ea\u5df1\u4f7f\u7528\u7684\u662f\u8fd9\u4e2a\u9a71\u52a8<br \/>\n<a href=\"https:\/\/github.com\/go-sql-driver\/mysql\" target=\"_blank\" rel=\"nofollow noopener\">https:\/\/github.com\/go-sql-driver\/mysql<\/a>\u00a0\u652f\u6301database\/sql\uff0c\u5168\u90e8\u91c7\u7528go\u5199\u3002<\/li>\n<li>\u4e3b\u8981\u7406\u7531\uff1a\n<ul>\n<li>\u8fd9\u4e2a\u9a71\u52a8\u6bd4\u8f83\u65b0\uff0c\u7ef4\u62a4\u7684\u6bd4\u8f83\u597d<\/li>\n<li>\u5b8c\u5168\u652f\u6301database\/sql\u63a5\u53e3<\/li>\n<li>\u652f\u6301keepalive\uff0c\u4fdd\u6301\u957f\u8fde\u63a5,\u867d\u7136<a href=\"http:\/\/www.mikespook.com\/\" target=\"_blank\" rel=\"nofollow noopener\">\u661f\u661f<\/a>fork\u7684mymysql\u4e5f\u652f\u6301keepalive\uff0c\u4f46\u4e0d\u662f\u7ebf\u7a0b\u5b89\u5168\u7684\uff0c\u8fd9\u4e2a\u4ece\u5e95\u5c42\u5c31\u652f\u6301\u4e86keepalive\u3002<\/li>\n<\/ul>\n<\/li>\n<li>2\u3001\u4f7f\u7528<code>git<\/code>\u62c9\u53d6\u4ee3\u7801<\/li>\n<\/ul>\n<pre class=\"hljs ruby\"><code class=\"ruby\">$ go get -u github.com\/go-sql-driver\/mysql\r\n<\/code><\/pre>\n<ul>\n<li>\u6700\u7ec8\u7684\u6548\u679c\u5982\u4e0b\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"672\" data-height=\"359\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-8260346448e2e69b.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/672\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-8260346448e2e69b.png\" data-original-width=\"672\" data-original-height=\"359\" data-original-format=\"image\/png\" data-original-filesize=\"88461\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">goPATh\u76ee\u5f55\u4e0b\u7684github\u76ee\u5f55\u7684src\u76ee\u5f55.png<\/div>\n<\/div>\n<\/li>\n<\/ul>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"645\" data-height=\"291\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-2dca9092efa06cb9.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/645\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-2dca9092efa06cb9.png\" data-original-width=\"645\" data-original-height=\"291\" data-original-format=\"image\/png\" data-original-filesize=\"57392\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">goPATh\u76ee\u5f55\u4e0b\u7684github\u76ee\u5f55\u7684pkg\u76ee\u5f55.png<\/div>\n<\/div>\n<h4>5\u3001\u4ee3\u7801\u5b9e\u73b0<\/h4>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">package main\r\n\r\nimport (\r\n    \"database\/sql\"\r\n    \"fmt\"\r\n    _ \"github.com\/go-sql-driver\/mysql\"\r\n    \/\/\u5176\u5b9e\u8fd9\u4e2a\u5c31\u662fGo\u8bbe\u8ba1\u7684\u5de7\u5999\u4e4b\u5904\uff0c\u6211\u4eec\u5728\u53d8\u91cf\u8d4b\u503c\u7684\u65f6\u5019\u7ecf\u5e38\u770b\u5230\u8fd9\u4e2a\u7b26\u53f7\uff0c\u5b83\u662f\u7528\u6765\u5ffd\u7565\u53d8\u91cf\u8d4b\u503c\u7684\u5360\u4f4d\u7b26\uff0c\u90a3\u4e48\u5305\u5f15\u5165\u7528\u5230\u8fd9\u4e2a\u7b26\u53f7\u4e5f\u662f\u76f8\u4f3c\u7684\u4f5c\u7528\uff0c\u8fd9\u513f\u4f7f\u7528_\u7684\u610f\u601d\u662f\u5f15\u5165\u540e\u9762\u7684\u5305\u540d\u800c\u4e0d\u76f4\u63a5\u4f7f\u7528\u8fd9\u4e2a\u5305\u4e2d\u5b9a\u4e49\u7684\u51fd\u6570\uff0c\u53d8\u91cf\u7b49\u8d44\u6e90\u3002\r\n)\r\n\r\nfunc init() {\r\n\/\/  Go\u4e2d\u652f\u6301MySQL\u7684\u9a71\u52a8\u76ee\u524d\u6bd4\u8f83\u591a\uff0c\u6709\u5982\u4e0b\u51e0\u79cd\uff0c\u6709\u4e9b\u662f\u652f\u6301database\/sql\u6807\u51c6\uff0c\u800c\u6709\u4e9b\u662f\u91c7\u7528\u4e86\u81ea\u5df1\u7684\u5b9e\u73b0\u63a5\u53e3,\u5e38\u7528\u7684\u6709\u5982\u4e0b\u51e0\u79cd:\r\n\/\/\r\n\/\/https:\/\/github.com\/go-sql-driver\/mysql \u652f\u6301database\/sql\uff0c\u5168\u90e8\u91c7\u7528go\u5199\u3002\r\n\/\/https:\/\/github.com\/ziutek\/mymysql \u652f\u6301database\/sql\uff0c\u4e5f\u652f\u6301\u81ea\u5b9a\u4e49\u7684\u63a5\u53e3\uff0c\u5168\u90e8\u91c7\u7528go\u5199\u3002\r\n\/\/https:\/\/github.com\/Philio\/GoMySQL \u4e0d\u652f\u6301database\/sql\uff0c\u81ea\u5b9a\u4e49\u63a5\u53e3\uff0c\u5168\u90e8\u91c7\u7528go\u5199\u3002\r\n\/\/  \u63a5\u4e0b\u6765\u7684\u4f8b\u5b50\u6211\u4e3b\u8981\u4ee5\u7b2c\u4e00\u4e2a\u9a71\u52a8\u4e3a\u4f8b(\u6211\u76ee\u524d\u9879\u76ee\u4e2d\u4e5f\u662f\u91c7\u7528\u5b83\u6765\u9a71\u52a8)\uff0c\u4e5f\u63a8\u8350\u5927\u5bb6\u91c7\u7528\u5b83\uff0c\u4e3b\u8981\u7406\u7531\uff1a\r\n\/\/\r\n\/\/  \u8fd9\u4e2a\u9a71\u52a8\u6bd4\u8f83\u65b0\uff0c\u7ef4\u62a4\u7684\u6bd4\u8f83\u597d\r\n\/\/  \u5b8c\u5168\u652f\u6301database\/sql\u63a5\u53e3\r\n\/\/  \u652f\u6301keepalive\uff0c\u4fdd\u6301\u957f\u8fde\u63a5,\u867d\u7136\u661f\u661ffork\u7684mymysql\u4e5f\u652f\u6301keepalive\uff0c\u4f46\u4e0d\u662f\u7ebf\u7a0b\u5b89\u5168\u7684\uff0c\u8fd9\u4e2a\u4ece\u5e95\u5c42\u5c31\u652f\u6301\u4e86keepalive\u3002\r\n}\r\nfunc main() {\r\n\/\/  user@unix(\/path\/to\/socket)\/dbname?charset=utf8\r\n\/\/user:password@tcp(localhost:5555)\/dbname?charset=utf8\r\n\/\/user:password@\/dbname\r\n\/\/user:password@tcp([de:ad:be:ef::ca:fe]:80)\/dbname\r\n\r\n\r\n    \/\/spring.datasource.url =jdbc:mysql:\/\/localhost:3306\/test\r\n    \/\/spring.datasource.username = root\r\n    \/\/#  \u6ce8\u610f\u5bc6\u7801\u7684\u95ee\u9898 \uff0c\u6570\u636e\u7684\u5bc6\u7801\u7684\r\n    \/\/spring.datasource.password = App123\r\n    \/\/ sql.Open()\u51fd\u6570\u7528\u6765\u6253\u5f00\u4e00\u4e2a\u6ce8\u518c\u8fc7\u7684\u6570\u636e\u5e93\u9a71\u52a8\uff0cgo-sql-driver\u4e2d\u6ce8\u518c\u4e86mysql\u8fd9\u4e2a\u6570\u636e\u5e93\u9a71\u52a8\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662fDSN(Data Source Name)\uff0c\u5b83\u662fgo-sql-driver\u5b9a\u4e49\u7684\u4e00\u4e9b\u6570\u636e\u5e93\u94fe\u63a5\u548c\u914d\u7f6e\u4fe1\u606f   \u5982\u4e0a\u7684\u56fe\u7247\r\n\r\n    db, err := sql.Open(\"mysql\", \"root:App123@tcp(localhost:3306)\/godbdemo?charset=utf8\")\r\n    checkErr(err)\r\n\r\n    \/\/\u63d2\u5165\u6570\u636e db.Prepare()\u51fd\u6570\u7528\u6765\u8fd4\u56de\u51c6\u5907\u8981\u6267\u884c\u7684sql\u64cd\u4f5c\uff0c\u7136\u540e\u8fd4\u56de\u51c6\u5907\u5b8c\u6bd5\u7684\u6267\u884c\u72b6\u6001\u3002\r\n    stmt, err := db.Prepare(\"INSERT userinfo SET username=?,department=?,created=?\")\r\n    checkErr(err)\r\n\r\n    for i:=1;i&lt;100000 ;i++  {\r\n        \/\/stmt.Exec()\u51fd\u6570\u7528\u6765\u6267\u884cstmt\u51c6\u5907\u597d\u7684SQL\u8bed\u53e5\r\n        res, err := stmt.Exec(\"shiming\", \"\u7814\u53d1\u90e8\u95e8\", \"20180706\")\r\n        checkErr(err)\r\n        \/\/shiming i== 9727 res=== {0xc0420a0000 0xc0422f5000}\r\n        fmt.Println(\"shiming i==\",i,\"res===\",res)\r\n\r\n    }\r\n    res, err := stmt.Exec(\"shiming\", \"\u7814\u53d1\u90e8\u95e8\", \"20180706\")\r\n    checkErr(err)\r\n\r\n    id, err := res.LastInsertId()\r\n    checkErr(err)\r\n\r\n    fmt.Println(id)\r\n    \/\/\u66f4\u65b0\u6570\u636e  \u4f20\u5165\u7684\u53c2\u6570\u90fd\u662f=?\u5bf9\u5e94\u7684\u6570\u636e\uff0c\u8fd9\u6837\u505a\u7684\u65b9\u5f0f\u53ef\u4ee5\u4e00\u5b9a\u7a0b\u5ea6\u4e0a\u9632\u6b62SQL\u6ce8\u5165\r\n    stmt, err = db.Prepare(\"update userinfo set username=? where uid=?\")\r\n    checkErr(err)\r\n\r\n    res, err = stmt.Exec(\"shimingupdate\", id)\r\n    checkErr(err)\r\n\r\n    affect, err := res.RowsAffected()\r\n    checkErr(err)\r\n\r\n    fmt.Println(affect)\r\n\r\n    \/\/\u67e5\u8be2\u6570\u636e  db.Query()\u51fd\u6570\u7528\u6765\u76f4\u63a5\u6267\u884cSql\u8fd4\u56deRows\u7ed3\u679c\u3002\r\n    rows, err := db.Query(\"SELECT * FROM userinfo\")\r\n    checkErr(err)\r\n\r\n    for rows.Next() {\r\n        var uid int\r\n        var username string\r\n        var department string\r\n        var created string\r\n        err = rows.Scan(&amp;uid, &amp;username, &amp;department, &amp;created)\r\n        checkErr(err)\r\n        fmt.Println(uid)\r\n        fmt.Println(username)\r\n        fmt.Println(department)\r\n        fmt.Println(created)\r\n    }\r\n\r\n    \/\/\u5220\u9664\u6570\u636e\r\n    \/\/stmt, err = db.Prepare(\"delete from userinfo where uid=?\")\r\n    \/\/checkErr(err)\r\n    \/\/\r\n    \/\/res, err = stmt.Exec(id)\r\n    \/\/checkErr(err)\r\n    \/\/\r\n    \/\/affect, err = res.RowsAffected()\r\n    \/\/checkErr(err)\r\n    \/\/\r\n    \/\/fmt.Println(affect)\r\n\r\n    db.Close()\r\n\r\n}\r\n\r\nfunc checkErr(err error) {\r\n    if err != nil {\r\n        panic(err) \/\/\u5927\u6982\u76f8\u5f53\u4e8e  Java\u4e2d\u7684\u5f02\u5e38\r\n    }\r\n}\r\n<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li><code>sql.Open()<\/code>\u51fd\u6570\u7528\u6765\u6253\u5f00\u4e00\u4e2a\u6ce8\u518c\u8fc7\u7684\u6570\u636e\u5e93\u9a71\u52a8\uff0c<code>go-sql-driver<\/code>\u4e2d\u6ce8\u518c\u4e86<code>mysql<\/code>\u8fd9\u4e2a\u6570\u636e\u5e93\u9a71\u52a8\uff0c\u7b2c\u4e8c\u4e2a\u53c2\u6570\u662f<code>DSN(Data Source Name)<\/code>\uff0c\u5b83\u662f<code>go-sql-driver<\/code>\u5b9a\u4e49\u7684\u4e00\u4e9b\u6570\u636e\u5e93\u94fe\u63a5\u548c\u914d\u7f6e\u4fe1\u606f\u3002\u5b83\u652f\u6301\u5982\u4e0b\u683c\u5f0f\uff1a<\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">user@unix(\/path\/to\/socket)\/dbname?charset=utf8\r\nuser:password@tcp(localhost:5555)\/dbname?charset=utf8\r\nuser:password@\/dbname\r\nuser:password@tcp([de:ad:be:ef::ca:fe]:80)\/dbname<\/pre>\n<p>&nbsp;<\/p>\n<p>\u5728\u6211\u7684\u4ee3\u7801\u4e2d\u662f\u4f7f\u7528\u7684\u662f\u8fd9\u79cd\u7684\u65b9\u5f0f<code>user:password@tcp(localhost:5555)\/dbname?charset=utf8<\/code>,\u4e5f\u5c31\u662f\u8fd9\u79cd\u7684\u6548\u679c\u00a0<code>db, err := sql.Open(\"mysql\", \"root:App123@tcp(localhost:3306)\/godbdemo?charset=utf8\")<\/code>\u00a0\u3002<\/p>\n<ul>\n<li>\u5176\u4e2d\u7684\u00a0<code>root<\/code>\u662f\u6570\u636e\u5e93\u7684\u7528\u6237\u540d\uff0c\u00a0<code>App123<\/code>\u662f\u6570\u636e\u5e93\u7684\u5bc6\u7801\u3002<\/li>\n<li>\u51e0\u4e2a\u5173\u952e\u7684\u65b9\u6cd5\n<ul>\n<li>db.Prepare()\u51fd\u6570\u7528\u6765\u8fd4\u56de\u51c6\u5907\u8981\u6267\u884c\u7684sql\u64cd\u4f5c\uff0c\u7136\u540e\u8fd4\u56de\u51c6\u5907\u5b8c\u6bd5\u7684\u6267\u884c\u72b6\u6001\u3002<\/li>\n<li>db.Query()\u51fd\u6570\u7528\u6765\u76f4\u63a5\u6267\u884cSql\u8fd4\u56deRows\u7ed3\u679c\u3002<\/li>\n<li>stmt.Exec()\u51fd\u6570\u7528\u6765\u6267\u884cstmt\u51c6\u5907\u597d\u7684SQL\u8bed\u53e5<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h4>6\u3001\u6700\u7ec8\u7684\u6548\u679c\u5982\u4e0b<\/h4>\n<p>\u7531\u4e8e\u6211\u7684\u4ee3\u7801\u4e2d\u6709\u4e2a\u5faa\u73af<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">for i:=1;i&lt;100000 ;i++  {\r\n    \/\/stmt.Exec()\u51fd\u6570\u7528\u6765\u6267\u884cstmt\u51c6\u5907\u597d\u7684SQL\u8bed\u53e5\r\n    res, err := stmt.Exec(\"shiming\", \"\u7814\u53d1\u90e8\u95e8\", \"20180706\")\r\n    checkErr(err)\r\n    \/\/shiming i== 9727 res=== {0xc0420a0000 0xc0422f5000}\r\n    fmt.Println(\"shiming i==\",i,\"res===\",res)\r\n\r\n}<\/pre>\n<p>&nbsp;<\/p>\n<ul>\n<li>\u70b9\u51fb\u8fd0\u884c<\/li>\n<\/ul>\n<div class=\"image-package\">\n<div class=\"image-container\">\n<div class=\"image-container-fill\"><\/div>\n<div class=\"image-view\" data-width=\"1700\" data-height=\"677\"><img decoding=\"async\" class=\"\" src=\"https:\/\/upload-images.jianshu.io\/upload_images\/5363507-4f27432bdb554d6d.png?imageMogr2\/auto-orient\/strip%7CimageView2\/2\/w\/1000\/format\/webp\" data-original-src=\"\/\/upload-images.jianshu.io\/upload_images\/5363507-4f27432bdb554d6d.png\" data-original-width=\"1700\" data-original-height=\"677\" data-original-format=\"image\/png\" data-original-filesize=\"88056\" \/><\/div>\n<\/div>\n<div class=\"image-caption\">image.png<\/div>\n<\/div>\n<h4>\u6700\u540e\uff0c\u8bf4\u660e\u4e00\u70b9\uff1a\u4ee5\u4e0a\u7684<a href=\"https:\/\/github.com\/Shimingli\/GoDemo\" target=\"_blank\" rel=\"nofollow noopener\">Demo<\/a>\u662f\u81ea\u5df1\u642d\u5efa\u73a9\u73a9\uff0c\u4e00\u5b9a\u4f1a\u6709\u4e9b\u5dee\u9519\uff0c\u8bf7\u5927\u725b\u4e0d\u8981\u89c1\u602a\u54c8~~~<\/h4>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u672c\u6587\u4e3b\u8981\u4ecb\u7ecd\u4f7f\u7528Go\u8bed\u8a00\u4f7f\u7528MySQL\u7684<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"colormag_page_container_layout":"default_layout","colormag_page_sidebar_layout":"default_layout","footnotes":""},"categories":[],"tags":[122],"class_list":["post-2663","post","type-post","status-publish","format-standard","hentry","tag-06-godocker"],"_links":{"self":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/2663","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/comments?post=2663"}],"version-history":[{"count":0,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/posts\/2663\/revisions"}],"wp:attachment":[{"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/media?parent=2663"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/categories?post=2663"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/i007.cc\/wordpress\/wp-json\/wp\/v2\/tags?post=2663"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}