//引入node事件模块
var events = require('events');
//创建事件实例化对象
var eventEmitter = new events.EventEmitter();
//声明连接事件处理器
var connectionHandler = function(){
console.log('database is connected ...');
}
//绑定事件
eventEmitter.on('connection',connectionHandler);//触发事件
eventEmitter.emit('connection');
node connection mysql
安装mysql模块
cnpm install mysql
//引入mysql模块
var mysql =require('mysql');//获取连接对象
var connection = mysql.createConnection({
host:'127.0.0.1',
port:2433,
user:'root',
password:'root',
database:'test'});//建立连接
connection.connect();
var sql ='select * from t_u_user';//crud都用query
connection.query(sql,function(error,results){if(error){throw error;}
console.log(results);});//释放资源
connection.end();
node demo
==>server.js
var http =require('http');
var url =require('url');
function start(route){
function onRequest(request,response){
var pathname = url.parse(request.url).pathname;
console.log('request context path :' + pathname);
route(pathname);
response.writeHead(200,{'Content-Type':'text/html'});
response.write('hello world...');
response.end();
}
http.createServer(onRequest).listen(8888);
}
expores.start = start ;
==>router.js
function route(pathname){
console.log(pathname);
}
exports.route = route;
==>index.js
var server = require('./server.js');
var router = require('./router.js');
server.start(router.route);