node.js 開髮指南Node.js 連接MySQL 並進行數據庫操作

Node.js是一套用來編寫高性能網絡服務器的JavaScript工具包

通常在NodeJS開發中我們經常涉及到操作數據庫，尤其是MySQL ，作為應用最為廣泛的開源數據庫則成為我們的首選，本篇就來介紹下如何通過NodeJS來操作MySQL 數據庫。 安裝MySQL模塊到NodeJS中我們需要讓NodeJS支持MySQL，則需要將MySQL模塊添加到系統支持庫

想要快速了解Node.js ，贊生推薦親看看node.js_guide.pdf ― node.js 開髮指南：想要電子版高清的留言發送

如果不想留言可以帶你做飛機！ 直接下載

Node.js

簡單介紹一下node.js的操作吧

安裝node-mysql

C代碼

$ npm install mysql

創建測試表

//數據庫名NodeSample

C代碼

CREATE TABLE `NodeSample`.`MyTable` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `firstname` VARCHAR( 20 ) NOT NULL , `lastname` VARCHAR( 20 ) NOT NULL , `message` TEXT NOT NULL ) ENGINE = MYISAM ;

連接數據庫

Js代碼

var sys = require('sys'); var Client = require('mysql').Client; var client = new Client(); client.user = 'someuser'; client.password = 'password'; client.connect(function(error, results) { if(error) { console.log('Connection Error: ' + error.message); return; } console.log('Connected to MySQL'); });

打開數據庫

Js代碼

ClientConnectionReady = function(client) { client.query('USE NodeSample', function(error, results) { if(error) { console.log('ClientConnectionReady Error: ' + error.message); client.end(); return; } }); };

完成數據庫操作程序

Js代碼

var sys = require('sys'); var Client = require('mysql').Client; var client = new Client(); client.user = 'someuser'; client.password = 'password'; console.log('Connecting to MySQL...'); client.connect(function(error, results) { if(error) { console.log('Connection Error: ' + error.message); return; } console.log('Connected to MySQL'); ClientConnectionReady(client); }); ClientConnectionReady = function(client) { client.query('USE NodeSample', function(error, results) { if(error) { console.log('ClientConnectionReady Error: ' + error.message); client.end(); return; } ClientReady(client); }); }; ClientReady = function(client) { var values = ['Chad', 'Lung', 'Hello World']; client.query('INSERT INTO MyTable SET firstname = ?, lastname = ? , message = ?', 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 MyTable', function selectCb(error, results, fields) { if (error) { console.log('GetData Error: ' + error.message); client.end(); return; } // Uncomment these if you want lots of feedback //console.log('Results:'); //console.log(results); //console.log('Field metadata:'); //console.log(fields); //console.log(sys.inspect(results)); if(results.length > 0) { var firstResult = results[0]; console.log('First Name: ' + firstResult['firstname']); console.log('Last Name: ' + firstResult['lastname']); console.log('Message: ' + firstResult['message']); } }); client.end(); console.log('Connection closed'); };