NodeJS使用mysql

標籤：img   use   sql   save   src   ons   depend   highlight   database   

1.環境準備

手動添加資料庫依賴：

在package.json的dependencies中新增, “mysql” : “latest”，

{  "name": "news",  "version": "0.0.0",  "private": true,  "scripts": {    "start": "node ./bin/www"  },  "dependencies": {    "body-parser": "~1.13.2",    "cookie-parser": "~1.3.5",    "debug": "~2.2.0",    "express": "~4.13.1",    "jade": "~1.11.0",    "morgan": "~1.6.1",    "serve-favicon": "~2.3.0",    "mysql":"latest"  }}

使用命令安裝mysql並添加依賴：

npm install mysql -save

　　

2.官方例子：

複製代碼//串連資料庫var mysql = require(‘mysql‘);var connection = mysql.createConnection({    host: ‘localhost‘,    user: ‘root‘,    password: ‘open00‘,    database:‘test‘});connection.connect();//查詢connection.query(‘select * from `mytable`‘, function(err, rows, fields) {    if (err) throw err;    console.log(‘查詢結果為: ‘, rows);});//關閉串連connection.end();

運行node

　　

NodeJS使用mysql