{"id":732,"date":"2017-03-07T11:36:00","date_gmt":"2017-03-07T03:36:00","guid":{"rendered":"http:\/\/feizhaojun.com\/?p=732"},"modified":"2017-03-07T11:36:00","modified_gmt":"2017-03-07T03:36:00","slug":"node-jsmysql%e7%a4%ba%e4%be%8b","status":"publish","type":"post","link":"https:\/\/feizhaojun.com\/?p=732","title":{"rendered":"Node.js+MySQL\u793a\u4f8b"},"content":{"rendered":"<p>1 \u5b89\u88c5Node\u7684MySQL\u6a21\u5757\uff0c\u65b9\u6cd5\u6709\u4e24\u79cd\uff1a<br \/>\n\u3000\u4e00\u79cd\u662f\u624b\u52a8\u5728package.json\u4e2d\u6dfb\u52a0\u4f9d\u8d56\uff08dependencies\uff09\uff0c\u7136\u540e\u6267\u884c npm install\u3002<br \/>\n\u4e00\u79cd\u662f\u76f4\u63a5\u6267\u884c npm install mysql\u3002<br \/>\npackage.json\u793a\u4f8b\uff1a<br \/>\n[javascript]<br \/>\n{<br \/>\n  &quot;name&quot;: &quot;test&quot;,<br \/>\n  &quot;version&quot;: &quot;0.0.0&quot;,<br \/>\n  &quot;private&quot;: true,<br \/>\n  &quot;scripts&quot;: {<br \/>\n    &quot;start&quot;: &quot;node .\/bin\/www&quot;<br \/>\n  },<br \/>\n  &quot;dependencies&quot;: {<br \/>\n    &quot;mysql&quot;:&quot;latest&quot;<br \/>\n  }<br \/>\n}<br \/>\n[\/javascript]<\/p>\n<p>2 Node\u8fde\u63a5MySQL\u7684\u793a\u4f8b\uff1a<br \/>\n[javascript]<br \/>\nlet mysql = require('mysql');<br \/>\nlet connection = mysql.createConnection({<br \/>\n\thost:'localhost',<br \/>\n\tuser:'root',<br \/>\n\tpassword:'850804',<br \/>\n\tdatabase:'test'<br \/>\n});<\/p>\n<p>connection.connect();<\/p>\n<p>connection.query('SELECT 1+1 AS solution', function(err,rows,fields){<br \/>\n\tif(err) throw err;<br \/>\n\tconsole.log('The solution is: ', rows[0].solution);<br \/>\n});<\/p>\n<p>connection.end();<br \/>\n[\/javascript]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1 \u5b89\u88c5Node\u7684MySQL\u6a21\u5757\uff0c\u65b9\u6cd5\u6709\u4e24\u79cd\uff1a \u3000\u4e00\u79cd\u662f\u624b\u52a8\u5728package.json\u4e2d\u6dfb\u52a0\u4f9d\u8d56\uff08dependencie&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[29,52],"tags":[],"class_list":["post-732","post","type-post","status-publish","format-standard","hentry","category-29","category-node"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/posts\/732","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=732"}],"version-history":[{"count":1,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/posts\/732\/revisions"}],"predecessor-version":[{"id":733,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=\/wp\/v2\/posts\/732\/revisions\/733"}],"wp:attachment":[{"href":"https:\/\/feizhaojun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=732"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=732"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/feizhaojun.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=732"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}