windows下如何使node.js和mysql数据库交互

1. 访问nodejs.org, 下载node-v0.10.20-x86.msi并安装

2. 运行-cmd-node，查看是否安装成功

3. 访问Python.org,下载python_2.7.3.msi并安装

4. 进入node-v0.10.20-x86.msi安装目录，cmd下运行vcbuild.bat relase。等20分钟

5. 生成了node.exe后，nodejs就安装完成啦

6. cmd下执行npm install mysql。安装npm

7.下载mysql-5.0.27-win32.zip、SQL-Front_Setup.zip。分别安装

8.桌面上新建一个文本文档(test.js)，敲入/**
 * Created by Administrator on 13-12-25.
 */
var mysql = require('mysql');
var connection = mysql.createConnection({
    host:'192.168.1.100',
    user:'root',
    password:'123456',
    insecureAuth: true
});


connection.connect();


connection.query('select 1+1 as solution', function(err, rows, fields) {
    if(err)throw err;
    console.log('This solution is: ', rows[0].solution);
});


connection.end();

9. 运行node test.js。OK！！！

10. 创建一个简单的服务器(server.js)var http = require('http');


http.createServer(function(req, res){
res.writeHead(200, {'Content-Type' : 'text/html'});
res.write('helloWorld!');
res.end('<p>!!!!!</p>');
}
).listen(3030);
console.log("http server is listening at port 3030");

11.cmd下输入node test.js回车，打开浏览器，输入127.0.0.1:3030, 输出helloWorld