1、安装nodejs
2、安装mysql npm包
地址:https://github.com/felixge/node-mysql
npm
install mysql
3、相应API查看及调用:
var
mysql = require('mysql');
var
connection = mysql.createConnection({
host : 'localhost',
user : 'me',
password : 'secret'
});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function(err,
rows, fields) {
if (err) throw err;
console.log('The solution is: ',
rows[0].solution);
});
connection.end();
4、相关注意点及方法
将相应结果进行文件形式保存,使用fs文件系统及path路径模块
var $ =
require('underscore');
var fs =
require('fs');
var path =
require('path');
underscore为数据处理集合,可以简单快捷的进行数据的遍历拼接等处理
npm
install underscore
connection.query('select * from xmmember', function (err, rows) {//account 用户账户表
if
(err) throw err;
var
tempAccount = $.map(rows, function (c) {
return {
id: c.ID,
name: c.m_username,
password: c.m_userpass,
surePassword: c.m_userpass,
qq: c.qq
}
});
fs.writeFile(path.join(__dirname, 'account.js'),
JSON.stringify(tempAccount), func