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

?

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

?

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

?

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

?

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

安裝 node-mysql

        $ npm install mysql
      

?

創建測試表

//數據庫名 NodeSample

        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 ;
      

?

連接數據庫

        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');
});
      

?

打開數據庫

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

?

完成數據庫操作程序

        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');
};
      

?