nodeJS串連MySQL資料庫

標籤：style   http   os   io   ar   for   資料   cti   代碼   

nodeJS串連MySQL資料庫，首先建立一個資料庫及表。如下： 

create databases node; create table test( id int AUTO_INCREMENT PRIMARY KEY , name char(50) )ENGINE=InnoDB DEFAULT CHARSET=utf8;

安裝MySQL驅動： 

$ npm install mysql

下面是nodeJS代碼： 

var sys = require(‘util‘); console.log(‘正在串連MySQL...‘); var client = require(‘mysql‘).createClient({‘host‘:‘localhost‘,‘port‘:3306,‘user‘:‘root‘,‘password‘:‘xxx‘});clientConnectionReady = function(client) {    client.query(‘use node‘, function(error, results) {         if(error) {             console.log(‘ClientConnectionReady Error: ‘ + error.message);             client.end();             return;         }else{     console.log(‘已經串連上MySQL....‘);}         clientReady(client);     }); };clientReady = function(client) {     var values = [‘不錯啊‘];     client.query(‘insert into test set name = ?‘, values,         function(error, results) {             if(error) {                 console.log("ClientReady Error: " + error.message);                 client.end();                 return;             }             console.log(‘Inserted: ‘ + results.affectedRows + ‘ row.‘);             console.log(‘Id inserted: ‘ + results.insertId);         }     );     getData(client); }getData = function(client) {     client.query(         ‘select * from test‘,         function selectCb(error, results, fields) {            if (error) {                 console.log(‘GetData Error: ‘ + error.message);                 client.end();                 return;            }    for(var i=0; i<results.length; i++){var firstResult = results[i];         console.log(‘id: ‘ + firstResult[‘id‘]+‘    name: ‘ + firstResult[‘name‘]);   }    }    );     client.end();     console.log(‘關閉MySQL串連...‘); };clientConnectionReady(client);

 

nodeJS串連MySQL資料庫